Home Forums SQL Server 2008 SQL Server 2008 Administration Login failed for WINDOWS Administrator login. (Microsoft SQL Server, Error: 18456) RE: Login failed for WINDOWS Administrator login. (Microsoft SQL Server, Error: 18456)
VastSQL
SSC-Dedicated
Points: 36067
More actions
August 31, 2010 at 1:48 am
#1214076
Connect to sql server in single user mode..
net start mssqlserver /c /m /t3604
sqlcmd -E
create a new sql login and give SA right
Hope this might help