09-23-2011 01:09 PM
Hi so first off I'm running ACT! by Sage 2010 Version 18.104.22.168, Hot Fix 1 on a winxp machine (all hoxfix/sevice packs up to date)
I've gone through the trouble shooting tips and can't start the SQL ACT7 service. My folder options are correct and I can't even create a new database much less open or restore an old one.
Here's my latestest error log:
2011-09-23 11:57:50.52 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.
2011-09-23 11:57:49.80 Server Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Dec 10 2010 10:56:29
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2011-09-23 11:57:49.80 Server (c) 2005 Microsoft Corporation.
2011-09-23 11:57:49.80 Server All rights reserved.
2011-09-23 11:57:49.82 Server Server process ID is 5372.
2011-09-23 11:57:49.82 Server Authentication mode is MIXED.
2011-09-23 11:57:49.82 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2011-09-23 11:57:49.82 Server This instance of SQL Server last reported using a process ID of 2232 at 9/22/2011 5:35:23 PM (local) 9/23/2011 12:35:23 AM (UTC). This is an informational message only; no user action is required.
2011-09-23 11:57:49.85 Server Registry startup parameters:
2011-09-23 11:57:49.85 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2011-09-23 11:57:49.85 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2011-09-23 11:57:49.85 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-09-23 11:57:49.86 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-09-23 11:57:49.86 Server Detected 4 CPUs. This is an informational message; no user action is required.
2011-09-23 11:57:50.44 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.
2011-09-23 11:57:50.46 Server Database mirroring has been enabled on this instance of SQL Server.
2011-09-23 11:57:50.47 spid5s Starting up database 'master'.
2011-09-23 11:57:50.52 spid5s Error: 9003, Severity: 20, State: 1.
2011-09-23 11:57:50.52 spid5s The log scan number (284:80: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.
Any ideas?? (i'm not super comper savvy)
PS I can't think of a single change I've made since it was working...it simply seemed to stop! My whole business is on here
09-24-2011 04:17 AM
09-24-2011 03:06 PM
-Making sure I'm logged on as the same user (though I'm the only user)
-see that permissions to use the folder are correct
-the files/folders are not compressed
-anti virus disabled completely
-manually started the service (starting act7 sql always results in event viewer event 7024.)
-checked the event logs for clues (did notice a lot of tcp/ip jam ups and noticed that act is using pipes and tcp/ip is there a connection?)
-deleted pad files and oped actdiag but couldn't connect to the server to proceed
-Checked C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA to verify that the user has permissions to the folder
-I also checked network placed and noticed the database had created a network place on june 30th (I didn't do that...why did that happen?)
basically I've tried every tip I could find on the forum short of unistalling and reinstalling ACT or the sql instance.
not only is my biz at a stand still (well I do have a pad and pencil) but here's the othe big concern: I haven't made any noteable changes to my system (I installed a soundcard driver - that's it) and suddenly all this has happened. Is this going to become a reocurring issue (provided I get it working again at all?)
09-25-2011 03:07 AM
I would suggest to to services.msc and make sure that the SQL database and browser is started as I have seen this a lot lately or the SQL service not being started.
09-25-2011 07:16 AM
I could go for the reinstall but am I going to find myself in the same situation a few months down the road? I'm not even sure reinstalling would work... I liked ACT I hope this can get soved.
09-25-2011 09:11 PM
If you do a google search of the error SQL error 3417 I saw there were a number of responses each seem t be related to some files missing from the installation. some of the reasons from this could be
1. compressed files on hard drive
2. Delete files
One mentioned in a wordpress "Decoding the Web" about the data folder missing from the SQL directory. so will a reinstall fix the problem, maybe, will it happen again? it seems to depend on what else is going on on your system but I think one of these responses will resolve your error unless you wanted to get a technical person to start looking at your machine.