Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-11 : 18:24:12
|
Ray writes "Lost sa password is there any way of recreating sa user account or granting sa privileges to another userid that can access SQL. One of our SQL servers crashed and after it came up we cannot login in to it. The MSDB & Master DB are suspect. Cannot run DBCC because I do not have admin privileges.. Any help is appreciated
Ray.
feurtador@dnb.com
OS NT4.0 SP6A
SQL 6.5 SP2
ERRORLOG
2001/04/09 10:49:29.42 kernel Microsoft SQL Server 6.50 - 6.50.416 (Intel X86)
Jan 23 1999 14:10:24
Copyright (c) 1988-1997 Microsoft Corporation
2001/04/09 10:49:29.48 kernel Copyright (C) 1988-1994 Microsoft Corporation.
2001/04/09 10:49:29.49 kernel All rights reserved.
2001/04/09 10:49:29.49 kernel Logging SQL Server messages in file 'C:\MSSQL\LOG\ERRORLOG'
2001/04/09 10:49:29.53 kernel initconfig: number of user connections limited to 400
2001/04/09 10:49:29.54 kernel SQL Server is starting at priority class 'normal' with dataserver semaphore = 1 (1 CPU detected, SMPStat=1).
2001/04/09 10:49:29.58 server LogLRU buffers: 0
2001/04/09 10:49:29.73 kernel Attempting to initialize Distributed Transaction Coordinator
2001/04/09 10:49:29.82 server RegOpenKeyEx of "SOFTWARE\Microsoft\MSSQLServer\" failed: Result Code = 0x00000005
2001/04/09 10:49:29.85 kernel initializing virtual device 0, C:\MSSQL\DATA\MASTER.DAT
2001/04/09 10:49:29.86 kernel Opening Master Database ...
2001/04/09 10:49:30.01 spid1 Loading SQL Server's default sort order and character set
2001/04/09 10:49:30.08 spid1 Recovering Database 'master'
2001/04/09 10:49:30.09 spid1 Recovery dbid 1 ckpt (13323,12) oldest tran=(13323,11)
2001/04/09 10:49:30.16 spid1 1 transactions rolled forward
2001/04/09 10:49:30.24 spid1 Activating disk 'DunsVoiceData1'
2001/04/09 10:49:30.27 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device C:\MSSQL\DATA\DunsVoiceData1.DAT
2001/04/09 10:49:30.27 kernel udactivate (primary): failed to open device C:\MSSQL\DATA\DunsVoiceData1.DAT for vdn 9
2001/04/09 10:49:30.27 spid1 Activating disk 'DunsVoiceLog1'
2001/04/09 10:49:30.27 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device C:\MSSQL\DATA\DunsVoiceLog1.DAT
2001/04/09 10:49:30.27 kernel udactivate (primary): failed to open device C:\MSSQL\DATA\DunsVoiceLog1.DAT for vdn 10
2001/04/09 10:49:30.27 spid1 Activating disk 'gldirdata1'
2001/04/09 10:49:30.27 kernel initializing virtual device 8, C:\MSSQL\DATA\gldirdata1.DAT
2001/04/09 10:49:30.27 spid1 Activating disk 'gldirlog1'
2001/04/09 10:49:30.28 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device C:\MSSQL\DATA\gldirlog1.DAT
2001/04/09 10:49:30.28 kernel udactivate (primary): failed to open device C:\MSSQL\DATA\gldirlog1.DAT for vdn 7
2001/04/09 10:49:30.28 spid1 Activating disk 'MSDBData'
2001/04/09 10:49:30.28 kernel initializing virtual device 127, C:\MSSQL\DATA\MSDB.DAT
2001/04/09 10:49:30.28 spid1 Activating disk 'MSDBLog'
2001/04/09 10:49:30.28 kernel initializing virtual device 126, C:\MSSQL\DATA\MSDBLOG.DAT
2001/04/09 10:49:30.28 spid1 Activating disk 'salesmktdata1'
2001/04/09 10:49:30.28 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device C:\MSSQL\DATA\salesmktdata1.DAT
2001/04/09 10:49:30.28 kernel udactivate (primary): failed to open device C:\MSSQL\DATA\salesmktdata1.DAT for vdn 11
2001/04/09 10:49:30.28 spid1 Activating disk 'salesmktlog1'
2001/04/09 10:49:30.28 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical devi |
|
|
|
|
|
Lost SQL 6.5 sa password