Some times on over prod. server i found some porcesses running for more than
2-3 hors, they r not in sleeping mode but runnable.
How it cab happen as our frontend uses commandtimout= 3 minutes.
ThanksThe timeout will just tell the client to give up after 3 minutes and
stop waiting for a response from the server. It doesn't tell the server
to abort the statement. The only way to get the server to give up in
the middle of a statement, assuming the server doesn't encounter an
exception (ie. throw an error) during processing of that statement, is
to use the KILL statement to terminate the SPID (process), which will
also disconnect the client application using that connection.
However, if a process has been running for a couple hours and you kill
it, then presumedly it has been doing a fair bit of work and the server
will need to roll that work back. So killing a process often, but not
always, takes as long as the current statement has been running for
anyway, and you never know if the statement is just seconds away from
finishing; that's the risk you take.
*mike hodgson*
http://sqlnerd.blogspot.com
vicky wrote:
>Some times on over prod. server i found some porcesses running for more tha
n
>2-3 hors, they r not in sleeping mode but runnable.
>How it cab happen as our frontend uses commandtimout= 3 minutes.
>Thanks
>
>|||Is this user process or some scheduled/system task. Please take a look at
one of Erland's script which should help narrow things down.
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
-oj
"vicky" <v@.v.com> wrote in message
news:%237T88MhmGHA.3600@.TK2MSFTNGP02.phx.gbl...
> Some times on over prod. server i found some porcesses running for more
> than 2-3 hors, they r not in sleeping mode but runnable.
> How it cab happen as our frontend uses commandtimout= 3 minutes.
> Thanks
>|||Is this user process or some scheduled/system task. Please take a look at
one of Erland's script which should help narrow things down.
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
-oj
"vicky" <v@.v.com> wrote in message
news:%237T88MhmGHA.3600@.TK2MSFTNGP02.phx.gbl...
> Some times on over prod. server i found some porcesses running for more
> than 2-3 hors, they r not in sleeping mode but runnable.
> How it cab happen as our frontend uses commandtimout= 3 minutes.
> Thanks
>|||The timeout will just tell the client to give up after 3 minutes and
stop waiting for a response from the server. It doesn't tell the server
to abort the statement. The only way to get the server to give up in
the middle of a statement, assuming the server doesn't encounter an
exception (ie. throw an error) during processing of that statement, is
to use the KILL statement to terminate the SPID (process), which will
also disconnect the client application using that connection.
However, if a process has been running for a couple hours and you kill
it, then presumedly it has been doing a fair bit of work and the server
will need to roll that work back. So killing a process often, but not
always, takes as long as the current statement has been running for
anyway, and you never know if the statement is just seconds away from
finishing; that's the risk you take.
*mike hodgson*
http://sqlnerd.blogspot.com
vicky wrote:
>Some times on over prod. server i found some porcesses running for more tha
n
>2-3 hors, they r not in sleeping mode but runnable.
>How it cab happen as our frontend uses commandtimout= 3 minutes.
>Thanks
>
>sql
Showing posts with label mode. Show all posts
Showing posts with label mode. Show all posts
Friday, March 30, 2012
long running runnable processess
Some times on over prod. server i found some porcesses running for more than
2-3 hors, they r not in sleeping mode but runnable.
How it cab happen as our frontend uses commandtimout= 3 minutes.
ThanksIs this user process or some scheduled/system task. Please take a look at
one of Erland's script which should help narrow things down.
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
--
-oj
"vicky" <v@.v.com> wrote in message
news:%237T88MhmGHA.3600@.TK2MSFTNGP02.phx.gbl...
> Some times on over prod. server i found some porcesses running for more
> than 2-3 hors, they r not in sleeping mode but runnable.
> How it cab happen as our frontend uses commandtimout= 3 minutes.
> Thanks
>|||This is a multi-part message in MIME format.
--080207000202000207010303
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
The timeout will just tell the client to give up after 3 minutes and
stop waiting for a response from the server. It doesn't tell the server
to abort the statement. The only way to get the server to give up in
the middle of a statement, assuming the server doesn't encounter an
exception (ie. throw an error) during processing of that statement, is
to use the KILL statement to terminate the SPID (process), which will
also disconnect the client application using that connection.
However, if a process has been running for a couple hours and you kill
it, then presumedly it has been doing a fair bit of work and the server
will need to roll that work back. So killing a process often, but not
always, takes as long as the current statement has been running for
anyway, and you never know if the statement is just seconds away from
finishing; that's the risk you take.
--
*mike hodgson*
http://sqlnerd.blogspot.com
vicky wrote:
>Some times on over prod. server i found some porcesses running for more than
>2-3 hors, they r not in sleeping mode but runnable.
>How it cab happen as our frontend uses commandtimout= 3 minutes.
>Thanks
>
>
--080207000202000207010303
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>The timeout will just tell the client to give up after 3 minutes
and stop waiting for a response from the server. It doesn't tell the
server to abort the statement. The only way to get the server to give
up in the middle of a statement, assuming the server doesn't encounter
an exception (ie. throw an error) during processing of that statement,
is to use the KILL statement to terminate the SPID (process), which
will also disconnect the client application using that connection.<br>
<br>
However, if a process has been running for a couple hours and you kill
it, then presumedly it has been doing a fair bit of work and the server
will need to roll that work back. So killing a process often, but not
always, takes as long as the current statement has been running for
anyway, and you never know if the statement is just seconds away from
finishing; that's the risk you take.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
vicky wrote:
<blockquote cite="mid%237T88MhmGHA.3600@.TK2MSFTNGP02.phx.gbl"
type="cite">
<pre wrap="">Some times on over prod. server i found some porcesses running for more than
2-3 hors, they r not in sleeping mode but runnable.
How it cab happen as our frontend uses commandtimout= 3 minutes.
Thanks
</pre>
</blockquote>
</body>
</html>
--080207000202000207010303--
2-3 hors, they r not in sleeping mode but runnable.
How it cab happen as our frontend uses commandtimout= 3 minutes.
ThanksIs this user process or some scheduled/system task. Please take a look at
one of Erland's script which should help narrow things down.
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
--
-oj
"vicky" <v@.v.com> wrote in message
news:%237T88MhmGHA.3600@.TK2MSFTNGP02.phx.gbl...
> Some times on over prod. server i found some porcesses running for more
> than 2-3 hors, they r not in sleeping mode but runnable.
> How it cab happen as our frontend uses commandtimout= 3 minutes.
> Thanks
>|||This is a multi-part message in MIME format.
--080207000202000207010303
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
The timeout will just tell the client to give up after 3 minutes and
stop waiting for a response from the server. It doesn't tell the server
to abort the statement. The only way to get the server to give up in
the middle of a statement, assuming the server doesn't encounter an
exception (ie. throw an error) during processing of that statement, is
to use the KILL statement to terminate the SPID (process), which will
also disconnect the client application using that connection.
However, if a process has been running for a couple hours and you kill
it, then presumedly it has been doing a fair bit of work and the server
will need to roll that work back. So killing a process often, but not
always, takes as long as the current statement has been running for
anyway, and you never know if the statement is just seconds away from
finishing; that's the risk you take.
--
*mike hodgson*
http://sqlnerd.blogspot.com
vicky wrote:
>Some times on over prod. server i found some porcesses running for more than
>2-3 hors, they r not in sleeping mode but runnable.
>How it cab happen as our frontend uses commandtimout= 3 minutes.
>Thanks
>
>
--080207000202000207010303
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>The timeout will just tell the client to give up after 3 minutes
and stop waiting for a response from the server. It doesn't tell the
server to abort the statement. The only way to get the server to give
up in the middle of a statement, assuming the server doesn't encounter
an exception (ie. throw an error) during processing of that statement,
is to use the KILL statement to terminate the SPID (process), which
will also disconnect the client application using that connection.<br>
<br>
However, if a process has been running for a couple hours and you kill
it, then presumedly it has been doing a fair bit of work and the server
will need to roll that work back. So killing a process often, but not
always, takes as long as the current statement has been running for
anyway, and you never know if the statement is just seconds away from
finishing; that's the risk you take.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
vicky wrote:
<blockquote cite="mid%237T88MhmGHA.3600@.TK2MSFTNGP02.phx.gbl"
type="cite">
<pre wrap="">Some times on over prod. server i found some porcesses running for more than
2-3 hors, they r not in sleeping mode but runnable.
How it cab happen as our frontend uses commandtimout= 3 minutes.
Thanks
</pre>
</blockquote>
</body>
</html>
--080207000202000207010303--
long running RESTORE
Hi all !
I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
2000(SP3). It takes a few minutes to restore it on another box which has
enough resurses, but when I tried to do the same on a box that is a bit old
and not so powerfull I just couldn't wait until it's done, - i canceled
restore operation. As a workaround I detached DB file and then attached them
on that box. But I'm still wondering is there another way to restore DB, may
be group by group or ...?
Thanks a lot in advance,
Alex
Backup and restore
and
sp_detach_db and sp_attach_db
are the best options
You could also try using DTS, but that would probably involve much more
effort on your part.
Keith
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>
|||Did you restore the database on the 'old box' when the database was not yet
created? If this was the first time, the 5 Gig file needs to be created
first before the restore can start, and depending on the speed of your disk
controllers, this might take some time. When you subsequently restore the
database again, don't delete the old database first.
Since you already have the database on the old box, try restoring using the
normal way, and see if it still takes as long. And by any chance, are you
using compressed folders?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>
|||Yes, I created DB before restoring with two file groups 2 G each and log
file. And I wasn't using compressed folder. My guess is maybe I wasn't
patient enough although I waited for about half an hour to let it finish.
But that 'old box' is really slow and that could be the case. I'll give it
another try and be more patien this time.
Thank you,
Alex
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:u2AMSofbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Did you restore the database on the 'old box' when the database was not
yet
> created? If this was the first time, the 5 Gig file needs to be created
> first before the restore can start, and depending on the speed of your
disk
> controllers, this might take some time. When you subsequently restore the
> database again, don't delete the old database first.
> Since you already have the database on the old box, try restoring using
the[vbcol=seagreen]
> normal way, and see if it still takes as long. And by any chance, are you
> using compressed folders?
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
>
> "Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
> news:10fo5ivqif63e54@.corp.supernews.com...
has
> old
> them
> may
>
I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
2000(SP3). It takes a few minutes to restore it on another box which has
enough resurses, but when I tried to do the same on a box that is a bit old
and not so powerfull I just couldn't wait until it's done, - i canceled
restore operation. As a workaround I detached DB file and then attached them
on that box. But I'm still wondering is there another way to restore DB, may
be group by group or ...?
Thanks a lot in advance,
Alex
Backup and restore
and
sp_detach_db and sp_attach_db
are the best options
You could also try using DTS, but that would probably involve much more
effort on your part.
Keith
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>
|||Did you restore the database on the 'old box' when the database was not yet
created? If this was the first time, the 5 Gig file needs to be created
first before the restore can start, and depending on the speed of your disk
controllers, this might take some time. When you subsequently restore the
database again, don't delete the old database first.
Since you already have the database on the old box, try restoring using the
normal way, and see if it still takes as long. And by any chance, are you
using compressed folders?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>
|||Yes, I created DB before restoring with two file groups 2 G each and log
file. And I wasn't using compressed folder. My guess is maybe I wasn't
patient enough although I waited for about half an hour to let it finish.
But that 'old box' is really slow and that could be the case. I'll give it
another try and be more patien this time.
Thank you,
Alex
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:u2AMSofbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Did you restore the database on the 'old box' when the database was not
yet
> created? If this was the first time, the 5 Gig file needs to be created
> first before the restore can start, and depending on the speed of your
disk
> controllers, this might take some time. When you subsequently restore the
> database again, don't delete the old database first.
> Since you already have the database on the old box, try restoring using
the[vbcol=seagreen]
> normal way, and see if it still takes as long. And by any chance, are you
> using compressed folders?
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
>
> "Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
> news:10fo5ivqif63e54@.corp.supernews.com...
has
> old
> them
> may
>
long running RESTORE
Hi all !
I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
2000(SP3). It takes a few minutes to restore it on another box which has
enough resurses, but when I tried to do the same on a box that is a bit old
and not so powerfull I just couldn't wait until it's done, - i canceled
restore operation. As a workaround I detached DB file and then attached them
on that box. But I'm still wondering is there another way to restore DB, may
be group by group or ...?
--
Thanks a lot in advance,
AlexBackup and restore
and
sp_detach_db and sp_attach_db
are the best options
You could also try using DTS, but that would probably involve much more
effort on your part.
Keith
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Did you restore the database on the 'old box' when the database was not yet
created? If this was the first time, the 5 Gig file needs to be created
first before the restore can start, and depending on the speed of your disk
controllers, this might take some time. When you subsequently restore the
database again, don't delete the old database first.
Since you already have the database on the old box, try restoring using the
normal way, and see if it still takes as long. And by any chance, are you
using compressed folders?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Yes, I created DB before restoring with two file groups 2 G each and log
file. And I wasn't using compressed folder. My guess is maybe I wasn't
patient enough although I waited for about half an hour to let it finish.
But that 'old box' is really slow and that could be the case. I'll give it
another try and be more patien this time.
Thank you,
Alex
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:u2AMSofbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Did you restore the database on the 'old box' when the database was not
yet
> created? If this was the first time, the 5 Gig file needs to be created
> first before the restore can start, and depending on the speed of your
disk
> controllers, this might take some time. When you subsequently restore the
> database again, don't delete the old database first.
> Since you already have the database on the old box, try restoring using
the
> normal way, and see if it still takes as long. And by any chance, are you
> using compressed folders?
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
>
> "Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
> news:10fo5ivqif63e54@.corp.supernews.com...
has[vbcol=seagreen]
> old
> them
> may
>
I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
2000(SP3). It takes a few minutes to restore it on another box which has
enough resurses, but when I tried to do the same on a box that is a bit old
and not so powerfull I just couldn't wait until it's done, - i canceled
restore operation. As a workaround I detached DB file and then attached them
on that box. But I'm still wondering is there another way to restore DB, may
be group by group or ...?
--
Thanks a lot in advance,
AlexBackup and restore
and
sp_detach_db and sp_attach_db
are the best options
You could also try using DTS, but that would probably involve much more
effort on your part.
Keith
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Did you restore the database on the 'old box' when the database was not yet
created? If this was the first time, the 5 Gig file needs to be created
first before the restore can start, and depending on the speed of your disk
controllers, this might take some time. When you subsequently restore the
database again, don't delete the old database first.
Since you already have the database on the old box, try restoring using the
normal way, and see if it still takes as long. And by any chance, are you
using compressed folders?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Yes, I created DB before restoring with two file groups 2 G each and log
file. And I wasn't using compressed folder. My guess is maybe I wasn't
patient enough although I waited for about half an hour to let it finish.
But that 'old box' is really slow and that could be the case. I'll give it
another try and be more patien this time.
Thank you,
Alex
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:u2AMSofbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Did you restore the database on the 'old box' when the database was not
yet
> created? If this was the first time, the 5 Gig file needs to be created
> first before the restore can start, and depending on the speed of your
disk
> controllers, this might take some time. When you subsequently restore the
> database again, don't delete the old database first.
> Since you already have the database on the old box, try restoring using
the
> normal way, and see if it still takes as long. And by any chance, are you
> using compressed folders?
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
>
> "Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
> news:10fo5ivqif63e54@.corp.supernews.com...
has[vbcol=seagreen]
> old
> them
> may
>
long running RESTORE
Hi all !
I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
2000(SP3). It takes a few minutes to restore it on another box which has
enough resurses, but when I tried to do the same on a box that is a bit old
and not so powerfull I just couldn't wait until it's done, - i canceled
restore operation. As a workaround I detached DB file and then attached them
on that box. But I'm still wondering is there another way to restore DB, may
be group by group or ...?
--
Thanks a lot in advance,
AlexBackup and restore
and
sp_detach_db and sp_attach_db
are the best options
You could also try using DTS, but that would probably involve much more
effort on your part.
--
Keith
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Did you restore the database on the 'old box' when the database was not yet
created? If this was the first time, the 5 Gig file needs to be created
first before the restore can start, and depending on the speed of your disk
controllers, this might take some time. When you subsequently restore the
database again, don't delete the old database first.
Since you already have the database on the old box, try restoring using the
normal way, and see if it still takes as long. And by any chance, are you
using compressed folders?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Yes, I created DB before restoring with two file groups 2 G each and log
file. And I wasn't using compressed folder. My guess is maybe I wasn't
patient enough although I waited for about half an hour to let it finish.
But that 'old box' is really slow and that could be the case. I'll give it
another try and be more patien this time.
--
Thank you,
Alex
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:u2AMSofbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Did you restore the database on the 'old box' when the database was not
yet
> created? If this was the first time, the 5 Gig file needs to be created
> first before the restore can start, and depending on the speed of your
disk
> controllers, this might take some time. When you subsequently restore the
> database again, don't delete the old database first.
> Since you already have the database on the old box, try restoring using
the
> normal way, and see if it still takes as long. And by any chance, are you
> using compressed folders?
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
>
> "Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
> news:10fo5ivqif63e54@.corp.supernews.com...
> > Hi all !
> >
> > I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> > 2000(SP3). It takes a few minutes to restore it on another box which
has
> > enough resurses, but when I tried to do the same on a box that is a bit
> old
> > and not so powerfull I just couldn't wait until it's done, - i canceled
> > restore operation. As a workaround I detached DB file and then attached
> them
> > on that box. But I'm still wondering is there another way to restore DB,
> may
> > be group by group or ...?
> > --
> >
> > Thanks a lot in advance,
> >
> > Alex
> >
> >
>
I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
2000(SP3). It takes a few minutes to restore it on another box which has
enough resurses, but when I tried to do the same on a box that is a bit old
and not so powerfull I just couldn't wait until it's done, - i canceled
restore operation. As a workaround I detached DB file and then attached them
on that box. But I'm still wondering is there another way to restore DB, may
be group by group or ...?
--
Thanks a lot in advance,
AlexBackup and restore
and
sp_detach_db and sp_attach_db
are the best options
You could also try using DTS, but that would probably involve much more
effort on your part.
--
Keith
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Did you restore the database on the 'old box' when the database was not yet
created? If this was the first time, the 5 Gig file needs to be created
first before the restore can start, and depending on the speed of your disk
controllers, this might take some time. When you subsequently restore the
database again, don't delete the old database first.
Since you already have the database on the old box, try restoring using the
normal way, and see if it still takes as long. And by any chance, are you
using compressed folders?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
news:10fo5ivqif63e54@.corp.supernews.com...
> Hi all !
> I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> 2000(SP3). It takes a few minutes to restore it on another box which has
> enough resurses, but when I tried to do the same on a box that is a bit
old
> and not so powerfull I just couldn't wait until it's done, - i canceled
> restore operation. As a workaround I detached DB file and then attached
them
> on that box. But I'm still wondering is there another way to restore DB,
may
> be group by group or ...?
> --
> Thanks a lot in advance,
> Alex
>|||Yes, I created DB before restoring with two file groups 2 G each and log
file. And I wasn't using compressed folder. My guess is maybe I wasn't
patient enough although I waited for about half an hour to let it finish.
But that 'old box' is really slow and that could be the case. I'll give it
another try and be more patien this time.
--
Thank you,
Alex
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:u2AMSofbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Did you restore the database on the 'old box' when the database was not
yet
> created? If this was the first time, the 5 Gig file needs to be created
> first before the restore can start, and depending on the speed of your
disk
> controllers, this might take some time. When you subsequently restore the
> database again, don't delete the old database first.
> Since you already have the database on the old box, try restoring using
the
> normal way, and see if it still takes as long. And by any chance, are you
> using compressed folders?
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
>
> "Alex" <amakarov_removethis_@.healthmetrx.com> wrote in message
> news:10fo5ivqif63e54@.corp.supernews.com...
> > Hi all !
> >
> > I have 5 GB backup file of DB running in SIMPLE recovery mode on SQL
> > 2000(SP3). It takes a few minutes to restore it on another box which
has
> > enough resurses, but when I tried to do the same on a box that is a bit
> old
> > and not so powerfull I just couldn't wait until it's done, - i canceled
> > restore operation. As a workaround I detached DB file and then attached
> them
> > on that box. But I'm still wondering is there another way to restore DB,
> may
> > be group by group or ...?
> > --
> >
> > Thanks a lot in advance,
> >
> > Alex
> >
> >
>
Monday, March 26, 2012
Long Queries Hang VS; Other Productivity Killers
Whenever I run long SQL in VS whether it's in the Data tab or in Preview
mode, I can't seem to get a report out of it. I'm talking SQL in excess of
200 lines.
I can run the SQL fine in Query Analyzer but running it in the Data tab, it
freezes VS, and when I run the Preview, the report never renders. I have even
tried hardcoding all parameters, creating a stored procedure, and running the
report off a view. None have resolved the issue.
On a possibly related note, my connection to the database times out
intermittently, saying:
--
Microsoft Development Environment
--
An error occurred while executing the query.
General network error. Check your network documentation.
--
OK
--
This absolutely kills me over the course of a day. I have to shut down VS
and restart it.
Is my Reporting Services VS package install corrupt? What do I do?How many fields are being returned? How many rows of data?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> Whenever I run long SQL in VS whether it's in the Data tab or in Preview
> mode, I can't seem to get a report out of it. I'm talking SQL in excess of
> 200 lines.
> I can run the SQL fine in Query Analyzer but running it in the Data tab,
it
> freezes VS, and when I run the Preview, the report never renders. I have
even
> tried hardcoding all parameters, creating a stored procedure, and running
the
> report off a view. None have resolved the issue.
> On a possibly related note, my connection to the database times out
> intermittently, saying:
> --
> Microsoft Development Environment
> --
> An error occurred while executing the query.
> General network error. Check your network documentation.
> --
> OK
> --
> This absolutely kills me over the course of a day. I have to shut down VS
> and restart it.
> Is my Reporting Services VS package install corrupt? What do I do?|||For one report in particular, about 727 rows, and today it's taking just over
4 minutes to run. The other has over 60,000 rows and I'm just going to have
to work on limiting that severely.
"Bruce L-C [MVP]" wrote:
> How many fields are being returned? How many rows of data?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > Whenever I run long SQL in VS whether it's in the Data tab or in Preview
> > mode, I can't seem to get a report out of it. I'm talking SQL in excess of
> > 200 lines.
> >
> > I can run the SQL fine in Query Analyzer but running it in the Data tab,
> it
> > freezes VS, and when I run the Preview, the report never renders. I have
> even
> > tried hardcoding all parameters, creating a stored procedure, and running
> the
> > report off a view. None have resolved the issue.
> >
> > On a possibly related note, my connection to the database times out
> > intermittently, saying:
> >
> > --
> > Microsoft Development Environment
> > --
> > An error occurred while executing the query.
> >
> > General network error. Check your network documentation.
> > --
> > OK
> > --
> >
> > This absolutely kills me over the course of a day. I have to shut down VS
> > and restart it.
> >
> > Is my Reporting Services VS package install corrupt? What do I do?
>
>|||The 727 rows should not be a problem. Is that one causing an issue from the
data tab?
It doesn't surprise me that the 60,000 row one has problems.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> For one report in particular, about 727 rows, and today it's taking just
over
> 4 minutes to run. The other has over 60,000 rows and I'm just going to
have
> to work on limiting that severely.
> "Bruce L-C [MVP]" wrote:
> > How many fields are being returned? How many rows of data?
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > Whenever I run long SQL in VS whether it's in the Data tab or in
Preview
> > > mode, I can't seem to get a report out of it. I'm talking SQL in
excess of
> > > 200 lines.
> > >
> > > I can run the SQL fine in Query Analyzer but running it in the Data
tab,
> > it
> > > freezes VS, and when I run the Preview, the report never renders. I
have
> > even
> > > tried hardcoding all parameters, creating a stored procedure, and
running
> > the
> > > report off a view. None have resolved the issue.
> > >
> > > On a possibly related note, my connection to the database times out
> > > intermittently, saying:
> > >
> > > --
> > > Microsoft Development Environment
> > > --
> > > An error occurred while executing the query.
> > >
> > > General network error. Check your network documentation.
> > > --
> > > OK
> > > --
> > >
> > > This absolutely kills me over the course of a day. I have to shut down
VS
> > > and restart it.
> > >
> > > Is my Reporting Services VS package install corrupt? What do I do?
> >
> >
> >|||For the most part, Mr. 727 will run on the data tab, but clocks endlessly on
Preview. The report does consist of about 20 fields, but I would still expect
it to render.
Sometimes I just lose connectivity and have to close out VS. I'm not sure if
it's related, but it could be I suppose.
Any ideas?
"Bruce L-C [MVP]" wrote:
> The 727 rows should not be a problem. Is that one causing an issue from the
> data tab?
> It doesn't surprise me that the 60,000 row one has problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > For one report in particular, about 727 rows, and today it's taking just
> over
> > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> have
> > to work on limiting that severely.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > How many fields are being returned? How many rows of data?
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> Preview
> > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> excess of
> > > > 200 lines.
> > > >
> > > > I can run the SQL fine in Query Analyzer but running it in the Data
> tab,
> > > it
> > > > freezes VS, and when I run the Preview, the report never renders. I
> have
> > > even
> > > > tried hardcoding all parameters, creating a stored procedure, and
> running
> > > the
> > > > report off a view. None have resolved the issue.
> > > >
> > > > On a possibly related note, my connection to the database times out
> > > > intermittently, saying:
> > > >
> > > > --
> > > > Microsoft Development Environment
> > > > --
> > > > An error occurred while executing the query.
> > > >
> > > > General network error. Check your network documentation.
> > > > --
> > > > OK
> > > > --
> > > >
> > > > This absolutely kills me over the course of a day. I have to shut down
> VS
> > > > and restart it.
> > > >
> > > > Is my Reporting Services VS package install corrupt? What do I do?
> > >
> > >
> > >
>
>|||Sometimes it runs from the data tab. Sometimes (like now), it hoses VS. The
query is 309 lines long and is pretty complex...Still, I'm having a heck of a
time. Could it be my RS client install, or could it be my machine?
"Bruce L-C [MVP]" wrote:
> The 727 rows should not be a problem. Is that one causing an issue from the
> data tab?
> It doesn't surprise me that the 60,000 row one has problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > For one report in particular, about 727 rows, and today it's taking just
> over
> > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> have
> > to work on limiting that severely.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > How many fields are being returned? How many rows of data?
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> Preview
> > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> excess of
> > > > 200 lines.
> > > >
> > > > I can run the SQL fine in Query Analyzer but running it in the Data
> tab,
> > > it
> > > > freezes VS, and when I run the Preview, the report never renders. I
> have
> > > even
> > > > tried hardcoding all parameters, creating a stored procedure, and
> running
> > > the
> > > > report off a view. None have resolved the issue.
> > > >
> > > > On a possibly related note, my connection to the database times out
> > > > intermittently, saying:
> > > >
> > > > --
> > > > Microsoft Development Environment
> > > > --
> > > > An error occurred while executing the query.
> > > >
> > > > General network error. Check your network documentation.
> > > > --
> > > > OK
> > > > --
> > > >
> > > > This absolutely kills me over the course of a day. I have to shut down
> VS
> > > > and restart it.
> > > >
> > > > Is my Reporting Services VS package install corrupt? What do I do?
> > >
> > >
> > >
>
>|||Did you say you tried it as a stored procedure and you still had problems.
20 fields should not be a problem. 309 lines of a query could be a problem
in the IDE (not necessarily when deployed). I suggest try deploying it and
see if it works to determine if it is an IDE only problem. Next, try having
it in a stored procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
The
> query is 309 lines long and is pretty complex...Still, I'm having a heck
of a
> time. Could it be my RS client install, or could it be my machine?
> "Bruce L-C [MVP]" wrote:
> > The 727 rows should not be a problem. Is that one causing an issue from
the
> > data tab?
> >
> > It doesn't surprise me that the 60,000 row one has problems.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > For one report in particular, about 727 rows, and today it's taking
just
> > over
> > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > have
> > > to work on limiting that severely.
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > How many fields are being returned? How many rows of data?
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > Preview
> > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > excess of
> > > > > 200 lines.
> > > > >
> > > > > I can run the SQL fine in Query Analyzer but running it in the
Data
> > tab,
> > > > it
> > > > > freezes VS, and when I run the Preview, the report never renders.
I
> > have
> > > > even
> > > > > tried hardcoding all parameters, creating a stored procedure, and
> > running
> > > > the
> > > > > report off a view. None have resolved the issue.
> > > > >
> > > > > On a possibly related note, my connection to the database times
out
> > > > > intermittently, saying:
> > > > >
> > > > > --
> > > > > Microsoft Development Environment
> > > > > --
> > > > > An error occurred while executing the query.
> > > > >
> > > > > General network error. Check your network documentation.
> > > > > --
> > > > > OK
> > > > > --
> > > > >
> > > > > This absolutely kills me over the course of a day. I have to shut
down
> > VS
> > > > > and restart it.
> > > > >
> > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > >
> > > >
> > > >
> >
> >
> >|||Yes, I did give it a shot as a stored procedure, with no luck.
Well, tomorrow's another day. I'll try deploying it and seeing what happens.
Thanks for the help.
Mike
"Bruce L-C [MVP]" wrote:
> Did you say you tried it as a stored procedure and you still had problems.
> 20 fields should not be a problem. 309 lines of a query could be a problem
> in the IDE (not necessarily when deployed). I suggest try deploying it and
> see if it works to determine if it is an IDE only problem. Next, try having
> it in a stored procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> > Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
> The
> > query is 309 lines long and is pretty complex...Still, I'm having a heck
> of a
> > time. Could it be my RS client install, or could it be my machine?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > The 727 rows should not be a problem. Is that one causing an issue from
> the
> > > data tab?
> > >
> > > It doesn't surprise me that the 60,000 row one has problems.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > > For one report in particular, about 727 rows, and today it's taking
> just
> > > over
> > > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > > have
> > > > to work on limiting that severely.
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > How many fields are being returned? How many rows of data?
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > > Preview
> > > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > > excess of
> > > > > > 200 lines.
> > > > > >
> > > > > > I can run the SQL fine in Query Analyzer but running it in the
> Data
> > > tab,
> > > > > it
> > > > > > freezes VS, and when I run the Preview, the report never renders.
> I
> > > have
> > > > > even
> > > > > > tried hardcoding all parameters, creating a stored procedure, and
> > > running
> > > > > the
> > > > > > report off a view. None have resolved the issue.
> > > > > >
> > > > > > On a possibly related note, my connection to the database times
> out
> > > > > > intermittently, saying:
> > > > > >
> > > > > > --
> > > > > > Microsoft Development Environment
> > > > > > --
> > > > > > An error occurred while executing the query.
> > > > > >
> > > > > > General network error. Check your network documentation.
> > > > > > --
> > > > > > OK
> > > > > > --
> > > > > >
> > > > > > This absolutely kills me over the course of a day. I have to shut
> down
> > > VS
> > > > > > and restart it.
> > > > > >
> > > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Have you tried changing the connection string of the data source to increase
the time out?
try
"data source=ServerName;initial catalog=DatabaseName;Connection Timeout=30"
The connection timeout has a default of 15.
"Bassist695" wrote:
> Yes, I did give it a shot as a stored procedure, with no luck.
> Well, tomorrow's another day. I'll try deploying it and seeing what happens.
> Thanks for the help.
> Mike
> "Bruce L-C [MVP]" wrote:
> > Did you say you tried it as a stored procedure and you still had problems.
> > 20 fields should not be a problem. 309 lines of a query could be a problem
> > in the IDE (not necessarily when deployed). I suggest try deploying it and
> > see if it works to determine if it is an IDE only problem. Next, try having
> > it in a stored procedure.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> > > Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
> > The
> > > query is 309 lines long and is pretty complex...Still, I'm having a heck
> > of a
> > > time. Could it be my RS client install, or could it be my machine?
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > The 727 rows should not be a problem. Is that one causing an issue from
> > the
> > > > data tab?
> > > >
> > > > It doesn't surprise me that the 60,000 row one has problems.
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > > > For one report in particular, about 727 rows, and today it's taking
> > just
> > > > over
> > > > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > > > have
> > > > > to work on limiting that severely.
> > > > >
> > > > > "Bruce L-C [MVP]" wrote:
> > > > >
> > > > > > How many fields are being returned? How many rows of data?
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Bruce Loehle-Conger
> > > > > > MVP SQL Server Reporting Services
> > > > > >
> > > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > > > Preview
> > > > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > > > excess of
> > > > > > > 200 lines.
> > > > > > >
> > > > > > > I can run the SQL fine in Query Analyzer but running it in the
> > Data
> > > > tab,
> > > > > > it
> > > > > > > freezes VS, and when I run the Preview, the report never renders.
> > I
> > > > have
> > > > > > even
> > > > > > > tried hardcoding all parameters, creating a stored procedure, and
> > > > running
> > > > > > the
> > > > > > > report off a view. None have resolved the issue.
> > > > > > >
> > > > > > > On a possibly related note, my connection to the database times
> > out
> > > > > > > intermittently, saying:
> > > > > > >
> > > > > > > --
> > > > > > > Microsoft Development Environment
> > > > > > > --
> > > > > > > An error occurred while executing the query.
> > > > > > >
> > > > > > > General network error. Check your network documentation.
> > > > > > > --
> > > > > > > OK
> > > > > > > --
> > > > > > >
> > > > > > > This absolutely kills me over the course of a day. I have to shut
> > down
> > > > VS
> > > > > > > and restart it.
> > > > > > >
> > > > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||No, I haven't tried that. I don't believe the queries are timing out.
Wouldn't I get an error message to indicate that?
At present, there is no timeout set, which I believe means that the query
will not time out.
I'm going to try the deploy-and-see method...Let's hope it's my IDE.
Mike
"Carl Finnegan" wrote:
> Have you tried changing the connection string of the data source to increase
> the time out?
> try
> "data source=ServerName;initial catalog=DatabaseName;Connection Timeout=30"
> The connection timeout has a default of 15.
> "Bassist695" wrote:
> > Yes, I did give it a shot as a stored procedure, with no luck.
> >
> > Well, tomorrow's another day. I'll try deploying it and seeing what happens.
> > Thanks for the help.
> >
> > Mike
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Did you say you tried it as a stored procedure and you still had problems.
> > > 20 fields should not be a problem. 309 lines of a query could be a problem
> > > in the IDE (not necessarily when deployed). I suggest try deploying it and
> > > see if it works to determine if it is an IDE only problem. Next, try having
> > > it in a stored procedure.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> > > > Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
> > > The
> > > > query is 309 lines long and is pretty complex...Still, I'm having a heck
> > > of a
> > > > time. Could it be my RS client install, or could it be my machine?
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > The 727 rows should not be a problem. Is that one causing an issue from
> > > the
> > > > > data tab?
> > > > >
> > > > > It doesn't surprise me that the 60,000 row one has problems.
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > > > > For one report in particular, about 727 rows, and today it's taking
> > > just
> > > > > over
> > > > > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > > > > have
> > > > > > to work on limiting that severely.
> > > > > >
> > > > > > "Bruce L-C [MVP]" wrote:
> > > > > >
> > > > > > > How many fields are being returned? How many rows of data?
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Bruce Loehle-Conger
> > > > > > > MVP SQL Server Reporting Services
> > > > > > >
> > > > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > > > > Preview
> > > > > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > > > > excess of
> > > > > > > > 200 lines.
> > > > > > > >
> > > > > > > > I can run the SQL fine in Query Analyzer but running it in the
> > > Data
> > > > > tab,
> > > > > > > it
> > > > > > > > freezes VS, and when I run the Preview, the report never renders.
> > > I
> > > > > have
> > > > > > > even
> > > > > > > > tried hardcoding all parameters, creating a stored procedure, and
> > > > > running
> > > > > > > the
> > > > > > > > report off a view. None have resolved the issue.
> > > > > > > >
> > > > > > > > On a possibly related note, my connection to the database times
> > > out
> > > > > > > > intermittently, saying:
> > > > > > > >
> > > > > > > > --
> > > > > > > > Microsoft Development Environment
> > > > > > > > --
> > > > > > > > An error occurred while executing the query.
> > > > > > > >
> > > > > > > > General network error. Check your network documentation.
> > > > > > > > --
> > > > > > > > OK
> > > > > > > > --
> > > > > > > >
> > > > > > > > This absolutely kills me over the course of a day. I have to shut
> > > down
> > > > > VS
> > > > > > > > and restart it.
> > > > > > > >
> > > > > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
mode, I can't seem to get a report out of it. I'm talking SQL in excess of
200 lines.
I can run the SQL fine in Query Analyzer but running it in the Data tab, it
freezes VS, and when I run the Preview, the report never renders. I have even
tried hardcoding all parameters, creating a stored procedure, and running the
report off a view. None have resolved the issue.
On a possibly related note, my connection to the database times out
intermittently, saying:
--
Microsoft Development Environment
--
An error occurred while executing the query.
General network error. Check your network documentation.
--
OK
--
This absolutely kills me over the course of a day. I have to shut down VS
and restart it.
Is my Reporting Services VS package install corrupt? What do I do?How many fields are being returned? How many rows of data?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> Whenever I run long SQL in VS whether it's in the Data tab or in Preview
> mode, I can't seem to get a report out of it. I'm talking SQL in excess of
> 200 lines.
> I can run the SQL fine in Query Analyzer but running it in the Data tab,
it
> freezes VS, and when I run the Preview, the report never renders. I have
even
> tried hardcoding all parameters, creating a stored procedure, and running
the
> report off a view. None have resolved the issue.
> On a possibly related note, my connection to the database times out
> intermittently, saying:
> --
> Microsoft Development Environment
> --
> An error occurred while executing the query.
> General network error. Check your network documentation.
> --
> OK
> --
> This absolutely kills me over the course of a day. I have to shut down VS
> and restart it.
> Is my Reporting Services VS package install corrupt? What do I do?|||For one report in particular, about 727 rows, and today it's taking just over
4 minutes to run. The other has over 60,000 rows and I'm just going to have
to work on limiting that severely.
"Bruce L-C [MVP]" wrote:
> How many fields are being returned? How many rows of data?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > Whenever I run long SQL in VS whether it's in the Data tab or in Preview
> > mode, I can't seem to get a report out of it. I'm talking SQL in excess of
> > 200 lines.
> >
> > I can run the SQL fine in Query Analyzer but running it in the Data tab,
> it
> > freezes VS, and when I run the Preview, the report never renders. I have
> even
> > tried hardcoding all parameters, creating a stored procedure, and running
> the
> > report off a view. None have resolved the issue.
> >
> > On a possibly related note, my connection to the database times out
> > intermittently, saying:
> >
> > --
> > Microsoft Development Environment
> > --
> > An error occurred while executing the query.
> >
> > General network error. Check your network documentation.
> > --
> > OK
> > --
> >
> > This absolutely kills me over the course of a day. I have to shut down VS
> > and restart it.
> >
> > Is my Reporting Services VS package install corrupt? What do I do?
>
>|||The 727 rows should not be a problem. Is that one causing an issue from the
data tab?
It doesn't surprise me that the 60,000 row one has problems.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> For one report in particular, about 727 rows, and today it's taking just
over
> 4 minutes to run. The other has over 60,000 rows and I'm just going to
have
> to work on limiting that severely.
> "Bruce L-C [MVP]" wrote:
> > How many fields are being returned? How many rows of data?
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > Whenever I run long SQL in VS whether it's in the Data tab or in
Preview
> > > mode, I can't seem to get a report out of it. I'm talking SQL in
excess of
> > > 200 lines.
> > >
> > > I can run the SQL fine in Query Analyzer but running it in the Data
tab,
> > it
> > > freezes VS, and when I run the Preview, the report never renders. I
have
> > even
> > > tried hardcoding all parameters, creating a stored procedure, and
running
> > the
> > > report off a view. None have resolved the issue.
> > >
> > > On a possibly related note, my connection to the database times out
> > > intermittently, saying:
> > >
> > > --
> > > Microsoft Development Environment
> > > --
> > > An error occurred while executing the query.
> > >
> > > General network error. Check your network documentation.
> > > --
> > > OK
> > > --
> > >
> > > This absolutely kills me over the course of a day. I have to shut down
VS
> > > and restart it.
> > >
> > > Is my Reporting Services VS package install corrupt? What do I do?
> >
> >
> >|||For the most part, Mr. 727 will run on the data tab, but clocks endlessly on
Preview. The report does consist of about 20 fields, but I would still expect
it to render.
Sometimes I just lose connectivity and have to close out VS. I'm not sure if
it's related, but it could be I suppose.
Any ideas?
"Bruce L-C [MVP]" wrote:
> The 727 rows should not be a problem. Is that one causing an issue from the
> data tab?
> It doesn't surprise me that the 60,000 row one has problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > For one report in particular, about 727 rows, and today it's taking just
> over
> > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> have
> > to work on limiting that severely.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > How many fields are being returned? How many rows of data?
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> Preview
> > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> excess of
> > > > 200 lines.
> > > >
> > > > I can run the SQL fine in Query Analyzer but running it in the Data
> tab,
> > > it
> > > > freezes VS, and when I run the Preview, the report never renders. I
> have
> > > even
> > > > tried hardcoding all parameters, creating a stored procedure, and
> running
> > > the
> > > > report off a view. None have resolved the issue.
> > > >
> > > > On a possibly related note, my connection to the database times out
> > > > intermittently, saying:
> > > >
> > > > --
> > > > Microsoft Development Environment
> > > > --
> > > > An error occurred while executing the query.
> > > >
> > > > General network error. Check your network documentation.
> > > > --
> > > > OK
> > > > --
> > > >
> > > > This absolutely kills me over the course of a day. I have to shut down
> VS
> > > > and restart it.
> > > >
> > > > Is my Reporting Services VS package install corrupt? What do I do?
> > >
> > >
> > >
>
>|||Sometimes it runs from the data tab. Sometimes (like now), it hoses VS. The
query is 309 lines long and is pretty complex...Still, I'm having a heck of a
time. Could it be my RS client install, or could it be my machine?
"Bruce L-C [MVP]" wrote:
> The 727 rows should not be a problem. Is that one causing an issue from the
> data tab?
> It doesn't surprise me that the 60,000 row one has problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > For one report in particular, about 727 rows, and today it's taking just
> over
> > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> have
> > to work on limiting that severely.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > How many fields are being returned? How many rows of data?
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> Preview
> > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> excess of
> > > > 200 lines.
> > > >
> > > > I can run the SQL fine in Query Analyzer but running it in the Data
> tab,
> > > it
> > > > freezes VS, and when I run the Preview, the report never renders. I
> have
> > > even
> > > > tried hardcoding all parameters, creating a stored procedure, and
> running
> > > the
> > > > report off a view. None have resolved the issue.
> > > >
> > > > On a possibly related note, my connection to the database times out
> > > > intermittently, saying:
> > > >
> > > > --
> > > > Microsoft Development Environment
> > > > --
> > > > An error occurred while executing the query.
> > > >
> > > > General network error. Check your network documentation.
> > > > --
> > > > OK
> > > > --
> > > >
> > > > This absolutely kills me over the course of a day. I have to shut down
> VS
> > > > and restart it.
> > > >
> > > > Is my Reporting Services VS package install corrupt? What do I do?
> > >
> > >
> > >
>
>|||Did you say you tried it as a stored procedure and you still had problems.
20 fields should not be a problem. 309 lines of a query could be a problem
in the IDE (not necessarily when deployed). I suggest try deploying it and
see if it works to determine if it is an IDE only problem. Next, try having
it in a stored procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
The
> query is 309 lines long and is pretty complex...Still, I'm having a heck
of a
> time. Could it be my RS client install, or could it be my machine?
> "Bruce L-C [MVP]" wrote:
> > The 727 rows should not be a problem. Is that one causing an issue from
the
> > data tab?
> >
> > It doesn't surprise me that the 60,000 row one has problems.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > For one report in particular, about 727 rows, and today it's taking
just
> > over
> > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > have
> > > to work on limiting that severely.
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > How many fields are being returned? How many rows of data?
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > Preview
> > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > excess of
> > > > > 200 lines.
> > > > >
> > > > > I can run the SQL fine in Query Analyzer but running it in the
Data
> > tab,
> > > > it
> > > > > freezes VS, and when I run the Preview, the report never renders.
I
> > have
> > > > even
> > > > > tried hardcoding all parameters, creating a stored procedure, and
> > running
> > > > the
> > > > > report off a view. None have resolved the issue.
> > > > >
> > > > > On a possibly related note, my connection to the database times
out
> > > > > intermittently, saying:
> > > > >
> > > > > --
> > > > > Microsoft Development Environment
> > > > > --
> > > > > An error occurred while executing the query.
> > > > >
> > > > > General network error. Check your network documentation.
> > > > > --
> > > > > OK
> > > > > --
> > > > >
> > > > > This absolutely kills me over the course of a day. I have to shut
down
> > VS
> > > > > and restart it.
> > > > >
> > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > >
> > > >
> > > >
> >
> >
> >|||Yes, I did give it a shot as a stored procedure, with no luck.
Well, tomorrow's another day. I'll try deploying it and seeing what happens.
Thanks for the help.
Mike
"Bruce L-C [MVP]" wrote:
> Did you say you tried it as a stored procedure and you still had problems.
> 20 fields should not be a problem. 309 lines of a query could be a problem
> in the IDE (not necessarily when deployed). I suggest try deploying it and
> see if it works to determine if it is an IDE only problem. Next, try having
> it in a stored procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> > Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
> The
> > query is 309 lines long and is pretty complex...Still, I'm having a heck
> of a
> > time. Could it be my RS client install, or could it be my machine?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > The 727 rows should not be a problem. Is that one causing an issue from
> the
> > > data tab?
> > >
> > > It doesn't surprise me that the 60,000 row one has problems.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > > For one report in particular, about 727 rows, and today it's taking
> just
> > > over
> > > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > > have
> > > > to work on limiting that severely.
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > How many fields are being returned? How many rows of data?
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > > Preview
> > > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > > excess of
> > > > > > 200 lines.
> > > > > >
> > > > > > I can run the SQL fine in Query Analyzer but running it in the
> Data
> > > tab,
> > > > > it
> > > > > > freezes VS, and when I run the Preview, the report never renders.
> I
> > > have
> > > > > even
> > > > > > tried hardcoding all parameters, creating a stored procedure, and
> > > running
> > > > > the
> > > > > > report off a view. None have resolved the issue.
> > > > > >
> > > > > > On a possibly related note, my connection to the database times
> out
> > > > > > intermittently, saying:
> > > > > >
> > > > > > --
> > > > > > Microsoft Development Environment
> > > > > > --
> > > > > > An error occurred while executing the query.
> > > > > >
> > > > > > General network error. Check your network documentation.
> > > > > > --
> > > > > > OK
> > > > > > --
> > > > > >
> > > > > > This absolutely kills me over the course of a day. I have to shut
> down
> > > VS
> > > > > > and restart it.
> > > > > >
> > > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Have you tried changing the connection string of the data source to increase
the time out?
try
"data source=ServerName;initial catalog=DatabaseName;Connection Timeout=30"
The connection timeout has a default of 15.
"Bassist695" wrote:
> Yes, I did give it a shot as a stored procedure, with no luck.
> Well, tomorrow's another day. I'll try deploying it and seeing what happens.
> Thanks for the help.
> Mike
> "Bruce L-C [MVP]" wrote:
> > Did you say you tried it as a stored procedure and you still had problems.
> > 20 fields should not be a problem. 309 lines of a query could be a problem
> > in the IDE (not necessarily when deployed). I suggest try deploying it and
> > see if it works to determine if it is an IDE only problem. Next, try having
> > it in a stored procedure.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> > > Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
> > The
> > > query is 309 lines long and is pretty complex...Still, I'm having a heck
> > of a
> > > time. Could it be my RS client install, or could it be my machine?
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > The 727 rows should not be a problem. Is that one causing an issue from
> > the
> > > > data tab?
> > > >
> > > > It doesn't surprise me that the 60,000 row one has problems.
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > > > For one report in particular, about 727 rows, and today it's taking
> > just
> > > > over
> > > > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > > > have
> > > > > to work on limiting that severely.
> > > > >
> > > > > "Bruce L-C [MVP]" wrote:
> > > > >
> > > > > > How many fields are being returned? How many rows of data?
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Bruce Loehle-Conger
> > > > > > MVP SQL Server Reporting Services
> > > > > >
> > > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > > > Preview
> > > > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > > > excess of
> > > > > > > 200 lines.
> > > > > > >
> > > > > > > I can run the SQL fine in Query Analyzer but running it in the
> > Data
> > > > tab,
> > > > > > it
> > > > > > > freezes VS, and when I run the Preview, the report never renders.
> > I
> > > > have
> > > > > > even
> > > > > > > tried hardcoding all parameters, creating a stored procedure, and
> > > > running
> > > > > > the
> > > > > > > report off a view. None have resolved the issue.
> > > > > > >
> > > > > > > On a possibly related note, my connection to the database times
> > out
> > > > > > > intermittently, saying:
> > > > > > >
> > > > > > > --
> > > > > > > Microsoft Development Environment
> > > > > > > --
> > > > > > > An error occurred while executing the query.
> > > > > > >
> > > > > > > General network error. Check your network documentation.
> > > > > > > --
> > > > > > > OK
> > > > > > > --
> > > > > > >
> > > > > > > This absolutely kills me over the course of a day. I have to shut
> > down
> > > > VS
> > > > > > > and restart it.
> > > > > > >
> > > > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||No, I haven't tried that. I don't believe the queries are timing out.
Wouldn't I get an error message to indicate that?
At present, there is no timeout set, which I believe means that the query
will not time out.
I'm going to try the deploy-and-see method...Let's hope it's my IDE.
Mike
"Carl Finnegan" wrote:
> Have you tried changing the connection string of the data source to increase
> the time out?
> try
> "data source=ServerName;initial catalog=DatabaseName;Connection Timeout=30"
> The connection timeout has a default of 15.
> "Bassist695" wrote:
> > Yes, I did give it a shot as a stored procedure, with no luck.
> >
> > Well, tomorrow's another day. I'll try deploying it and seeing what happens.
> > Thanks for the help.
> >
> > Mike
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Did you say you tried it as a stored procedure and you still had problems.
> > > 20 fields should not be a problem. 309 lines of a query could be a problem
> > > in the IDE (not necessarily when deployed). I suggest try deploying it and
> > > see if it works to determine if it is an IDE only problem. Next, try having
> > > it in a stored procedure.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > news:0C35989D-938D-4EE6-B1F3-746130C76E80@.microsoft.com...
> > > > Sometimes it runs from the data tab. Sometimes (like now), it hoses VS.
> > > The
> > > > query is 309 lines long and is pretty complex...Still, I'm having a heck
> > > of a
> > > > time. Could it be my RS client install, or could it be my machine?
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > The 727 rows should not be a problem. Is that one causing an issue from
> > > the
> > > > > data tab?
> > > > >
> > > > > It doesn't surprise me that the 60,000 row one has problems.
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > news:CED42435-B092-427F-A344-1A6F707C67B2@.microsoft.com...
> > > > > > For one report in particular, about 727 rows, and today it's taking
> > > just
> > > > > over
> > > > > > 4 minutes to run. The other has over 60,000 rows and I'm just going to
> > > > > have
> > > > > > to work on limiting that severely.
> > > > > >
> > > > > > "Bruce L-C [MVP]" wrote:
> > > > > >
> > > > > > > How many fields are being returned? How many rows of data?
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Bruce Loehle-Conger
> > > > > > > MVP SQL Server Reporting Services
> > > > > > >
> > > > > > > "Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
> > > > > > > news:188CC9BC-F0D3-46A7-A4F7-896E279E5252@.microsoft.com...
> > > > > > > > Whenever I run long SQL in VS whether it's in the Data tab or in
> > > > > Preview
> > > > > > > > mode, I can't seem to get a report out of it. I'm talking SQL in
> > > > > excess of
> > > > > > > > 200 lines.
> > > > > > > >
> > > > > > > > I can run the SQL fine in Query Analyzer but running it in the
> > > Data
> > > > > tab,
> > > > > > > it
> > > > > > > > freezes VS, and when I run the Preview, the report never renders.
> > > I
> > > > > have
> > > > > > > even
> > > > > > > > tried hardcoding all parameters, creating a stored procedure, and
> > > > > running
> > > > > > > the
> > > > > > > > report off a view. None have resolved the issue.
> > > > > > > >
> > > > > > > > On a possibly related note, my connection to the database times
> > > out
> > > > > > > > intermittently, saying:
> > > > > > > >
> > > > > > > > --
> > > > > > > > Microsoft Development Environment
> > > > > > > > --
> > > > > > > > An error occurred while executing the query.
> > > > > > > >
> > > > > > > > General network error. Check your network documentation.
> > > > > > > > --
> > > > > > > > OK
> > > > > > > > --
> > > > > > > >
> > > > > > > > This absolutely kills me over the course of a day. I have to shut
> > > down
> > > > > VS
> > > > > > > > and restart it.
> > > > > > > >
> > > > > > > > Is my Reporting Services VS package install corrupt? What do I do?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
Friday, March 23, 2012
Logshipping
Hi
I have a strange problem started happening in my log shipping. The database
went to suspect/loading/read-only mode in the middle of the night.
Can't see any particular reason in the sql srever errorlog.
One thing i noticed in th msdb..backupset. This table did not have an entry
for anyother transaction log that happened after the last transaction log
that got applid to the database. But the logshipping copy job is fine and it
copies all the logs. Something broken internally in the logshpping. I looked
online for anymore info. Apparently there was a hotfix before SP3. We already
have sp3 on this server.
Did anyone experience this problem?
Any idea?
Any kind of help is appreciated.
Thanks
Uday
Hi
Can you see how did the last LOG restore to the database? What happened?
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> Hi
> I have a strange problem started happening in my log shipping. The
> database
> went to suspect/loading/read-only mode in the middle of the night.
> Can't see any particular reason in the sql srever errorlog.
> One thing i noticed in th msdb..backupset. This table did not have an
> entry
> for anyother transaction log that happened after the last transaction log
> that got applid to the database. But the logshipping copy job is fine and
> it
> copies all the logs. Something broken internally in the logshpping. I
> looked
> online for anymore info. Apparently there was a hotfix before SP3. We
> already
> have sp3 on this server.
> Did anyone experience this problem?
> Any idea?
> Any kind of help is appreciated.
> Thanks
> Uday
|||The logshipping_plan_databases table says that the last file loaded was the
midbight file. The database didn't get recovered after that.
It doesn't tell me any reason why this happened.
It went to suspect. I reset the suspect bit and restarted the services.
That didn't help.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>
|||Hi Uri
I also notice something strange.
The database that was doing the full backup job failed.
It actually did do the backup. But the job failed saying that it can't find
the network path name. The full backup job says that it ran for 1:26minutes
before it failed. But i see transaction log for every 15minutes in that 1:26
minutes. Usually when the ful backup starts, the transaction log back starts
but never does the transaction log backup until its completed. Right.
This is strange.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>
|||Ignore this reply.
It did say that it waited for the hour that it took for the full backup to
fail.
I had the backup file. Bayut the job reported failure.
Back to square onw. I am not sure what happened.
Help please
Ud
"Udayasree" wrote:
[vbcol=seagreen]
> Hi Uri
> I also notice something strange.
> The database that was doing the full backup job failed.
> It actually did do the backup. But the job failed saying that it can't find
> the network path name. The full backup job says that it ran for 1:26minutes
> before it failed. But i see transaction log for every 15minutes in that 1:26
> minutes. Usually when the ful backup starts, the transaction log back starts
> but never does the transaction log backup until its completed. Right.
> This is strange.
> --Uday
> "Uri Dimant" wrote:
|||Well, try restore a last good full backup.
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...[vbcol=seagreen]
> Ignore this reply.
> It did say that it waited for the hour that it took for the full backup to
> fail.
> I had the backup file. Bayut the job reported failure.
> Back to square onw. I am not sure what happened.
> Help please
> Ud
> "Udayasree" wrote:
|||I did.
This has been happening lately. Thats how i reestablish the logshipping.
But if this happens on a big database, it will take me a day or 2 to bring
the standby database.
You think i should call Microsoft.
You guys never encountered this issue.
Uday
"Uri Dimant" wrote:
> Well, try restore a last good full backup.
>
>
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
>
>
I have a strange problem started happening in my log shipping. The database
went to suspect/loading/read-only mode in the middle of the night.
Can't see any particular reason in the sql srever errorlog.
One thing i noticed in th msdb..backupset. This table did not have an entry
for anyother transaction log that happened after the last transaction log
that got applid to the database. But the logshipping copy job is fine and it
copies all the logs. Something broken internally in the logshpping. I looked
online for anymore info. Apparently there was a hotfix before SP3. We already
have sp3 on this server.
Did anyone experience this problem?
Any idea?
Any kind of help is appreciated.
Thanks
Uday
Hi
Can you see how did the last LOG restore to the database? What happened?
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> Hi
> I have a strange problem started happening in my log shipping. The
> database
> went to suspect/loading/read-only mode in the middle of the night.
> Can't see any particular reason in the sql srever errorlog.
> One thing i noticed in th msdb..backupset. This table did not have an
> entry
> for anyother transaction log that happened after the last transaction log
> that got applid to the database. But the logshipping copy job is fine and
> it
> copies all the logs. Something broken internally in the logshpping. I
> looked
> online for anymore info. Apparently there was a hotfix before SP3. We
> already
> have sp3 on this server.
> Did anyone experience this problem?
> Any idea?
> Any kind of help is appreciated.
> Thanks
> Uday
|||The logshipping_plan_databases table says that the last file loaded was the
midbight file. The database didn't get recovered after that.
It doesn't tell me any reason why this happened.
It went to suspect. I reset the suspect bit and restarted the services.
That didn't help.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>
|||Hi Uri
I also notice something strange.
The database that was doing the full backup job failed.
It actually did do the backup. But the job failed saying that it can't find
the network path name. The full backup job says that it ran for 1:26minutes
before it failed. But i see transaction log for every 15minutes in that 1:26
minutes. Usually when the ful backup starts, the transaction log back starts
but never does the transaction log backup until its completed. Right.
This is strange.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>
|||Ignore this reply.
It did say that it waited for the hour that it took for the full backup to
fail.
I had the backup file. Bayut the job reported failure.
Back to square onw. I am not sure what happened.
Help please
Ud
"Udayasree" wrote:
[vbcol=seagreen]
> Hi Uri
> I also notice something strange.
> The database that was doing the full backup job failed.
> It actually did do the backup. But the job failed saying that it can't find
> the network path name. The full backup job says that it ran for 1:26minutes
> before it failed. But i see transaction log for every 15minutes in that 1:26
> minutes. Usually when the ful backup starts, the transaction log back starts
> but never does the transaction log backup until its completed. Right.
> This is strange.
> --Uday
> "Uri Dimant" wrote:
|||Well, try restore a last good full backup.
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...[vbcol=seagreen]
> Ignore this reply.
> It did say that it waited for the hour that it took for the full backup to
> fail.
> I had the backup file. Bayut the job reported failure.
> Back to square onw. I am not sure what happened.
> Help please
> Ud
> "Udayasree" wrote:
|||I did.
This has been happening lately. Thats how i reestablish the logshipping.
But if this happens on a big database, it will take me a day or 2 to bring
the standby database.
You think i should call Microsoft.
You guys never encountered this issue.
Uday
"Uri Dimant" wrote:
> Well, try restore a last good full backup.
>
>
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
>
>
Logshipping
Hi
I have a strange problem started happening in my log shipping. The database
went to suspect/loading/read-only mode in the middle of the night.
Can't see any particular reason in the sql srever errorlog.
One thing i noticed in th msdb..backupset. This table did not have an entry
for anyother transaction log that happened after the last transaction log
that got applid to the database. But the logshipping copy job is fine and it
copies all the logs. Something broken internally in the logshpping. I looked
online for anymore info. Apparently there was a hotfix before SP3. We alread
y
have sp3 on this server.
Did anyone experience this problem?
Any idea?
Any kind of help is appreciated.
Thanks
UdayHi
Can you see how did the last LOG restore to the database? What happened?
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> Hi
> I have a strange problem started happening in my log shipping. The
> database
> went to suspect/loading/read-only mode in the middle of the night.
> Can't see any particular reason in the sql srever errorlog.
> One thing i noticed in th msdb..backupset. This table did not have an
> entry
> for anyother transaction log that happened after the last transaction log
> that got applid to the database. But the logshipping copy job is fine and
> it
> copies all the logs. Something broken internally in the logshpping. I
> looked
> online for anymore info. Apparently there was a hotfix before SP3. We
> already
> have sp3 on this server.
> Did anyone experience this problem?
> Any idea?
> Any kind of help is appreciated.
> Thanks
> Uday|||The logshipping_plan_databases table says that the last file loaded was the
midbight file. The database didn't get recovered after that.
It doesn't tell me any reason why this happened.
It went to suspect. I reset the suspect bit and restarted the services.
That didn't help.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>|||Hi Uri
I also notice something strange.
The database that was doing the full backup job failed.
It actually did do the backup. But the job failed saying that it can't find
the network path name. The full backup job says that it ran for 1:26minutes
before it failed. But i see transaction log for every 15minutes in that 1:26
minutes. Usually when the ful backup starts, the transaction log back starts
but never does the transaction log backup until its completed. Right.
This is strange.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>|||Ignore this reply.
It did say that it waited for the hour that it took for the full backup to
fail.
I had the backup file. Bayut the job reported failure.
Back to square onw. I am not sure what happened.
Help please
Ud
"Udayasree" wrote:
[vbcol=seagreen]
> Hi Uri
> I also notice something strange.
> The database that was doing the full backup job failed.
> It actually did do the backup. But the job failed saying that it can't fin
d
> the network path name. The full backup job says that it ran for 1:26minute
s
> before it failed. But i see transaction log for every 15minutes in that 1:
26
> minutes. Usually when the ful backup starts, the transaction log back star
ts
> but never does the transaction log backup until its completed. Right.
> This is strange.
> --Uday
> "Uri Dimant" wrote:
>|||Well, try restore a last good full backup.
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...[vbcol=seagreen]
> Ignore this reply.
> It did say that it waited for the hour that it took for the full backup to
> fail.
> I had the backup file. Bayut the job reported failure.
> Back to square onw. I am not sure what happened.
> Help please
> Ud
> "Udayasree" wrote:
>|||I did.
This has been happening lately. Thats how i reestablish the logshipping.
But if this happens on a big database, it will take me a day or 2 to bring
the standby database.
You think i should call Microsoft.
You guys never encountered this issue.
Uday
"Uri Dimant" wrote:
> Well, try restore a last good full backup.
>
>
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
>
>sql
I have a strange problem started happening in my log shipping. The database
went to suspect/loading/read-only mode in the middle of the night.
Can't see any particular reason in the sql srever errorlog.
One thing i noticed in th msdb..backupset. This table did not have an entry
for anyother transaction log that happened after the last transaction log
that got applid to the database. But the logshipping copy job is fine and it
copies all the logs. Something broken internally in the logshpping. I looked
online for anymore info. Apparently there was a hotfix before SP3. We alread
y
have sp3 on this server.
Did anyone experience this problem?
Any idea?
Any kind of help is appreciated.
Thanks
UdayHi
Can you see how did the last LOG restore to the database? What happened?
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> Hi
> I have a strange problem started happening in my log shipping. The
> database
> went to suspect/loading/read-only mode in the middle of the night.
> Can't see any particular reason in the sql srever errorlog.
> One thing i noticed in th msdb..backupset. This table did not have an
> entry
> for anyother transaction log that happened after the last transaction log
> that got applid to the database. But the logshipping copy job is fine and
> it
> copies all the logs. Something broken internally in the logshpping. I
> looked
> online for anymore info. Apparently there was a hotfix before SP3. We
> already
> have sp3 on this server.
> Did anyone experience this problem?
> Any idea?
> Any kind of help is appreciated.
> Thanks
> Uday|||The logshipping_plan_databases table says that the last file loaded was the
midbight file. The database didn't get recovered after that.
It doesn't tell me any reason why this happened.
It went to suspect. I reset the suspect bit and restarted the services.
That didn't help.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>|||Hi Uri
I also notice something strange.
The database that was doing the full backup job failed.
It actually did do the backup. But the job failed saying that it can't find
the network path name. The full backup job says that it ran for 1:26minutes
before it failed. But i see transaction log for every 15minutes in that 1:26
minutes. Usually when the ful backup starts, the transaction log back starts
but never does the transaction log backup until its completed. Right.
This is strange.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>
>|||Ignore this reply.
It did say that it waited for the hour that it took for the full backup to
fail.
I had the backup file. Bayut the job reported failure.
Back to square onw. I am not sure what happened.
Help please
Ud
"Udayasree" wrote:
[vbcol=seagreen]
> Hi Uri
> I also notice something strange.
> The database that was doing the full backup job failed.
> It actually did do the backup. But the job failed saying that it can't fin
d
> the network path name. The full backup job says that it ran for 1:26minute
s
> before it failed. But i see transaction log for every 15minutes in that 1:
26
> minutes. Usually when the ful backup starts, the transaction log back star
ts
> but never does the transaction log backup until its completed. Right.
> This is strange.
> --Uday
> "Uri Dimant" wrote:
>|||Well, try restore a last good full backup.
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...[vbcol=seagreen]
> Ignore this reply.
> It did say that it waited for the hour that it took for the full backup to
> fail.
> I had the backup file. Bayut the job reported failure.
> Back to square onw. I am not sure what happened.
> Help please
> Ud
> "Udayasree" wrote:
>|||I did.
This has been happening lately. Thats how i reestablish the logshipping.
But if this happens on a big database, it will take me a day or 2 to bring
the standby database.
You think i should call Microsoft.
You guys never encountered this issue.
Uday
"Uri Dimant" wrote:
> Well, try restore a last good full backup.
>
>
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
>
>sql
Wednesday, March 21, 2012
Logshipping
Hi
I have a strange problem started happening in my log shipping. The database
went to suspect/loading/read-only mode in the middle of the night.
Can't see any particular reason in the sql srever errorlog.
One thing i noticed in th msdb..backupset. This table did not have an entry
for anyother transaction log that happened after the last transaction log
that got applid to the database. But the logshipping copy job is fine and it
copies all the logs. Something broken internally in the logshpping. I looked
online for anymore info. Apparently there was a hotfix before SP3. We already
have sp3 on this server.
Did anyone experience this problem?
Any idea?
Any kind of help is appreciated.
Thanks
UdayHi
Can you see how did the last LOG restore to the database? What happened?
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> Hi
> I have a strange problem started happening in my log shipping. The
> database
> went to suspect/loading/read-only mode in the middle of the night.
> Can't see any particular reason in the sql srever errorlog.
> One thing i noticed in th msdb..backupset. This table did not have an
> entry
> for anyother transaction log that happened after the last transaction log
> that got applid to the database. But the logshipping copy job is fine and
> it
> copies all the logs. Something broken internally in the logshpping. I
> looked
> online for anymore info. Apparently there was a hotfix before SP3. We
> already
> have sp3 on this server.
> Did anyone experience this problem?
> Any idea?
> Any kind of help is appreciated.
> Thanks
> Uday|||The logshipping_plan_databases table says that the last file loaded was the
midbight file. The database didn't get recovered after that.
It doesn't tell me any reason why this happened.
It went to suspect. I reset the suspect bit and restarted the services.
That didn't help.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> > Hi
> >
> > I have a strange problem started happening in my log shipping. The
> > database
> > went to suspect/loading/read-only mode in the middle of the night.
> > Can't see any particular reason in the sql srever errorlog.
> >
> > One thing i noticed in th msdb..backupset. This table did not have an
> > entry
> > for anyother transaction log that happened after the last transaction log
> > that got applid to the database. But the logshipping copy job is fine and
> > it
> > copies all the logs. Something broken internally in the logshpping. I
> > looked
> > online for anymore info. Apparently there was a hotfix before SP3. We
> > already
> > have sp3 on this server.
> >
> > Did anyone experience this problem?
> > Any idea?
> > Any kind of help is appreciated.
> >
> > Thanks
> > Uday
>
>|||Hi Uri
I also notice something strange.
The database that was doing the full backup job failed.
It actually did do the backup. But the job failed saying that it can't find
the network path name. The full backup job says that it ran for 1:26minutes
before it failed. But i see transaction log for every 15minutes in that 1:26
minutes. Usually when the ful backup starts, the transaction log back starts
but never does the transaction log backup until its completed. Right.
This is strange.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> > Hi
> >
> > I have a strange problem started happening in my log shipping. The
> > database
> > went to suspect/loading/read-only mode in the middle of the night.
> > Can't see any particular reason in the sql srever errorlog.
> >
> > One thing i noticed in th msdb..backupset. This table did not have an
> > entry
> > for anyother transaction log that happened after the last transaction log
> > that got applid to the database. But the logshipping copy job is fine and
> > it
> > copies all the logs. Something broken internally in the logshpping. I
> > looked
> > online for anymore info. Apparently there was a hotfix before SP3. We
> > already
> > have sp3 on this server.
> >
> > Did anyone experience this problem?
> > Any idea?
> > Any kind of help is appreciated.
> >
> > Thanks
> > Uday
>
>|||Ignore this reply.
It did say that it waited for the hour that it took for the full backup to
fail.
I had the backup file. Bayut the job reported failure.
Back to square onw. I am not sure what happened.
Help please
Ud
"Udayasree" wrote:
> Hi Uri
> I also notice something strange.
> The database that was doing the full backup job failed.
> It actually did do the backup. But the job failed saying that it can't find
> the network path name. The full backup job says that it ran for 1:26minutes
> before it failed. But i see transaction log for every 15minutes in that 1:26
> minutes. Usually when the ful backup starts, the transaction log back starts
> but never does the transaction log backup until its completed. Right.
> This is strange.
> --Uday
> "Uri Dimant" wrote:
> > Hi
> > Can you see how did the last LOG restore to the database? What happened?
> >
> > "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> > news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> > > Hi
> > >
> > > I have a strange problem started happening in my log shipping. The
> > > database
> > > went to suspect/loading/read-only mode in the middle of the night.
> > > Can't see any particular reason in the sql srever errorlog.
> > >
> > > One thing i noticed in th msdb..backupset. This table did not have an
> > > entry
> > > for anyother transaction log that happened after the last transaction log
> > > that got applid to the database. But the logshipping copy job is fine and
> > > it
> > > copies all the logs. Something broken internally in the logshpping. I
> > > looked
> > > online for anymore info. Apparently there was a hotfix before SP3. We
> > > already
> > > have sp3 on this server.
> > >
> > > Did anyone experience this problem?
> > > Any idea?
> > > Any kind of help is appreciated.
> > >
> > > Thanks
> > > Uday
> >
> >
> >|||Well, try restore a last good full backup.
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
> Ignore this reply.
> It did say that it waited for the hour that it took for the full backup to
> fail.
> I had the backup file. Bayut the job reported failure.
> Back to square onw. I am not sure what happened.
> Help please
> Ud
> "Udayasree" wrote:
>> Hi Uri
>> I also notice something strange.
>> The database that was doing the full backup job failed.
>> It actually did do the backup. But the job failed saying that it can't
>> find
>> the network path name. The full backup job says that it ran for
>> 1:26minutes
>> before it failed. But i see transaction log for every 15minutes in that
>> 1:26
>> minutes. Usually when the ful backup starts, the transaction log back
>> starts
>> but never does the transaction log backup until its completed. Right.
>> This is strange.
>> --Uday
>> "Uri Dimant" wrote:
>> > Hi
>> > Can you see how did the last LOG restore to the database? What
>> > happened?
>> >
>> > "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
>> > news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>> > > Hi
>> > >
>> > > I have a strange problem started happening in my log shipping. The
>> > > database
>> > > went to suspect/loading/read-only mode in the middle of the night.
>> > > Can't see any particular reason in the sql srever errorlog.
>> > >
>> > > One thing i noticed in th msdb..backupset. This table did not have an
>> > > entry
>> > > for anyother transaction log that happened after the last transaction
>> > > log
>> > > that got applid to the database. But the logshipping copy job is fine
>> > > and
>> > > it
>> > > copies all the logs. Something broken internally in the logshpping. I
>> > > looked
>> > > online for anymore info. Apparently there was a hotfix before SP3. We
>> > > already
>> > > have sp3 on this server.
>> > >
>> > > Did anyone experience this problem?
>> > > Any idea?
>> > > Any kind of help is appreciated.
>> > >
>> > > Thanks
>> > > Uday
>> >
>> >
>> >|||I did.
This has been happening lately. Thats how i reestablish the logshipping.
But if this happens on a big database, it will take me a day or 2 to bring
the standby database.
You think i should call Microsoft.
You guys never encountered this issue.
Uday
"Uri Dimant" wrote:
> Well, try restore a last good full backup.
>
>
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
> > Ignore this reply.
> > It did say that it waited for the hour that it took for the full backup to
> > fail.
> > I had the backup file. Bayut the job reported failure.
> >
> > Back to square onw. I am not sure what happened.
> > Help please
> > Ud
> >
> > "Udayasree" wrote:
> >
> >> Hi Uri
> >>
> >> I also notice something strange.
> >> The database that was doing the full backup job failed.
> >> It actually did do the backup. But the job failed saying that it can't
> >> find
> >> the network path name. The full backup job says that it ran for
> >> 1:26minutes
> >> before it failed. But i see transaction log for every 15minutes in that
> >> 1:26
> >> minutes. Usually when the ful backup starts, the transaction log back
> >> starts
> >> but never does the transaction log backup until its completed. Right.
> >> This is strange.
> >>
> >> --Uday
> >>
> >> "Uri Dimant" wrote:
> >>
> >> > Hi
> >> > Can you see how did the last LOG restore to the database? What
> >> > happened?
> >> >
> >> > "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> >> > news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> >> > > Hi
> >> > >
> >> > > I have a strange problem started happening in my log shipping. The
> >> > > database
> >> > > went to suspect/loading/read-only mode in the middle of the night.
> >> > > Can't see any particular reason in the sql srever errorlog.
> >> > >
> >> > > One thing i noticed in th msdb..backupset. This table did not have an
> >> > > entry
> >> > > for anyother transaction log that happened after the last transaction
> >> > > log
> >> > > that got applid to the database. But the logshipping copy job is fine
> >> > > and
> >> > > it
> >> > > copies all the logs. Something broken internally in the logshpping. I
> >> > > looked
> >> > > online for anymore info. Apparently there was a hotfix before SP3. We
> >> > > already
> >> > > have sp3 on this server.
> >> > >
> >> > > Did anyone experience this problem?
> >> > > Any idea?
> >> > > Any kind of help is appreciated.
> >> > >
> >> > > Thanks
> >> > > Uday
> >> >
> >> >
> >> >
>
>sql
I have a strange problem started happening in my log shipping. The database
went to suspect/loading/read-only mode in the middle of the night.
Can't see any particular reason in the sql srever errorlog.
One thing i noticed in th msdb..backupset. This table did not have an entry
for anyother transaction log that happened after the last transaction log
that got applid to the database. But the logshipping copy job is fine and it
copies all the logs. Something broken internally in the logshpping. I looked
online for anymore info. Apparently there was a hotfix before SP3. We already
have sp3 on this server.
Did anyone experience this problem?
Any idea?
Any kind of help is appreciated.
Thanks
UdayHi
Can you see how did the last LOG restore to the database? What happened?
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> Hi
> I have a strange problem started happening in my log shipping. The
> database
> went to suspect/loading/read-only mode in the middle of the night.
> Can't see any particular reason in the sql srever errorlog.
> One thing i noticed in th msdb..backupset. This table did not have an
> entry
> for anyother transaction log that happened after the last transaction log
> that got applid to the database. But the logshipping copy job is fine and
> it
> copies all the logs. Something broken internally in the logshpping. I
> looked
> online for anymore info. Apparently there was a hotfix before SP3. We
> already
> have sp3 on this server.
> Did anyone experience this problem?
> Any idea?
> Any kind of help is appreciated.
> Thanks
> Uday|||The logshipping_plan_databases table says that the last file loaded was the
midbight file. The database didn't get recovered after that.
It doesn't tell me any reason why this happened.
It went to suspect. I reset the suspect bit and restarted the services.
That didn't help.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> > Hi
> >
> > I have a strange problem started happening in my log shipping. The
> > database
> > went to suspect/loading/read-only mode in the middle of the night.
> > Can't see any particular reason in the sql srever errorlog.
> >
> > One thing i noticed in th msdb..backupset. This table did not have an
> > entry
> > for anyother transaction log that happened after the last transaction log
> > that got applid to the database. But the logshipping copy job is fine and
> > it
> > copies all the logs. Something broken internally in the logshpping. I
> > looked
> > online for anymore info. Apparently there was a hotfix before SP3. We
> > already
> > have sp3 on this server.
> >
> > Did anyone experience this problem?
> > Any idea?
> > Any kind of help is appreciated.
> >
> > Thanks
> > Uday
>
>|||Hi Uri
I also notice something strange.
The database that was doing the full backup job failed.
It actually did do the backup. But the job failed saying that it can't find
the network path name. The full backup job says that it ran for 1:26minutes
before it failed. But i see transaction log for every 15minutes in that 1:26
minutes. Usually when the ful backup starts, the transaction log back starts
but never does the transaction log backup until its completed. Right.
This is strange.
--Uday
"Uri Dimant" wrote:
> Hi
> Can you see how did the last LOG restore to the database? What happened?
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> > Hi
> >
> > I have a strange problem started happening in my log shipping. The
> > database
> > went to suspect/loading/read-only mode in the middle of the night.
> > Can't see any particular reason in the sql srever errorlog.
> >
> > One thing i noticed in th msdb..backupset. This table did not have an
> > entry
> > for anyother transaction log that happened after the last transaction log
> > that got applid to the database. But the logshipping copy job is fine and
> > it
> > copies all the logs. Something broken internally in the logshpping. I
> > looked
> > online for anymore info. Apparently there was a hotfix before SP3. We
> > already
> > have sp3 on this server.
> >
> > Did anyone experience this problem?
> > Any idea?
> > Any kind of help is appreciated.
> >
> > Thanks
> > Uday
>
>|||Ignore this reply.
It did say that it waited for the hour that it took for the full backup to
fail.
I had the backup file. Bayut the job reported failure.
Back to square onw. I am not sure what happened.
Help please
Ud
"Udayasree" wrote:
> Hi Uri
> I also notice something strange.
> The database that was doing the full backup job failed.
> It actually did do the backup. But the job failed saying that it can't find
> the network path name. The full backup job says that it ran for 1:26minutes
> before it failed. But i see transaction log for every 15minutes in that 1:26
> minutes. Usually when the ful backup starts, the transaction log back starts
> but never does the transaction log backup until its completed. Right.
> This is strange.
> --Uday
> "Uri Dimant" wrote:
> > Hi
> > Can you see how did the last LOG restore to the database? What happened?
> >
> > "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> > news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> > > Hi
> > >
> > > I have a strange problem started happening in my log shipping. The
> > > database
> > > went to suspect/loading/read-only mode in the middle of the night.
> > > Can't see any particular reason in the sql srever errorlog.
> > >
> > > One thing i noticed in th msdb..backupset. This table did not have an
> > > entry
> > > for anyother transaction log that happened after the last transaction log
> > > that got applid to the database. But the logshipping copy job is fine and
> > > it
> > > copies all the logs. Something broken internally in the logshpping. I
> > > looked
> > > online for anymore info. Apparently there was a hotfix before SP3. We
> > > already
> > > have sp3 on this server.
> > >
> > > Did anyone experience this problem?
> > > Any idea?
> > > Any kind of help is appreciated.
> > >
> > > Thanks
> > > Uday
> >
> >
> >|||Well, try restore a last good full backup.
"Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
> Ignore this reply.
> It did say that it waited for the hour that it took for the full backup to
> fail.
> I had the backup file. Bayut the job reported failure.
> Back to square onw. I am not sure what happened.
> Help please
> Ud
> "Udayasree" wrote:
>> Hi Uri
>> I also notice something strange.
>> The database that was doing the full backup job failed.
>> It actually did do the backup. But the job failed saying that it can't
>> find
>> the network path name. The full backup job says that it ran for
>> 1:26minutes
>> before it failed. But i see transaction log for every 15minutes in that
>> 1:26
>> minutes. Usually when the ful backup starts, the transaction log back
>> starts
>> but never does the transaction log backup until its completed. Right.
>> This is strange.
>> --Uday
>> "Uri Dimant" wrote:
>> > Hi
>> > Can you see how did the last LOG restore to the database? What
>> > happened?
>> >
>> > "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
>> > news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
>> > > Hi
>> > >
>> > > I have a strange problem started happening in my log shipping. The
>> > > database
>> > > went to suspect/loading/read-only mode in the middle of the night.
>> > > Can't see any particular reason in the sql srever errorlog.
>> > >
>> > > One thing i noticed in th msdb..backupset. This table did not have an
>> > > entry
>> > > for anyother transaction log that happened after the last transaction
>> > > log
>> > > that got applid to the database. But the logshipping copy job is fine
>> > > and
>> > > it
>> > > copies all the logs. Something broken internally in the logshpping. I
>> > > looked
>> > > online for anymore info. Apparently there was a hotfix before SP3. We
>> > > already
>> > > have sp3 on this server.
>> > >
>> > > Did anyone experience this problem?
>> > > Any idea?
>> > > Any kind of help is appreciated.
>> > >
>> > > Thanks
>> > > Uday
>> >
>> >
>> >|||I did.
This has been happening lately. Thats how i reestablish the logshipping.
But if this happens on a big database, it will take me a day or 2 to bring
the standby database.
You think i should call Microsoft.
You guys never encountered this issue.
Uday
"Uri Dimant" wrote:
> Well, try restore a last good full backup.
>
>
> "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> news:B119E88C-4856-4C0F-B481-1CA7656C0266@.microsoft.com...
> > Ignore this reply.
> > It did say that it waited for the hour that it took for the full backup to
> > fail.
> > I had the backup file. Bayut the job reported failure.
> >
> > Back to square onw. I am not sure what happened.
> > Help please
> > Ud
> >
> > "Udayasree" wrote:
> >
> >> Hi Uri
> >>
> >> I also notice something strange.
> >> The database that was doing the full backup job failed.
> >> It actually did do the backup. But the job failed saying that it can't
> >> find
> >> the network path name. The full backup job says that it ran for
> >> 1:26minutes
> >> before it failed. But i see transaction log for every 15minutes in that
> >> 1:26
> >> minutes. Usually when the ful backup starts, the transaction log back
> >> starts
> >> but never does the transaction log backup until its completed. Right.
> >> This is strange.
> >>
> >> --Uday
> >>
> >> "Uri Dimant" wrote:
> >>
> >> > Hi
> >> > Can you see how did the last LOG restore to the database? What
> >> > happened?
> >> >
> >> > "Udayasree" <Udayasree@.discussions.microsoft.com> wrote in message
> >> > news:27D5BE75-8F73-44CE-8614-EEE00372D2C6@.microsoft.com...
> >> > > Hi
> >> > >
> >> > > I have a strange problem started happening in my log shipping. The
> >> > > database
> >> > > went to suspect/loading/read-only mode in the middle of the night.
> >> > > Can't see any particular reason in the sql srever errorlog.
> >> > >
> >> > > One thing i noticed in th msdb..backupset. This table did not have an
> >> > > entry
> >> > > for anyother transaction log that happened after the last transaction
> >> > > log
> >> > > that got applid to the database. But the logshipping copy job is fine
> >> > > and
> >> > > it
> >> > > copies all the logs. Something broken internally in the logshpping. I
> >> > > looked
> >> > > online for anymore info. Apparently there was a hotfix before SP3. We
> >> > > already
> >> > > have sp3 on this server.
> >> > >
> >> > > Did anyone experience this problem?
> >> > > Any idea?
> >> > > Any kind of help is appreciated.
> >> > >
> >> > > Thanks
> >> > > Uday
> >> >
> >> >
> >> >
>
>sql
Friday, March 9, 2012
Login/connection problem
I have installed SQL Server 2000 SP3a on an XP machine and running in
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, Larzeb
Hello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com! reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
|
|||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsservers
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>|
|||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
|||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, Larzeb
Hello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com! reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
|
|||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!tex
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsservers
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>|
|||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
|||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!meg
anewsservers.com!reader1.on.meganewsservers.com!re ader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsserver s.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com !reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
Login/connection problem
I have installed SQL Server 2000 SP3a on an XP machine and running in
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, LarzebHello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
||||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>||||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
||||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
mixed mode. I log on using a local user name belonging to the
Administrators group.
When I attempt to connect to the DB through .Net with the following
string:
Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
I receive the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
However, I can login using osql -Uuser and password pwd.
What am I missing here? I am desperate!
TIA, LarzebHello Larzeb,
It seems that SQL client network protocals are not enabled properly. I
suggest that you run
%windir%\SYSTEM32\cliconfg.exe
and enable TCP/IP and named pipes protocals.
Also, please run server network utility to enable the same protocals:
%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Login/connection problem
| Date: Tue, 01 Feb 2005 14:25:15 -0800
| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 20
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
216.251.47.166:52402
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!tex
tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsservers
.com!reader1.on.meganewsservers.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have installed SQL Server 2000 SP3a on an XP machine and running in
| mixed mode. I log on using a local user name belonging to the
| Administrators group.
|
| When I attempt to connect to the DB through .Net with the following
| string:
|
| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
|
| I receive the following error:
|
| Login failed for user '(null)'. Reason: Not associated with a trusted
| SQL Server connection.
|
| However, I can login using osql -Uuser and password pwd.
|
| What am I missing here? I am desperate!
|
| TIA, Larzeb
||||Peter,
Both protocols where already set in both the client and server
utilities. Any other ideas?
Larzeb
On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
Yang [MSFT]) wrote:
>Hello Larzeb,
>It seems that SQL client network protocals are not enabled properly. I
>suggest that you run
>%windir%\SYSTEM32\cliconfg.exe
>and enable TCP/IP and named pipes protocals.
>Also, please run server network utility to enable the same protocals:
>%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
>Best Regards,
>Peter Yang
>MCSE2000/2003, MCSA, MCDBA
>Microsoft Online Partner Support
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>--
>| ath: nntpswitch.com
>| From: larzeb <larzeb@.community.nospam>
>| Newsgroups: microsoft.public.sqlserver.server
>| Subject: Login/connection problem
>| Date: Tue, 01 Feb 2005 14:25:15 -0800
>| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
>| X-Newsreader: Forte Agent 2.0/32.652
>| MIME-Version: 1.0
>| Content-Type: text/plain; charset=us-ascii
>| Content-Transfer-Encoding: 7bit
>| Organization: We
>| Lines: 20
>| NNTP-Posting-Host: 216.251.47.166
>| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
>216.251.47.166:52402
>| Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
>.com!reader1.on.meganewsservers.com!not-for-mail
>| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
>| X-Tomcat-NG: microsoft.public.sqlserver.server
>|
>| I have installed SQL Server 2000 SP3a on an XP machine and running in
>| mixed mode. I log on using a local user name belonging to the
>| Administrators group.
>|
>| When I attempt to connect to the DB through .Net with the following
>| string:
>|
>| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
>| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
>|
>| I receive the following error:
>|
>| Login failed for user '(null)'. Reason: Not associated with a trusted
>| SQL Server connection.
>|
>| However, I can login using osql -Uuser and password pwd.
>|
>| What am I missing here? I am desperate!
>|
>| TIA, Larzeb
>||||Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
||||The error message is telling you that, although you passed SQL Server
authentication credentials, the DBMS is actually attempting Integrated
Security=SSPI, that is, Windows Authentication. You should check to make
sure your network account has been granted SQL Server login access or force
SQL Server, and your connection string, to use SQL Server logins.
Sincerely,
Anthony Thomas
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:cbDBaKZCFHA.644@.cpmsftngxa10.phx.gbl...
Hello Larzeb,
Did you use ASP.net? If so, please check if you encountered the following
issue:
324479 FIX: ASP.NET SQL Server Session State Impersonation Is Lost Under
Load
http://support.microsoft.com/?id=324479
Actually, the error message is most likely caused by Windows
authentication. Could you double check if the error is caused by the
ADO.net call with the sql authention connection string?
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
| ath: nntpswitch.com
| From: larzeb <larzeb@.community.nospam>
| Newsgroups: microsoft.public.sqlserver.server
| Subject: Re: Login/connection problem
| Date: Wed, 02 Feb 2005 09:07:45 -0800
| Message-ID: <652201ph3q6pe86ntu562ms8p05ml68hia@.4ax.com>
| References: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
<BtuQRGPCFHA.768@.cpmsftngxa10.phx.gbl>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Organization: We
| Lines: 80
| NNTP-Posting-Host: 216.251.47.166
| X-Trace: 1107364054 reader1.on.meganewsservers.com 2179
216.251.47.166:59658
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!meg
anewsservers.com!reader1.on.meganewsservers.com!reader1.on.meganewsservers.c
om!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376672
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Peter,
|
| Both protocols where already set in both the client and server
| utilities. Any other ideas?
|
| Larzeb
| On Wed, 02 Feb 2005 06:36:42 GMT, petery@.online.microsoft.com (Peter
| Yang [MSFT]) wrote:
|
| >Hello Larzeb,
| >
| >It seems that SQL client network protocals are not enabled properly. I
| >suggest that you run
| >
| >%windir%\SYSTEM32\cliconfg.exe
| >
| >and enable TCP/IP and named pipes protocals.
| >
| >Also, please run server network utility to enable the same protocals:
| >
| >%programfiles%\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
| >
| >Best Regards,
| >
| >Peter Yang
| >MCSE2000/2003, MCSA, MCDBA
| >Microsoft Online Partner Support
| >
| >When responding to posts, please "Reply to Group" via your newsreader so
| >that others may learn and benefit from your issue.
| >
| >This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >--
| >| ath: nntpswitch.com
| >| From: larzeb <larzeb@.community.nospam>
| >| Newsgroups: microsoft.public.sqlserver.server
| >| Subject: Login/connection problem
| >| Date: Tue, 01 Feb 2005 14:25:15 -0800
| >| Message-ID: <0300011rd2bceg4lile10275tvhgbvm9ko@.4ax.com>
| >| X-Newsreader: Forte Agent 2.0/32.652
| >| MIME-Version: 1.0
| >| Content-Type: text/plain; charset=us-ascii
| >| Content-Transfer-Encoding: 7bit
| >| Organization: We
| >| Lines: 20
| >| NNTP-Posting-Host: 216.251.47.166
| >| X-Trace: 1107296715 reader1.on.meganewsservers.com 2181
| >216.251.47.166:52402
| >| Path:
|
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
|
>ul.t-online.de!t-online.de!news.glorb.com!feeder2.on.meganewsservers.com!te
x
|
>tfeed1.on.meganewsservers.com!meganewsservers.com!reader1.on.meganewsserver
s
| >.com!reader1.on.meganewsservers.com!not-for-mail
| >| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376551
| >| X-Tomcat-NG: microsoft.public.sqlserver.server
| >|
| >| I have installed SQL Server 2000 SP3a on an XP machine and running in
| >| mixed mode. I log on using a local user name belonging to the
| >| Administrators group.
| >|
| >| When I attempt to connect to the DB through .Net with the following
| >| string:
| >|
| >| Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
| >| Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"
| >|
| >| I receive the following error:
| >|
| >| Login failed for user '(null)'. Reason: Not associated with a trusted
| >| SQL Server connection.
| >|
| >| However, I can login using osql -Uuser and password pwd.
| >|
| >| What am I missing here? I am desperate!
| >|
| >| TIA, Larzeb
| >|
|
|
Subscribe to:
Posts (Atom)