Error while connecting to database, Need support urgently in ASP.NET

Control Panel Forum Hosting Help ASP.NET 4 & SQL 2008 R2 Hosting Resources Notice

Total members: 210361
Average new registrations per day (in last 7 days): 16

New Registration: Open

Register Now

Home » Questions & Answers » Error while connecting to database, Need support urgently

Error while connecting to database, Need support urgently

3/9/2010

Author: Angel Group

Hi,

I have uploaded a site with URL http://aspspider.info/OurExpenseManager/test.aspx. If you go to this URL you will notice the connecting string I am using is in sync with the one available in tips. Still I am getting the following error, please help

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Answers .............

Author: Ahmed Talu

Posted Date: 3/13/2010

*************************************************

Angel Group

You write that your connection string is "is in sync with the one available in tips". Since you did not post your connection string I will post it below.

If your SQL database is called xxxx.mdf then your connections string at ASPSPIDER will be:
"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=OurExpenseManager_xxxx"

I've posted some more comments about use of SQL in this thread: http://www.aspspider.com/qa/Question4644.aspx .

*************************************************

You must login to post answer for this question.