MSDE 2000 on Windows 2003

Question

Post reply

MSDE 2000 on Windows 2003

yihua833

SSC Enthusiast

Points: 140
More actions
July 14, 2003 at 5:31 pm

#64836

i have a MSDE 2000 installed on the Windows 2003.
i use Enterpise Manager connect to it.
only name pipe(Local server) can find the server.
but i need to use TCP/IP register the server.
it give me an error "sql server does not exist or access denied. connectionopen(connect())"
please help!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Try to use server network library (svrnetcn.exe) to enable TCP/IP protocol.

yihua833 SSC Enthusiast Points: 140 More actions · Answer 2

thanks allen.

i checked the server network utility. the tcp/ip already enabled.

i think might need to setup security on windows 2003 server.? i dont' know how...

bcoz i tried to install msde2000 on windows 2000 server. everything is working proper.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

There is a known issue with Wndows 2003 and SQL Server 2000 engines. You need to apply SP3 if you haven't already.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;329329

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

mdreyer Grasshopper Points: 21 More actions · Answer 4

I am having the same issue. I am sure it is because server 2003 is so locked down. Problem is I don't know what to open up. I have installed msde2ksp3

Michael Dreyer