Improve company productivity with a Business Account.Sign Up

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

How to correct the SQL server error in XP /Office 2007

After updating my XP SP3 workstation to latest patches i see this errror in the event log

Source MSSQL$MSSMLBIZ event ID 17207
FCB::Open:Operating system error 5(Access is denied) occured while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdl"  Diagnose and correct the operating system error and retry the operation.
Is this a critical error that will create problems down the line using web apps?
0
XCLN
Asked:
XCLN
  • 4
  • 2
2 Solutions
 
XCLNAuthor Commented:
Microsoft has offered a patch but I can't get that to work ..
http://support.microsoft.com/kb/929665

"To work around this issue, repair Windows Internal Database. To do this, run the following command line at a command prompt:
Msiexec /i SSEE_10.msi CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v <Log_File_Path> " 

Trying this return a syntax error. - I can download SSE_10.msi and but it in the directory where i run this command line, but same syntax error.

Any clues how I should be running this command? SQL server 2005 was installed from Office 2007 - and the latest patch for SQL server couldnt install for some reason.

0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Just change the SQL Server service account to LocalSystem which should help fix the issue.
Else Grant Full privileges to c:\Program Files\Microsoft SQL Server for the user account under which SQL Server service is up and running.

http://pjondevelopment.50webs.com/blog/2008/02/sql-server-2005-troubleshooting.html
0
 
XCLNAuthor Commented:
Okay - that sounds great - thanks . .. let me try these fixes.  Will report back  ;-)
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
XCLNAuthor Commented:
Indeed that did it - thanks a lot for your prompt answer !
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
0
 
XCLNAuthor Commented:
timely too
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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