Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection Issues - Again!
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01501104
Message ID:
01501124
Views:
39
>>>I have SQL 2005 running on Win 2003 Server box. I have a Win 7 Pro box that can connect to the server just fine. My laptop running XP Pro also connects fine. I just bought another PC running Win 7 Home Premium. I put SSMS on it and when I try to connect to the server I get:
>>>
>>>
>>>Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
>>>
>>>
>>>One thing to note: I have only been able to connect to SQL from my older PC and my laptop via the IP address. There's an issue with my domain controller on the server. I'm working on it, but like I said, I have been able to connect to SQL via IP.
>>
>>Have you tried connecting using sa as a user and sa password?
>
>Yes. I have an sa account. Took off the password. Same error

You misunderstood me.

Can you pick up the server name from the drop down box for the servers? If yes, you should be able to connect using sa in the user name and the password you have for sa in the password.

One extra idea I just thought of. Is it possible you installed SSMS for SQL Server 2005 64 bit (if there is 64 bit for SQL Server 2005) and you have it in 32 bit?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform