Problem logging on to SQL Server Manager Studio Express 2005 using Windows Authentication Mode
How do I logon to SQL Server Manager Studio Express 2005 using Windows Authentication Mode? When I try to logon I get the following error message
"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 corr开发者_如何学编程ect and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)"
Thank You,
NH
Check the server name. If it is your local server, try connecting to server name .
or (local)
, or .\SQLEXPRESS
if the server instance is names SQLEXPRESS
. If it is a remote server, you may have to enable some network protocols and/or enable remote connections on that server.
精彩评论