I tried to create connection to remote sql server through Enterprise Manager. I have Microsoft SQL Server 2000. I configure sql Connection Alias in Client Network Utility. Then I go to Enterprise Manager and add New SQL Server Registration under SQL Server Group. I follow the wizard until complete then I got error message something like registration not success. logon for user natasha failed. For sure it's not firewall problem because I can use remote desktop to go to that server.
Thanks in advance
asked May 04 '12 at 04:41 PM in Default
Can you ping the server and the port from the machine you're trying to connect to? If you can't do both, that's the beginning of the issue.
answered May 04 '12 at 05:14 PM
Grant Fritchey ♦♦