ProdigyOne2k
asked on
SQL Server 2008 R2 Login Issue
Our server crashed yesterday and I had to take the .mdf file and put it on another server.
Now when I login I get the following error:
Server Name: 192.168.1.155
Error Number: 18456
Severity: 14
State: 1
Is there something I need to reset to be able to login to the database again?
Now when I login I get the following error:
Server Name: 192.168.1.155
Error Number: 18456
Severity: 14
State: 1
Is there something I need to reset to be able to login to the database again?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
your missing the log file
if you don't have the ldf you need to do some stuff.
http://stackoverflow.com/questions/773059/how-to-recover-database-from-mdf-in-sql-server-2005
http://stackoverflow.com/questions/773059/how-to-recover-database-from-mdf-in-sql-server-2005
ASKER
Looked at my logs...it indicated I was not in "mixed authentication mode" - I WAS...but I had not restarted the server. I right clicked and restarted the server...problem solved
Thanks!
Thanks!