March 28, 2006 at 10:43 pm
Hi Everybody,
I am using SQL 7. I am unable start the sql server giving error 5. This is the information from the log file. Can anybody help me? Thanks in advance
17207 :
udopen: Operating system error 5(Access is denied.) during the
creation/opening of physical device e:\mssql7
\data\db290305_data.mdf.
Ramaa
March 28, 2006 at 11:05 pm
Hi,
U can check the services 'MSSQLSERVER'. U can check the log on tab. If you have access to start the services... start it.
DJ
March 28, 2006 at 11:11 pm
Check the Permissions tab on the Folder E:\MSSQL7\Data and see to that the Startup Account of SQL Server has Full Permissions on that Folder. Also please check that the db290305_data.mdf file is not read only.
Sumit
March 28, 2006 at 11:31 pm
Thank You DKS,Sumit,
Even my System Administrator is unable to start the mssql service giving the same error. I checked the file db290305_data.mdf it is not read only.
Yesterday evening i found some of the databases are marked for suspect, then i executed sp_resetstatus for that datbase. What is problem? Please....
Ramaa
March 28, 2006 at 11:50 pm
What is the startup Account of SQL Server ??
Check the Permissions tab on the Folder E:\MSSQL7\Data and see to that the Startup Account of SQL Server has Full Permissions on that Folder
March 29, 2006 at 12:32 am
Hi Sumit,
Startup Account Administrator and the administrator has full rights on the E:\mssql7 directory.
Ramaa
March 29, 2006 at 7:06 am
Try changing the service account login using Enterprise Manager. If for some reason the service account login was changed outside of SEM several account properties were probably omitted. SEM alters these properties in accordance with those necessary to run the service correctly.
April 1, 2006 at 12:51 am
Hi all,
Thank you for your suggestions.
Finally I uninstalled sql 7 and reinstall sql7 .My problem solved.
Ramaa
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply