Fix to SQL server Express - 2005
by satheesh[ Edit ] 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)
