Category: sql server express
RTCary on Wed, 23 Jan 2013 16:15:55
This is my first encounter with Windows 8 and installing SQL Server Express 2012 (use to using LAN). I want ot have SQL Server on my Windows 8 notebook for test applications. I downloaded and installed SQLManagementStudio_x86_ENU and SQLEXPR_x86_ENU however when I try to connect the Studio to the DB, I get an error:
TITLE: Connect to Server
Cannot connect to SPEEDY\SQLEXPRESS.
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
Any help would be appreciated...
Janos Berke on Wed, 23 Jan 2013 16:44:25
Can you start the SQL Server configuration manager and check whether the SQL Server (SQLEXPRESS) service is started?
Maggie Luo on Fri, 25 Jan 2013 07:40:05
Did you connect to local database or remote database?
In a word, the reason that we get this error message is the client stack could not receive SSRP response UDP packet from SQL Browser.
If you connect to remote database, here are the steps:
1) Make sure your server name is correct, e.g., no typo on the name.
2) Make sure your instance name is correct and there is actually such an instance on your target machine.
3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
4) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.
For more information, please refer to http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx.
If you connect to local database, please make sure database engine is running and Shared Memory protocol is enabled. And use ComputerName\InstanceName to connect the database engine.