Posted by Erland Sommarskog on 08/28/06 21:57

zuEgg (zuegg@hotmail.it) writes:
> 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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: grant access to extended properties
• Prev in forum: Re: delete sql server registration in tsql
• Thread view: Re: problem on login: user is inactive

[Reply to this message]