Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006

    Unanswered: The account is disabled. (MSSQL, Error: 18470)

    Hi, need help

    Yesterday Installed MSSQL Server 2005 Developer Edition
    on Windows XP SP2
    IIS 5.1
    Windows Authentication
    login/psw the same as login to Windows

    Everything was ok, can log to server and play with Database Engine

    But today can't login.

    ================================================== =====

    TITLE: Connect to Server
    Cannot connect to MyPCName.
    Login failed for user 'MyPCName\MyLogin'. Reason: The account is disabled. (MS Server, Error: 18470)

    Server Name: MyPCName
    Error Number: 18470
    Severity: 14
    State: 1
    Line Number: 65536

    Program Location:

    at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK)
    at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
    at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo ci, IServerType server)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()
    ================================================== ====

    Is it possible to enable this account again?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    It could be that the login was created to change passwords at their next login or some such. Check in the user's properties to see if the account has been locked out.

  3. #3
    Join Date
    Jan 2006
    It could be that the login was created to change passwords at their next login or some such. Check in the user's properties to see if the account has been locked out.

    MCrowley, thank you for your replay.
    Checked, the account has not locked ourt, was created with password never expired, type computer administrator.
    Restarted my PC several times using this account - everything is ok.

    Can connect to Analysis Services, another services with this account, but can not connect to server ( Database Engine ), mining not able to acces to my database.

    What can be done not reinstalling MSSQL?

  4. #4
    Join Date
    Jan 2006


    To rebuild system databases for a default instance of SQL Server 2005 from the command prompt

    Insert the SQL Server 2005 installation media into the disk drive.

    Use the following syntax:

    start/wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>


    Now can log to Server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts