Hi, I have a web application which is taking a fair bit of traffic.
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP pages
are returning that the SQL server does not exist or that access if denied.
Having explored the Microsoft Support Site, and exhausted all possible
solutions, without actually reaching a solution - I was wondering - is it
possible that the server is actually just taking so many requests that it
can't be found? Surely this should return a timeout?
The web box is a Windows 2000 IIS installation, and the SQL box is a
separate Windows 2000 / SQL Server 2000 installation.
Anyone got any ideas?
Many thanks.
MattWhat are you using to handle connections -- TCP/IP sockets, named pipes or
both? I would double check your IIS server and SQL server to make sure the
server and client network utilities match up with connection parameters.
Have you tried using Performance Monitor on the SQL server? You will take a
small performance hit, but you can get some more information on what is
happening when the connection fails. You should probably start off
monitoring a few basic SQL counters -- like for reads, writes and
connections.
When a SQL connection can't be made, the SQL server does not exist or access
denied is actually a common error. In my line of support, it usually means
that a network connection (ipc$) between the client and server can't be
made, but I imagine this is not the case for you.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Matt Pallatt" <matt.pallatt@.bnm.co.uk> wrote in message
news:%23ZMUOpzQEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi, I have a web application which is taking a fair bit of traffic.
> It involves a registration process, and then a series of questions which
> must be answered. The SQL server receives upwards of 1,000,000 queries a
> day.
> Unfortunately on a small number of these queries (~500 a day), the ASP
pages
> are returning that the SQL server does not exist or that access if denied.
> Having explored the Microsoft Support Site, and exhausted all possible
> solutions, without actually reaching a solution - I was wondering - is it
> possible that the server is actually just taking so many requests that it
> can't be found? Surely this should return a timeout?
> The web box is a Windows 2000 IIS installation, and the SQL box is a
> separate Windows 2000 / SQL Server 2000 installation.
> Anyone got any ideas?
> Many thanks.
> Matt
>|||So connection/session pooling should be in use for large web based
applications. If you've disabled connection/session pooling then this
would put a heavier burden on the server.
What is your connection Timeout value?
What is running on the server when the timeouts happen?
Is there any blocking?
How many web servers are connecting to the SQL Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||We were having the exact same problem. It seems that by stopping SQL Server
from listening on named pipes (ie. just leaving tcp/ip) stopped the problem|||Sorry, may have spoken too soon. Our error have come back.
Showing posts with label denied. Show all posts
Showing posts with label denied. Show all posts
Friday, March 30, 2012
Intermittent SQL Server does not exist or access denied.
ASP.NET application with intermittent returns of 503 errors with the
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Servers running Windows 2003 SQL 2000.
This has been a problem for a long time (less than .3% of the time). No
code changes have been made. The only changes was Windows SP1 and post
SP patches on all servers. The patching may have made this issue more
pronounced.
Any suggestions from the experts?
Thanks,
RoxanneWhen they are intermittent they are difficult to track down.
Often those related to network connectivity issues. Have you
checked the event logs on the IIS box - particularly looking
for any network related issues?
-Sue
On 2 Nov 2005 10:32:52 -0800, roxy636@.yahoo.com wrote:
>ASP.NET application with intermittent returns of 503 errors with the
>following message.
>System.Data.SqlClient.SqlException: SQL Server does not exist or access
>denied. SQL Server does not exist or access denied.
>An unhandled exception was generated during the execution of the
>current web request. Information regarding the origin and location of
>the exception can be identified using the exception stack trace below.
>Servers running Windows 2003 SQL 2000.
>This has been a problem for a long time (less than .3% of the time). No
>code changes have been made. The only changes was Windows SP1 and post
>SP patches on all servers. The patching may have made this issue more
>pronounced.
>Any suggestions from the experts?
>Thanks,
>Roxanne|||Search no further...
http://support.microsoft.com/defaul...kb;en-us;328476
Note, this answer took forever to find so I'm posting everywhere...|||So was your solution to enable connection pooling? Or was it simply a
tcp/ip configuration issue. Unless you explicitly disable connection
pooling, then connections should be pooled, were you disabling pooling?
Thanks for any info, we are seeing the exact same symptoms at a client
of ours.|||Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:
path:
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Ultimately is connection ooliing is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt...if you see around
4000 connections in TIME_WAIT, then that is the problem.|||Thanks, since connection pooling is enabled and this is occuring even
soon after a reboot under low load. I do not suspect we are creating
too many connections to sql, but I do suspect some network
communication problems. I am going to further diagnose thier network
configuration relative to the front and back planes of the web server.
But I will not overlook this as a possibility, so I will also get a
netstat -n Thanks so much for the info..|||Turned out to be Bandwidth Throttling, disabling that option for the
Application Pool alleviated the HTTP 503 errors.
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Servers running Windows 2003 SQL 2000.
This has been a problem for a long time (less than .3% of the time). No
code changes have been made. The only changes was Windows SP1 and post
SP patches on all servers. The patching may have made this issue more
pronounced.
Any suggestions from the experts?
Thanks,
RoxanneWhen they are intermittent they are difficult to track down.
Often those related to network connectivity issues. Have you
checked the event logs on the IIS box - particularly looking
for any network related issues?
-Sue
On 2 Nov 2005 10:32:52 -0800, roxy636@.yahoo.com wrote:
>ASP.NET application with intermittent returns of 503 errors with the
>following message.
>System.Data.SqlClient.SqlException: SQL Server does not exist or access
>denied. SQL Server does not exist or access denied.
>An unhandled exception was generated during the execution of the
>current web request. Information regarding the origin and location of
>the exception can be identified using the exception stack trace below.
>Servers running Windows 2003 SQL 2000.
>This has been a problem for a long time (less than .3% of the time). No
>code changes have been made. The only changes was Windows SP1 and post
>SP patches on all servers. The patching may have made this issue more
>pronounced.
>Any suggestions from the experts?
>Thanks,
>Roxanne|||Search no further...
http://support.microsoft.com/defaul...kb;en-us;328476
Note, this answer took forever to find so I'm posting everywhere...|||So was your solution to enable connection pooling? Or was it simply a
tcp/ip configuration issue. Unless you explicitly disable connection
pooling, then connections should be pooled, were you disabling pooling?
Thanks for any info, we are seeing the exact same symptoms at a client
of ours.|||Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:
path:
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Ultimately is connection ooliing is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt...if you see around
4000 connections in TIME_WAIT, then that is the problem.|||Thanks, since connection pooling is enabled and this is occuring even
soon after a reboot under low load. I do not suspect we are creating
too many connections to sql, but I do suspect some network
communication problems. I am going to further diagnose thier network
configuration relative to the front and back planes of the web server.
But I will not overlook this as a possibility, so I will also get a
netstat -n Thanks so much for the info..|||Turned out to be Bandwidth Throttling, disabling that option for the
Application Pool alleviated the HTTP 503 errors.
Intermittent SQL Server does not exist or access denied.
ASP.NET application with intermittent returns of 503 errors with the
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Servers running Windows 2003 SQL 2000.
This has been a problem for a long time (less than .3% of the time). No
code changes have been made. The only changes was Windows SP1 and post
SP patches on all servers. The patching may have made this issue more
pronounced.
Any suggestions from the experts?
Thanks,
Roxanne
When they are intermittent they are difficult to track down.
Often those related to network connectivity issues. Have you
checked the event logs on the IIS box - particularly looking
for any network related issues?
-Sue
On 2 Nov 2005 10:32:52 -0800, roxy636@.yahoo.com wrote:
>ASP.NET application with intermittent returns of 503 errors with the
>following message.
>System.Data.SqlClient.SqlException: SQL Server does not exist or access
>denied. SQL Server does not exist or access denied.
>An unhandled exception was generated during the execution of the
>current web request. Information regarding the origin and location of
>the exception can be identified using the exception stack trace below.
>Servers running Windows 2003 SQL 2000.
>This has been a problem for a long time (less than .3% of the time). No
>code changes have been made. The only changes was Windows SP1 and post
>SP patches on all servers. The patching may have made this issue more
>pronounced.
>Any suggestions from the experts?
>Thanks,
>Roxanne
|||Search no further...
http://support.microsoft.com/default...b;en-us;328476
Note, this answer took forever to find so I'm posting everywhere...
|||So was your solution to enable connection pooling? Or was it simply a
tcp/ip configuration issue. Unless you explicitly disable connection
pooling, then connections should be pooled, were you disabling pooling?
Thanks for any info, we are seeing the exact same symptoms at a client
of ours.
|||Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:
path:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\servic es\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Ultimately is connection ooliing is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt...if you see around
4000 connections in TIME_WAIT, then that is the problem.
|||Thanks, since connection pooling is enabled and this is occuring even
soon after a reboot under low load. I do not suspect we are creating
too many connections to sql, but I do suspect some network
communication problems. I am going to further diagnose thier network
configuration relative to the front and back planes of the web server.
But I will not overlook this as a possibility, so I will also get a
netstat -n Thanks so much for the info..
|||Turned out to be Bandwidth Throttling, disabling that option for the
Application Pool alleviated the HTTP 503 errors.
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Servers running Windows 2003 SQL 2000.
This has been a problem for a long time (less than .3% of the time). No
code changes have been made. The only changes was Windows SP1 and post
SP patches on all servers. The patching may have made this issue more
pronounced.
Any suggestions from the experts?
Thanks,
Roxanne
When they are intermittent they are difficult to track down.
Often those related to network connectivity issues. Have you
checked the event logs on the IIS box - particularly looking
for any network related issues?
-Sue
On 2 Nov 2005 10:32:52 -0800, roxy636@.yahoo.com wrote:
>ASP.NET application with intermittent returns of 503 errors with the
>following message.
>System.Data.SqlClient.SqlException: SQL Server does not exist or access
>denied. SQL Server does not exist or access denied.
>An unhandled exception was generated during the execution of the
>current web request. Information regarding the origin and location of
>the exception can be identified using the exception stack trace below.
>Servers running Windows 2003 SQL 2000.
>This has been a problem for a long time (less than .3% of the time). No
>code changes have been made. The only changes was Windows SP1 and post
>SP patches on all servers. The patching may have made this issue more
>pronounced.
>Any suggestions from the experts?
>Thanks,
>Roxanne
|||Search no further...
http://support.microsoft.com/default...b;en-us;328476
Note, this answer took forever to find so I'm posting everywhere...
|||So was your solution to enable connection pooling? Or was it simply a
tcp/ip configuration issue. Unless you explicitly disable connection
pooling, then connections should be pooled, were you disabling pooling?
Thanks for any info, we are seeing the exact same symptoms at a client
of ours.
|||Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:
path:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\servic es\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Ultimately is connection ooliing is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt...if you see around
4000 connections in TIME_WAIT, then that is the problem.
|||Thanks, since connection pooling is enabled and this is occuring even
soon after a reboot under low load. I do not suspect we are creating
too many connections to sql, but I do suspect some network
communication problems. I am going to further diagnose thier network
configuration relative to the front and back planes of the web server.
But I will not overlook this as a possibility, so I will also get a
netstat -n Thanks so much for the info..
|||Turned out to be Bandwidth Throttling, disabling that option for the
Application Pool alleviated the HTTP 503 errors.
Intermittent SQL Server does not exist or access denied.
Hi, I have a web application which is taking a fair bit of traffic.
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP pages
are returning that the SQL server does not exist or that access if denied.
Having explored the Microsoft Support Site, and exhausted all possible
solutions, without actually reaching a solution - I was wondering - is it
possible that the server is actually just taking so many requests that it
can't be found? Surely this should return a timeout?
The web box is a windows 2000 IIS installation, and the SQL box is a
separate Windows 2000 / SQL Server 2000 installation.
Anyone got any ideas?
Many thanks.
Matt
What are you using to handle connections -- TCP/IP sockets, named pipes or
both? I would double check your IIS server and SQL server to make sure the
server and client network utilities match up with connection parameters.
Have you tried using Performance Monitor on the SQL server? You will take a
small performance hit, but you can get some more information on what is
happening when the connection fails. You should probably start off
monitoring a few basic SQL counters -- like for reads, writes and
connections.
When a SQL connection can't be made, the SQL server does not exist or access
denied is actually a common error. In my line of support, it usually means
that a network connection (ipc$) between the client and server can't be
made, but I imagine this is not the case for you.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Matt Pallatt" <matt.pallatt@.bnm.co.uk> wrote in message
news:%23ZMUOpzQEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi, I have a web application which is taking a fair bit of traffic.
> It involves a registration process, and then a series of questions which
> must be answered. The SQL server receives upwards of 1,000,000 queries a
> day.
> Unfortunately on a small number of these queries (~500 a day), the ASP
pages
> are returning that the SQL server does not exist or that access if denied.
> Having explored the Microsoft Support Site, and exhausted all possible
> solutions, without actually reaching a solution - I was wondering - is it
> possible that the server is actually just taking so many requests that it
> can't be found? Surely this should return a timeout?
> The web box is a windows 2000 IIS installation, and the SQL box is a
> separate Windows 2000 / SQL Server 2000 installation.
> Anyone got any ideas?
> Many thanks.
> Matt
>
|||So connection/session pooling should be in use for large web based
applications. If you've disabled connection/session pooling then this
would put a heavier burden on the server.
What is your connection Timeout value?
What is running on the server when the timeouts happen?
Is there any blocking?
How many web servers are connecting to the SQL Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||We were having the exact same problem. It seems that by stopping SQL
Server from listening on named pipes (ie. just leaving tcp/ip) stopped
the problem
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
|||Sorry, may have spoken too soon. Our error have come back.
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP pages
are returning that the SQL server does not exist or that access if denied.
Having explored the Microsoft Support Site, and exhausted all possible
solutions, without actually reaching a solution - I was wondering - is it
possible that the server is actually just taking so many requests that it
can't be found? Surely this should return a timeout?
The web box is a windows 2000 IIS installation, and the SQL box is a
separate Windows 2000 / SQL Server 2000 installation.
Anyone got any ideas?
Many thanks.
Matt
What are you using to handle connections -- TCP/IP sockets, named pipes or
both? I would double check your IIS server and SQL server to make sure the
server and client network utilities match up with connection parameters.
Have you tried using Performance Monitor on the SQL server? You will take a
small performance hit, but you can get some more information on what is
happening when the connection fails. You should probably start off
monitoring a few basic SQL counters -- like for reads, writes and
connections.
When a SQL connection can't be made, the SQL server does not exist or access
denied is actually a common error. In my line of support, it usually means
that a network connection (ipc$) between the client and server can't be
made, but I imagine this is not the case for you.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Matt Pallatt" <matt.pallatt@.bnm.co.uk> wrote in message
news:%23ZMUOpzQEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi, I have a web application which is taking a fair bit of traffic.
> It involves a registration process, and then a series of questions which
> must be answered. The SQL server receives upwards of 1,000,000 queries a
> day.
> Unfortunately on a small number of these queries (~500 a day), the ASP
pages
> are returning that the SQL server does not exist or that access if denied.
> Having explored the Microsoft Support Site, and exhausted all possible
> solutions, without actually reaching a solution - I was wondering - is it
> possible that the server is actually just taking so many requests that it
> can't be found? Surely this should return a timeout?
> The web box is a windows 2000 IIS installation, and the SQL box is a
> separate Windows 2000 / SQL Server 2000 installation.
> Anyone got any ideas?
> Many thanks.
> Matt
>
|||So connection/session pooling should be in use for large web based
applications. If you've disabled connection/session pooling then this
would put a heavier burden on the server.
What is your connection Timeout value?
What is running on the server when the timeouts happen?
Is there any blocking?
How many web servers are connecting to the SQL Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||We were having the exact same problem. It seems that by stopping SQL
Server from listening on named pipes (ie. just leaving tcp/ip) stopped
the problem
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
|||Sorry, may have spoken too soon. Our error have come back.
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
intermittent SQL Server does not exist or access denied
Hi,
We seperated out our web server (IIS) from our SQL Server recently. Things
have gone well, except one thing. Intermittently, we get the message "SQL
Server does not exist or access denied" when users try to get to the site.
The two machines are connected via a 1GBps direct connection. We've seen
high usage of that connection at times when this has happened, but not
always. Does anyone have any ideas?
Here's the connection string...
"Provider=SQLOLEDB;User ID=our_db_user;Initial
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
rd"
Thanks in advance.
JoshNo one has any ideas?
"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> Hi,
> We seperated out our web server (IIS) from our SQL Server recently.
Things
> have gone well, except one thing. Intermittently, we get the message
"SQL
> Server does not exist or access denied" when users try to get to the site.
> The two machines are connected via a 1GBps direct connection. We've seen
> high usage of that connection at times when this has happened, but not
> always. Does anyone have any ideas?
> Here's the connection string...
> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
> rd"
> Thanks in advance.
> Josh
>|||Try the following troubleshooting article:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>No one has any ideas?
>"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> Hi,
>> We seperated out our web server (IIS) from our SQL Server recently.
>Things
>> have gone well, except one thing. Intermittently, we get the message
>"SQL
>> Server does not exist or access denied" when users try to get to the site.
>> The two machines are connected via a 1GBps direct connection. We've seen
>> high usage of that connection at times when this has happened, but not
>> always. Does anyone have any ideas?
>> Here's the connection string...
>> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
>> rd"
>> Thanks in advance.
>> Josh
>>
>|||Thanks for the info, Sue.
I think most of those are for cases where you can't EVER connect.
Unfortunately, ours is only intermittant. It seems like the number of
connections jumps up when it happens, too. Any thoughts?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
> Try the following troubleshooting article:
> INF: Potential Causes of the "SQL Server Does Not Exist or
> Access Denied" Error Message
> http://support.microsoft.com/?id=328306
> -Sue
> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
> <josh@.sparkpeople.com> wrote:
> >No one has any ideas?
> >
> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> >> Hi,
> >>
> >> We seperated out our web server (IIS) from our SQL Server recently.
> >Things
> >> have gone well, except one thing. Intermittently, we get the message
> >"SQL
> >> Server does not exist or access denied" when users try to get to the
site.
> >> The two machines are connected via a 1GBps direct connection. We've
seen
> >> high usage of that connection at times when this has happened, but not
> >> always. Does anyone have any ideas?
> >>
> >> Here's the connection string...
> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
> >>
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
o
> >> rd"
> >>
> >> Thanks in advance.
> >> Josh
> >>
> >>
> >
>|||You can still have intermittent problems with some of the
network related issues sited in the article. You may also
want to check the Windows event logs on both servers for any
network related issues.
-Sue
On Thu, 23 Oct 2003 14:42:31 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>Thanks for the info, Sue.
>I think most of those are for cases where you can't EVER connect.
>Unfortunately, ours is only intermittant. It seems like the number of
>connections jumps up when it happens, too. Any thoughts?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
>> Try the following troubleshooting article:
>> INF: Potential Causes of the "SQL Server Does Not Exist or
>> Access Denied" Error Message
>> http://support.microsoft.com/?id=328306
>> -Sue
>> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
>> <josh@.sparkpeople.com> wrote:
>> >No one has any ideas?
>> >
>> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> >> Hi,
>> >>
>> >> We seperated out our web server (IIS) from our SQL Server recently.
>> >Things
>> >> have gone well, except one thing. Intermittently, we get the message
>> >"SQL
>> >> Server does not exist or access denied" when users try to get to the
>site.
>> >> The two machines are connected via a 1GBps direct connection. We've
>seen
>> >> high usage of that connection at times when this has happened, but not
>> >> always. Does anyone have any ideas?
>> >>
>> >> Here's the connection string...
>> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>> >>
>>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
>o
>> >> rd"
>> >>
>> >> Thanks in advance.
>> >> Josh
>> >>
>> >>
>> >
>sql
We seperated out our web server (IIS) from our SQL Server recently. Things
have gone well, except one thing. Intermittently, we get the message "SQL
Server does not exist or access denied" when users try to get to the site.
The two machines are connected via a 1GBps direct connection. We've seen
high usage of that connection at times when this has happened, but not
always. Does anyone have any ideas?
Here's the connection string...
"Provider=SQLOLEDB;User ID=our_db_user;Initial
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
rd"
Thanks in advance.
JoshNo one has any ideas?
"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> Hi,
> We seperated out our web server (IIS) from our SQL Server recently.
Things
> have gone well, except one thing. Intermittently, we get the message
"SQL
> Server does not exist or access denied" when users try to get to the site.
> The two machines are connected via a 1GBps direct connection. We've seen
> high usage of that connection at times when this has happened, but not
> always. Does anyone have any ideas?
> Here's the connection string...
> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
> rd"
> Thanks in advance.
> Josh
>|||Try the following troubleshooting article:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>No one has any ideas?
>"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> Hi,
>> We seperated out our web server (IIS) from our SQL Server recently.
>Things
>> have gone well, except one thing. Intermittently, we get the message
>"SQL
>> Server does not exist or access denied" when users try to get to the site.
>> The two machines are connected via a 1GBps direct connection. We've seen
>> high usage of that connection at times when this has happened, but not
>> always. Does anyone have any ideas?
>> Here's the connection string...
>> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
>> rd"
>> Thanks in advance.
>> Josh
>>
>|||Thanks for the info, Sue.
I think most of those are for cases where you can't EVER connect.
Unfortunately, ours is only intermittant. It seems like the number of
connections jumps up when it happens, too. Any thoughts?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
> Try the following troubleshooting article:
> INF: Potential Causes of the "SQL Server Does Not Exist or
> Access Denied" Error Message
> http://support.microsoft.com/?id=328306
> -Sue
> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
> <josh@.sparkpeople.com> wrote:
> >No one has any ideas?
> >
> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> >> Hi,
> >>
> >> We seperated out our web server (IIS) from our SQL Server recently.
> >Things
> >> have gone well, except one thing. Intermittently, we get the message
> >"SQL
> >> Server does not exist or access denied" when users try to get to the
site.
> >> The two machines are connected via a 1GBps direct connection. We've
seen
> >> high usage of that connection at times when this has happened, but not
> >> always. Does anyone have any ideas?
> >>
> >> Here's the connection string...
> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
> >>
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
o
> >> rd"
> >>
> >> Thanks in advance.
> >> Josh
> >>
> >>
> >
>|||You can still have intermittent problems with some of the
network related issues sited in the article. You may also
want to check the Windows event logs on both servers for any
network related issues.
-Sue
On Thu, 23 Oct 2003 14:42:31 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>Thanks for the info, Sue.
>I think most of those are for cases where you can't EVER connect.
>Unfortunately, ours is only intermittant. It seems like the number of
>connections jumps up when it happens, too. Any thoughts?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
>> Try the following troubleshooting article:
>> INF: Potential Causes of the "SQL Server Does Not Exist or
>> Access Denied" Error Message
>> http://support.microsoft.com/?id=328306
>> -Sue
>> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
>> <josh@.sparkpeople.com> wrote:
>> >No one has any ideas?
>> >
>> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> >> Hi,
>> >>
>> >> We seperated out our web server (IIS) from our SQL Server recently.
>> >Things
>> >> have gone well, except one thing. Intermittently, we get the message
>> >"SQL
>> >> Server does not exist or access denied" when users try to get to the
>site.
>> >> The two machines are connected via a 1GBps direct connection. We've
>seen
>> >> high usage of that connection at times when this has happened, but not
>> >> always. Does anyone have any ideas?
>> >>
>> >> Here's the connection string...
>> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>> >>
>>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
>o
>> >> rd"
>> >>
>> >> Thanks in advance.
>> >> Josh
>> >>
>> >>
>> >
>sql
Wednesday, March 28, 2012
Intermittent error: SQL Server does not exist or access denied
I need some help. I've seen this error has randomly occured for many
people, but I still haven't found a solution that works. We have a new
web application that is load balanced between two new web servers,
which are located in a DMZ. This is the only website running on these
servers. It connects back to a SQL server which is located inside of
the network. The web servers are running Win2003 Server w/SP1, IIS 6.
The SQL Server is running Win2k Server / SQL 2000.
When logging into the site, it connects back to a database located on
the SQL server to retrieve login information. I'd say 90% of the time
it works fine, but other times when attempting login it will pause for
a few seconds and then eventually display the error "SQL Server Does
Not Exist or Access Denied." The stack trace is pointing back to the
database which contains the accounts. I've done quite a bit of
research on this and have already tried a few things. I've verified
that we are connecting via TCP/IP, and named pipes is blocked through
the firewall. I've also made these registry entries related to
connection pooling, which were suggested in the links below:
path:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21589707.html?query=random+error+sql+server+does+not+exist+or+access+denied&clearTAFilter=true#15305052
http://support.microsoft.com/?kbid=328476
Modifying the registry did not help, as the error still randomly pops
up. When running a netstat -n from the web servers, I do not see a
large amount of connections in the TIME_Wait state. As I said these are
load balanced web servers and we have generated the error after
connecting through each one at random times. There is no real pattern.
It can fail in one attempt, then I will try again a few seconds later
and it logs in just fine with no errors. I'm able to make succesful
test connections through ODBC and telnet from the web servers to the
SQL server. The database it is failing on is shared between other web
apps, but there does not appear to be a very high load when the errors
are occuring. If anyone has any other suggestions besides the ones
I've listed then I would love to hear them. This error seems to be
getting more and more common from the research I've done. If someone
is able to help me resolve this I will give you all the points I
possibly can!!
Please let me know if you need anymore info.To me that sounds like a network issue. I would try the basics,
changing network cables, switches, that sort of stuff.
people, but I still haven't found a solution that works. We have a new
web application that is load balanced between two new web servers,
which are located in a DMZ. This is the only website running on these
servers. It connects back to a SQL server which is located inside of
the network. The web servers are running Win2003 Server w/SP1, IIS 6.
The SQL Server is running Win2k Server / SQL 2000.
When logging into the site, it connects back to a database located on
the SQL server to retrieve login information. I'd say 90% of the time
it works fine, but other times when attempting login it will pause for
a few seconds and then eventually display the error "SQL Server Does
Not Exist or Access Denied." The stack trace is pointing back to the
database which contains the accounts. I've done quite a bit of
research on this and have already tried a few things. I've verified
that we are connecting via TCP/IP, and named pipes is blocked through
the firewall. I've also made these registry entries related to
connection pooling, which were suggested in the links below:
path:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21589707.html?query=random+error+sql+server+does+not+exist+or+access+denied&clearTAFilter=true#15305052
http://support.microsoft.com/?kbid=328476
Modifying the registry did not help, as the error still randomly pops
up. When running a netstat -n from the web servers, I do not see a
large amount of connections in the TIME_Wait state. As I said these are
load balanced web servers and we have generated the error after
connecting through each one at random times. There is no real pattern.
It can fail in one attempt, then I will try again a few seconds later
and it logs in just fine with no errors. I'm able to make succesful
test connections through ODBC and telnet from the web servers to the
SQL server. The database it is failing on is shared between other web
apps, but there does not appear to be a very high load when the errors
are occuring. If anyone has any other suggestions besides the ones
I've listed then I would love to hear them. This error seems to be
getting more and more common from the research I've done. If someone
is able to help me resolve this I will give you all the points I
possibly can!!
Please let me know if you need anymore info.To me that sounds like a network issue. I would try the basics,
changing network cables, switches, that sort of stuff.
Intermittent error: SQL Server does not exist or access denied
I need some help. I've seen this error has randomly occured for many
people, but I still haven't found a solution that works. We have a new
web application that is load balanced between two new web servers,
which are located in a DMZ. This is the only website running on these
servers. It connects back to a SQL server which is located inside of
the network. The web servers are running Win2003 Server w/SP1, IIS 6.
The SQL Server is running Win2k Server / SQL 2000.
When logging into the site, it connects back to a database located on
the SQL server to retrieve login information. I'd say 90% of the time
it works fine, but other times when attempting login it will pause for
a few seconds and then eventually display the error "SQL Server Does
Not Exist or Access Denied." The stack trace is pointing back to the
database which contains the accounts. I've done quite a bit of
research on this and have already tried a few things. I've verified
that we are connecting via TCP/IP, and named pipes is blocked through
the firewall. I've also made these registry entries related to
connection pooling, which were suggested in the links below:
path:
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
5052" target="_blank">http://www.experts-exchange.com/Dat...530
5052
http://support.microsoft.com/?kbid=328476
Modifying the registry did not help, as the error still randomly pops
up. When running a netstat -n from the web servers, I do not see a
large amount of connections in the TIME_Wait state. As I said these are
load balanced web servers and we have generated the error after
connecting through each one at random times. There is no real pattern.
It can fail in one attempt, then I will try again a few seconds later
and it logs in just fine with no errors. I'm able to make succesful
test connections through ODBC and telnet from the web servers to the
SQL server. The database it is failing on is shared between other web
apps, but there does not appear to be a very high load when the errors
are occuring. If anyone has any other suggestions besides the ones
I've listed then I would love to hear them. This error seems to be
getting more and more common from the research I've done. If someone
is able to help me resolve this I will give you all the points I
possibly can!!
Please let me know if you need anymore info.To me that sounds like a network issue. I would try the basics,
changing network cables, switches, that sort of stuff.
people, but I still haven't found a solution that works. We have a new
web application that is load balanced between two new web servers,
which are located in a DMZ. This is the only website running on these
servers. It connects back to a SQL server which is located inside of
the network. The web servers are running Win2003 Server w/SP1, IIS 6.
The SQL Server is running Win2k Server / SQL 2000.
When logging into the site, it connects back to a database located on
the SQL server to retrieve login information. I'd say 90% of the time
it works fine, but other times when attempting login it will pause for
a few seconds and then eventually display the error "SQL Server Does
Not Exist or Access Denied." The stack trace is pointing back to the
database which contains the accounts. I've done quite a bit of
research on this and have already tried a few things. I've verified
that we are connecting via TCP/IP, and named pipes is blocked through
the firewall. I've also made these registry entries related to
connection pooling, which were suggested in the links below:
path:
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
5052" target="_blank">http://www.experts-exchange.com/Dat...530
5052
http://support.microsoft.com/?kbid=328476
Modifying the registry did not help, as the error still randomly pops
up. When running a netstat -n from the web servers, I do not see a
large amount of connections in the TIME_Wait state. As I said these are
load balanced web servers and we have generated the error after
connecting through each one at random times. There is no real pattern.
It can fail in one attempt, then I will try again a few seconds later
and it logs in just fine with no errors. I'm able to make succesful
test connections through ODBC and telnet from the web servers to the
SQL server. The database it is failing on is shared between other web
apps, but there does not appear to be a very high load when the errors
are occuring. If anyone has any other suggestions besides the ones
I've listed then I would love to hear them. This error seems to be
getting more and more common from the research I've done. If someone
is able to help me resolve this I will give you all the points I
possibly can!!
Please let me know if you need anymore info.To me that sounds like a network issue. I would try the basics,
changing network cables, switches, that sort of stuff.
Monday, March 26, 2012
Intermittent "SQL Server does not exist or access denied."
I've seen this topic posted several times, but it seems my situation is
unique for every other case I've seen.
I have a web site that has been running for over 3 years. Recently, we've
hit a major spike in activity. Now, after a few days (sometimes less), the
site will start returning the following error:
SQL Server does not exist or access denied.
Here are my server specs:
WEB SERVER (Shuttle SK41G)
- Windows 2000 Server SP4 (IIS 5.0)
- Athlon XP 2100+
- 1GB RAM
- 80GB SATA HD (7200 RPM)
- All pages in ASP (traditional, not .NET)
- Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
- Zonet Gb PCI NIC - used for crossover connection to DB server
DATABASE SERVER (Dell PowerEdge SC420)
- Windows 2000 Server SP4
- MS SQL Server 2000 SP4
- Pentium 4 2.8 GHz
- 1GB RAM
- 2x 80GB SATA HD (7200 RPM), Raid 1
- Broadcom NetXtreme 5751 Gb on-board NIC
- Zonet Gb PCI NIC - used for crossover connection to web server
The two additional dedicated NICs were installed recently.
Here is a rough cycle of the problem. About a day or two after I installed
the two NICs, I started getting this error. But it wasn't intermittent in
that it would fix itself after a while -- once it started throwing the
error, it would fairly consistently throw it, only allowing a connection on
rare occasions. The only fix was to reboot the server. After rebooting,
everything seems find for a day or two, then it starts back up, another
reboot... repeat.
I have tested for connection issues between the two NICs, and pinging is
always successful. I have even completely ruled that out by disabling the
new NICs, and going back to the original shared connection, and even on that
connection it will start throwing the errors. I have an alias configured
using TCP/IP, but I have tried both using the alias and not using it (having
the IP configured directly in my connection string), and the results are the
same. I have tried using the machine name (which is different than the
alias), same results.
I read about disabling connection pooling causing this, but to my knowledge,
connection pooling is enabled.
I'm at a loss. I don't know why this is happening all of the sudden. I
thought it may be related to the new NICs, but after disabling them and
still getting the problems, that doesn't seem to be the case.
Please, any suggestions would be appreciated.
Thanks in advance.
Jerad
Hi
You may want to look at other things such as DNS problems, incorrect routing
or firewall problems. Check out the logs for all of these to see if anything
corresponds to the time of your failure.
It is not clear from your post if you reboot the database server or the web
server, if the former then try restarting IIS or rebooting the web server
and see if that also cures it!
John
"Jerad Rose" <no@.spam.com> wrote in message
news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
> I've seen this topic posted several times, but it seems my situation is
> unique for every other case I've seen.
> I have a web site that has been running for over 3 years. Recently, we've
> hit a major spike in activity. Now, after a few days (sometimes less),
> the site will start returning the following error:
> SQL Server does not exist or access denied.
> Here are my server specs:
> WEB SERVER (Shuttle SK41G)
> - Windows 2000 Server SP4 (IIS 5.0)
> - Athlon XP 2100+
> - 1GB RAM
> - 80GB SATA HD (7200 RPM)
> - All pages in ASP (traditional, not .NET)
> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
> - Zonet Gb PCI NIC - used for crossover connection to DB server
> DATABASE SERVER (Dell PowerEdge SC420)
> - Windows 2000 Server SP4
> - MS SQL Server 2000 SP4
> - Pentium 4 2.8 GHz
> - 1GB RAM
> - 2x 80GB SATA HD (7200 RPM), Raid 1
> - Broadcom NetXtreme 5751 Gb on-board NIC
> - Zonet Gb PCI NIC - used for crossover connection to web server
> The two additional dedicated NICs were installed recently.
> Here is a rough cycle of the problem. About a day or two after I
> installed the two NICs, I started getting this error. But it wasn't
> intermittent in that it would fix itself after a while -- once it started
> throwing the error, it would fairly consistently throw it, only allowing a
> connection on rare occasions. The only fix was to reboot the server.
> After rebooting, everything seems find for a day or two, then it starts
> back up, another reboot... repeat.
> I have tested for connection issues between the two NICs, and pinging is
> always successful. I have even completely ruled that out by disabling the
> new NICs, and going back to the original shared connection, and even on
> that connection it will start throwing the errors. I have an alias
> configured using TCP/IP, but I have tried both using the alias and not
> using it (having the IP configured directly in my connection string), and
> the results are the same. I have tried using the machine name (which is
> different than the alias), same results.
> I read about disabling connection pooling causing this, but to my
> knowledge, connection pooling is enabled.
> I'm at a loss. I don't know why this is happening all of the sudden. I
> thought it may be related to the new NICs, but after disabling them and
> still getting the problems, that doesn't seem to be the case.
> Please, any suggestions would be appreciated.
> Thanks in advance.
> Jerad
>
|||Thanks for your response, John.
A few clarifcations. The database and webserver are connected to each other
directly via crossover cable, so there is no dns/firewall/routing in the
equasion. I have checked event logs on both web and database server, and
cannot see *anything* that would indicate new problems. I only see the
ongoing events that are normally there, such as SMTP routing problems
(nothing new). Also, I should have specified which server I reboot -- it is
the web server that is rebooted.
So I beleive I have ruled out most of the obvious problems. If there's any
other info you need that may help, let me know.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
> Hi
> You may want to look at other things such as DNS problems, incorrect
> routing or firewall problems. Check out the logs for all of these to see
> if anything corresponds to the time of your failure.
> It is not clear from your post if you reboot the database server or the
> web server, if the former then try restarting IIS or rebooting the web
> server and see if that also cures it!
> John
>
> "Jerad Rose" <no@.spam.com> wrote in message
> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>
|||Hi
Can one assume that you have not installed any new software, updated
existing software or reconfigured any settings on either machine e.g
anti-virus
John
"Jerad Rose" <no@.spam.com> wrote in message
news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response, John.
> A few clarifcations. The database and webserver are connected to each
> other directly via crossover cable, so there is no dns/firewall/routing in
> the equasion. I have checked event logs on both web and database server,
> and cannot see *anything* that would indicate new problems. I only see
> the ongoing events that are normally there, such as SMTP routing problems
> (nothing new). Also, I should have specified which server I reboot -- it
> is the web server that is rebooted.
> So I beleive I have ruled out most of the obvious problems. If there's
> any other info you need that may help, let me know.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>
|||I have Windows auto-updates turned on, and it updates once a week, so
whatever has been installed there recently. Also, to do some network
monitoring, I have intalled two different monitoring apps (DUMeter and
Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can try
turning those off once I start seeing problem again, but I wouldn't think
those would be my culprit. I haven't done anything else though -- no
configuration changes (at least, outside of potential changes from the
mentioned software) and no antivirus software has been installed.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
> Hi
> Can one assume that you have not installed any new software, updated
> existing software or reconfigured any settings on either machine e.g
> anti-virus
> John
> "Jerad Rose" <no@.spam.com> wrote in message
> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>
|||Hi
This is not necessarily a problem with the web server and SQL Server it
could be that access is denied because of authentication problems. Try using
profiler to monitor logon attempts.
Check out:
http://support.microsoft.com/default...b;en-us;328306
http://support.microsoft.com/default...b;en-us;827422
http://support.microsoft.com/default...b;en-us;821498
John
"Jerad Rose" <no@.spam.com> wrote in message
news:%233gceCCBGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I have Windows auto-updates turned on, and it updates once a week, so
>whatever has been installed there recently. Also, to do some network
>monitoring, I have intalled two different monitoring apps (DUMeter and
>Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can
>try turning those off once I start seeing problem again, but I wouldn't
>think those would be my culprit. I haven't done anything else though -- no
>configuration changes (at least, outside of potential changes from the
>mentioned software) and no antivirus software has been installed.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
>
sql
unique for every other case I've seen.
I have a web site that has been running for over 3 years. Recently, we've
hit a major spike in activity. Now, after a few days (sometimes less), the
site will start returning the following error:
SQL Server does not exist or access denied.
Here are my server specs:
WEB SERVER (Shuttle SK41G)
- Windows 2000 Server SP4 (IIS 5.0)
- Athlon XP 2100+
- 1GB RAM
- 80GB SATA HD (7200 RPM)
- All pages in ASP (traditional, not .NET)
- Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
- Zonet Gb PCI NIC - used for crossover connection to DB server
DATABASE SERVER (Dell PowerEdge SC420)
- Windows 2000 Server SP4
- MS SQL Server 2000 SP4
- Pentium 4 2.8 GHz
- 1GB RAM
- 2x 80GB SATA HD (7200 RPM), Raid 1
- Broadcom NetXtreme 5751 Gb on-board NIC
- Zonet Gb PCI NIC - used for crossover connection to web server
The two additional dedicated NICs were installed recently.
Here is a rough cycle of the problem. About a day or two after I installed
the two NICs, I started getting this error. But it wasn't intermittent in
that it would fix itself after a while -- once it started throwing the
error, it would fairly consistently throw it, only allowing a connection on
rare occasions. The only fix was to reboot the server. After rebooting,
everything seems find for a day or two, then it starts back up, another
reboot... repeat.
I have tested for connection issues between the two NICs, and pinging is
always successful. I have even completely ruled that out by disabling the
new NICs, and going back to the original shared connection, and even on that
connection it will start throwing the errors. I have an alias configured
using TCP/IP, but I have tried both using the alias and not using it (having
the IP configured directly in my connection string), and the results are the
same. I have tried using the machine name (which is different than the
alias), same results.
I read about disabling connection pooling causing this, but to my knowledge,
connection pooling is enabled.
I'm at a loss. I don't know why this is happening all of the sudden. I
thought it may be related to the new NICs, but after disabling them and
still getting the problems, that doesn't seem to be the case.
Please, any suggestions would be appreciated.
Thanks in advance.
Jerad
Hi
You may want to look at other things such as DNS problems, incorrect routing
or firewall problems. Check out the logs for all of these to see if anything
corresponds to the time of your failure.
It is not clear from your post if you reboot the database server or the web
server, if the former then try restarting IIS or rebooting the web server
and see if that also cures it!
John
"Jerad Rose" <no@.spam.com> wrote in message
news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
> I've seen this topic posted several times, but it seems my situation is
> unique for every other case I've seen.
> I have a web site that has been running for over 3 years. Recently, we've
> hit a major spike in activity. Now, after a few days (sometimes less),
> the site will start returning the following error:
> SQL Server does not exist or access denied.
> Here are my server specs:
> WEB SERVER (Shuttle SK41G)
> - Windows 2000 Server SP4 (IIS 5.0)
> - Athlon XP 2100+
> - 1GB RAM
> - 80GB SATA HD (7200 RPM)
> - All pages in ASP (traditional, not .NET)
> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
> - Zonet Gb PCI NIC - used for crossover connection to DB server
> DATABASE SERVER (Dell PowerEdge SC420)
> - Windows 2000 Server SP4
> - MS SQL Server 2000 SP4
> - Pentium 4 2.8 GHz
> - 1GB RAM
> - 2x 80GB SATA HD (7200 RPM), Raid 1
> - Broadcom NetXtreme 5751 Gb on-board NIC
> - Zonet Gb PCI NIC - used for crossover connection to web server
> The two additional dedicated NICs were installed recently.
> Here is a rough cycle of the problem. About a day or two after I
> installed the two NICs, I started getting this error. But it wasn't
> intermittent in that it would fix itself after a while -- once it started
> throwing the error, it would fairly consistently throw it, only allowing a
> connection on rare occasions. The only fix was to reboot the server.
> After rebooting, everything seems find for a day or two, then it starts
> back up, another reboot... repeat.
> I have tested for connection issues between the two NICs, and pinging is
> always successful. I have even completely ruled that out by disabling the
> new NICs, and going back to the original shared connection, and even on
> that connection it will start throwing the errors. I have an alias
> configured using TCP/IP, but I have tried both using the alias and not
> using it (having the IP configured directly in my connection string), and
> the results are the same. I have tried using the machine name (which is
> different than the alias), same results.
> I read about disabling connection pooling causing this, but to my
> knowledge, connection pooling is enabled.
> I'm at a loss. I don't know why this is happening all of the sudden. I
> thought it may be related to the new NICs, but after disabling them and
> still getting the problems, that doesn't seem to be the case.
> Please, any suggestions would be appreciated.
> Thanks in advance.
> Jerad
>
|||Thanks for your response, John.
A few clarifcations. The database and webserver are connected to each other
directly via crossover cable, so there is no dns/firewall/routing in the
equasion. I have checked event logs on both web and database server, and
cannot see *anything* that would indicate new problems. I only see the
ongoing events that are normally there, such as SMTP routing problems
(nothing new). Also, I should have specified which server I reboot -- it is
the web server that is rebooted.
So I beleive I have ruled out most of the obvious problems. If there's any
other info you need that may help, let me know.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
> Hi
> You may want to look at other things such as DNS problems, incorrect
> routing or firewall problems. Check out the logs for all of these to see
> if anything corresponds to the time of your failure.
> It is not clear from your post if you reboot the database server or the
> web server, if the former then try restarting IIS or rebooting the web
> server and see if that also cures it!
> John
>
> "Jerad Rose" <no@.spam.com> wrote in message
> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>
|||Hi
Can one assume that you have not installed any new software, updated
existing software or reconfigured any settings on either machine e.g
anti-virus
John
"Jerad Rose" <no@.spam.com> wrote in message
news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response, John.
> A few clarifcations. The database and webserver are connected to each
> other directly via crossover cable, so there is no dns/firewall/routing in
> the equasion. I have checked event logs on both web and database server,
> and cannot see *anything* that would indicate new problems. I only see
> the ongoing events that are normally there, such as SMTP routing problems
> (nothing new). Also, I should have specified which server I reboot -- it
> is the web server that is rebooted.
> So I beleive I have ruled out most of the obvious problems. If there's
> any other info you need that may help, let me know.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>
|||I have Windows auto-updates turned on, and it updates once a week, so
whatever has been installed there recently. Also, to do some network
monitoring, I have intalled two different monitoring apps (DUMeter and
Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can try
turning those off once I start seeing problem again, but I wouldn't think
those would be my culprit. I haven't done anything else though -- no
configuration changes (at least, outside of potential changes from the
mentioned software) and no antivirus software has been installed.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
> Hi
> Can one assume that you have not installed any new software, updated
> existing software or reconfigured any settings on either machine e.g
> anti-virus
> John
> "Jerad Rose" <no@.spam.com> wrote in message
> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>
|||Hi
This is not necessarily a problem with the web server and SQL Server it
could be that access is denied because of authentication problems. Try using
profiler to monitor logon attempts.
Check out:
http://support.microsoft.com/default...b;en-us;328306
http://support.microsoft.com/default...b;en-us;827422
http://support.microsoft.com/default...b;en-us;821498
John
"Jerad Rose" <no@.spam.com> wrote in message
news:%233gceCCBGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I have Windows auto-updates turned on, and it updates once a week, so
>whatever has been installed there recently. Also, to do some network
>monitoring, I have intalled two different monitoring apps (DUMeter and
>Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can
>try turning those off once I start seeing problem again, but I wouldn't
>think those would be my culprit. I haven't done anything else though -- no
>configuration changes (at least, outside of potential changes from the
>mentioned software) and no antivirus software has been installed.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
>
sql
Intermittent "SQL Server does not exist or access denied."
I've seen this topic posted several times, but it seems my situation is
unique for every other case I've seen.
I have a web site that has been running for over 3 years. Recently, we've
hit a major spike in activity. Now, after a few days (sometimes less), the
site will start returning the following error:
SQL Server does not exist or access denied.
Here are my server specs:
WEB SERVER (Shuttle SK41G)
- Windows 2000 Server SP4 (IIS 5.0)
- Athlon XP 2100+
- 1GB RAM
- 80GB SATA HD (7200 RPM)
- All pages in ASP (traditional, not .NET)
- Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
- Zonet Gb PCI NIC - used for crossover connection to DB server
DATABASE SERVER (Dell PowerEdge SC420)
- Windows 2000 Server SP4
- MS SQL Server 2000 SP4
- Pentium 4 2.8 GHz
- 1GB RAM
- 2x 80GB SATA HD (7200 RPM), Raid 1
- Broadcom NetXtreme 5751 Gb on-board NIC
- Zonet Gb PCI NIC - used for crossover connection to web server
The two additional dedicated NICs were installed recently.
Here is a rough cycle of the problem. About a day or two after I installed
the two NICs, I started getting this error. But it wasn't intermittent in
that it would fix itself after a while -- once it started throwing the
error, it would fairly consistently throw it, only allowing a connection on
rare occasions. The only fix was to reboot the server. After rebooting,
everything seems find for a day or two, then it starts back up, another
reboot... repeat.
I have tested for connection issues between the two NICs, and pinging is
always successful. I have even completely ruled that out by disabling the
new NICs, and going back to the original shared connection, and even on that
connection it will start throwing the errors. I have an alias configured
using TCP/IP, but I have tried both using the alias and not using it (having
the IP configured directly in my connection string), and the results are the
same. I have tried using the machine name (which is different than the
alias), same results.
I read about disabling connection pooling causing this, but to my knowledge,
connection pooling is enabled.
I'm at a loss. I don't know why this is happening all of the sudden. I
thought it may be related to the new NICs, but after disabling them and
still getting the problems, that doesn't seem to be the case.
Please, any suggestions would be appreciated.
Thanks in advance.
JeradHi
You may want to look at other things such as DNS problems, incorrect routing
or firewall problems. Check out the logs for all of these to see if anything
corresponds to the time of your failure.
It is not clear from your post if you reboot the database server or the web
server, if the former then try restarting IIS or rebooting the web server
and see if that also cures it!
John
"Jerad Rose" <no@.spam.com> wrote in message
news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
> I've seen this topic posted several times, but it seems my situation is
> unique for every other case I've seen.
> I have a web site that has been running for over 3 years. Recently, we've
> hit a major spike in activity. Now, after a few days (sometimes less),
> the site will start returning the following error:
> SQL Server does not exist or access denied.
> Here are my server specs:
> WEB SERVER (Shuttle SK41G)
> - Windows 2000 Server SP4 (IIS 5.0)
> - Athlon XP 2100+
> - 1GB RAM
> - 80GB SATA HD (7200 RPM)
> - All pages in ASP (traditional, not .NET)
> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
> - Zonet Gb PCI NIC - used for crossover connection to DB server
> DATABASE SERVER (Dell PowerEdge SC420)
> - Windows 2000 Server SP4
> - MS SQL Server 2000 SP4
> - Pentium 4 2.8 GHz
> - 1GB RAM
> - 2x 80GB SATA HD (7200 RPM), Raid 1
> - Broadcom NetXtreme 5751 Gb on-board NIC
> - Zonet Gb PCI NIC - used for crossover connection to web server
> The two additional dedicated NICs were installed recently.
> Here is a rough cycle of the problem. About a day or two after I
> installed the two NICs, I started getting this error. But it wasn't
> intermittent in that it would fix itself after a while -- once it started
> throwing the error, it would fairly consistently throw it, only allowing a
> connection on rare occasions. The only fix was to reboot the server.
> After rebooting, everything seems find for a day or two, then it starts
> back up, another reboot... repeat.
> I have tested for connection issues between the two NICs, and pinging is
> always successful. I have even completely ruled that out by disabling the
> new NICs, and going back to the original shared connection, and even on
> that connection it will start throwing the errors. I have an alias
> configured using TCP/IP, but I have tried both using the alias and not
> using it (having the IP configured directly in my connection string), and
> the results are the same. I have tried using the machine name (which is
> different than the alias), same results.
> I read about disabling connection pooling causing this, but to my
> knowledge, connection pooling is enabled.
> I'm at a loss. I don't know why this is happening all of the sudden. I
> thought it may be related to the new NICs, but after disabling them and
> still getting the problems, that doesn't seem to be the case.
> Please, any suggestions would be appreciated.
> Thanks in advance.
> Jerad
>|||Thanks for your response, John.
A few clarifcations. The database and webserver are connected to each other
directly via crossover cable, so there is no dns/firewall/routing in the
equasion. I have checked event logs on both web and database server, and
cannot see *anything* that would indicate new problems. I only see the
ongoing events that are normally there, such as SMTP routing problems
(nothing new). Also, I should have specified which server I reboot -- it is
the web server that is rebooted.
So I beleive I have ruled out most of the obvious problems. If there's any
other info you need that may help, let me know.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
> Hi
> You may want to look at other things such as DNS problems, incorrect
> routing or firewall problems. Check out the logs for all of these to see
> if anything corresponds to the time of your failure.
> It is not clear from your post if you reboot the database server or the
> web server, if the former then try restarting IIS or rebooting the web
> server and see if that also cures it!
> John
>
> "Jerad Rose" <no@.spam.com> wrote in message
> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>|||Hi
Can one assume that you have not installed any new software, updated
existing software or reconfigured any settings on either machine e.g
anti-virus
John
"Jerad Rose" <no@.spam.com> wrote in message
news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response, John.
> A few clarifcations. The database and webserver are connected to each
> other directly via crossover cable, so there is no dns/firewall/routing in
> the equasion. I have checked event logs on both web and database server,
> and cannot see *anything* that would indicate new problems. I only see
> the ongoing events that are normally there, such as SMTP routing problems
> (nothing new). Also, I should have specified which server I reboot -- it
> is the web server that is rebooted.
> So I beleive I have ruled out most of the obvious problems. If there's
> any other info you need that may help, let me know.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>|||I have Windows auto-updates turned on, and it updates once a week, so
whatever has been installed there recently. Also, to do some network
monitoring, I have intalled two different monitoring apps (DUMeter and
Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can try
turning those off once I start seeing problem again, but I wouldn't think
those would be my culprit. I haven't done anything else though -- no
configuration changes (at least, outside of potential changes from the
mentioned software) and no antivirus software has been installed.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
> Hi
> Can one assume that you have not installed any new software, updated
> existing software or reconfigured any settings on either machine e.g
> anti-virus
> John
> "Jerad Rose" <no@.spam.com> wrote in message
> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>|||Hi
This is not necessarily a problem with the web server and SQL Server it
could be that access is denied because of authentication problems. Try using
profiler to monitor logon attempts.
Check out:
http://support.microsoft.com/defaul...kb;en-us;328306
http://support.microsoft.com/defaul...kb;en-us;827422
http://support.microsoft.com/defaul...kb;en-us;821498
John
"Jerad Rose" <no@.spam.com> wrote in message
news:%233gceCCBGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I have Windows auto-updates turned on, and it updates once a week, so
>whatever has been installed there recently. Also, to do some network
>monitoring, I have intalled two different monitoring apps (DUMeter and
>Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can
>try turning those off once I start seeing problem again, but I wouldn't
>think those would be my culprit. I haven't done anything else though -- no
>configuration changes (at least, outside of potential changes from the
>mentioned software) and no antivirus software has been installed.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
>
unique for every other case I've seen.
I have a web site that has been running for over 3 years. Recently, we've
hit a major spike in activity. Now, after a few days (sometimes less), the
site will start returning the following error:
SQL Server does not exist or access denied.
Here are my server specs:
WEB SERVER (Shuttle SK41G)
- Windows 2000 Server SP4 (IIS 5.0)
- Athlon XP 2100+
- 1GB RAM
- 80GB SATA HD (7200 RPM)
- All pages in ASP (traditional, not .NET)
- Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
- Zonet Gb PCI NIC - used for crossover connection to DB server
DATABASE SERVER (Dell PowerEdge SC420)
- Windows 2000 Server SP4
- MS SQL Server 2000 SP4
- Pentium 4 2.8 GHz
- 1GB RAM
- 2x 80GB SATA HD (7200 RPM), Raid 1
- Broadcom NetXtreme 5751 Gb on-board NIC
- Zonet Gb PCI NIC - used for crossover connection to web server
The two additional dedicated NICs were installed recently.
Here is a rough cycle of the problem. About a day or two after I installed
the two NICs, I started getting this error. But it wasn't intermittent in
that it would fix itself after a while -- once it started throwing the
error, it would fairly consistently throw it, only allowing a connection on
rare occasions. The only fix was to reboot the server. After rebooting,
everything seems find for a day or two, then it starts back up, another
reboot... repeat.
I have tested for connection issues between the two NICs, and pinging is
always successful. I have even completely ruled that out by disabling the
new NICs, and going back to the original shared connection, and even on that
connection it will start throwing the errors. I have an alias configured
using TCP/IP, but I have tried both using the alias and not using it (having
the IP configured directly in my connection string), and the results are the
same. I have tried using the machine name (which is different than the
alias), same results.
I read about disabling connection pooling causing this, but to my knowledge,
connection pooling is enabled.
I'm at a loss. I don't know why this is happening all of the sudden. I
thought it may be related to the new NICs, but after disabling them and
still getting the problems, that doesn't seem to be the case.
Please, any suggestions would be appreciated.
Thanks in advance.
JeradHi
You may want to look at other things such as DNS problems, incorrect routing
or firewall problems. Check out the logs for all of these to see if anything
corresponds to the time of your failure.
It is not clear from your post if you reboot the database server or the web
server, if the former then try restarting IIS or rebooting the web server
and see if that also cures it!
John
"Jerad Rose" <no@.spam.com> wrote in message
news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
> I've seen this topic posted several times, but it seems my situation is
> unique for every other case I've seen.
> I have a web site that has been running for over 3 years. Recently, we've
> hit a major spike in activity. Now, after a few days (sometimes less),
> the site will start returning the following error:
> SQL Server does not exist or access denied.
> Here are my server specs:
> WEB SERVER (Shuttle SK41G)
> - Windows 2000 Server SP4 (IIS 5.0)
> - Athlon XP 2100+
> - 1GB RAM
> - 80GB SATA HD (7200 RPM)
> - All pages in ASP (traditional, not .NET)
> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
> - Zonet Gb PCI NIC - used for crossover connection to DB server
> DATABASE SERVER (Dell PowerEdge SC420)
> - Windows 2000 Server SP4
> - MS SQL Server 2000 SP4
> - Pentium 4 2.8 GHz
> - 1GB RAM
> - 2x 80GB SATA HD (7200 RPM), Raid 1
> - Broadcom NetXtreme 5751 Gb on-board NIC
> - Zonet Gb PCI NIC - used for crossover connection to web server
> The two additional dedicated NICs were installed recently.
> Here is a rough cycle of the problem. About a day or two after I
> installed the two NICs, I started getting this error. But it wasn't
> intermittent in that it would fix itself after a while -- once it started
> throwing the error, it would fairly consistently throw it, only allowing a
> connection on rare occasions. The only fix was to reboot the server.
> After rebooting, everything seems find for a day or two, then it starts
> back up, another reboot... repeat.
> I have tested for connection issues between the two NICs, and pinging is
> always successful. I have even completely ruled that out by disabling the
> new NICs, and going back to the original shared connection, and even on
> that connection it will start throwing the errors. I have an alias
> configured using TCP/IP, but I have tried both using the alias and not
> using it (having the IP configured directly in my connection string), and
> the results are the same. I have tried using the machine name (which is
> different than the alias), same results.
> I read about disabling connection pooling causing this, but to my
> knowledge, connection pooling is enabled.
> I'm at a loss. I don't know why this is happening all of the sudden. I
> thought it may be related to the new NICs, but after disabling them and
> still getting the problems, that doesn't seem to be the case.
> Please, any suggestions would be appreciated.
> Thanks in advance.
> Jerad
>|||Thanks for your response, John.
A few clarifcations. The database and webserver are connected to each other
directly via crossover cable, so there is no dns/firewall/routing in the
equasion. I have checked event logs on both web and database server, and
cannot see *anything* that would indicate new problems. I only see the
ongoing events that are normally there, such as SMTP routing problems
(nothing new). Also, I should have specified which server I reboot -- it is
the web server that is rebooted.
So I beleive I have ruled out most of the obvious problems. If there's any
other info you need that may help, let me know.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
> Hi
> You may want to look at other things such as DNS problems, incorrect
> routing or firewall problems. Check out the logs for all of these to see
> if anything corresponds to the time of your failure.
> It is not clear from your post if you reboot the database server or the
> web server, if the former then try restarting IIS or rebooting the web
> server and see if that also cures it!
> John
>
> "Jerad Rose" <no@.spam.com> wrote in message
> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>|||Hi
Can one assume that you have not installed any new software, updated
existing software or reconfigured any settings on either machine e.g
anti-virus
John
"Jerad Rose" <no@.spam.com> wrote in message
news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response, John.
> A few clarifcations. The database and webserver are connected to each
> other directly via crossover cable, so there is no dns/firewall/routing in
> the equasion. I have checked event logs on both web and database server,
> and cannot see *anything* that would indicate new problems. I only see
> the ongoing events that are normally there, such as SMTP routing problems
> (nothing new). Also, I should have specified which server I reboot -- it
> is the web server that is rebooted.
> So I beleive I have ruled out most of the obvious problems. If there's
> any other info you need that may help, let me know.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>|||I have Windows auto-updates turned on, and it updates once a week, so
whatever has been installed there recently. Also, to do some network
monitoring, I have intalled two different monitoring apps (DUMeter and
Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can try
turning those off once I start seeing problem again, but I wouldn't think
those would be my culprit. I haven't done anything else though -- no
configuration changes (at least, outside of potential changes from the
mentioned software) and no antivirus software has been installed.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
> Hi
> Can one assume that you have not installed any new software, updated
> existing software or reconfigured any settings on either machine e.g
> anti-virus
> John
> "Jerad Rose" <no@.spam.com> wrote in message
> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>|||Hi
This is not necessarily a problem with the web server and SQL Server it
could be that access is denied because of authentication problems. Try using
profiler to monitor logon attempts.
Check out:
http://support.microsoft.com/defaul...kb;en-us;328306
http://support.microsoft.com/defaul...kb;en-us;827422
http://support.microsoft.com/defaul...kb;en-us;821498
John
"Jerad Rose" <no@.spam.com> wrote in message
news:%233gceCCBGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I have Windows auto-updates turned on, and it updates once a week, so
>whatever has been installed there recently. Also, to do some network
>monitoring, I have intalled two different monitoring apps (DUMeter and
>Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can
>try turning those off once I start seeing problem again, but I wouldn't
>think those would be my culprit. I haven't done anything else though -- no
>configuration changes (at least, outside of potential changes from the
>mentioned software) and no antivirus software has been installed.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
>
Intermittent "SQL Server does not exist or access denied."
I've seen this topic posted several times, but it seems my situation is
unique for every other case I've seen.
I have a web site that has been running for over 3 years. Recently, we've
hit a major spike in activity. Now, after a few days (sometimes less), the
site will start returning the following error:
SQL Server does not exist or access denied.
Here are my server specs:
WEB SERVER (Shuttle SK41G)
- Windows 2000 Server SP4 (IIS 5.0)
- Athlon XP 2100+
- 1GB RAM
- 80GB SATA HD (7200 RPM)
- All pages in ASP (traditional, not .NET)
- Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
- Zonet Gb PCI NIC - used for crossover connection to DB server
DATABASE SERVER (Dell PowerEdge SC420)
- Windows 2000 Server SP4
- MS SQL Server 2000 SP4
- Pentium 4 2.8 GHz
- 1GB RAM
- 2x 80GB SATA HD (7200 RPM), Raid 1
- Broadcom NetXtreme 5751 Gb on-board NIC
- Zonet Gb PCI NIC - used for crossover connection to web server
The two additional dedicated NICs were installed recently.
Here is a rough cycle of the problem. About a day or two after I installed
the two NICs, I started getting this error. But it wasn't intermittent in
that it would fix itself after a while -- once it started throwing the
error, it would fairly consistently throw it, only allowing a connection on
rare occasions. The only fix was to reboot the server. After rebooting,
everything seems find for a day or two, then it starts back up, another
reboot... repeat.
I have tested for connection issues between the two NICs, and pinging is
always successful. I have even completely ruled that out by disabling the
new NICs, and going back to the original shared connection, and even on that
connection it will start throwing the errors. I have an alias configured
using TCP/IP, but I have tried both using the alias and not using it (having
the IP configured directly in my connection string), and the results are the
same. I have tried using the machine name (which is different than the
alias), same results.
I read about disabling connection pooling causing this, but to my knowledge,
connection pooling is enabled.
I'm at a loss. I don't know why this is happening all of the sudden. I
thought it may be related to the new NICs, but after disabling them and
still getting the problems, that doesn't seem to be the case.
Please, any suggestions would be appreciated.
Thanks in advance.
JeradHi
You may want to look at other things such as DNS problems, incorrect routing
or firewall problems. Check out the logs for all of these to see if anything
corresponds to the time of your failure.
It is not clear from your post if you reboot the database server or the web
server, if the former then try restarting IIS or rebooting the web server
and see if that also cures it!
John
"Jerad Rose" <no@.spam.com> wrote in message
news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
> I've seen this topic posted several times, but it seems my situation is
> unique for every other case I've seen.
> I have a web site that has been running for over 3 years. Recently, we've
> hit a major spike in activity. Now, after a few days (sometimes less),
> the site will start returning the following error:
> SQL Server does not exist or access denied.
> Here are my server specs:
> WEB SERVER (Shuttle SK41G)
> - Windows 2000 Server SP4 (IIS 5.0)
> - Athlon XP 2100+
> - 1GB RAM
> - 80GB SATA HD (7200 RPM)
> - All pages in ASP (traditional, not .NET)
> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
> - Zonet Gb PCI NIC - used for crossover connection to DB server
> DATABASE SERVER (Dell PowerEdge SC420)
> - Windows 2000 Server SP4
> - MS SQL Server 2000 SP4
> - Pentium 4 2.8 GHz
> - 1GB RAM
> - 2x 80GB SATA HD (7200 RPM), Raid 1
> - Broadcom NetXtreme 5751 Gb on-board NIC
> - Zonet Gb PCI NIC - used for crossover connection to web server
> The two additional dedicated NICs were installed recently.
> Here is a rough cycle of the problem. About a day or two after I
> installed the two NICs, I started getting this error. But it wasn't
> intermittent in that it would fix itself after a while -- once it started
> throwing the error, it would fairly consistently throw it, only allowing a
> connection on rare occasions. The only fix was to reboot the server.
> After rebooting, everything seems find for a day or two, then it starts
> back up, another reboot... repeat.
> I have tested for connection issues between the two NICs, and pinging is
> always successful. I have even completely ruled that out by disabling the
> new NICs, and going back to the original shared connection, and even on
> that connection it will start throwing the errors. I have an alias
> configured using TCP/IP, but I have tried both using the alias and not
> using it (having the IP configured directly in my connection string), and
> the results are the same. I have tried using the machine name (which is
> different than the alias), same results.
> I read about disabling connection pooling causing this, but to my
> knowledge, connection pooling is enabled.
> I'm at a loss. I don't know why this is happening all of the sudden. I
> thought it may be related to the new NICs, but after disabling them and
> still getting the problems, that doesn't seem to be the case.
> Please, any suggestions would be appreciated.
> Thanks in advance.
> Jerad
>|||Thanks for your response, John.
A few clarifcations. The database and webserver are connected to each other
directly via crossover cable, so there is no dns/firewall/routing in the
equasion. I have checked event logs on both web and database server, and
cannot see *anything* that would indicate new problems. I only see the
ongoing events that are normally there, such as SMTP routing problems
(nothing new). Also, I should have specified which server I reboot -- it is
the web server that is rebooted.
So I beleive I have ruled out most of the obvious problems. If there's any
other info you need that may help, let me know.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
> Hi
> You may want to look at other things such as DNS problems, incorrect
> routing or firewall problems. Check out the logs for all of these to see
> if anything corresponds to the time of your failure.
> It is not clear from your post if you reboot the database server or the
> web server, if the former then try restarting IIS or rebooting the web
> server and see if that also cures it!
> John
>
> "Jerad Rose" <no@.spam.com> wrote in message
> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation is
>> unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it started
>> throwing the error, it would fairly consistently throw it, only allowing
>> a connection on rare occasions. The only fix was to reboot the server.
>> After rebooting, everything seems find for a day or two, then it starts
>> back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging is
>> always successful. I have even completely ruled that out by disabling
>> the new NICs, and going back to the original shared connection, and even
>> on that connection it will start throwing the errors. I have an alias
>> configured using TCP/IP, but I have tried both using the alias and not
>> using it (having the IP configured directly in my connection string), and
>> the results are the same. I have tried using the machine name (which is
>> different than the alias), same results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden. I
>> thought it may be related to the new NICs, but after disabling them and
>> still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>|||Hi
Can one assume that you have not installed any new software, updated
existing software or reconfigured any settings on either machine e.g
anti-virus
John
"Jerad Rose" <no@.spam.com> wrote in message
news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response, John.
> A few clarifcations. The database and webserver are connected to each
> other directly via crossover cable, so there is no dns/firewall/routing in
> the equasion. I have checked event logs on both web and database server,
> and cannot see *anything* that would indicate new problems. I only see
> the ongoing events that are normally there, such as SMTP routing problems
> (nothing new). Also, I should have specified which server I reboot -- it
> is the web server that is rebooted.
> So I beleive I have ruled out most of the obvious problems. If there's
> any other info you need that may help, let me know.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> You may want to look at other things such as DNS problems, incorrect
>> routing or firewall problems. Check out the logs for all of these to see
>> if anything corresponds to the time of your failure.
>> It is not clear from your post if you reboot the database server or the
>> web server, if the former then try restarting IIS or rebooting the web
>> server and see if that also cures it!
>> John
>>
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation is
>> unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external
>> connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it
>> started throwing the error, it would fairly consistently throw it, only
>> allowing a connection on rare occasions. The only fix was to reboot the
>> server. After rebooting, everything seems find for a day or two, then it
>> starts back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging is
>> always successful. I have even completely ruled that out by disabling
>> the new NICs, and going back to the original shared connection, and even
>> on that connection it will start throwing the errors. I have an alias
>> configured using TCP/IP, but I have tried both using the alias and not
>> using it (having the IP configured directly in my connection string),
>> and the results are the same. I have tried using the machine name
>> (which is different than the alias), same results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden. I
>> thought it may be related to the new NICs, but after disabling them and
>> still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>>
>|||I have Windows auto-updates turned on, and it updates once a week, so
whatever has been installed there recently. Also, to do some network
monitoring, I have intalled two different monitoring apps (DUMeter and
Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can try
turning those off once I start seeing problem again, but I wouldn't think
those would be my culprit. I haven't done anything else though -- no
configuration changes (at least, outside of potential changes from the
mentioned software) and no antivirus software has been installed.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
> Hi
> Can one assume that you have not installed any new software, updated
> existing software or reconfigured any settings on either machine e.g
> anti-virus
> John
> "Jerad Rose" <no@.spam.com> wrote in message
> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>> Thanks for your response, John.
>> A few clarifcations. The database and webserver are connected to each
>> other directly via crossover cable, so there is no dns/firewall/routing
>> in the equasion. I have checked event logs on both web and database
>> server, and cannot see *anything* that would indicate new problems. I
>> only see the ongoing events that are normally there, such as SMTP routing
>> problems (nothing new). Also, I should have specified which server I
>> reboot -- it is the web server that is rebooted.
>> So I beleive I have ruled out most of the obvious problems. If there's
>> any other info you need that may help, let me know.
>> Thanks again.
>> Jerad
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> You may want to look at other things such as DNS problems, incorrect
>> routing or firewall problems. Check out the logs for all of these to see
>> if anything corresponds to the time of your failure.
>> It is not clear from your post if you reboot the database server or the
>> web server, if the former then try restarting IIS or rebooting the web
>> server and see if that also cures it!
>> John
>>
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation is
>> unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external
>> connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it
>> started throwing the error, it would fairly consistently throw it, only
>> allowing a connection on rare occasions. The only fix was to reboot
>> the server. After rebooting, everything seems find for a day or two,
>> then it starts back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging
>> is always successful. I have even completely ruled that out by
>> disabling the new NICs, and going back to the original shared
>> connection, and even on that connection it will start throwing the
>> errors. I have an alias configured using TCP/IP, but I have tried both
>> using the alias and not using it (having the IP configured directly in
>> my connection string), and the results are the same. I have tried
>> using the machine name (which is different than the alias), same
>> results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden.
>> I thought it may be related to the new NICs, but after disabling them
>> and still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>>
>>
>|||Hi
This is not necessarily a problem with the web server and SQL Server it
could be that access is denied because of authentication problems. Try using
profiler to monitor logon attempts.
Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
http://support.microsoft.com/default.aspx?scid=kb;en-us;821498
John
"Jerad Rose" <no@.spam.com> wrote in message
news:%233gceCCBGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I have Windows auto-updates turned on, and it updates once a week, so
>whatever has been installed there recently. Also, to do some network
>monitoring, I have intalled two different monitoring apps (DUMeter and
>Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can
>try turning those off once I start seeing problem again, but I wouldn't
>think those would be my culprit. I haven't done anything else though -- no
>configuration changes (at least, outside of potential changes from the
>mentioned software) and no antivirus software has been installed.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
>> Hi
>> Can one assume that you have not installed any new software, updated
>> existing software or reconfigured any settings on either machine e.g
>> anti-virus
>> John
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>> Thanks for your response, John.
>> A few clarifcations. The database and webserver are connected to each
>> other directly via crossover cable, so there is no dns/firewall/routing
>> in the equasion. I have checked event logs on both web and database
>> server, and cannot see *anything* that would indicate new problems. I
>> only see the ongoing events that are normally there, such as SMTP
>> routing problems (nothing new). Also, I should have specified which
>> server I reboot -- it is the web server that is rebooted.
>> So I beleive I have ruled out most of the obvious problems. If there's
>> any other info you need that may help, let me know.
>> Thanks again.
>> Jerad
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> You may want to look at other things such as DNS problems, incorrect
>> routing or firewall problems. Check out the logs for all of these to
>> see if anything corresponds to the time of your failure.
>> It is not clear from your post if you reboot the database server or the
>> web server, if the former then try restarting IIS or rebooting the web
>> server and see if that also cures it!
>> John
>>
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation
>> is unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external
>> connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it
>> started throwing the error, it would fairly consistently throw it,
>> only allowing a connection on rare occasions. The only fix was to
>> reboot the server. After rebooting, everything seems find for a day or
>> two, then it starts back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging
>> is always successful. I have even completely ruled that out by
>> disabling the new NICs, and going back to the original shared
>> connection, and even on that connection it will start throwing the
>> errors. I have an alias configured using TCP/IP, but I have tried
>> both using the alias and not using it (having the IP configured
>> directly in my connection string), and the results are the same. I
>> have tried using the machine name (which is different than the alias),
>> same results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden.
>> I thought it may be related to the new NICs, but after disabling them
>> and still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>>
>>
>>
>
unique for every other case I've seen.
I have a web site that has been running for over 3 years. Recently, we've
hit a major spike in activity. Now, after a few days (sometimes less), the
site will start returning the following error:
SQL Server does not exist or access denied.
Here are my server specs:
WEB SERVER (Shuttle SK41G)
- Windows 2000 Server SP4 (IIS 5.0)
- Athlon XP 2100+
- 1GB RAM
- 80GB SATA HD (7200 RPM)
- All pages in ASP (traditional, not .NET)
- Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
- Zonet Gb PCI NIC - used for crossover connection to DB server
DATABASE SERVER (Dell PowerEdge SC420)
- Windows 2000 Server SP4
- MS SQL Server 2000 SP4
- Pentium 4 2.8 GHz
- 1GB RAM
- 2x 80GB SATA HD (7200 RPM), Raid 1
- Broadcom NetXtreme 5751 Gb on-board NIC
- Zonet Gb PCI NIC - used for crossover connection to web server
The two additional dedicated NICs were installed recently.
Here is a rough cycle of the problem. About a day or two after I installed
the two NICs, I started getting this error. But it wasn't intermittent in
that it would fix itself after a while -- once it started throwing the
error, it would fairly consistently throw it, only allowing a connection on
rare occasions. The only fix was to reboot the server. After rebooting,
everything seems find for a day or two, then it starts back up, another
reboot... repeat.
I have tested for connection issues between the two NICs, and pinging is
always successful. I have even completely ruled that out by disabling the
new NICs, and going back to the original shared connection, and even on that
connection it will start throwing the errors. I have an alias configured
using TCP/IP, but I have tried both using the alias and not using it (having
the IP configured directly in my connection string), and the results are the
same. I have tried using the machine name (which is different than the
alias), same results.
I read about disabling connection pooling causing this, but to my knowledge,
connection pooling is enabled.
I'm at a loss. I don't know why this is happening all of the sudden. I
thought it may be related to the new NICs, but after disabling them and
still getting the problems, that doesn't seem to be the case.
Please, any suggestions would be appreciated.
Thanks in advance.
JeradHi
You may want to look at other things such as DNS problems, incorrect routing
or firewall problems. Check out the logs for all of these to see if anything
corresponds to the time of your failure.
It is not clear from your post if you reboot the database server or the web
server, if the former then try restarting IIS or rebooting the web server
and see if that also cures it!
John
"Jerad Rose" <no@.spam.com> wrote in message
news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
> I've seen this topic posted several times, but it seems my situation is
> unique for every other case I've seen.
> I have a web site that has been running for over 3 years. Recently, we've
> hit a major spike in activity. Now, after a few days (sometimes less),
> the site will start returning the following error:
> SQL Server does not exist or access denied.
> Here are my server specs:
> WEB SERVER (Shuttle SK41G)
> - Windows 2000 Server SP4 (IIS 5.0)
> - Athlon XP 2100+
> - 1GB RAM
> - 80GB SATA HD (7200 RPM)
> - All pages in ASP (traditional, not .NET)
> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
> - Zonet Gb PCI NIC - used for crossover connection to DB server
> DATABASE SERVER (Dell PowerEdge SC420)
> - Windows 2000 Server SP4
> - MS SQL Server 2000 SP4
> - Pentium 4 2.8 GHz
> - 1GB RAM
> - 2x 80GB SATA HD (7200 RPM), Raid 1
> - Broadcom NetXtreme 5751 Gb on-board NIC
> - Zonet Gb PCI NIC - used for crossover connection to web server
> The two additional dedicated NICs were installed recently.
> Here is a rough cycle of the problem. About a day or two after I
> installed the two NICs, I started getting this error. But it wasn't
> intermittent in that it would fix itself after a while -- once it started
> throwing the error, it would fairly consistently throw it, only allowing a
> connection on rare occasions. The only fix was to reboot the server.
> After rebooting, everything seems find for a day or two, then it starts
> back up, another reboot... repeat.
> I have tested for connection issues between the two NICs, and pinging is
> always successful. I have even completely ruled that out by disabling the
> new NICs, and going back to the original shared connection, and even on
> that connection it will start throwing the errors. I have an alias
> configured using TCP/IP, but I have tried both using the alias and not
> using it (having the IP configured directly in my connection string), and
> the results are the same. I have tried using the machine name (which is
> different than the alias), same results.
> I read about disabling connection pooling causing this, but to my
> knowledge, connection pooling is enabled.
> I'm at a loss. I don't know why this is happening all of the sudden. I
> thought it may be related to the new NICs, but after disabling them and
> still getting the problems, that doesn't seem to be the case.
> Please, any suggestions would be appreciated.
> Thanks in advance.
> Jerad
>|||Thanks for your response, John.
A few clarifcations. The database and webserver are connected to each other
directly via crossover cable, so there is no dns/firewall/routing in the
equasion. I have checked event logs on both web and database server, and
cannot see *anything* that would indicate new problems. I only see the
ongoing events that are normally there, such as SMTP routing problems
(nothing new). Also, I should have specified which server I reboot -- it is
the web server that is rebooted.
So I beleive I have ruled out most of the obvious problems. If there's any
other info you need that may help, let me know.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
> Hi
> You may want to look at other things such as DNS problems, incorrect
> routing or firewall problems. Check out the logs for all of these to see
> if anything corresponds to the time of your failure.
> It is not clear from your post if you reboot the database server or the
> web server, if the former then try restarting IIS or rebooting the web
> server and see if that also cures it!
> John
>
> "Jerad Rose" <no@.spam.com> wrote in message
> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation is
>> unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it started
>> throwing the error, it would fairly consistently throw it, only allowing
>> a connection on rare occasions. The only fix was to reboot the server.
>> After rebooting, everything seems find for a day or two, then it starts
>> back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging is
>> always successful. I have even completely ruled that out by disabling
>> the new NICs, and going back to the original shared connection, and even
>> on that connection it will start throwing the errors. I have an alias
>> configured using TCP/IP, but I have tried both using the alias and not
>> using it (having the IP configured directly in my connection string), and
>> the results are the same. I have tried using the machine name (which is
>> different than the alias), same results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden. I
>> thought it may be related to the new NICs, but after disabling them and
>> still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>|||Hi
Can one assume that you have not installed any new software, updated
existing software or reconfigured any settings on either machine e.g
anti-virus
John
"Jerad Rose" <no@.spam.com> wrote in message
news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response, John.
> A few clarifcations. The database and webserver are connected to each
> other directly via crossover cable, so there is no dns/firewall/routing in
> the equasion. I have checked event logs on both web and database server,
> and cannot see *anything* that would indicate new problems. I only see
> the ongoing events that are normally there, such as SMTP routing problems
> (nothing new). Also, I should have specified which server I reboot -- it
> is the web server that is rebooted.
> So I beleive I have ruled out most of the obvious problems. If there's
> any other info you need that may help, let me know.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> You may want to look at other things such as DNS problems, incorrect
>> routing or firewall problems. Check out the logs for all of these to see
>> if anything corresponds to the time of your failure.
>> It is not clear from your post if you reboot the database server or the
>> web server, if the former then try restarting IIS or rebooting the web
>> server and see if that also cures it!
>> John
>>
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation is
>> unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external
>> connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it
>> started throwing the error, it would fairly consistently throw it, only
>> allowing a connection on rare occasions. The only fix was to reboot the
>> server. After rebooting, everything seems find for a day or two, then it
>> starts back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging is
>> always successful. I have even completely ruled that out by disabling
>> the new NICs, and going back to the original shared connection, and even
>> on that connection it will start throwing the errors. I have an alias
>> configured using TCP/IP, but I have tried both using the alias and not
>> using it (having the IP configured directly in my connection string),
>> and the results are the same. I have tried using the machine name
>> (which is different than the alias), same results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden. I
>> thought it may be related to the new NICs, but after disabling them and
>> still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>>
>|||I have Windows auto-updates turned on, and it updates once a week, so
whatever has been installed there recently. Also, to do some network
monitoring, I have intalled two different monitoring apps (DUMeter and
Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can try
turning those off once I start seeing problem again, but I wouldn't think
those would be my culprit. I haven't done anything else though -- no
configuration changes (at least, outside of potential changes from the
mentioned software) and no antivirus software has been installed.
Thanks again.
Jerad
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
> Hi
> Can one assume that you have not installed any new software, updated
> existing software or reconfigured any settings on either machine e.g
> anti-virus
> John
> "Jerad Rose" <no@.spam.com> wrote in message
> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>> Thanks for your response, John.
>> A few clarifcations. The database and webserver are connected to each
>> other directly via crossover cable, so there is no dns/firewall/routing
>> in the equasion. I have checked event logs on both web and database
>> server, and cannot see *anything* that would indicate new problems. I
>> only see the ongoing events that are normally there, such as SMTP routing
>> problems (nothing new). Also, I should have specified which server I
>> reboot -- it is the web server that is rebooted.
>> So I beleive I have ruled out most of the obvious problems. If there's
>> any other info you need that may help, let me know.
>> Thanks again.
>> Jerad
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> You may want to look at other things such as DNS problems, incorrect
>> routing or firewall problems. Check out the logs for all of these to see
>> if anything corresponds to the time of your failure.
>> It is not clear from your post if you reboot the database server or the
>> web server, if the former then try restarting IIS or rebooting the web
>> server and see if that also cures it!
>> John
>>
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation is
>> unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external
>> connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it
>> started throwing the error, it would fairly consistently throw it, only
>> allowing a connection on rare occasions. The only fix was to reboot
>> the server. After rebooting, everything seems find for a day or two,
>> then it starts back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging
>> is always successful. I have even completely ruled that out by
>> disabling the new NICs, and going back to the original shared
>> connection, and even on that connection it will start throwing the
>> errors. I have an alias configured using TCP/IP, but I have tried both
>> using the alias and not using it (having the IP configured directly in
>> my connection string), and the results are the same. I have tried
>> using the machine name (which is different than the alias), same
>> results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden.
>> I thought it may be related to the new NICs, but after disabling them
>> and still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>>
>>
>|||Hi
This is not necessarily a problem with the web server and SQL Server it
could be that access is denied because of authentication problems. Try using
profiler to monitor logon attempts.
Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
http://support.microsoft.com/default.aspx?scid=kb;en-us;821498
John
"Jerad Rose" <no@.spam.com> wrote in message
news:%233gceCCBGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I have Windows auto-updates turned on, and it updates once a week, so
>whatever has been installed there recently. Also, to do some network
>monitoring, I have intalled two different monitoring apps (DUMeter and
>Bandwidth Monitor Pro) -- maybe those are causing the disruption? I can
>try turning those off once I start seeing problem again, but I wouldn't
>think those would be my culprit. I haven't done anything else though -- no
>configuration changes (at least, outside of potential changes from the
>mentioned software) and no antivirus software has been installed.
> Thanks again.
> Jerad
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uUazFVBBGHA.1584@.TK2MSFTNGP10.phx.gbl...
>> Hi
>> Can one assume that you have not installed any new software, updated
>> existing software or reconfigured any settings on either machine e.g
>> anti-virus
>> John
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:euHnTQBBGHA.4092@.TK2MSFTNGP09.phx.gbl...
>> Thanks for your response, John.
>> A few clarifcations. The database and webserver are connected to each
>> other directly via crossover cable, so there is no dns/firewall/routing
>> in the equasion. I have checked event logs on both web and database
>> server, and cannot see *anything* that would indicate new problems. I
>> only see the ongoing events that are normally there, such as SMTP
>> routing problems (nothing new). Also, I should have specified which
>> server I reboot -- it is the web server that is rebooted.
>> So I beleive I have ruled out most of the obvious problems. If there's
>> any other info you need that may help, let me know.
>> Thanks again.
>> Jerad
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%23wekqiABGHA.976@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> You may want to look at other things such as DNS problems, incorrect
>> routing or firewall problems. Check out the logs for all of these to
>> see if anything corresponds to the time of your failure.
>> It is not clear from your post if you reboot the database server or the
>> web server, if the former then try restarting IIS or rebooting the web
>> server and see if that also cures it!
>> John
>>
>> "Jerad Rose" <no@.spam.com> wrote in message
>> news:OuW4AM$AGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> I've seen this topic posted several times, but it seems my situation
>> is unique for every other case I've seen.
>> I have a web site that has been running for over 3 years. Recently,
>> we've hit a major spike in activity. Now, after a few days (sometimes
>> less), the site will start returning the following error:
>> SQL Server does not exist or access denied.
>> Here are my server specs:
>> WEB SERVER (Shuttle SK41G)
>> - Windows 2000 Server SP4 (IIS 5.0)
>> - Athlon XP 2100+
>> - 1GB RAM
>> - 80GB SATA HD (7200 RPM)
>> - All pages in ASP (traditional, not .NET)
>> - Realtek RTL8139 on-board NIC (*not* 1Gb) - used for external
>> connection
>> - Zonet Gb PCI NIC - used for crossover connection to DB server
>> DATABASE SERVER (Dell PowerEdge SC420)
>> - Windows 2000 Server SP4
>> - MS SQL Server 2000 SP4
>> - Pentium 4 2.8 GHz
>> - 1GB RAM
>> - 2x 80GB SATA HD (7200 RPM), Raid 1
>> - Broadcom NetXtreme 5751 Gb on-board NIC
>> - Zonet Gb PCI NIC - used for crossover connection to web server
>> The two additional dedicated NICs were installed recently.
>> Here is a rough cycle of the problem. About a day or two after I
>> installed the two NICs, I started getting this error. But it wasn't
>> intermittent in that it would fix itself after a while -- once it
>> started throwing the error, it would fairly consistently throw it,
>> only allowing a connection on rare occasions. The only fix was to
>> reboot the server. After rebooting, everything seems find for a day or
>> two, then it starts back up, another reboot... repeat.
>> I have tested for connection issues between the two NICs, and pinging
>> is always successful. I have even completely ruled that out by
>> disabling the new NICs, and going back to the original shared
>> connection, and even on that connection it will start throwing the
>> errors. I have an alias configured using TCP/IP, but I have tried
>> both using the alias and not using it (having the IP configured
>> directly in my connection string), and the results are the same. I
>> have tried using the machine name (which is different than the alias),
>> same results.
>> I read about disabling connection pooling causing this, but to my
>> knowledge, connection pooling is enabled.
>> I'm at a loss. I don't know why this is happening all of the sudden.
>> I thought it may be related to the new NICs, but after disabling them
>> and still getting the problems, that doesn't seem to be the case.
>> Please, any suggestions would be appreciated.
>> Thanks in advance.
>> Jerad
>>
>>
>>
>
Wednesday, March 21, 2012
interesting case for "SQL Server does not exist or access denied." error
My connection string is :
server=localhost;Database=INFOSEC;Integrated Security=true
It works for the login page, but it does not work for the registration page, and give the "SQL Server does not exist or access denied." error.
Any IDEA?
You shouls check your connection string properly and make sure you are calling proper database for registration form.Otherwise can you give the code here.So i can findout the error.
Friday, February 24, 2012
Integration Server access denied
Hello,
I am trying to enable one of our employees to access Integration
Server remotely, however I am received an "access denied" error. I
have set this up on two other machines; one of those is used by an
admin, and it works. The other is used by a user, and it also works.
The employee I receiving the error is an admin on the network. I tried
searching the web, and found steps to add permissions for users in
dcom components settings, but after following these steps, the
situation remains.
Did anyone experience access problems even with admin rights?
Thank you,
KrzysztofHello,
I am not sure what you mean by "admin on the network" but one of the choices
is to add the user as a local Administrator.
You can also try the section 'Eliminating the 'Acess is Denied' Error'
listed here
Connecting to a Remote Integration Services Server
http://technet.microsoft.com/en-us/library/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
"psion" wrote:
> Hello,
> I am trying to enable one of our employees to access Integration
> Server remotely, however I am received an "access denied" error. I
> have set this up on two other machines; one of those is used by an
> admin, and it works. The other is used by a user, and it also works.
> The employee I receiving the error is an admin on the network. I tried
> searching the web, and found steps to add permissions for users in
> dcom components settings, but after following these steps, the
> situation remains.
> Did anyone experience access problems even with admin rights?
> Thank you,
> Krzysztof
>|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=es
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=
.com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
> > Hello,
> > I am trying to enable one of our employees to access Integration
> > Server remotely, however I am received an "access denied" error. I
> > have set this up on two other machines; one of those is used by an
> > admin, and it works. The other is used by a user, and it also works.
> > The employee I receiving the error is an admin on the network. I tried
> > searching the web, and found steps to add permissions for users in
> > dcom components settings, but after following these steps, the
> > situation remains.
> > Did anyone experience access problems even with admin rights?
> > Thank you,
> > Krzysztof- Hide quoted text -
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer, and on the
domain, and the error persists.
Thank you.|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=es
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=
.com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
> > Hello,
> > I am trying to enable one of our employees to access Integration
> > Server remotely, however I am received an "access denied" error. I
> > have set this up on two other machines; one of those is used by an
> > admin, and it works. The other is used by a user, and it also works.
> > The employee I receiving the error is an admin on the network. I tried
> > searching the web, and found steps to add permissions for users in
> > dcom components settings, but after following these steps, the
> > situation remains.
> > Did anyone experience access problems even with admin rights?
> > Thank you,
> > Krzysztof- Hide quoted text -
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer and on the
domain.
THanks
I am trying to enable one of our employees to access Integration
Server remotely, however I am received an "access denied" error. I
have set this up on two other machines; one of those is used by an
admin, and it works. The other is used by a user, and it also works.
The employee I receiving the error is an admin on the network. I tried
searching the web, and found steps to add permissions for users in
dcom components settings, but after following these steps, the
situation remains.
Did anyone experience access problems even with admin rights?
Thank you,
KrzysztofHello,
I am not sure what you mean by "admin on the network" but one of the choices
is to add the user as a local Administrator.
You can also try the section 'Eliminating the 'Acess is Denied' Error'
listed here
Connecting to a Remote Integration Services Server
http://technet.microsoft.com/en-us/library/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
"psion" wrote:
> Hello,
> I am trying to enable one of our employees to access Integration
> Server remotely, however I am received an "access denied" error. I
> have set this up on two other machines; one of those is used by an
> admin, and it works. The other is used by a user, and it also works.
> The employee I receiving the error is an admin on the network. I tried
> searching the web, and found steps to add permissions for users in
> dcom components settings, but after following these steps, the
> situation remains.
> Did anyone experience access problems even with admin rights?
> Thank you,
> Krzysztof
>|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=es
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=
.com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
> > Hello,
> > I am trying to enable one of our employees to access Integration
> > Server remotely, however I am received an "access denied" error. I
> > have set this up on two other machines; one of those is used by an
> > admin, and it works. The other is used by a user, and it also works.
> > The employee I receiving the error is an admin on the network. I tried
> > searching the web, and found steps to add permissions for users in
> > dcom components settings, but after following these steps, the
> > situation remains.
> > Did anyone experience access problems even with admin rights?
> > Thank you,
> > Krzysztof- Hide quoted text -
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer, and on the
domain, and the error persists.
Thank you.|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=es
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=
.com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
> > Hello,
> > I am trying to enable one of our employees to access Integration
> > Server remotely, however I am received an "access denied" error. I
> > have set this up on two other machines; one of those is used by an
> > admin, and it works. The other is used by a user, and it also works.
> > The employee I receiving the error is an admin on the network. I tried
> > searching the web, and found steps to add permissions for users in
> > dcom components settings, but after following these steps, the
> > situation remains.
> > Did anyone experience access problems even with admin rights?
> > Thank you,
> > Krzysztof- Hide quoted text -
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer and on the
domain.
THanks
Integration Server access denied
Hello,
I am trying to enable one of our employees to access Integration
Server remotely, however I am received an "access denied" error. I
have set this up on two other machines; one of those is used by an
admin, and it works. The other is used by a user, and it also works.
The employee I receiving the error is an admin on the network. I tried
searching the web, and found steps to add permissions for users in
dcom components settings, but after following these steps, the
situation remains.
Did anyone experience access problems even with admin rights?
Thank you,
KrzysztofHello,
I am not sure what you mean by "admin on the network" but one of the choices
is to add the user as a local Administrator.
You can also try the section 'Eliminating the 'Acess is Denied' Error'
listed here
Connecting to a Remote Integration Services Server
http://technet.microsoft.com/en-us/...y/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
"psion" wrote:
> Hello,
> I am trying to enable one of our employees to access Integration
> Server remotely, however I am received an "access denied" error. I
> have set this up on two other machines; one of those is used by an
> admin, and it works. The other is used by a user, and it also works.
> The employee I receiving the error is an admin on the network. I tried
> searching the web, and found steps to add permissions for users in
> dcom components settings, but after following these steps, the
> situation remains.
> Did anyone experience access problems even with admin rights?
> Thank you,
> Krzysztof
>|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=[/vbcol
]
es[vbcol=seagreen]
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=[/vbcol
]
.com/en-us/library/aa337083.aspx[vbcol=seagreen]
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer, and on the
domain, and the error persists.
Thank you.|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=[/vbcol
]
es[vbcol=seagreen]
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=[/vbcol
]
.com/en-us/library/aa337083.aspx[vbcol=seagreen]
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer and on the
domain.
THanks
I am trying to enable one of our employees to access Integration
Server remotely, however I am received an "access denied" error. I
have set this up on two other machines; one of those is used by an
admin, and it works. The other is used by a user, and it also works.
The employee I receiving the error is an admin on the network. I tried
searching the web, and found steps to add permissions for users in
dcom components settings, but after following these steps, the
situation remains.
Did anyone experience access problems even with admin rights?
Thank you,
KrzysztofHello,
I am not sure what you mean by "admin on the network" but one of the choices
is to add the user as a local Administrator.
You can also try the section 'Eliminating the 'Acess is Denied' Error'
listed here
Connecting to a Remote Integration Services Server
http://technet.microsoft.com/en-us/...y/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
"psion" wrote:
> Hello,
> I am trying to enable one of our employees to access Integration
> Server remotely, however I am received an "access denied" error. I
> have set this up on two other machines; one of those is used by an
> admin, and it works. The other is used by a user, and it also works.
> The employee I receiving the error is an admin on the network. I tried
> searching the web, and found steps to add permissions for users in
> dcom components settings, but after following these steps, the
> situation remains.
> Did anyone experience access problems even with admin rights?
> Thank you,
> Krzysztof
>|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=[/vbcol
]
es[vbcol=seagreen]
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=[/vbcol
]
.com/en-us/library/aa337083.aspx[vbcol=seagreen]
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer, and on the
domain, and the error persists.
Thank you.|||On Jan 3, 11:41=A0am, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choic=[/vbcol
]
es[vbcol=seagreen]
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft=[/vbcol
]
.com/en-us/library/aa337083.aspx[vbcol=seagreen]
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer and on the
domain.
THanks
Integration Server access denied
Hello,
I am trying to enable one of our employees to access Integration
Server remotely, however I am received an "access denied" error. I
have set this up on two other machines; one of those is used by an
admin, and it works. The other is used by a user, and it also works.
The employee I receiving the error is an admin on the network. I tried
searching the web, and found steps to add permissions for users in
dcom components settings, but after following these steps, the
situation remains.
Did anyone experience access problems even with admin rights?
Thank you,
Krzysztof
Hello,
I am not sure what you mean by "admin on the network" but one of the choices
is to add the user as a local Administrator.
You can also try the section 'Eliminating the 'Acess is Denied' Error'
listed here
Connecting to a Remote Integration Services Server
http://technet.microsoft.com/en-us/library/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
"psion" wrote:
> Hello,
> I am trying to enable one of our employees to access Integration
> Server remotely, however I am received an "access denied" error. I
> have set this up on two other machines; one of those is used by an
> admin, and it works. The other is used by a user, and it also works.
> The employee I receiving the error is an admin on the network. I tried
> searching the web, and found steps to add permissions for users in
> dcom components settings, but after following these steps, the
> situation remains.
> Did anyone experience access problems even with admin rights?
> Thank you,
> Krzysztof
>
|||On Jan 3, 11:41Xam, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choices
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft..com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer, and on the
domain, and the error persists.
Thank you.
|||On Jan 3, 11:41Xam, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choices
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft..com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer and on the
domain.
THanks
I am trying to enable one of our employees to access Integration
Server remotely, however I am received an "access denied" error. I
have set this up on two other machines; one of those is used by an
admin, and it works. The other is used by a user, and it also works.
The employee I receiving the error is an admin on the network. I tried
searching the web, and found steps to add permissions for users in
dcom components settings, but after following these steps, the
situation remains.
Did anyone experience access problems even with admin rights?
Thank you,
Krzysztof
Hello,
I am not sure what you mean by "admin on the network" but one of the choices
is to add the user as a local Administrator.
You can also try the section 'Eliminating the 'Acess is Denied' Error'
listed here
Connecting to a Remote Integration Services Server
http://technet.microsoft.com/en-us/library/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
"psion" wrote:
> Hello,
> I am trying to enable one of our employees to access Integration
> Server remotely, however I am received an "access denied" error. I
> have set this up on two other machines; one of those is used by an
> admin, and it works. The other is used by a user, and it also works.
> The employee I receiving the error is an admin on the network. I tried
> searching the web, and found steps to add permissions for users in
> dcom components settings, but after following these steps, the
> situation remains.
> Did anyone experience access problems even with admin rights?
> Thank you,
> Krzysztof
>
|||On Jan 3, 11:41Xam, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choices
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft..com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer, and on the
domain, and the error persists.
Thank you.
|||On Jan 3, 11:41Xam, Ben Nevarez <BenNeva...@.discussions.microsoft.com>
wrote:
> Hello,
> I am not sure what you mean by "admin on the network" but one of the choices
> is to add the user as a local Administrator.
> You can also try the section 'Eliminating the 'Acess is Denied' Error'
> listed here
> Connecting to a Remote Integration Services Serverhttp://technet.microsoft..com/en-us/library/aa337083.aspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "psion" wrote:
>
> - Show quoted text -
Hi Ben,
The user is already an administrator on the local computer and on the
domain.
THanks
Subscribe to:
Posts (Atom)