x

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
more ▼

asked May 04 '12 at 04:41 PM in Default

knowledge_base gravatar image

knowledge_base
0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered May 04 '12 at 05:14 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
90.7k 19 21 74

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 srvabc\dbxyz. 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 ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x472

asked: May 04 '12 at 04:41 PM

Seen: 831 times

Last Updated: May 05 '12 at 06:20 PM