How to configure sql server 2005 For Remote Connection.

[manish m meshram]

How to configure sql server 2005 For Remote Connection. I have to access local sql server with web Aplication.

[sashidhar]

This Might Help http://www.scrumdesk.com/Articles/HowToEnableSQLServerRemoteConnections.html[^] http://www.datamasker.com/SSE2005_NetworkCfg.htm[^] http://support.microsoft.com/kb/914277[^]

[manish m meshram]

Hello Sir I had tried All This link, But it is not working. My Sqlserver is on local machine which is connected in a netork. On which internet connection is through D-link router. i am passing user id and password also. I want to access sqlserver 2005 through internet (i.e Web application) it gives following eror 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)

[sashidhar]

Sorry Dude I dont Know the Answer U better Post this Question in System Admin Blog or General Datase blog Rather Than Asp.net Blog