connecting to local sql server 2005 from website

[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)

[dan sh]

1. Is your connection string correct? (the server name, credentials etc.) 2. Is the server running? (Check the related services) 3. Have you enabled remote connectivity? (It is disabled by default and can be enable using Surface Area Configuration) Hope this helps.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[manish m meshram]

Hi, Yes My Connection Sting Is Correct. And My Server is Also Running, Yes I enable Remote Connectivity, I created A Website , When i run it from local network it execute properly. When i run it from Internet it gives following Error: 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) Thank You

[dan sh]

Well, to connect to remote SQL server, all you need is IP address of the server, port number(1433 by default) and credentials. Is your server behind firewall? See this[^] link.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[manish m meshram]

No, My Firwall is Off

[dan sh]

Is the SQL browser service on? Seriously, if these things are correct then you should be able to connect to the server. If you are using ASP.Net, check out the membership provider and role provider properties as well.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[Vimalsoft Pty Ltd]

Try to ping that server with its name from different locations and see if you can see it

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[manish m meshram]

Yes SQL browser service is On

[i i i]

Try to do this we use to do connect to remote servers and uses odbc connection your port address should be 1433 goto SQL Server Configuration Manager ----> Network configuration ------> Protocols for your Server and see Named Pipes and TCPIP should be enable , you can use either one of them at a time also make sure you to check aliases and your SQL Browser is running and in connection string try server name like ".\SQLServer" not "machineName\instanceName" and are you using sql express then also see your configuration file located in C:\WINDOWS\Microsoft.NET\Framework\yourFrameWOrkVersion I hope so it will solve the problem

Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...