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

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

Total members: 149203
Average new registrations per day (in last 7 days): 122

New Registration: Open

Register Now

Learn Windows 7: Windows Defender Features in Windows 7 This article explains about the Windows Defender which protects your Windows operating system against pop-ups, spyware, malware and other unwanted softwares.Windows Defender has some new feature in its latest OS Windows 7

Want to become a DBA ? SQL Server 2008 training courses - by AspSpider team

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.