Connection String will not connect from ASP.NET

2 Mar 2006 3:01 PM

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

2 Mar 2006 4:09 PM

Paul Clement

On 2 Mar 2006 07:01:34 -0800, david.pe***@bl.uk 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)

2 Mar 2006 9:56 PM

Miha Markic [MVP C#]

Sounds to me like security issue.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message
news:u36e029fj6kd0u4honspq9ge4j6l39tpfa@4ax.com...
> On 2 Mar 2006 07:01:34 -0800, david.pe***@bl.uk 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)

6 Mar 2006 9:43 AM

Fillostein

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.