February 14, 2006 at 8:36 am
When I log into sql 2005 using the "sa" account I get this error message
>>
Cannot connect to myPC\sql2005
Additional informaiton: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]
>>>>
Any idea what's wrong?
TIA,
Bill
February 14, 2006 at 8:55 am
Default installation is windows only authentication *thank Bill*
February 14, 2006 at 4:10 pm
>> Default installation is windows only authentication
I tried to change it to suuport both Windows and Sql. I found that I could have one or the other, per sever, but not both. Can this be true?
TIA,
Bill
February 15, 2006 at 2:42 am
Hi Bill!
Not sure how you've tried to change the authentication mode, but if you go to Management Studio and right click over a server there should be two options on the Security window - one for Windows Authentication and one for SQL Server and Windows Authentication.
Cath
February 15, 2006 at 4:58 am
You really don't want to enable SQL authentication anyway or use the sa account - grant a windows group access and add your windows account to it.
February 15, 2006 at 9:25 am
>> You really don't want to enable SQL authentication anyway or
Correct, but on some of our sql 2000 servers we have users accessing the same database via Sql authenticaiton and other by Windows authentication. I'm saying that, from what I see in sql 2005, it's either one way or the other. We can not have both types of authentication active in the same database at the same time. Is this correct?
February 15, 2006 at 9:49 am
Sure you can. The authentication type is set on the server level, not on the database level. It could be Windows Only or Mixed (both Windows and SQL Server)
Regards,Yelena Varsha
February 15, 2006 at 11:58 am
February 16, 2006 at 5:28 am
To clarify:
Windows authentication is ALWAYS enabled.
The authentcation mode options are whether you allow SQL authentication or not.
February 16, 2006 at 5:44 am
Joseph's point is correct.
I just tested on my server.before i had security set to both, and then I set it to windows authentication only and had to restart it.when i tried to logon as as 'sa' i got your error.
so you might want to change the security to sql and windows authentication
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply