Jump to content
Sign in to follow this  
Paul Hackett

Cannot create new DB during Install

Recommended Posts

I am using the SA account for our SQL 2012 Server running setup from a Windows 2016 server.  I have turned off the firewall.   I am able to make a connection to the SQL server from my password state server and browse the databases.

I get this error in the Database Creation Log

Resolving host name of database server...
Executing creation of temporary database...
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. 

Share this post


Link to post
Share on other sites

Hi Paul,

 

Could it be an SQL Instance name issue? Sometimes customers are not aware their SQL server has be installed with an instance name, or they have specified an instance name of MSSQLSERVER and you do not need to specify this with SQL Server Standard and above.

 

Regards

Click Studios

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×