Solved

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

Posted on 2010-11-17
6
939 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
  • 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 500 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Grid querry results 41 72
Analysis of table use 7 43
sql query help 2 45
Urgent help needed! Unable to to paste in query designer 29 38
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now