adding new sql server registration - login fail

Hi,

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

knowledge_base
0 ● 1 ● 1

(comments are locked)

1 answer:

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 ♦♦
62.2k ● 12 ● 20 ● 66

I can access the server by using remote desktop (in remote desktop, I input ip and port). Is't that same thing with ping.

May 04 '12 at 05:29 PM knowledge_base

The port for remote desktop is different than the port for SQL Server. Make sure you're testing the right port. If that port isn't accessible, then you'll need to poke a hole in the firewall to let that communication through.

May 04 '12 at 06:11 PM Grant Fritchey ♦♦

Hi,

I think the problem is in configuration. My co-worker can access the same sql database thru sql Management Studio. She has SQL server 2008. I have 2000. I don't have management studio and I don't want to un-install/re-install. I have close to 0 knowledge in sql server so I must have missed something. My co-worker doesn't know much too. This's the first time we tried to go in sql server.

May 04 '12 at 08:15 PM knowledge_base

I saw in the post that someone has the same problem and the problem got resolve by going to security tab in property and then chose the authentication mode that allows both Windows and SQL Server authentication. I want to tried that but I cannot get to the property. When I right click on my sql server then select property, I got error msg as below.

A connection counld not be estrablished to srvabcdbxyz. Reason: Logon failed for user 'myusrid'

May 04 '12 at 09:05 PM knowledge_base

If you're trying to connect to a 2008 or 2008R2 server, you may need to have that level of management studio.

That last error makes it sound like your login doesn't have correct permissions or isn't actually registered on the server.

May 05 '12 at 11:09 AM Grant Fritchey ♦♦

show 2 more replies

(comments are locked)