[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1898
  • Last Modified:

How do I reconnect to my SQL Server?

Hi Guys!

Connecting to the remote machine via the Terminal Services client, I ran this batch script on my SQL Server:
      
      %windir%\System32\net.exe stop "SQLServerAgent"
      %windir%\System32\net.exe stop "MSSQLServer"
      %windir%\System32\net.exe start "MSSQLServer"
      %windir%\System32\net.exe start "SQLServerAgent"
      pause
      
Now when I bring up a local web page (that connects to my SQL Server via ODBC) from my local browser, I get this error:
      
      java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
      at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:677)
      at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:123)
      at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:138)
      at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:125)
      at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:120)
      at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75)
      at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
      ...
      
And now when I try to connect to my SQL Server using my local copy of Enterprise Manager, I get this error:
      
      A connection could not be established to MY_SQL_SERVER.
      
      Reason: SQL Server does not exist or access denied.
      ConnectOpen (Connect())..
      
I have no problem connecting to the remote machine via Terminal Services and running its copy of Enterprise Manager and connecting from there. I have no problem running a web page located on another server (that connects to my SQL Server via ODBC) from my local browser.

Unblocking Server Message Block Protocol (UDP) and exiting and shutting down my personal firewall has no effect. I can even see that MSTSC.EXE has been allowed to connect to my SQL Server via outbound TCP on remote port 3389 and that JAVAW.EXE have been allowed to connect to my SQL Server via outbound TCP on the MS SQL Server remote port.

I have done this before and there is a quick fix, but I can't remember what it is. I assumed it was just starting up the Distributed Transaction Coordinator (MSDTC) Service on the remote machine via the Terminal Services client, but that has no effect either. All three services in the MS SQL Server Manager are running as shown in the icon in the system tray on the remote machine as seen through the Terminal Services client.

How do I reconnect to my SQL Server?

Thanx

Dave
0
dbabbitt
Asked:
dbabbitt
  • 5
  • 5
1 Solution
 
Kevin3NFCommented:
Is the SQL Server listening on TCP?  Check the current SQL error log for a line similar to:

Listening on TCP, shared memory, named pipes...

Look also for a different line telling you what IP address and port combination
0
 
dbabbittAuthor Commented:
How do I check the current SQL error log?
0
 
Kevin3NFCommented:
Look in the LOG directory for a file called ERRORLOG (no extension)

Mine is in:
C:\Program Files\Microsoft SQL Server\MSSQL\LOG

Looking for lines like:

2005-04-27 09:08:16.03 server    SQL server listening on xxx.xx.x.xxx: 1433.
2005-04-27 09:08:16.03 server    SQL server listening on 127.0.0.1: 1433.

and

2005-04-27 09:08:16.15 server    SQL server listening on TCP, Shared Memory, Named Pipes.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
dbabbittAuthor Commented:
There is nothing in F:\MSSQL7\LOG\ERRORLOG on the remote machine except backing up entries; i.e., no "listening" entries.
0
 
Kevin3NFCommented:
really?  that sort of thing has been in every SQL log I have ever seen.  It should be in there among the earliest timestamps.  Look at the older logs as well.  What is the very first chronological entry or series of entries?

What version of SQL Server and O/S?
0
 
dbabbittAuthor Commented:
2005-04-26 11:00:38.07 kernel   Microsoft SQL Server  7.00 - 7.00.842 (Intel X86)
      Mar  2 2000 06:49:37
      Copyright (c) 1988-1998 Microsoft Corporation
      Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

