Monday, February 27, 2012

Help!

Our sql server started to this...
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
We added new, quite huge sql-based site to our iis farm and after that we
get some times these error messages. Pages wich report these erros are fully
working. Why do get these errors? In last day we have recieved about ten of
these erors. Eroros are coming from all kins of asp. and .net pages at the
same time. After error occusr everything works fine again.
Wha can we do to prevent this happening? What causes these type of error
messages?
Server and connection strings are configured well, this is not error of miss
spelled program or connectionstrings. Theese erros are caused somewhere
else.
tHi
DSN, Did you configure an alias in Client Network Utility?
"TLehtinen" <timo@.raa.to> wrote in message
news:44155ecc$0$7489$39db0f71@.news.song.fi...
> Our sql server started to this...
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> We added new, quite huge sql-based site to our iis farm and after that we
> get some times these error messages. Pages wich report these erros are
> fully working. Why do get these errors? In last day we have recieved about
> ten of these erors. Eroros are coming from all kins of asp. and .net pages
> at the same time. After error occusr everything works fine again.
> Wha can we do to prevent this happening? What causes these type of error
> messages?
>
> Server and connection strings are configured well, this is not error of
> miss spelled program or connectionstrings. Theese erros are caused
> somewhere else.
>
> t
>|||Hello!
alias?
Everything has worked fine before we added this quite huge new web page
thing... Now pages applications that have worked before are reporting theese
error. not all the time only about ten error / day (and we do have now quite
a bit of transactions).
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
> Hi
> DSN, Did you configure an alias in Client Network Utility?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that we
>> get some times these error messages. Pages wich report these erros are
>> fully working. Why do get these errors? In last day we have recieved
>> about ten of these erors. Eroros are coming from all kins of asp. and
>> .net pages at the same time. After error occusr everything works fine
>> again.
>> Wha can we do to prevent this happening? What causes these type of error
>> messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>|||The error is pretty clear. It could not find the server. Did you connect to
SQL Server on this (new one) web page?
"TLehtinen" <timo@.raa.to> wrote in message
news:441564a0$0$7479$39db0f71@.news.song.fi...
> Hello!
> alias?
> Everything has worked fine before we added this quite huge new web page
> thing... Now pages applications that have worked before are reporting
> theese error. not all the time only about ten error / day (and we do have
> now quite a bit of transactions).
>
> T
>
> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have recieved
>> about ten of these erors. Eroros are coming from all kins of asp. and
>> .net pages at the same time. After error occusr everything works fine
>> again.
>> Wha can we do to prevent this happening? What causes these type of error
>> messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>>
>|||aargh!!
Yes I know it seems like pretty clear to you and to me. But theese erros are
not systmaticly hapepening. These erros are occuring becouse of something
else. But what is that something else?
Normally every page are workin fine then I see from our eroor log that in
same minute (in same ten seconds) many applications are reporting this
error. And after that many hours without errors...
Does SQL server report theese erros if there is too much load on that time?
Or what might cause theese erros...
t
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestissä:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl...
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>> Hello!
>> alias?
>> Everything has worked fine before we added this quite huge new web page
>> thing... Now pages applications that have worked before are reporting
>> theese error. not all the time only about ten error / day (and we do have
>> now quite a bit of transactions).
>>
>> T
>>
>> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
>> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have
>> recieved about ten of these erors. Eroros are coming from all kins of
>> asp. and .net pages at the same time. After error occusr everything
>> works fine again.
>> Wha can we do to prevent this happening? What causes these type of
>> error messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>>
>>
>|||Could my prblem be related to this?
http://support.microsoft.com/default.aspx?scid=kb;en-us;328476
We have one SQL-server and 2 separate iis server as cluster. I run netstat
and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session
open to our SQLserver. What shoud I do to prevent these erros happening?
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestissä:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl...
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>> Hello!
>> alias?
>> Everything has worked fine before we added this quite huge new web page
>> thing... Now pages applications that have worked before are reporting
>> theese error. not all the time only about ten error / day (and we do have
>> now quite a bit of transactions).
>>
>> T
>>
>> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
>> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have
>> recieved about ten of these erors. Eroros are coming from all kins of
>> asp. and .net pages at the same time. After error occusr everything
>> works fine again.
>> Wha can we do to prevent this happening? What causes these type of
>> error messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>>
>>
>

No comments:

Post a Comment