question

coolguy-3283 avatar image
0 Votes"
coolguy-3283 asked jenben1029-4633 commented

SQL Server v18.8 configuration manager

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

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


But can you type the server name manually?

0 Votes 0 ·

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

0 Votes 0 ·
coolguy-3283 avatar image
0 Votes"
coolguy-3283 answered Viorel-1 edited

I can but don't know what to type'

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Did you try “.” or “(local)”?

Or close the dialog, go to Management Studio menu, View, Registered Servers, and see if server names were detected.

0 Votes 0 ·
coolguy-3283 avatar image
0 Votes"
coolguy-3283 answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

coolguy-3283 avatar image
0 Votes"
coolguy-3283 answered Viorel-1 commented

Doesn;t seem to be any detected

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Is SQL Server installed on your computer or some other server?

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.