SQL Sever Instance is showing blank. How to get it
Question
Thursday, August 1, 2019 2:04 AM
In SQL Server 2017, the SQL Server Name is blank. I don't know how to get the sql server name so that I could connect it with the database. Any help would be appreciated.....
All replies (3)
Thursday, August 1, 2019 4:59 AM ✅Answered | 1 vote
Is that EXPRESS Edition? This can be because only the SQL Server Management Studio is installed and not SQL Server
>>>so that I could connect it with the database
Open the Services management console and look for the SQL Server service. The instance name will be displayed next to it.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
Thursday, August 1, 2019 5:09 AM ✅Answered | 1 vote
In SQL Server 2017, the SQL Server Name is blank. I don't know how to get the sql server name so that I could connect it with the database. Any help would be appreciated.....
Have you installed SQL 2017 or just SQL Management studio?
If SQL 2017 is installed with default instance, then enter localhost OR . OR machine name in Server name text box and click on connect.
Check this:
https://stackoverflow.com/questions/16088151/how-to-find-server-name-of-sql-server-management-studio
Cheers
Vaibhav
MCSA (SQL Server 2012)
Friday, August 2, 2019 3:37 AM ✅Answered | 1 vote
Hi Rajat_Agarwal,
>>I don't know how to get the sql server name so that I could connect it with the database.
If you have installed SQL server instance successfully. You can get the SQL server name from SQL server configure manager or SQL Server Management Studio like below screenshot.
Note: If you get the name from SSCM and your SQL server instance is not default instance ( MSSQLSERVER), you need to use machine name\server name to connect SQL server. For example, in my environment machine name is Node1, SQL server name is SQL2017 in SSCM, so I use Node1\SQL2017 to connect SQL server. If your SQL server is default instance, as Vaibhav mentioned, you can enter localhost OR . OR machine name in Server name text box and click on connect.
Best regards,
Cathy Ji
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com