Sunday, March 11, 2012

connection going to sleep?

Ok, here's the scenario. On a Windows 2003 Server I have MSSQL 2000
installed. On another test server I have Windows 2003 server, IIS 6 and
Coldfusion installed. There has been an account created in SQL and assigned
permissions. My coldfusion web site makes multiple calls to the database
server using the account created. All is wonderful. Then, all of a sudden
I start getting connection problems (SQL STATE: HTY00). My web site cannot
connect using that account. I can still ping the SQL server from the
development server so I know thats not the problem. So I tried creating an
ODBC connection using that account. Same error. Sometimes resetting the
password in SQL works. A few days ago, however, I had to reboot the SQL
server and now everything is fine again, until the next time. Can anyone
explain to me why that user account seems to "goes to sleep" every few
days' There have been occasions when it's been fine for a week or two
but sooner or later, it will always do this!when you're dealing with connection problems it helps to do things like:
* try the connection from a different client
* check to see if you can connect from other accounts
* check to see if you can connect from a Windows and/or SQL authenticated
account
* check the SQL Server error logs for messages....
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Steve" <StephenGL@.sabian.ca> wrote in message
news:5Lovb.33154$R13.985896@.ursa-nb00s0.nbnet.nb.ca...
> Ok, here's the scenario. On a Windows 2003 Server I have MSSQL 2000
> installed. On another test server I have Windows 2003 server, IIS 6 and
> Coldfusion installed. There has been an account created in SQL and
assigned
> permissions. My coldfusion web site makes multiple calls to the database
> server using the account created. All is wonderful. Then, all of a
sudden
> I start getting connection problems (SQL STATE: HTY00). My web site
cannot
> connect using that account. I can still ping the SQL server from the
> development server so I know thats not the problem. So I tried creating
an
> ODBC connection using that account. Same error. Sometimes resetting the
> password in SQL works. A few days ago, however, I had to reboot the SQL
> server and now everything is fine again, until the next time. Can anyone
> explain to me why that user account seems to "goes to sleep" every few
> days' There have been occasions when it's been fine for a week or two
> but sooner or later, it will always do this!
>

No comments:

Post a Comment