I am trying to register my local Sql2000 server. I can connect to all remote servers with no issues, however, when I attempt to use my own server instance I get a "Sql server does not exist or access is denied.ConnectionOpen(connect))"
It then tells me to check my properties by this is not possible to edit either.
I attempt access with both my NT login and sa account to no avail.
All info would be appreciated.
What operating system are you using ? Well anyway, I have seen this problem before. Normally, you use your machine name and that is it. If this is what you are doing, then try the following for a machine name of test:
I am using NT4 Server with all service packs for sql...
I have tried registering all sorts of test servers and accessing through isqlw but no joy.
I just reinstalled and that is it resolved now anyways...
Love to find out what the hell it was though..all connection access and rights/named pipes etc were fine..
Any road thanks for all the advice guys, hope I can be of some assistance to you in future..