This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have loaded SQL Server Management studio on my new computer, When I try to connect the data base engine there are no "Server Name"'s available for selection. I think this is related to not having the SQL Server v18.8 configuration manager tool, Can anyone help me with getting this set up. Thanks in advance
But can you type the server name manually?
Hello! Did you by chance figure out what on earth to do to fix this issue because I'm currently struggling with it too :/
Best,
Jen
I can but don't know what to type'
Did you try “.” or “(local)”?
Or close the dialog, go to Management Studio menu, View, Registered Servers, and see if server names were detected.
I get the following:
TITLE: Connect to Server
Cannot connect to C:\Program Files (x86)\Microsoft SQL Server.
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
BUTTONS:
OK
Doesn;t seem to be any detected
Is SQL Server installed on your computer or some other server?
I can but don't know what to type'
Well, you need to ask your DBA what is the name of the SQL Server instance you are supposed to connect to.
SSMS is only a query tool to connect to SQL Server. It is useless on its own. So if there is no SQL Server instance in your environment, you need to install one. Both SQL Server Express Edition and SQL Server Developer Edition are free. Developer is more versatile, but is not licensed for production. Express is limited, but is licensed for production.
Hi coolguy-3283,
Cannot connect to C:\Program Files (x86)\Microsoft SQL Server.
It seems the SQL Server instance name you want to connect to is incorrect.
When connecting to SQL Server, you must specify the name of the SQL Server instance. If the instance of SQL Server is the default instance, then specify the name of the computer where SQL Server is installed, or the IP address of the computer. If the instance of SQL Server is a named instance, then specify the name of the computer where SQL Server is installed or the IP address of the computer, and add a slash and the instance name (computername\instancename).
In addition, is your instance installed on local computer or remote computer?
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.