Connection String will not connect from ASP.NET

  • Thread starter Thread starter david.penty
  • Start date Start date
D

david.penty

I have been using the following connection string to connect to sql
server from an asp.net page:

packet size=4096;user id=xxxxxx;data source=w2k3bspsqldevvs;persist
security info=True;initial catalog=xxxxxx;password=xxxxxx

It worked perfectly well. I had a week off and now the asp.net page
will no longer connect to the sql server.

If I create a c# desktop app and use the connection string above then
it works.

If I create a new asp.net page and use the connection string then it
doesn't work.

I found a similar message in this group entitled "ASP.NET Connection
String" - the solution was to restart the SQL Server. Unfortunately my
sql server is in a cluster and never gets rebooted.

Any one got any ideas?

Thanks
 
On 2 Mar 2006 07:01:34 -0800, (e-mail address removed) wrote:

¤ I have been using the following connection string to connect to sql
¤ server from an asp.net page:
¤
¤ packet size=4096;user id=xxxxxx;data source=w2k3bspsqldevvs;persist
¤ security info=True;initial catalog=xxxxxx;password=xxxxxx
¤
¤ It worked perfectly well. I had a week off and now the asp.net page
¤ will no longer connect to the sql server.
¤
¤ If I create a c# desktop app and use the connection string above then
¤ it works.
¤
¤ If I create a new asp.net page and use the connection string then it
¤ doesn't work.
¤
¤ I found a similar message in this group entitled "ASP.NET Connection
¤ String" - the solution was to restart the SQL Server. Unfortunately my
¤ sql server is in a cluster and never gets rebooted.
¤

Sounds like it might be a system configuration issue. What is the exact error you encounter when the
attempted connection fails?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
I have checked the config file, it's fine.
There are no firewall issues as this is all on an internal network

The error that I get is: System.Data.SqlClient.SqlException: SQL Server
does not exist or access denied.
 
Back
Top