Does SQL Server 2000 have any method or sp to copy files from other machine? -

If I use a workstation connected to a SQL Server 2000, can I remote the SQL Server to copy some external files (mdf & ldf) from other network machine.
I need to do it by programming, under condition:
SQL Server name is provided.
Network paths of mdf & ldf files are provided.You need to detach them using SP_DETACH_DB and copy them to the new location. Also refer to books online for RESTORE ... WITH MOVE topic for more information.

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Db
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>
|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas

"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003
,
and I want to migrate the win2k pdc to win server 2k3, that I will promote t
o
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in II
S
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running Windows 2000 server that I promoted t
o a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 200
03,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sit
es
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running Windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Dbsql

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does Service Pack 2 affect Client Tools?

Hello,

Does Service Pack 2 affect client tools? In other words, if you have a client machine with just the tools installed (management studio, BIDS, etc) do I need to run the SP2 package on this client as well?

Regards, Jeroen

YES. Always update ALL clients to the same SP as the servers.

|||thnx Tom...sql

Does reporting services run on the same machine as SQL Server?

Hi,
We're getting ready to install and start using SQL Server Reporting
Services. Do we install it on the same server as SQL Server? If yes, is that
the only way to do it? Can we install it on a separate server? Does it make
sense to do so?
Thanks,
SamIf you install it on the same server as a current licenced copy of SQl Server
2000 then it's free. If you install it on it's own server then you have to
pay a licence fee for Reporting Services (which I think is equivalent to a
SQL Server licence).
"Sam" wrote:
> Hi,
> We're getting ready to install and start using SQL Server Reporting
> Services. Do we install it on the same server as SQL Server? If yes, is that
> the only way to do it? Can we install it on a separate server? Does it make
> sense to do so?
> Thanks,
> Sam
>
>

Does IIS need to be installed on the SQL Server machine?

If I have Reporting Service installed on one server and the ReportServer
database on another server, do I need IIS installed on the server that houses
the ReportServer database? I'd rather not have IIS and SQL Server on the
same machine.No you do not. IIS has to be only on the server that has RS installed. RS is
an asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Munter" <Dave Munter@.discussions.microsoft.com> wrote in message
news:B0E4CDDD-F2B6-42C1-976B-03315BC1AF85@.microsoft.com...
> If I have Reporting Service installed on one server and the ReportServer
> database on another server, do I need IIS installed on the server that
houses
> the ReportServer database? I'd rather not have IIS and SQL Server on the
> same machine.
>

Does Graphics Card affect preformance of rendering?

I have a feeling that this is an urban legend, but I'd to verify:

Will the graphics card installed in the RS machine affect performance of any of the rendering laternatives? If so, significantlly?

An RS machine is typically a server, and such tend to have low-end graphics cards.

Two of my customers insists that they have "heard this somewhere"...

RS uses GDI internally for some rendering operations. In theory, a video driver can hook GDI and perform some of the operations more efficiently. In practice, I don't think we have seen anyone report any performance boost because of this though.

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
FrankFrank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
--
David Gugick
Imceda Software
www.imceda.com|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersion\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Frank wrote:
>> David,
>> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
>> restart, the file was changed again to SSNETLIB.OLD.
>> B/R
>> Frank
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> > David,
> > Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> > restart, the file was changed again to SSNETLIB.OLD.
> > B/R
> > Frank
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:
>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, but
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>> Hi gurus,
>> Recently, my SQL Server Machine is suffering auto shutdown.
>> After the auto shutdown, and restart of the machine, I found that the file
>> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
>> could not be started if I didn't change it back to SSNETLIB.DLL. But after
>a
>> while (usually minutes to tens of minutes), it will auto shutdown again.
>If
>> I didn't not rename it, there will be no auto shutdown.
>> My SQL Server was MSDN developer edition, with SP3 applied.
>> My machine is Windows 2000 professional edition with the latest patches
>> installed.
>> Please help me out
>> Thanks in advance
>> Frank
>>
>

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
Frank
Frank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
David Gugick
Imceda Software
www.imceda.com
|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersion\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Frank wrote:
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/d...displaylang=en
|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>
|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/d...displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:

>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, but
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>a
>If
>

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
FrankFrank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
David Gugick
Imceda Software
www.imceda.com|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/...&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersio
n\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Frank wrote:
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/...&displaylang=en|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/... />
laylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:

>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, bu
t
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>a
>If
>

Document Map not displaying for some users.

I have noticed that with some users the document map pane is empty,
whereas on my machine and others it displays as it should. Has anyone
seen this behavior before and how do you think I could resolve this?Ok, I figured it out.
With reporting services 2000, the document maps do not appear
correctly with users running IE7. There is a hotfix you can download
from Microsoft's site to resolve this.
On Apr 10, 10:08=A0am, Just Another Reporter <Crystal.War...@.gmail.com>
wrote:
> I have noticed that with some users the document map pane is empty,
> whereas on my machine and others it displays as it should. =A0Has anyone
> seen this behavior before and how do you think I could resolve this?