First off, I'm not sure whether this is an IIS or SQL question so forgive me
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
NigelUse Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
forgive[vbcol=seagreen]
> me
> NT4
(sp4),[vbcol=seagreen]
> based.
name[vbcol=seagreen]
> (as
and[vbcol=seagreen]
are[vbcol=seagreen]
IP[vbcol=seagreen]
shouldn't[vbcol=seagreen]
> be
way[vbcol=seagreen]
> head
>|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556
@.tk2msftngp13.phx.gbl>...
<snip>
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (a
s
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16> ).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt
Showing posts with label iis5. Show all posts
Showing posts with label iis5. Show all posts
Friday, March 9, 2012
IIS5 & SQL Server 2000
First off, I'm not sure whether this is an IIS or SQL question so forgive me
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
NigelUse Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> > First off, I'm not sure whether this is an IIS or SQL question so
forgive
> me
> > if I'm posting off topic.
> >
> > I am in the process of moving a number of webs from a single box running
> NT4
> > (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server
(sp4),
> > with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
> based.
> > The connection strings are configured to use SQLOLEDB with the server
name
> > appearing somewhere in the string.
> >
> > The problem is that when you try to connect the web to SQL Server it
> > generates an "SQL Server Does Not Exist or Access Denied" error message
> (as
> > per kb328306). I have gone through all of the options in this article
and
> > am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc)
are
> > fully functional. However when I change the server name to the server
IP
> > address in the connection string, it works.
> >
> > Oh, while I remember, both servers have valid dns entries so it
shouldn't
> be
> > a cased of unresolved names.
> >
> > The question then is, is this something to do with differences in the
way
> > IIS 5 works as against IIS 4.
> >
> > Long life and prosperity to anyone who can help me out with this - my
> head
> > hurts and the wall is about to collapse...
> >
> > TIA
> >
> > Nigel
> >
> >
>|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556@.tk2msftngp13.phx.gbl>...
<snip>
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16>).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
NigelUse Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> > First off, I'm not sure whether this is an IIS or SQL question so
forgive
> me
> > if I'm posting off topic.
> >
> > I am in the process of moving a number of webs from a single box running
> NT4
> > (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server
(sp4),
> > with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
> based.
> > The connection strings are configured to use SQLOLEDB with the server
name
> > appearing somewhere in the string.
> >
> > The problem is that when you try to connect the web to SQL Server it
> > generates an "SQL Server Does Not Exist or Access Denied" error message
> (as
> > per kb328306). I have gone through all of the options in this article
and
> > am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc)
are
> > fully functional. However when I change the server name to the server
IP
> > address in the connection string, it works.
> >
> > Oh, while I remember, both servers have valid dns entries so it
shouldn't
> be
> > a cased of unresolved names.
> >
> > The question then is, is this something to do with differences in the
way
> > IIS 5 works as against IIS 4.
> >
> > Long life and prosperity to anyone who can help me out with this - my
> head
> > hurts and the wall is about to collapse...
> >
> > TIA
> >
> > Nigel
> >
> >
>|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556@.tk2msftngp13.phx.gbl>...
<snip>
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16>).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt
IIS5 & SQL Server 2000
First off, I'm not sure whether this is an IIS or SQL question so forgive me
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
Nigel
Use Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>
|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when[vbcol=seagreen]
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
forgive[vbcol=seagreen]
> me
> NT4
(sp4),[vbcol=seagreen]
> based.
name[vbcol=seagreen]
> (as
and[vbcol=seagreen]
are[vbcol=seagreen]
IP[vbcol=seagreen]
shouldn't[vbcol=seagreen]
> be
way
> head
>
|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556@.tk2msftngp13.phx.gbl>...
<snip>
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16>).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
Nigel
Use Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>
|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when[vbcol=seagreen]
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
forgive[vbcol=seagreen]
> me
> NT4
(sp4),[vbcol=seagreen]
> based.
name[vbcol=seagreen]
> (as
and[vbcol=seagreen]
are[vbcol=seagreen]
IP[vbcol=seagreen]
shouldn't[vbcol=seagreen]
> be
way
> head
>
|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556@.tk2msftngp13.phx.gbl>...
<snip>
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16>).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt
IIS security problem
Hi,
I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS has all the patches that I can find. While IIS running, this computer has been hijacked or turn to proxy server to deliver spam mails. How can I provent it (no smpt service running.)I am not sure I understand the issue you're facing, can you explain some
more?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> Hi,
> I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS
has all the patches that I can find. While IIS running, this computer has
been hijacked or turn to proxy server to deliver spam mails. How can I
provent it (no smpt service running.)|||Note that you do not need to have either an email client nor an email server
running. There would be no way for your server to be hijacked if you do not
have these installed. Yes, you can use either but you do not need to. I am
configured where RS sends the email to an SMTP server which resides
elsewhere.
Bruce L-C
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> I keep getting email indicate that my computer was hijack and used as
proxy server to deliver hugh emails while IIS5.0 running. It is very
difficult to get budget to try sql reporting service specially it is not
secure. First I did implement sending email in sql reporting service by
changing in configuration file (drop off email files in a folder to smtp to
pick them up). Once I had this problem then I turned off smtp but I still
got emails indicated that my computer was hijacked. I installed lock down
IIS and all the patch for IIS5.0. I would like to try RS but if I still
cause problem to others, I might not be able to test or implement this
software. If you need more info. please let me know.
> "Tudor Trufinescu (MSFT)" wrote:
> > I am not sure I understand the issue you're facing, can you explain some
> > more?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > Hi,
> > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
IIS
> > has all the patches that I can find. While IIS running, this computer
has
> > been hijacked or turn to proxy server to deliver spam mails. How can I
> > provent it (no smpt service running.)
> >
> >
> >|||Thanks. Unfortunately, this is a test on my computer, I have to have mail client on this computer.
"Bruce Loehle-Conger" wrote:
> Note that you do not need to have either an email client nor an email server
> running. There would be no way for your server to be hijacked if you do not
> have these installed. Yes, you can use either but you do not need to. I am
> configured where RS sends the email to an SMTP server which resides
> elsewhere.
> Bruce L-C
> "csoon" <csoon@.discussions.microsoft.com> wrote in message
> news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> > I keep getting email indicate that my computer was hijack and used as
> proxy server to deliver hugh emails while IIS5.0 running. It is very
> difficult to get budget to try sql reporting service specially it is not
> secure. First I did implement sending email in sql reporting service by
> changing in configuration file (drop off email files in a folder to smtp to
> pick them up). Once I had this problem then I turned off smtp but I still
> got emails indicated that my computer was hijacked. I installed lock down
> IIS and all the patch for IIS5.0. I would like to try RS but if I still
> cause problem to others, I might not be able to test or implement this
> software. If you need more info. please let me know.
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > I am not sure I understand the issue you're facing, can you explain some
> > > more?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > > Hi,
> > > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
> IIS
> > > has all the patches that I can find. While IIS running, this computer
> has
> > > been hijacked or turn to proxy server to deliver spam mails. How can I
> > > provent it (no smpt service running.)
> > >
> > >
> > >
>
>
I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS has all the patches that I can find. While IIS running, this computer has been hijacked or turn to proxy server to deliver spam mails. How can I provent it (no smpt service running.)I am not sure I understand the issue you're facing, can you explain some
more?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> Hi,
> I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS
has all the patches that I can find. While IIS running, this computer has
been hijacked or turn to proxy server to deliver spam mails. How can I
provent it (no smpt service running.)|||Note that you do not need to have either an email client nor an email server
running. There would be no way for your server to be hijacked if you do not
have these installed. Yes, you can use either but you do not need to. I am
configured where RS sends the email to an SMTP server which resides
elsewhere.
Bruce L-C
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> I keep getting email indicate that my computer was hijack and used as
proxy server to deliver hugh emails while IIS5.0 running. It is very
difficult to get budget to try sql reporting service specially it is not
secure. First I did implement sending email in sql reporting service by
changing in configuration file (drop off email files in a folder to smtp to
pick them up). Once I had this problem then I turned off smtp but I still
got emails indicated that my computer was hijacked. I installed lock down
IIS and all the patch for IIS5.0. I would like to try RS but if I still
cause problem to others, I might not be able to test or implement this
software. If you need more info. please let me know.
> "Tudor Trufinescu (MSFT)" wrote:
> > I am not sure I understand the issue you're facing, can you explain some
> > more?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > Hi,
> > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
IIS
> > has all the patches that I can find. While IIS running, this computer
has
> > been hijacked or turn to proxy server to deliver spam mails. How can I
> > provent it (no smpt service running.)
> >
> >
> >|||Thanks. Unfortunately, this is a test on my computer, I have to have mail client on this computer.
"Bruce Loehle-Conger" wrote:
> Note that you do not need to have either an email client nor an email server
> running. There would be no way for your server to be hijacked if you do not
> have these installed. Yes, you can use either but you do not need to. I am
> configured where RS sends the email to an SMTP server which resides
> elsewhere.
> Bruce L-C
> "csoon" <csoon@.discussions.microsoft.com> wrote in message
> news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> > I keep getting email indicate that my computer was hijack and used as
> proxy server to deliver hugh emails while IIS5.0 running. It is very
> difficult to get budget to try sql reporting service specially it is not
> secure. First I did implement sending email in sql reporting service by
> changing in configuration file (drop off email files in a folder to smtp to
> pick them up). Once I had this problem then I turned off smtp but I still
> got emails indicated that my computer was hijacked. I installed lock down
> IIS and all the patch for IIS5.0. I would like to try RS but if I still
> cause problem to others, I might not be able to test or implement this
> software. If you need more info. please let me know.
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > I am not sure I understand the issue you're facing, can you explain some
> > > more?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > > Hi,
> > > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
> IIS
> > > has all the patches that I can find. While IIS running, this computer
> has
> > > been hijacked or turn to proxy server to deliver spam mails. How can I
> > > provent it (no smpt service running.)
> > >
> > >
> > >
>
>
Wednesday, March 7, 2012
IIS + SQL (Not enough storage is available to complete this operation)
Sometimes we got an error (Not enough storage is available to complete this
operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful
Thanks"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>
and the event error log says what?|||Do you see any errors in the Event Log (particularly about non-paged or
paged pool depletion)?
Cheers
Ken
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>|||"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
How much space is free in your database and the tempdb database? Are the
transaction logs full or not large enough? Are there any errors in the SQL
logs?
kind regards,
Karl Levinson, CISSP, CCSA, MCSE [MS MVP]
--
Microsoft Security FAQ:
http://securityadmin.info|||There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.
Thanks
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>
operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful
Thanks"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>
and the event error log says what?|||Do you see any errors in the Event Log (particularly about non-paged or
paged pool depletion)?
Cheers
Ken
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>|||"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
How much space is free in your database and the tempdb database? Are the
transaction logs full or not large enough? Are there any errors in the SQL
logs?
kind regards,
Karl Levinson, CISSP, CCSA, MCSE [MS MVP]
--
Microsoft Security FAQ:
http://securityadmin.info|||There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.
Thanks
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>
IIS + SQL (Not enough storage is available to complete this operation)
Sometimes we got an error (Not enough storage is available to complete this
operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful
Thanks"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>
and the event error log says what?|||Do you see any errors in the Event Log (particularly about non-paged or
paged pool depletion)?
Cheers
Ken
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>|||"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
How much space is free in your database and the tempdb database? Are the
transaction logs full or not large enough? Are there any errors in the SQL
logs?
--
kind regards,
Karl Levinson, CISSP, CCSA, MCSE [MS MVP]
--
Microsoft Security FAQ:
http://securityadmin.info|||There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.
Thanks
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>|||Sometimes we got an error (Not enough storage is available to complete
this
operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check
the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful
There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.|||tolgay wrote:
> Sometimes we got an error (Not enough storage is available to
> complete this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could
> not find the error reason. When the error occured the server cpu or
> mem or I/O usage is normal and I try to find out from internet and
> some says check the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of
> them close after the proccess also all recordset are close and set
> nothing. The server transaction is kind of high but there are
> several indexes so it not seems a problem there. When IIS restarts
> the problem solves but all users sesions are closed. Have you ever
> met the error before or what can be problem. Any advice would be
> helpful
> There is nothing in to event log even a warning also temp db size
> quite large and the db transaction log is about 2 gbyte and %75 is
> free and there is nothing also in sql server logs.
We were seeing this problem and tracked ours back to a huge number of
active directory groups - we use the following in a .reg file to
increase the size - works ok after reboot then - it affected all sorts
of things - we couldnt add a pc to the domain without seeing this error.
Copy the following into notepad and save with name of your choosing,
ours in mtsize.reg then run it to make the change in the registry.
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parame
ters]
"MaxTokenSize"=dword:00010000
operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful
Thanks"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>
and the event error log says what?|||Do you see any errors in the Event Log (particularly about non-paged or
paged pool depletion)?
Cheers
Ken
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>|||"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
How much space is free in your database and the tempdb database? Are the
transaction logs full or not large enough? Are there any errors in the SQL
logs?
--
kind regards,
Karl Levinson, CISSP, CCSA, MCSE [MS MVP]
--
Microsoft Security FAQ:
http://securityadmin.info|||There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.
Thanks
"tolgay" <tgul@.tgul.com> wrote in message
news:uibNfg0qGHA.4676@.TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
> Thanks
>|||Sometimes we got an error (Not enough storage is available to complete
this
operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check
the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful
There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.|||tolgay wrote:
> Sometimes we got an error (Not enough storage is available to
> complete this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could
> not find the error reason. When the error occured the server cpu or
> mem or I/O usage is normal and I try to find out from internet and
> some says check the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of
> them close after the proccess also all recordset are close and set
> nothing. The server transaction is kind of high but there are
> several indexes so it not seems a problem there. When IIS restarts
> the problem solves but all users sesions are closed. Have you ever
> met the error before or what can be problem. Any advice would be
> helpful
> There is nothing in to event log even a warning also temp db size
> quite large and the db transaction log is about 2 gbyte and %75 is
> free and there is nothing also in sql server logs.
We were seeing this problem and tracked ours back to a huge number of
active directory groups - we use the following in a .reg file to
increase the size - works ok after reboot then - it affected all sorts
of things - we couldnt add a pc to the domain without seeing this error.
Copy the following into notepad and save with name of your choosing,
ours in mtsize.reg then run it to make the change in the registry.
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parame
ters]
"MaxTokenSize"=dword:00010000
Subscribe to:
Posts (Atom)