sqlexpress on sbs2003 will not start

After a power outage and re-boot, my sbs 2003 server is unable to start the SQLEXPRESS 2005 service. I am a total sql rookie and will try to provide all available details. We are running Blackberry Enterprise Server 4.1 which appears to be running on SQLEXPRESS 2005. Backup Exec 12 is successfully running on SQLSERVER 2005 without issue.

When launching the Blackberry Manager, I see - "Database login failed using trusted credentials, database connection lost. Please test connection again with a valid user ID and password."

Blackberry Server Configuration/Test Database Connection yields the following error message - "Test connection to database failed. Please verify that all database settings are correctly entered and that the specified SQL server is running."

When attempting to start the SQLEXPRESS service an application event 9003 is logged - "The log scan number (51:472:1) 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."

The SQL errorlog for for the failed service startup reads as follows:
2010-10-18 16:12:13.96 Server      Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
      May 26 2009 14:24:20
      Copyright (c) 1988-2005 Microsoft Corporation
      Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2010-10-18 16:12:13.99 Server      (c) 2005 Microsoft Corporation.
2010-10-18 16:12:13.99 Server      All rights reserved.
2010-10-18 16:12:13.99 Server      Server process ID is 7736.
2010-10-18 16:12:13.99 Server      Authentication mode is WINDOWS-ONLY.
2010-10-18 16:12:13.99 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-10-18 16:12:13.99 Server      This instance of SQL Server last reported using a process ID of 3296 at 10/18/2010 12:32:43 PM (local) 10/18/2010 6:32:43 PM (UTC). This is an informational message only; no user action is required.
2010-10-18 16:12:14.00 Server      Registry startup parameters:
2010-10-18 16:12:14.01 Server             -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-10-18 16:12:14.01 Server             -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-10-18 16:12:14.01 Server             -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-10-18 16:12:14.06 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-10-18 16:12:14.06 Server      Detected 4 CPUs. This is an informational message; no user action is required.
2010-10-18 16:12:14.65 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-10-18 16:12:15.66 Server      Database mirroring has been enabled on this instance of SQL Server.
2010-10-18 16:12:15.78 spid4s      Starting up database 'master'.
2010-10-18 16:12:16.54 spid4s      SQL Trace ID 1 was started by login "sa".
2010-10-18 16:12:16.60 spid4s      Starting up database 'mssqlsystemresource'.
2010-10-18 16:12:16.62 spid4s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-10-18 16:12:17.16 spid8s      Starting up database 'model'.
2010-10-18 16:12:17.17 spid4s      Server name is 'SERVERNAME\SQLEXPRESS'. This is an informational message only. No user action is required.
2010-10-18 16:12:17.17 spid4s      Starting up database 'msdb'.
2010-10-18 16:12:17.28 spid8s      Error: 9003, Severity: 20, State: 1.
2010-10-18 16:12:17.28 spid8s      The log scan number (51:472:1) 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.
2010-10-18 16:12:17.32 spid8s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

I have no idea how to resolve my SQLEXPRESS issue. It seems that the Blackberry Enterprise Server cannot function until I am able to successfully start SQLEXPRESS. I currently have 6 Blackberry users whose email is not working. Please help!!!




bctf1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bctf1Author Commented:
Thank you pqm554 for your response. My problem is that I cannot connect to the SQLexpress 2005 server at all or launch it's service in order to test it's associated database for errors. When I attempt to do so I get the following 2 event errors:

Application event - error 9003:
The log scan number (51:472:1) 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.

System event - error 3414:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 3414 (0xD56).

I am unsure what I need to do to be able to resolve the connection failure to SQLExpress 2005. I have downloaded the SQLExpress 2005 sp3 installer but am hesitant to run it for fear that it could compromise my SQL server 2005 installation which is running a Backup Exec 12 database without any problems. After much research I am at a loss on how to proceed.
pgm554Commented:
There should be a 2nd named instance of the SQL DB that the BB uses.
You would run the command line specific repair utility  to repair that instance of the DB.

http://msdn.microsoft.com/en-us/library/ms165662(v=SQL.90).aspx
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

bctf1Author Commented:
I viewed the link you provided. The results appear below. However, I already know the version, server name and instance name.

I ran sqlcmd -S servername\SQLEXPRESS from a command prompt window and here are the results:
C:\Documents and Settings\Administrator>sqlcmd -S servername\SQLEXPRESS
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

The Blackberry Server Manager indicates that it is using servername\SQLEXPRESS as it's sql server and BESmgmt as the database name. As you can see by the attached images, Remote Connections are enabled using both tcp/ip and named pipes and the SQLEXPRESS server is stopped.

I am able to test databases for errors using SQL Management Studio Express for SQLServer but not for  SQLEXPRESS since I cannot connect to it or start it.

sql2.jpg
sql3.jpg
bctf1Author Commented:
Since I cannot connect to or start SQLEXPRESS, what would happen if I reinstalled it?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bctf1Author Commented:
No successful solution was provided by an expert.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.