Sunday, March 11, 2012

Cannot login using 'sa' user name and password

Used configuration and enabled IP and is fiexed. Thanks.
--
Mike
"Mike9900" wrote:

> Hello,
> When I try to connect it give the following message I copied from the log:
> Source Logon
> Message
> Login failed for user 'sa'. The user is not associated with a trusted SQL
> Server connection. [CLIENT: <local machine>]
>
> I am using Win 2003 Ent. and is domain controller. I use administrator
> login in win 2003. I recently installed a new win2003, but I had Win2003
> before and was fine.
> In SQL Server, it is a mixed mode and everything seems to be fine.
> What could be the other problems?
> Thanks
> --
> MikeHello,
When I try to connect it give the following message I copied from the log:
Source Logon
Message
Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection. [CLIENT: <local machine>]
I am using Win 2003 Ent. and is domain controller. I use administrator
login in win 2003. I recently installed a new win2003, but I had Win2003
before and was fine.
In SQL Server, it is a mixed mode and everything seems to be fine.
What could be the other problems?
Thanks
Mike|||Used configuration and enabled IP and is fiexed. Thanks.
--
Mike
"Mike9900" wrote:

> Hello,
> When I try to connect it give the following message I copied from the log:
> Source Logon
> Message
> Login failed for user 'sa'. The user is not associated with a trusted SQL
> Server connection. [CLIENT: <local machine>]
>
> I am using Win 2003 Ent. and is domain controller. I use administrator
> login in win 2003. I recently installed a new win2003, but I had Win2003
> before and was fine.
> In SQL Server, it is a mixed mode and everything seems to be fine.
> What could be the other problems?
> Thanks
> --
> Mike

No comments:

Post a Comment