Saturday, February 25, 2012

registering MSDE 2000 FROM SQL 2000

Hi There,

I have install msde in one computer and try to register from my sql server, the following error message is coming.

A connection could not be established to Cal-itimilsina (computer in which MSDE IS INSTALLED)

RESON: SQL SERVER DOES NOT EXIST OR ACCESS DENIED

CONNECTIONOPEN(CONNECT())

====

BUT THE MSDE IS RUNNING IN THE CLIENT MACHINE. Could any one please help me

Thanks.

Indra.Check this (http://www.microsoft.com/sql/msde/productinfo/features.asp) site, but in short, - Named Pipes is not supported on MSDE. You need to create an alias on your server for MSDE instance using TCP/IP protocol, and specify the alias during server registration in EM. You can also use the IP address for registration.|||Thanks, i will have a check now.|||Hi,

I setup alias with TCP/IP and try to connect with alias name as well with tcp/ip, but same error message is comming. by the way what cold be my instance, i just install msde with setup.exe from command prompt.

thanks for help|||Type "OSQL -L" in command window.|||Originally posted by rdjabarov
Type "OSQL -L" in command window.

it display the name of the sql server available inthe network.

No comments:

Post a Comment