Showing posts with label occours. Show all posts
Showing posts with label occours. Show all posts

Tuesday, March 20, 2012

problem on login: user is inactive

hi,

i've just restored my db and when i try to login with a user (even if
the user is "sa"), an error occours.

The error is "User sa is currently inactive"

How can i solve this problem?

Thanks,
MassimozuEgg (zuegg@.hotmail.it) writes:

Quote:

Originally Posted by

i've just restored my db and when i try to login with a user (even if
the user is "sa"), an error occours.
>
The error is "User sa is currently inactive"
>
How can i solve this problem?


I can't find any such message in sysmessages. Which version of SQL Server
do you use? Exactly how do you try to connect? Through Query Analyzer
or Enterprise Manager? Through an application?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx