Error: 1101, Severity: 17, State: 10

Error: 1101, Severity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There
are no more pages available in filegroup DEFAULT. Space
can be created by dropping objects, adding additional
files, or allowing file growth..
Does anybody know the quick fix to this? Thx.Rose,
Tempdb has filled up its space or has filled the disk
where it was created.
This leads to an MSDN article on expanding databases with
some specific comments on tempdb.
http://tinyurl.com/hoh4
Since tempdb is recreated each time you start the server
a restart will clear the current problem. However, you
should try to find out what was happening that filled
tempdb and try to prevent it from happening again.
Russell Fields
>--Original Message--
>Error: 1101, Severity: 17, State: 10
>Could not allocate new page for database 'TEMPDB'. There
>are no more pages available in filegroup DEFAULT. Space
>can be created by dropping objects, adding additional
>files, or allowing file growth..
>Does anybody know the quick fix to this? Thx.
>.
>|||Rose,
>> Does anybody know the quick fix to this?
How about the one mentioned in the error message itself? Did you check if
there is enough space in the filegroup?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rose Mbatuchic" <simacy6@.yahoo.com> wrote in message
news:0bd401c35059$82aec8b0$a401280a@.phx.gbl...
> Error: 1101, Severity: 17, State: 10
> Could not allocate new page for database 'TEMPDB'. There
> are no more pages available in filegroup DEFAULT. Space
> can be created by dropping objects, adding additional
> files, or allowing file growth..
> Does anybody know the quick fix to this? Thx.

Error: [DBNMPNTW]Access denied.

Hi,
I have set up a server with IIS. The pages needs authentication to browse.
When the pages are browsed from the machine where IIS is set up It is loging
in the user.
When a user is trying to login from a different location or machine, its
gives the following error message, How to fix the issue.
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.
We are using Named Pipes. Do we have to make any settings changes...
Can any one help...
I always use TCP/IP when connecting from ASP/VB. Have you tried that
instead?
http://www.aspfaq.com/
(Reverse address to reply.)
"Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> Hi,
> I have set up a server with IIS. The pages needs authentication to browse.
> When the pages are browsed from the machine where IIS is set up It is
loging
> in the user.
> When a user is trying to login from a different location or machine, its
> gives the following error message, How to fix the issue.
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNMPNTW]Access denied.
>
> We are using Named Pipes. Do we have to make any settings changes...
> Can any one help...
>
>
|||Aaron,
Thanx for your reply, The problem is like this.
Like if i logion to the machine where teh site is set up and Login, for the
next five minutes or so i am able to login from different machines/ location.
After that if the session in the Server Machine expires then from all the
other places if i try to login the login is giving the below mentioned error
message
Deepak
"Aaron [SQL Server MVP]" wrote:

> I always use TCP/IP when connecting from ASP/VB. Have you tried that
> instead?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
> message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> loging
>
>

Error: [DBNMPNTW]Access denied.

Hi,
I have set up a server with IIS. The pages needs authentication to browse.
When the pages are browsed from the machine where IIS is set up It is loging
in the user.
When a user is trying to login from a different location or machine, its
gives the following error message, How to fix the issue.
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.
We are using Named Pipes. Do we have to make any settings changes...
Can any one help...I always use TCP/IP when connecting from ASP/VB. Have you tried that
instead?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> Hi,
> I have set up a server with IIS. The pages needs authentication to browse.
> When the pages are browsed from the machine where IIS is set up It is
loging
> in the user.
> When a user is trying to login from a different location or machine, its
> gives the following error message, How to fix the issue.
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNMPNTW]Access denied.
>
> We are using Named Pipes. Do we have to make any settings changes...
> Can any one help...
>
>|||Aaron,
Thanx for your reply, The problem is like this.
Like if i logion to the machine where teh site is set up and Login, for the
next five minutes or so i am able to login from different machines/ location.
After that if the session in the Server Machine expires then from all the
other places if i try to login the login is giving the below mentioned error
message
Deepak
"Aaron [SQL Server MVP]" wrote:
> I always use TCP/IP when connecting from ASP/VB. Have you tried that
> instead?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
> message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> > Hi,
> >
> > I have set up a server with IIS. The pages needs authentication to browse.
> > When the pages are browsed from the machine where IIS is set up It is
> loging
> > in the user.
> >
> > When a user is trying to login from a different location or machine, its
> > gives the following error message, How to fix the issue.
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> >
> > [DBNMPNTW]Access denied.
> >
> >
> > We are using Named Pipes. Do we have to make any settings changes...
> >
> > Can any one help...
> >
> >
> >
> >
>
>

