Hi All,

         I have installed Sql Server 2000 at two machines containing, Microsoft XP Professional. I will call both machines X and Y for reference.

Now when i want to make registration at Machine X for Sql server installed at machine Y. whenever i do this it gives me error that "Msg 17 Level 6 Server Does Not exists or Access Denied".

I tried again and again but all in vain... interesting factor is that when i make this registration at Machine Y for Sql Server installed at Machine X.... it was successful...

Any help will be highly appreciated..

__________________
Tiyyob

Are you using intergrated security (trust) or SQL security?

It seems that machine Y does not accept the user credentials you supply from machine X.

1. If using SQL security, make sure username and password is correct
2. It using trust, add the user for Machine X to Machine Y in appropriate group.

Since it is Windows XP, do you have service pack 2 with Firewall security turned on on machine Y? This might also cause a problem...

When you install sql server set them both up with domain security and sql security. Insure you can ping the other server and your port (normally 1433) is open between them. Also insure you using the exact same version of mdac on both computers.

Just my two cents.