|
|
SQL Server does not allow remote connections Error 26
Sat, 08/14/2010 - 09:01
I am using "SQL Server 2005 Express edition" and "SQL Server Management Studio Express" on my windows 2003 server.I cretead a database user and gave it proper authorization.Now i am able to login in Management studio using new user but when i tried to make a connection from an application it throws following error.
Error :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)
Is there any setting which is required in order to allow remote connections.
Similar entries
- No process is on the otherend of the pipe Microsoft SQL Server Error: 233
- How to resolve "Failed to generate a user instance of SQL Server due to failure in
- solution to winsock error
- IIS problem:The Web server reported the following error
- Script action to job in Server Management Studio Express
- 500 - Internal server error generic error message in ASP pages
- How to enable user instance in SQL Server
- connection with the server could not be established asp.net web application
- database restore from .bak file problem
- windows 2003 shares Error 2114: ther server service is not startd
in my case solution which workedout is
In START menu go to Microsoft SQL server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration
Click on "Surface Area Configuration for Services and Connections" link
in SQL Server Surface Area Configuration window go to SQLEXPRESS -> Database Engine -> Remote Connections
Select "Local and remote connections" Select protocols as per requirement.