Re: Login Failed

From: Noor (noor_at_ngsol.com)
Date: 06/03/04

  • Next message: John Bell: "Re: SQL Error: Text file size of zero" 
    Date: Thu, 3 Jun 2004 10:21:59 +0500

    Thanks Hari, here is the result after using sqlserver.exe -c

    D:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -c

    2004-06-03 10:19:21.03 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:21.35 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:21.68 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:22.00 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:22.31 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:22.62 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:22.93 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:23.25 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:23.56 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:23.87 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    2004-06-03 10:19:24.18 server initerrlog: Could not open error log file
    'D:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system
    error =32(The process cannot access the file because it is being used by
    another process.).

    Any idea what I have to next ?

    Thanks
    Noor

    "Hari" <hari_prasad_k@hotmail.com> wrote in message
    news:%23dwn8gKSEHA.2372@TK2MSFTNGP12.phx.gbl...
    > Hi ,
    >
    > Try starting SQL Server from command prompt.
    >
    > sqlservr.exe -c
    >
    > here it gives you the detail of the cause for failure.
    >
    > Note:
    >
    > If you reconstruct the PDC server , on recreating the user all the SID to
    > the user will change, in this case you may need
    > to revoke and provide access for the users using Trusted connection (OS
    > Users) in sql server.
    >
    > Thanks
    > Hari
    > MCDBA
    >
    > "Noor" <noor@ngsol.com> wrote in message
    > news:uqDjSsJSEHA.3420@TK2MSFTNGP11.phx.gbl...
    > > Thanks for your reply but I wanna reply your questions. like you asked
    > >
    > > Are you using domain OS user as the service startup account for MSSQL
    > Server
    > > service.
    > > No... MsSqlServer and SqlServer Agent service use LocalSystem account.
    > >
    > > 1. Did you recreated the same Domain user in PDC
    > > YES.. Same domain
    > >
    > > 2. By any change did you change the domain name. If yes then you have to
    > > redefine service startup account , recreate OS users to access SQL
    > Server.
    > > Nothing changes but we resinstall the whole system so recreated all the
    > > users.
    > >
    > > One more error while restarting the sql server service.
    > >
    > > Could not start the SQLSERVERAGENT service on Local Computer.
    > > The service did not return an error. This could be an internal Windows
    > > error or an internal service error.
    > > If the problem persists, contact your system administrator.
    > >
    > > Waiting for your reply
    > >
    > > Noor
    > >
    > >
    > > "Hari" <hari_prasad_k@hotmail.com> wrote in message
    > > news:uWQHgEJSEHA.3444@TK2MSFTNGP12.phx.gbl...
    > > > Hi,
    > > >
    > > > Are you using domain OS user as the service startup account for MSSQL
    > > Server
    > > > service.
    > > >
    > > > Then did you consider those:-
    > > >
    > > > 1. Did you recreated the same Domain user in PDC
    > > > 2. By any change did you change the domain name. If yes then you have
    to
    > > > redefine service startup account ,
    > > > recreate OS users to access SQL Server.
    > > >
    > > > Thanks
    > > > Hari
    > > > MCDBA
    > > >
    > > > "Noor" <noor@ngsol.com> wrote in message
    > > > news:#1aHrrHSEHA.380@tk2msftngp13.phx.gbl...
    > > > > Yesterday my sql server was running properly but after reinstalling
    > > > primary
    > > > > domain controller I failed to login like when I login through
    windows
    > > > > authentication so it gave an error that login failed and if I log
    > > through
    > > > sa
    > > > > password then it gave login failed for default database.
    > > > >
    > > > > Can any body give me some idea what I have to do ?
    > > > >
    > > > > Thanks
    > > > > Noor
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

  • Next message: John Bell: "Re: SQL Error: Text file size of zero"

    Relevant Pages

    • Re: SQL I/O Errors
      ... Thanks ever so much for this, it was in fact the fibre cable between the SQL ... We have a major problem with our Test SQL Server, ... SQL Data resides on the E Drive which is SAN Fibre attached, ... At first we thought it was an Operating System fault and completely ...
      (microsoft.public.sqlserver.server)
    • Re: SSAS 2005 - 3GB memory limit still there?
      ... correction #2 when you say '64bit machine' you have to be more concise, ... I'm now looking at the option of upgrading the operating system to ... For this to happen do i also need the 64bit versions of SQL Server 2005 ...
      (microsoft.public.sqlserver.olap)
    • Re: Windows 2003 cluster trust issue during install?
      ... I followed the instructions to remove a node from an SQL install (which can ... How can I remove NODE1 from the SQL install if the system will ... Operating System Service Pack Level Requirement. ...
      (microsoft.public.sqlserver.clustering)
    • Re: SQL 2k on Window 2008
      ... and then upgrade the operating system to 2008 and see if SQL ... Server still functions as expected... ... if you are upgrading the operating system where SQL Server ...
      (microsoft.public.sqlserver.setup)
    • Re: Windows 2003 cluster trust issue during install?
      ... I followed the instructions to remove a node from an SQL install (which can ... How can I remove NODE1 from the SQL install if the system will ... Operating System Service Pack Level Requirement. ...
      (microsoft.public.sqlserver.clustering)
    Loading