Fix to SQL server Express - 2005

by satheesh 2010-02-04 09:02:25

1) Go to C or D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data, right-clicked on each file and make sure that "Compress contents" was NOT checked. When you check "ready to archive", you will get a different error (instead of 26 it was 40) when creating a new database.

2) Run SQLdiag found in C:\Program Files\Microsoft SQL Server\90\Tools\Binn, to get some hints.

3) Right Click SQLExpress in Services.msc and changed the Log On to "Local System Account" with the box check.

4) See-> Windows control panel -> Performance and maintenance -> Administrative tools -> Services ->right click on SQLEXPRESS -> Properties -> Under Logon tab check Local logon and allow interact with local services!

5) Granting the “Network Service” account Full Permission on the “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” folder will do.

(NT AUTHORITY\NetworkService - Services.msc -> SQLExpress)

Tagged in:


You must LOGIN to add comments