?
Solved

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

Posted on 2010-11-17
6
Medium Priority
?
947 Views
Last Modified: 2012-05-10
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
Comment
Question by:XCLN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 

Author Comment

by:XCLN
ID: 34154127
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
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 2000 total points
ID: 34154358
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
 

Author Comment

by:XCLN
ID: 34154471
Okay - that sounds great - thanks . .. let me try these fixes.  Will report back  ;-)
0
Technology Partners: 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!

 

Accepted Solution

by:
XCLN earned 0 total points
ID: 34154663
Indeed that did it - thanks a lot for your prompt answer !
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34154724
Welcome..
0
 

Author Closing Comment

by:XCLN
ID: 34186348
timely too
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question