Connection String will not connect from ASP.NET

2 Mar 2006 3:02 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 7:10 PM

W.G. Ryan - MVP

David:

Like Paul mentioned, check the config file if you're using it.
If not, is there any chance that some ports have been blocked by the
firewall while you were away?

<david.pe***@bl.uk> wrote in message
Show quote

news:1141311747.539663.19540@v46g2000cwv.googlegroups.com...
>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
>