Dear all,
I have installed sql server 2005 Express with SQLADV.exe. But when I open Management Studio Express it has error:
Can not connect to server
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified).
I searched on google but did not find any solution. Anyone know about that, please help me.
check this link http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx
there are few things to be done to access database engine
(a) Remote connection to be enabled
(b) Create exception if firewall is enabled on this srever
(c) start SQL Browser service
(d) check the protocols
Madhu
|||Dear Madhu K Nair,
I just use my local computer to test, how can I check for protocol and should I do it. Now I just use my computer to create a website and database in my computer too.
|||check this http://support.microsoft.com/kb/914277
Madhu
|||Please check my blog for this:
http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
No comments:
Post a Comment