2005-04-26 11:00:38.07 kernel   Copyright (C) 1988-1997 Microsoft Corporation.
2005-04-26 11:00:38.07 kernel   All rights reserved.
2005-04-26 11:00:38.07 kernel   Logging SQL Server messages in file 'F:\MSSQL7\log\ERRORLOG'.
2005-04-26 11:00:38.09 kernel   initconfig: Number of user connections limited to 32767.
2005-04-26 11:00:38.09 kernel   SQL Server is starting at priority class 'high'(2 CPUs detected).
2005-04-26 11:00:38.12 kernel   User Mode Scheduler configured for thread processing
2005-04-26 11:00:40.31 server   Directory Size: 64943
2005-04-26 11:00:40.32 spid1    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2005-04-26 11:00:40.32 kernel   Attempting to initialize Distributed Transaction Coordinator.
2005-04-26 11:00:43.50 spid1    Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2005-04-26 11:00:43.51 spid1    Starting up database 'master'.
2005-04-26 11:00:43.51 spid1    Opening file F:\MSSQL7\data\master.mdf.
2005-04-26 11:00:43.51 spid1    Opening file F:\MSSQL7\data\mastlog.ldf.
2005-04-26 11:00:43.56 spid1    Loading SQL Server's  Unicode collation.
2005-04-26 11:00:43.56 spid1    Loading SQL Server's  non-Unicode sort order and character set.
2005-04-26 11:00:43.64 spid1    15 transactions rolled forward in database 'master' (1).
2005-04-26 11:00:43.64 spid1    0 transactions rolled back in database 'master' (1).
2005-04-26 11:00:43.73 spid1    Starting up database 'model'.
2005-04-26 11:00:43.73 spid1    Opening file F:\MSSQL7\DATA\model.mdf.
2005-04-26 11:00:43.75 spid1    Opening file F:\MSSQL7\DATA\modellog.ldf.
2005-04-26 11:00:43.86 spid1    Clearing tempdb database.
2005-04-26 11:00:43.87 spid1    Creating file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-26 11:00:43.98 spid1    Closing file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-26 11:00:44.01 spid1    Creating file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-26 11:00:44.07 spid1    Closing file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-26 11:00:44.14 spid1    Opening file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-26 11:00:44.14 spid1    Opening file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-26 11:00:44.42 spid1    Closing file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-26 11:00:44.45 spid1    Closing file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-26 11:00:44.46 spid1    Starting up database 'tempdb'.
2005-04-26 11:00:44.46 spid1    Opening file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-26 11:00:44.48 spid1    Opening file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-26 11:00:44.64 spid1    Server name is 'SQL21'.
2005-04-26 11:00:44.64 kernel   Using 'SQLEVN70.DLL' version '7.00.842'.
2005-04-26 11:00:44.64 kernel   Using 'OPENDS60.DLL' version '7.00.00.0839'.
2005-04-26 11:00:44.64 ods      Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\\.\pipe\sql\query'.
2005-04-26 11:00:44.64 ods      Using 'SSMSSO70.DLL' version '7.0.694' to listen on '1433'.
2005-04-26 11:00:44.64 ods      Error: 17833, Severity: 18, State: 1
2005-04-26 11:00:44.64 ods      ListenOn connection '1433' is already in use..
2005-04-26 11:00:44.65 ods      Using 'SSMSRP70.DLL' version '7.0.839' to listen on 'SQL21'.
2005-04-26 11:00:44.67 spid6    Starting up database 'msdb'.
2005-04-26 11:00:44.67 spid6    Opening file F:\MSSQL7\DATA\msdbdata.mdf.
2005-04-26 11:00:44.67 spid7    Starting up database 'pubs'.
2005-04-26 11:00:44.67 spid7    Opening file F:\MSSQL7\DATA\pubs.mdf.
2005-04-26 11:00:44.67 spid9    Starting up database 'hhss'.
2005-04-26 11:00:44.67 spid9    Opening file F:\MSSQL7\data\hhss.mdf.
2005-04-26 11:00:44.67 spid8    Starting up database 'Northwind'.
2005-04-26 11:00:44.67 spid8    Opening file F:\MSSQL7\DATA\northwnd.mdf.
2005-04-26 11:00:44.67 spid10   Starting up database 'trial'.
2005-04-26 11:00:44.67 spid10   Opening file F:\MSSQL7\DATA\trial.mdf.
2005-04-26 11:00:44.67 spid12   Starting up database 'SafetyManager'.
2005-04-26 11:00:44.67 spid12   Opening file F:\MSSQL7\DATA\SafetyManager.mdf.
2005-04-26 11:00:44.67 spid11   Starting up database 'Quali_Assur'.
2005-04-26 11:00:44.67 spid11   Opening file F:\MSSQL7\data\Quali_Assur_Data.MDF.
2005-04-26 11:00:44.67 spid13   Starting up database 'IR'.
2005-04-26 11:00:44.68 spid13   Opening file F:\MSSQL7\DATA\IR.mdf.
2005-04-26 11:00:44.73 spid7    Opening file F:\MSSQL7\DATA\pubs_log.ldf.
2005-04-26 11:00:44.76 spid10   Opening file F:\MSSQL7\DATA\trial.ldf.
2005-04-26 11:00:44.76 spid9    Opening file F:\MSSQL7\data\HHSS_Log.LDF.
2005-04-26 11:00:44.76 spid8    Opening file F:\MSSQL7\DATA\northwnd.ldf.
2005-04-26 11:00:44.76 spid6    Opening file F:\MSSQL7\DATA\msdblog.ldf.
2005-04-26 11:00:44.78 spid13   Opening file F:\MSSQL7\DATA\IR.ldf.
2005-04-26 11:00:44.78 spid12   Opening file F:\MSSQL7\DATA\SafetyManager.ldf.
2005-04-26 11:00:44.78 spid11   Opening file F:\MSSQL7\data\Quali_Assur_Log.LDF.
2005-04-26 11:00:45.17 spid7    Starting up database 'PayrollARC'.
2005-04-26 11:00:45.17 spid7    Opening file F:\MSSQL7\DATA\PayrollARC.mdf.
2005-04-26 11:00:45.26 spid8    Starting up database 'LumigentDemoDB'.
2005-04-26 11:00:45.26 spid8    Opening file F:\MSSQL7\Data\LumigentDemoDB_Data.MDF.
2005-04-26 11:00:45.28 spid7    Opening file F:\MSSQL7\DATA\PayrollARC.ldf.
2005-04-26 11:00:45.34 spid8    Opening file F:\MSSQL7\Data\LumigentDemoDB_Log.LDF.
2005-04-26 11:00:45.40 spid10   Starting up database 'RentACoder'.
2005-04-26 11:00:45.40 spid10   Opening file F:\MSSQL7\DATA\RentACoder.mdf.
2005-04-26 11:00:45.46 spid10   Opening file F:\MSSQL7\DATA\RentACoder.ldf.
2005-04-26 11:00:45.46 spid12   Starting up database 'Cold_Fusion_Client_Variables'.
2005-04-26 11:00:45.46 spid12   Opening file F:\MSSQL7\DATA\Cold_Fusion_Client_Variables.mdf.
2005-04-26 11:00:45.62 spid12   Opening file F:\MSSQL7\DATA\Cold_Fusion_Client_Variables.ldf.
2005-04-26 11:00:45.62 spid11   Starting up database 'Traffic_Analysis'.
2005-04-26 11:00:45.62 spid11   Opening file F:\MSSQL7\DATA\Traffic_Analysis.mdf.
2005-04-26 11:00:45.67 spid13   Starting up database 'Marketing'.
2005-04-26 11:00:45.67 spid13   Opening file F:\MSSQL7\data\Marketing_Data.MDF.
2005-04-26 11:00:45.68 spid11   Opening file F:\MSSQL7\DATA\Traffic_Analysis.ldf.
2005-04-26 11:00:45.75 spid13   Opening file F:\MSSQL7\data\Marketing_Log.LDF.
2005-04-26 11:00:45.81 spid7    Starting up database 'Intuit_Payroll_Services'.
2005-04-26 11:00:45.81 spid7    Opening file F:\MSSQL7\data\Intuit_Payroll_Services_Data.MDF.
2005-04-26 11:00:45.90 spid7    Opening file F:\MSSQL7\data\Intuit_Payroll_Services_Log.LDF.
2005-04-26 11:00:47.20 spid9    Recovery progress on database 'hhss' (7): 50 percent.
2005-04-26 11:00:47.32 spid9    2 transactions rolled forward in database 'hhss' (7).
2005-04-26 11:00:47.36 spid9    1 transactions rolled back in database 'hhss' (7).
2005-04-26 11:00:47.50 spid9    Recovery progress on database 'hhss' (7): 100 percent.
2005-04-26 11:00:47.50 spid1    Recovery complete.
2005-04-26 11:00:47.50 spid1    SQL Server's Unicode collation is:
2005-04-26 11:00:47.50 spid1            'English' (ID = 1033).
2005-04-26 11:00:47.50 spid1            comparison style = 196609.
2005-04-26 11:00:47.50 spid1    SQL Server's non-Unicode sort order is:
2005-04-26 11:00:47.50 spid1            'nocase_iso' (ID = 52).
2005-04-26 11:00:47.50 spid1    SQL Server's non-Unicode character set is:
2005-04-26 11:00:47.50 spid1            'iso_1' (ID = 1).
2005-04-26 11:00:47.54 spid1    Launched startup procedure 'sp_LumigentStart'
2005-04-26 11:00:47.59 spid7    Using 'xp_logattach.dll' version '0001.00.00' to execute extended stored procedure 'xp_logattach_StartProf'.
2005-04-26 11:00:48.11 spid7    Using 'xpsqlbot.dll' version '1998.11.13' to execute extended stored procedure 'xp_qv'.
2005-04-26 11:00:48.20 spid8    Using 'xpstar.dll' version '2000.02.08' to execute extended stored procedure 'xp_sqlagent_monitor'.
2005-04-26 12:00:03.84 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:924:1, last LSN: 7191:1388:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 12:00:05.73 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504261200.TRN'}).
2005-04-26 12:00:06.60 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:452:1, last LSN: 49:454:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504261200.TRN'}).
2005-04-26 13:00:02.76 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:1388:1, last LSN: 7191:1540:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 14:00:02.75 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:1540:1, last LSN: 7191:1671:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 14:00:06.00 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504261400.TRN'}).
2005-04-26 14:00:06.79 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:454:1, last LSN: 49:454:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504261400.TRN'}).
2005-04-26 15:00:02.79 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:1671:1, last LSN: 7191:1894:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 16:00:02.76 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:1894:1, last LSN: 7191:2266:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 16:00:05.43 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504261600.TRN'}).
2005-04-26 16:00:06.20 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:454:1, last LSN: 49:454:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504261600.TRN'}).
2005-04-26 17:00:02.76 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:2266:1, last LSN: 7191:2486:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 17:30:41.03 backup   Database incremental changes backed up with following information: Database: HHSS, creation date and time: 2004/10/15(15:48:27), pages dumped: 25852, first LSN: 7191:1408:1, last LSN: 7191:2535:1, full backup LSN: 7190:13141:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\hhss_530_PM_Diff.bak'}).
2005-04-26 17:40:01.29 backup   Database incremental changes backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), pages dumped: 172, first LSN: 49:454:1, last LSN: 49:456:1, full backup LSN: 49:450:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\Quali_Assur_530_PM_Diff'}).
2005-04-26 18:00:02.78 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:2486:1, last LSN: 7191:2589:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 18:00:06.00 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504261800.TRN'}).
2005-04-26 18:00:06.82 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:454:1, last LSN: 49:456:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504261800.TRN'}).
2005-04-26 19:00:02.78 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:2589:1, last LSN: 7191:2680:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 20:00:02.78 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:2680:1, last LSN: 7191:2811:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 20:00:05.37 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504262000.TRN'}).
2005-04-26 20:00:06.15 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:456:1, last LSN: 49:456:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504262000.TRN'}).
2005-04-26 21:00:02.79 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:2811:1, last LSN: 7191:2956:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 22:00:02.81 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:2956:1, last LSN: 7191:3090:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-26 22:00:06.01 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504262200.TRN'}).
2005-04-26 22:00:06.82 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:456:1, last LSN: 49:456:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504262200.TRN'}).
2005-04-26 22:30:41.42 backup   Database incremental changes backed up with following information: Database: HHSS, creation date and time: 2004/10/15(15:48:27), pages dumped: 28325, first LSN: 7191:1408:1, last LSN: 7191:3156:1, full backup LSN: 7190:13141:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\HHSS_1030_PM_Diff.bak'}).
2005-04-26 22:40:01.35 backup   Database incremental changes backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), pages dumped: 172, first LSN: 49:456:1, last LSN: 49:458:1, full backup LSN: 49:450:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\Quali_Assur_1030_PM_Diff.bak'}).
2005-04-26 23:00:02.82 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:3090:1, last LSN: 7191:3359:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 00:00:02.82 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:3359:1, last LSN: 7191:3612:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 00:00:05.53 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504270000.TRN'}).
2005-04-27 00:00:06.35 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:456:1, last LSN: 49:458:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504270000.TRN'}).
2005-04-27 01:00:02.81 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:3612:1, last LSN: 7191:3617:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 01:05:59.14 backup   Database backed up with following information: Database: HHSS, creation date and time: 2004/10/15(15:48:27), pages dumped: 98904, first LSN: 7191:1408:1, last LSN: 7191:3620:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\hhss_wed.bak'}).
2005-04-27 01:25:05.64 backup   Database backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), pages dumped: 131, first LSN: 49:458:1, last LSN: 49:460:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\quali_assur_wed.bak'}).
2005-04-27 02:00:04.20 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:3617:1, last LSN: 7191:3634:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 02:00:12.67 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504270200.TRN'}).
2005-04-27 02:00:13.48 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:458:1, last LSN: 49:460:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504270200.TRN'}).
2005-04-27 03:00:02.93 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:3634:1, last LSN: 7191:6103:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 04:00:02.82 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:6103:1, last LSN: 7191:6320:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 04:00:05.79 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504270400.TRN'}).
2005-04-27 04:00:06.59 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:460:1, last LSN: 49:460:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504270400.TRN'}).
2005-04-27 05:00:02.79 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:6320:1, last LSN: 7191:6320:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 05:00:03.81 kernel   The Microsoft Tape Format (MTF) soft filemark database on backup device 'E:\sql_backups\hhss_5_AM_diff.bak' cannot be read, inhibiting random access.
2005-04-27 05:10:05.92 backup   Database incremental changes backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), pages dumped: 172, first LSN: 49:460:1, last LSN: 49:462:1, full backup LSN: 49:460:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\Quali_Assur_5_AM_diff.bak'}).
2005-04-27 06:00:03.45 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:6320:1, last LSN: 7191:6333:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 06:00:05.46 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504270600.TRN'}).
2005-04-27 06:00:06.35 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:460:1, last LSN: 49:462:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504270600.TRN'}).
2005-04-27 07:00:02.81 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:6333:1, last LSN: 7191:6403:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 08:00:02.82 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:6403:1, last LSN: 7191:6655:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 08:00:05.67 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504270800.TRN'}).
2005-04-27 08:00:06.43 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:462:1, last LSN: 49:462:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504270800.TRN'}).
2005-04-27 09:00:03.01 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:6655:1, last LSN: 7191:7171:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 10:00:02.87 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:7171:1, last LSN: 7191:7904:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 10:00:05.82 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504271000.TRN'}).
2005-04-27 10:00:06.60 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:462:1, last LSN: 49:462:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504271000.TRN'}).
2005-04-27 10:30:00.28 kernel   The Microsoft Tape Format (MTF) soft filemark database on backup device 'E:\sql_backups\HHSS_1030_AM_Diff.bak' cannot be read, inhibiting random access.
2005-04-27 10:40:00.81 backup   Database incremental changes backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), pages dumped: 172, first LSN: 49:462:1, last LSN: 49:464:1, full backup LSN: 49:460:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\Quali_Assur_1030_AM_Diff.bak'}).
2005-04-27 11:00:02.82 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:7904:1, last LSN: 7191:7971:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 12:00:02.85 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:7971:1, last LSN: 7191:8058:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 12:00:05.82 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504271200.TRN'}).
2005-04-27 12:00:06.74 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:462:1, last LSN: 49:464:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504271200.TRN'}).
2005-04-27 13:00:02.84 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:8058:1, last LSN: 7191:8172:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 14:00:02.84 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:8172:1, last LSN: 7191:8258:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
2005-04-27 14:00:05.51 backup   Log backed up with following information: Database: IR, creation date and time: 2000/10/18(12:27:43), first LSN: 198:378:1, last LSN: 198:378:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\IR\IR_tlog_200504271400.TRN'}).
2005-04-27 14:00:06.53 backup   Log backed up with following information: Database: Quali_Assur, creation date and time: 2000/09/13(10:25:05), first LSN: 49:464:1, last LSN: 49:464:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\Quali_Assur\Quali_Assur_tlog_200504271400.TRN'}).
2005-04-27 15:00:02.86 backup   Log backed up with following information: Database: hhss, creation date and time: 2004/10/15(15:48:27), first LSN: 7191:8258:1, last LSN: 7191:8661:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\sql_backups\TRN\tlog.trn'}).
0
 
