Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reg: Windows Authentication Expand / Collapse
Author
Message
Posted Sunday, September 30, 2012 2:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 4:17 AM
Points: 61, Visits: 380
Hi

In My Laptop i am using sqlserver 2008.i forget my 'sa' password. I tried windows authentication.But I am facing following Error.


Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft sqlserver,Error : 18452 )


Please give me a solution .
Post #1366240
Posted Sunday, September 30, 2012 3:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 2:17 PM
Points: 291, Visits: 201
If you are logged in with administrator privilege on the laptop then restart the SQL server service with the -m switch and then log in using windows authentication.
Post #1366244
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse