• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

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?
0
ProdigyOne2k
Asked:
ProdigyOne2k
  • 2
1 Solution
 
strickddCommented:
You'll have to look at the server logs and determine the actual error state to decode what it means: http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
0
 
coolfigerCommented:
your missing the log file
0
 
coolfigerCommented:
0
 
ProdigyOne2kAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now