Problem Adding A New Server

Hi all,

I have a database hosted by a webspace provider, I've got the IP address, login name and password, however when I try to do the New SQL Server Registration, it keeps coming up with the error "Remote Server doesn't exist or access denied", I can be sure the remote server is up and running and that I have access to it.

Any ideas? I've been struggling for nearly a week

This is how I do it:

1. Open the Client Network Utility.

2. Select the Alias tab.

3. Click on the Add? button.

4. Ensure that the TCP/IP option is selected in the Network libraries

5. In the Server alias field enter the fully qualified domain name, or the IP address, of the SQL Server to which you are connecting.

The Connection parameters are filled in automatically.

6. Click on the OK button to save the settings and exit the Client Network Utility.

7. Open the Microsoft SQL Server Enterprise Manager.

8. In the Tree view on the left-hand side of the application window, expand the Microsoft SQL Server node.

9. Right click on the SQL Server Group entry, and select New SQL Server Registration from the menu that appears.

10. Click on the Next button to display the Register SQL Server Wizard

11. Select the alias that you have just created, and click on the Add button, followed by Next.

12. Select Use SQL Server Authentication

13. Click on the Next button.

14. Enter your SQL Server username and password, and click Next twice, followed by Finish.


Cheers! Thx a lot!!!!

annie x