dbTalk Databases Forums  

Need help for the MSDE 2000 sp3 and win2003 Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Need help for the MSDE 2000 sp3 and win2003 Server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nelson
 
Posts: n/a

Default Need help for the MSDE 2000 sp3 and win2003 Server - 02-19-2005 , 09:03 AM






I have been setup a Win2k3 Server and MSDE 2000 SP3, both of them can startup
success. But I can not connect MSDE with other computer, the error message
is connect fail ....something like that. I can connect MSDE in the Win2k3
Server when I type localhost to connect it. I can not connect it when i type
//server_name. I have been disable the firewall and network security in
Win2k3.
Thank you very much
Nelson

Reply With Quote
  #2  
Old   
Jim Young
 
Posts: n/a

Default Re: Need help for the MSDE 2000 sp3 and win2003 Server - 02-19-2005 , 12:20 PM






The default installation for MSDE 2000 SP3 will disable any network
libraries from being loaded so that the server instance is only accepting
connection through shared memory, or local connections. MSDE installs a
utility, svrnetcn.exe, that can be used to enable the network libraries and
allow remote connections. You will find this program in the Tools\Binn
directory under your MSDE install directory.

Jim

"Nelson" <Nelson @discussions.microsoft.com> wrote

Quote:
I have been setup a Win2k3 Server and MSDE 2000 SP3, both of them can
startup
success. But I can not connect MSDE with other computer, the error
message
is connect fail ....something like that. I can connect MSDE in the Win2k3
Server when I type localhost to connect it. I can not connect it when i
type
//server_name. I have been disable the firewall and network security in
Win2k3.
Thank you very much
Nelson



Reply With Quote
  #3  
Old   
Nelson
 
Posts: n/a

Default Re: Need help for the MSDE 2000 sp3 and win2003 Server - 02-20-2005 , 08:25 PM



I have been do there. In the svrnetcn, choose TCP/IP, it will been show me
the port No.. I have been cheak it.
But I have been find a solution for that. When I install the Win2k3, I
should be choose auto. Setup network, MSDE will be work fine.

Thanks for your reply
Nelson


"Jim Young" wrote:

Quote:
The default installation for MSDE 2000 SP3 will disable any network
libraries from being loaded so that the server instance is only accepting
connection through shared memory, or local connections. MSDE installs a
utility, svrnetcn.exe, that can be used to enable the network libraries and
allow remote connections. You will find this program in the Tools\Binn
directory under your MSDE install directory.

Jim

"Nelson" <Nelson @discussions.microsoft.com> wrote in message
news:4672C687-1834-41D7-9ECC-C528E05DAB0E (AT) microsoft (DOT) com...
I have been setup a Win2k3 Server and MSDE 2000 SP3, both of them can
startup
success. But I can not connect MSDE with other computer, the error
message
is connect fail ....something like that. I can connect MSDE in the Win2k3
Server when I type localhost to connect it. I can not connect it when i
type
//server_name. I have been disable the firewall and network security in
Win2k3.
Thank you very much
Nelson




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.