Error with sqlxml and ServerXMLHTTP

After I installed windows 2003 sp1 in the server with iis the asp pages that
use the object "MSXML2.ServerXMLHTTP.3.0" and SQLXML 3.0 with sp1 started to
return errors:
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: Query not specified
The code used is like this one:
<%@.language="VBScript"%>
<%
Response.Expires = 0
Response.CacheControl = "private"
Response.Buffer = True
dim objXMLDocument, vTabela
dim objSrvHTTP, sXml
dim vXMLTemplate
'this is the path of the virtual directory mangead by sqlxml 3.0
sXml = "http://s3iapps.tcontas.pt/gent"
vXMLTemplate = "<GENT xmlns:sql=""urn:schemas-microsoft-com:xml-sql""
sql:xsl=""forms/ResultadoPesqDel.xsl""><sql:query>exec usp_pesq_entidade
@.Colunas ='1010000100', @.Argumentos1 ='Design_Abrev like ''%cml%'' AND Estado
= ''A''',@.Argumentos2 ='',@.Argumentos3 ='', @.Descricao ='(sem descri??o)',
@.Funcionario =461, @.Gravar = 0,
@.vNomeTabela='0687972767815343'</sql:query></GENT>"
set objSrvHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
set objXMLDocument = Server.CreateObject ("MSXML2.DOMDocument.3.0")
objXMLDocument.loadXML vXMLTemplate
objSrvHTTP.setTimeouts 0, 0, (15 * 1000000), (15 * 1000000)
objSrvHTTP.open "POST",sXml, false
objSrvHTTP.setRequestHeader "Content-Type", "application/xml"
objSrvHTTP.send objXMLDocument
Response.ContentType = "text/html"
Response.CharSet = "iso-8859-1"
Response.Write objSrvHTTP.responseText
%>
Any help is welcome,
thanks in advance
Joao Carlos
Which version of the OS did you upgrade from?
Also, you may want to check out SQLXML 3.0 SP3 - the latest and greatest
version of SQLXML 3.0 from
http://www.microsoft.com/downloads/d...displaylang=en
Thanks,
Adam Wiener [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"jcc" <jcc@.discussions.microsoft.com> wrote in message
news:DA9E6B50-EDE2-443B-9949-001CEE4C30F6@.microsoft.com...
> After I installed windows 2003 sp1 in the server with iis the asp pages
that
> use the object "MSXML2.ServerXMLHTTP.3.0" and SQLXML 3.0 with sp1 started
to
> return errors:
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: Query not specified
>
> The code used is like this one:
> <%@.language="VBScript"%>
>
> <%
> Response.Expires = 0
> Response.CacheControl = "private"
> Response.Buffer = True
> dim objXMLDocument, vTabela
> dim objSrvHTTP, sXml
> dim vXMLTemplate
> 'this is the path of the virtual directory mangead by sqlxml 3.0
> sXml = "http://s3iapps.tcontas.pt/gent"
> vXMLTemplate = "<GENT xmlns:sql=""urn:schemas-microsoft-com:xml-sql""
> sql:xsl=""forms/ResultadoPesqDel.xsl""><sql:query>exec usp_pesq_entidade
> @.Colunas ='1010000100', @.Argumentos1 ='Design_Abrev like ''%cml%'' AND
Estado
> = ''A''',@.Argumentos2 ='',@.Argumentos3 ='', @.Descricao ='(sem descrio)',
> @.Funcionario =461, @.Gravar = 0,
> @.vNomeTabela='0687972767815343'</sql:query></GENT>"
> set objSrvHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
> set objXMLDocument = Server.CreateObject ("MSXML2.DOMDocument.3.0")
> objXMLDocument.loadXML vXMLTemplate
> objSrvHTTP.setTimeouts 0, 0, (15 * 1000000), (15 * 1000000)
> objSrvHTTP.open "POST",sXml, false
> objSrvHTTP.setRequestHeader "Content-Type", "application/xml"
> objSrvHTTP.send objXMLDocument
> Response.ContentType = "text/html"
> Response.CharSet = "iso-8859-1"
> Response.Write objSrvHTTP.responseText
> %>
>
> Any help is welcome,
> thanks in advance
> Joao Carlos

