Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

New Member
Posts: 3
Country: USA

ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

Hello, 
 
No ACT Databases can be opened.
 
It appears that the SQL service will not start.
 
I have tried removing and reinstalling ACT, but this does not correct the problem.
 
It is possible the SQL 2005 master database needs to be rebuilt.
 
This procedure involves running the Setup.exe for MS SQL 2005 with command line parameters to perform master database rebuild, as well as specifying the master database password. 
 
The ACT distribution CD includes no Setup.exe, however, there is an executable SQLInstall.exe as well as an SQLInstall.msi 
 
Is there a recommended procedure to recover from a corrupted SQL Master Database?
 
Thanks, Dennis
 
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

What happens when you try to open a database?
What error do you get?
 
What makes you think the master database needs to be rebuilt?
 
Have you looked at ACTDIAG?
New Member
Posts: 3
Country: USA

Re: ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

Hello,
 
The ACT! connection error:
---------------------------
Error
---------------------------
The database act9demo could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software on your computer or the server.
---------------------------
OK  
---------------------------
 
I followed knowledgebase troubleshooting procedures that included making sure the SQL Server would start.  Researching possible reasons the SQL Server would not start, I came across instructions to rebuild the master database.  This is problematic because the SQL Server 2005 bundled with ACT! Premium for WG does not include the Setup.exe file used to perform this procedure.
 
I ran ACTDIAG and after a moment it returned an error that it could not connect to the SQL Server.
 
Thanks, Dennis
 
 
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

What happens if you manually try and start the SQL service from services.msc?
New Member
Posts: 3
Country: USA

Re: ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

When manually starting the service:
 
When starting service via services.msc:
 
---------------------------
Services
---------------------------
Windows could not start the SQL Server (ACT7) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.
---------------------------
OK  
---------------------------
 
 
Because of what the ERRORLOG file generated by MSSQL Server shows, I believe the master database must be rebuilt, repaired or replaced:

2008-01-30 13:20:07.95 Server      Microsoft SQL Server 2005 - 9.00.2170.00 (Intel X86)  Jun 28 2006 15:24:03
 Copyright (c) 1988-2005 Microsoft Corporation
 Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
 
2008-01-30 13:20:07.95 Server      (c) 2005 Microsoft Corporation.
2008-01-30 13:20:07.95 Server      All rights reserved.
2008-01-30 13:20:07.95 Server      Server process ID is 2612.
2008-01-30 13:20:07.95 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2008-01-30 13:20:07.95 Server      This instance of SQL Server last reported using a process ID of 2600 at 1/30/2008 9:01:58 AM (local) 1/30/2008 2:01:58 PM (UTC). This is an informational message only; no user action is required.
2008-01-30 13:20:07.95 Server      Registry startup parameters:
2008-01-30 13:20:07.95 Server        -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2008-01-30 13:20:07.95 Server        -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2008-01-30 13:20:07.95 Server        -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2008-01-30 13:20:07.98 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2008-01-30 13:20:07.98 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2008-01-30 13:20:08.20 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2008-01-30 13:20:08.23 Server      Database mirroring has been enabled on this instance of SQL Server.
2008-01-30 13:20:08.25 spid5s      Starting up database 'master'.
2008-01-30 13:20:08.29 spid5s      Error: 9003, Severity: 20, State: 1.
2008-01-30 13:20:08.29 spid5s      The log scan number (213:200:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2008-01-30 13:20:08.29 spid5s      Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

-- Dennis
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT Prem for WG 2007 - rebuild SQL 2005 "master database"

My fist choice would be:
 
With the services stopped, copy the database folder (to make sure you have it all backed-up in case something goes wrong)
 
Follow these steps to uninstall and re-install ACT!... it's my personal way to get the most clean install possible
  • Uninstall any version of ACT! from Control Panel
  • Use the Uninstaller.exe from the ACT! KB 19338 to make sure it's clean
  • Uninstall .Net Framework (any and all versions)
  • Uninstall MS SQL from Control Panel
  • Uninstall MSXML Services from Control Panel
  • Perform a Selective restart with MSCONFIG as per ACT! KB 14499
  • Re-Install .Net 2.0 Framework from MS web site - http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displa...
  • Manually install MS SQL as per ACT! KB 19386
  • Install ACT! 10
  • Restore from Selective Startup Mode with MSCONFIG
  • Reboot