I have designed a website ASP.NET and in the website I have made a contact and username and password form. I have created the database file Sql. Now i am getting below mentioned error in remote server, locally it works fine.

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

Please explain me how to solve this error.

Thanking you,
Apurva

That error literally means your application is unable to locate the Server you specified. This can be caused by a myraid of reasons most noteably: you have specificed an incorrect server name, the web server that you are getting the error from cant "see" the sql server, and so on.

Are you actually using SQL Server or are you attaching an MDF to some instance of SQL Server on the web server?

-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

Thank you Mr. Doug for your immediate response.

I am not using Sql server. We have taken web server space to host our website. I am just attaching the MDF file.

I have with me Sql server IP address, port no., UserID and Password with me.

Pl. let me know how to proceed further.

Thanking you,

Apurva

Apurva:
Where does the .mdf file reside? It is not clear from your question.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

The .mdf file is resided in App_Data folder.

Dear p2p forum,

I am eagerly awaiting for the answer about my query on above said subject. I have intimated you that the .mdf file is resided in the App_Data folder.

I hope the all the details like sql server IP address, port, UserId, and password should be written in web.config file. But I am not clear.

Pl. help me out and indicate the way the path to be written.

Thanking you,

Apurva

Apurva:

Scroll to the list of "Similar Threads", located at the bottom of your thread. Click the thread by fs22. Open the thread, then scroll to the bottom again for the list of "Similar Threads"'. Open the thread entitled "connection strings issues, web.config issues. Planoie suggests two web sites to visit. In your case, the following url is very helpful: http://www.connections.com/ . Check it out.


Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.