This internal article applies to the SQL Server (WASPDBEXPRESS) service not starting. Try each step, then test. If the error still occurs, try the next step in turn. If none of the steps fix the problem, SQL may just be corrupt and will need to be removed and reinstalled. Be sure to move or copy any relevant data files to a safe location before attempting fixes.
1. Go to the following location:
32-bit Windows: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data64-bit Windows: C:\Program Files(x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data:
Confirm the .mdf and .ldf files are not compressed. If compressed, uncheck "Compress contents to save disk space" from the Advanced Attributes of the file's Properties.
2. Grant the Windows user and then the "NETWORK SERVICE" account full permission to the before-mentioned Data folder.
3. It is also possible that the master.mdf file is corrupt. If steps 1 and 2 do not resolve, backup the current master.mdf and master.ldf (or mastlog.ldf) files, then replace them with known good files. Note that any attached database(s) have their file paths saved in the Master database, so if the paths to the database files are different on the two PCs (for example, 32-bit vs 64-bit Windows), there will still be an error when starting the SQL service.
4. Last step and finally working step- back up master.mdf and mastlog.ldf and tempdb.mdf and templog.ldfand goto folder C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.TOUCHE9\MSSQL\Template Data and copy master.mdf and tempdb.mdf and log file also and paste to
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.TOUCHE9\MSSQL\Data and then starting the SQL service.
Reattach all db and permission to opm1 user then problem solved.
1. Go to the following location:
32-bit Windows: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data64-bit Windows: C:\Program Files(x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data:
Confirm the .mdf and .ldf files are not compressed. If compressed, uncheck "Compress contents to save disk space" from the Advanced Attributes of the file's Properties.
2. Grant the Windows user and then the "NETWORK SERVICE" account full permission to the before-mentioned Data folder.
3. It is also possible that the master.mdf file is corrupt. If steps 1 and 2 do not resolve, backup the current master.mdf and master.ldf (or mastlog.ldf) files, then replace them with known good files. Note that any attached database(s) have their file paths saved in the Master database, so if the paths to the database files are different on the two PCs (for example, 32-bit vs 64-bit Windows), there will still be an error when starting the SQL service.
4. Last step and finally working step- back up master.mdf and mastlog.ldf and tempdb.mdf and templog.ldfand goto folder C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.TOUCHE9\MSSQL\Template Data and copy master.mdf and tempdb.mdf and log file also and paste to
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.TOUCHE9\MSSQL\Data and then starting the SQL service.
Reattach all db and permission to opm1 user then problem solved.
No comments:
Post a Comment