dbabbittAuthor Commented:
Here's SQLAGENT.OUT:
4/26/2005 11:00:45 AM - ? [129] SQLServerAgent starting under Windows NT service control
4/26/2005 11:00:45 AM - ? [393] Waiting for SQL Server to recover databases...
4/26/2005 11:00:48 AM - ? [100] Microsoft SQLServerAgent version 7.00.839 (x86 unicode retail build) : Process ID 3068
4/26/2005 11:00:48 AM - ? [101] SQL Server SQL21 version 7.00.842 (0 connection limit)
4/26/2005 11:00:48 AM - ? [102] SQL Server ODBC driver version 3.70.1146
4/26/2005 11:00:48 AM - ? [103] NetLib being used by driver is DBNMPNTW.DLL; Local host server is (local)
4/26/2005 11:00:48 AM - ? [310] 2 processor(s) and 1536 MB RAM detected
4/26/2005 11:00:48 AM - ? [339] Local computer is SQL21 running Windows NT 5.0 (2195) Service Pack 3
4/26/2005 11:00:48 AM - + [260] Unable to start mail session (reason: No mail profile defined)
4/26/2005 11:00:48 AM - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
0
 
Kevin3NFCommented:

Some items of concern:

Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3) --shouldn't your O/S be SP4?

2005-04-26 11:00:43.50 spid1    Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
--distributed transactions may fail

2005-04-26 11:00:44.64 ods      Using 'SSMSSO70.DLL' version '7.0.694' to listen on '1433'.
2005-04-26 11:00:44.64 ods      Error: 17833, Severity: 18, State: 1
2005-04-26 11:00:44.64 ods      ListenOn connection '1433' is already in use..
You cannot listen on the default port if something else is already using it.  I believe Netstat can help you determine what is using that port...
0
 
dbabbittAuthor Commented:
Installing SP4 fixed the problem. Here is what the error log says now:
2005-04-28 08:03:01.45 kernel   Microsoft SQL Server  7.00 - 7.00.842 (Intel X86)
      Mar  2 2000 06:49:37
      Copyright (c) 1988-1998 Microsoft Corporation
      Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2005-04-28 08:03:01.45 kernel   Copyright (C) 1988-1997 Microsoft Corporation.
2005-04-28 08:03:01.45 kernel   All rights reserved.
2005-04-28 08:03:01.46 kernel   Logging SQL Server messages in file 'F:\MSSQL7\log\ERRORLOG'.
2005-04-28 08:03:01.50 kernel   initconfig: Number of user connections limited to 32767.
2005-04-28 08:03:01.50 kernel   SQL Server is starting at priority class 'high'(2 CPUs detected).
2005-04-28 08:03:01.59 kernel   User Mode Scheduler configured for thread processing
2005-04-28 08:03:03.82 server   Directory Size: 64943
2005-04-28 08:03:03.86 spid1    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2005-04-28 08:03:03.86 kernel   Attempting to initialize Distributed Transaction Coordinator.
2005-04-28 08:03:08.96 spid1    Starting up database 'master'.
2005-04-28 08:03:08.96 spid1    Opening file F:\MSSQL7\data\master.mdf.
2005-04-28 08:03:08.98 spid1    Opening file F:\MSSQL7\data\mastlog.ldf.
2005-04-28 08:03:09.04 spid1    Loading SQL Server's  Unicode collation.
2005-04-28 08:03:09.06 spid1    Loading SQL Server's  non-Unicode sort order and character set.
2005-04-28 08:03:09.14 spid1    15 transactions rolled forward in database 'master' (1).
2005-04-28 08:03:09.15 spid1    0 transactions rolled back in database 'master' (1).
2005-04-28 08:03:09.25 spid1    Starting up database 'model'.
2005-04-28 08:03:09.25 spid1    Opening file F:\MSSQL7\DATA\model.mdf.
2005-04-28 08:03:09.26 spid1    Opening file F:\MSSQL7\DATA\modellog.ldf.
2005-04-28 08:03:09.37 spid1    Clearing tempdb database.
2005-04-28 08:03:09.40 spid1    Creating file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-28 08:03:09.51 spid1    Closing file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-28 08:03:09.53 spid1    Creating file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-28 08:03:09.61 spid1    Closing file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-28 08:03:09.67 spid1    Opening file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-28 08:03:09.67 spid1    Opening file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-28 08:03:09.95 spid1    Closing file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-28 08:03:09.96 spid1    Closing file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-28 08:03:10.00 spid1    Starting up database 'tempdb'.
2005-04-28 08:03:10.00 spid1    Opening file F:\MSSQL7\DATA\TEMPDB.MDF.
2005-04-28 08:03:10.01 spid1    Opening file F:\MSSQL7\DATA\TEMPLOG.LDF.
2005-04-28 08:03:10.15 spid1    Server name is 'SQL21'.
2005-04-28 08:03:10.15 kernel   Using 'SQLEVN70.DLL' version '7.00.842'.
2005-04-28 08:03:10.15 kernel   Using 'OPENDS60.DLL' version '7.00.00.0839'.
2005-04-28 08:03:10.20 ods      Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\\.\pipe\sql\query'.
2005-04-28 08:03:10.20 ods      Using 'SSMSSO70.DLL' version '7.0.694' to listen on '1433'.
2005-04-28 08:03:10.20 ods      Using 'SSMSRP70.DLL' version '7.0.839' to listen on 'SQL21'.
2005-04-28 08:03:10.23 spid6    Starting up database 'msdb'.
2005-04-28 08:03:10.23 spid6    Opening file F:\MSSQL7\DATA\msdbdata.mdf.
2005-04-28 08:03:10.23 spid7    Starting up database 'pubs'.
2005-04-28 08:03:10.23 spid7    Opening file F:\MSSQL7\DATA\pubs.mdf.
2005-04-28 08:03:10.25 spid10   Starting up database 'trial'.
2005-04-28 08:03:10.25 spid10   Opening file F:\MSSQL7\DATA\trial.mdf.
2005-04-28 08:03:10.26 spid8    Starting up database 'Northwind'.
2005-04-28 08:03:10.26 spid8    Opening file F:\MSSQL7\DATA\northwnd.mdf.
2005-04-28 08:03:10.26 spid9    Starting up database 'hhss'.
2005-04-28 08:03:10.26 spid9    Opening file F:\MSSQL7\data\hhss.mdf.
2005-04-28 08:03:10.26 spid11   Starting up database 'Quali_Assur'.
2005-04-28 08:03:10.26 spid11   Opening file F:\MSSQL7\data\Quali_Assur_Data.MDF.
2005-04-28 08:03:10.29 spid12   Starting up database 'SafetyManager'.
2005-04-28 08:03:10.29 spid12   Opening file F:\MSSQL7\DATA\SafetyManager.mdf.
2005-04-28 08:03:10.29 spid13   Starting up database 'IR'.
2005-04-28 08:03:10.29 spid13   Opening file F:\MSSQL7\DATA\IR.mdf.
2005-04-28 08:03:10.37 spid6    Opening file F:\MSSQL7\DATA\msdblog.ldf.
2005-04-28 08:03:10.37 spid7    Opening file F:\MSSQL7\DATA\pubs_log.ldf.
2005-04-28 08:03:10.39 spid8    Opening file F:\MSSQL7\DATA\northwnd.ldf.
2005-04-28 08:03:10.40 spid11   Opening file F:\MSSQL7\data\Quali_Assur_Log.LDF.
2005-04-28 08:03:10.40 spid13   Opening file F:\MSSQL7\DATA\IR.ldf.
2005-04-28 08:03:10.40 spid10   Opening file F:\MSSQL7\DATA\trial.ldf.
2005-04-28 08:03:10.43 spid12   Opening file F:\MSSQL7\DATA\SafetyManager.ldf.
2005-04-28 08:03:10.67 spid9    Opening file F:\MSSQL7\data\HHSS_Log.LDF.
2005-04-28 08:03:10.86 spid7    Starting up database 'PayrollARC'.
2005-04-28 08:03:10.86 spid7    Opening file F:\MSSQL7\DATA\PayrollARC.mdf.
2005-04-28 08:03:10.95 spid10   Starting up database 'LumigentDemoDB'.
2005-04-28 08:03:10.95 spid10   Opening file F:\MSSQL7\Data\LumigentDemoDB_Data.MDF.
2005-04-28 08:03:11.11 spid7    Opening file F:\MSSQL7\DATA\PayrollARC.ldf.
2005-04-28 08:03:11.11 spid8    Starting up database 'RentACoder'.
2005-04-28 08:03:11.11 spid8    Opening file F:\MSSQL7\DATA\RentACoder.mdf.
2005-04-28 08:03:11.18 spid10   Opening file F:\MSSQL7\Data\LumigentDemoDB_Log.LDF.
2005-04-28 08:03:11.18 spid11   Starting up database 'Cold_Fusion_Client_Variables'.
2005-04-28 08:03:11.18 spid11   Opening file F:\MSSQL7\DATA\Cold_Fusion_Client_Variables.mdf.
2005-04-28 08:03:11.23 spid8    Opening file F:\MSSQL7\DATA\RentACoder.ldf.
2005-04-28 08:03:11.31 spid13   Starting up database 'Traffic_Analysis'.
2005-04-28 08:03:11.31 spid13   Opening file F:\MSSQL7\DATA\Traffic_Analysis.mdf.
2005-04-28 08:03:11.37 spid12   Starting up database 'Marketing'.
2005-04-28 08:03:11.37 spid12   Opening file F:\MSSQL7\data\Marketing_Data.MDF.
2005-04-28 08:03:11.39 spid11   Opening file F:\MSSQL7\DATA\Cold_Fusion_Client_Variables.ldf.
2005-04-28 08:03:11.48 spid12   Opening file F:\MSSQL7\data\Marketing_Log.LDF.
2005-04-28 08:03:11.50 spid13   Opening file F:\MSSQL7\DATA\Traffic_Analysis.ldf.
2005-04-28 08:03:11.75 spid7    Starting up database 'Intuit_Payroll_Services'.
2005-04-28 08:03:11.75 spid7    Opening file F:\MSSQL7\data\Intuit_Payroll_Services_Data.MDF.
2005-04-28 08:03:11.93 spid7    Opening file F:\MSSQL7\data\Intuit_Payroll_Services_Log.LDF.
2005-04-28 08:03:13.26 spid1    Recovery complete.
2005-04-28 08:03:13.26 spid1    SQL Server's Unicode collation is:
2005-04-28 08:03:13.26 spid1            'English' (ID = 1033).
2005-04-28 08:03:13.26 spid1            comparison style = 196609.
2005-04-28 08:03:13.26 spid1    SQL Server's non-Unicode sort order is:
2005-04-28 08:03:13.26 spid1            'nocase_iso' (ID = 52).
2005-04-28 08:03:13.26 spid1    SQL Server's non-Unicode character set is:
2005-04-28 08:03:13.26 spid1            'iso_1' (ID = 1).
2005-04-28 08:03:13.34 spid1    Launched startup procedure 'sp_LumigentStart'
2005-04-28 08:03:13.59 spid7    Using 'xp_logattach.dll' version '0001.00.00' to execute extended stored procedure 'xp_logattach_StartProf'.
2005-04-28 08:03:14.32 spid7    Using 'xpsqlbot.dll' version '1998.11.13' to execute extended stored procedure 'xp_qv'.
2005-04-28 08:03:14.62 spid8    Using 'xpstar.dll' version '2000.02.08' to execute extended stored procedure 'xp_sqlagent_monitor'.
0
 
Kevin3NFCommented:
You are also two service packs behind on SQL Server....

http://www.aspfaq.com/show.asp?id=2160

.842 is SP2.  SP4 is out and stable.  Lots of performance, memory and bug fixes.  Test first on a backup box.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now