SQL Server Model Database Error 9003
While connecting SQL Server, if you experience "An error has occurred while establishing a connection to the server" error with following error details, SQL Server model database might be corrupted, or the model database log file modellog.ldf does not match the data file model.mdf
Starting up database 'model'.
Error: 9003, Severity: 20, State: 1.
The log scan number (n:n:n) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
SQL Server system model database log file modellog.ldf is corrupted or has inconsistencies.
In such a case the model database data file and the log file should be replaced with a healthy mdf and ldf file of the same SQL Server version model datafiles.
You can restore model database from previous backups or rebuild the system databases.
You can find model database data files in the SQL Server installation media.
SQL Server 2012 model database model.mdf and modellog.ldf file zipped which you can download: SQLServer2012-model-database.zip
SQL Server 2008 RTM Model database data and log file download: SQLServer2008-model-database.zip
Also a friend reported he had experienced SQL Server model database error 9003 right after SQL Server 2008 installation.
But we've suspected that the error is caused because on that Windows 7 operating system version, only SQL Server 2008 Service Pack 1 (SP1) was supported.
If you face the same SQL model database error, you can try to connect SQL Server 2008 after SP1 setup is also completed.