Error with sqlxml and ServerXMLHTTP

After I installed windows 2003 sp1 in the server with iis the asp pages that
use the object "MSXML2.ServerXMLHTTP.3.0" and SQLXML 3.0 with sp1 started to
return errors:
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: Query not specified
The code used is like this one:
<%@.language="VBScript"%>
<%
Response.Expires = 0
Response.CacheControl = "private"
Response.Buffer = True
dim objXMLDocument, vTabela
dim objSrvHTTP, sXml
dim vXMLTemplate
'this is the path of the virtual directory mangead by sqlxml 3.0
sXml = "http://s3iapps.tcontas.pt/gent"
vXMLTemplate = "<GENT xmlns:sql=""urn:schemas-microsoft-com:xml-sql""
sql:xsl=""forms/ResultadoPesqDel.xsl""><sql:query>exec usp_pesq_entidade
@.Colunas ='1010000100', @.Argumentos1 ='Design_Abrev like ''%cml%'' AND Estad
o
= ''A''',@.Argumentos2 ='',@.Argumentos3 ='', @.Descricao ='(sem descri??o)',
@.Funcionario =461, @.Gravar = 0,
@.vNomeTabela='0687972767815343'</sql:query></GENT>"
set objSrvHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
set objXMLDocument = Server.CreateObject ("MSXML2.DOMDocument.3.0")
objXMLDocument.loadXML vXMLTemplate
objSrvHTTP.setTimeouts 0, 0, (15 * 1000000), (15 * 1000000)
objSrvHTTP.open "POST",sXml, false
objSrvHTTP.setRequestHeader "Content-Type", "application/xml"
objSrvHTTP.send objXMLDocument
Response.ContentType = "text/html"
Response.CharSet = "iso-8859-1"
Response.Write objSrvHTTP.responseText
%>
Any help is welcome,
thanks in advance
Joao CarlosWhich version of the OS did you upgrade from?
Also, you may want to check out SQLXML 3.0 SP3 - the latest and greatest
version of SQLXML 3.0 from
http://www.microsoft.com/downloads/...&displaylang=en
Thanks,
Adam Wiener [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"jcc" <jcc@.discussions.microsoft.com> wrote in message
news:DA9E6B50-EDE2-443B-9949-001CEE4C30F6@.microsoft.com...
> After I installed windows 2003 sp1 in the server with iis the asp pages
that
> use the object "MSXML2.ServerXMLHTTP.3.0" and SQLXML 3.0 with sp1 started
to
> return errors:
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: Query not specified
>
> The code used is like this one:
> <%@.language="VBScript"%>
>
> <%
> Response.Expires = 0
> Response.CacheControl = "private"
> Response.Buffer = True
> dim objXMLDocument, vTabela
> dim objSrvHTTP, sXml
> dim vXMLTemplate
> 'this is the path of the virtual directory mangead by sqlxml 3.0
> sXml = "http://s3iapps.tcontas.pt/gent"
> vXMLTemplate = "<GENT xmlns:sql=""urn:schemas-microsoft-com:xml-sql""
> sql:xsl=""forms/ResultadoPesqDel.xsl""><sql:query>exec usp_pesq_entidade
> @.Colunas ='1010000100', @.Argumentos1 ='Design_Abrev like ''%cml%'' AND
Estado
> = ''A''',@.Argumentos2 ='',@.Argumentos3 ='', @.Descricao ='(sem descrio)',
> @.Funcionario =461, @.Gravar = 0,
> @.vNomeTabela='0687972767815343'</sql:query></GENT>"
> set objSrvHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
> set objXMLDocument = Server.CreateObject ("MSXML2.DOMDocument.3.0")
> objXMLDocument.loadXML vXMLTemplate
> objSrvHTTP.setTimeouts 0, 0, (15 * 1000000), (15 * 1000000)
> objSrvHTTP.open "POST",sXml, false
> objSrvHTTP.setRequestHeader "Content-Type", "application/xml"
> objSrvHTTP.send objXMLDocument
> Response.ContentType = "text/html"
> Response.CharSet = "iso-8859-1"
> Response.Write objSrvHTTP.responseText
> %>
>
> Any help is welcome,
> thanks in advance
> Joao Carlos