SQL Server 2008 Express: Can't start service

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Server 2008 Express: Can't start service

Author

Topic

sbeecroft
Starting Member

3 Posts

Posted - 2010-07-29 : 12:51:52

I asked this on another forum, where I was directed here. Many thanks to anyone who can help me. I have pasted the original below, with irrelevant parts elided [...] and a few clarifications [added].

**************************

Baby question here. I was surprised that I didn't find this already discussed when I did a search, but maybe I just missed it. Or maybe everyone is much smarter than I am. If you point me to a thread that covers this topic, I will thank you kindly, apologize for bothering everyone, and go read it.

SERVER STATS
Dell laptop (Latitude D820) running Win XP Pro 2002 SP3, Intel Core2 T7200 @ 2 GHz, 2 GB RAM. Installed VS C# 2010 Express, VS C++ 2010 Express, SQL Server 2008 Express.

SHORT PROBLEM DESCRIPTION
I can't start the DB service. SQL Config Mgr shows service "SQL Server (SQLEXPRESS)" as "Stopped" (start mode Automatic, though it didn't start up on reboot). Selecting "Start" from the context menu causes a "Starting service..." notification to grind away for a while, then displays "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

(I don't know where the log files are. A directory search through "C:\Program Files\" and "C:\Windows\" for "*sql*log*" returned nothing modified more recently than a week ago. Googling "sql server 2008 express log location" likewise returned nothing of use in the first dozen or so returns; didn't investigate the next 1000.)

LONGER PROBLEM DESCRIPTION
I know almost nothing about databases in general or SQL Server in specific. This, I am sure, is the ultimate genesis of my problem. [...] I followed his installation instructions for SQL Server 2008 Express. Things worked lovely for a while, then the VC# [2010 Express] IDE could no longer connect to the database. I finally fixed it by reinstalling SQL Server 2008 Express. Now it's doing it to me again, and reinstalling SQL Server is a stupid solution that I refuse to continue doing.

Let me go through an example [...]

1. Open VC# 2010 [Express] IDE.
2. On Start Page, click 'New Project'.
3. Select 'Console Application' (name it "ADONet2ConnectedService").
4. Click 'OK'.
5. Ctrl-Shift-A (or right-click Project, select 'Add' from context menu and select 'New Item').
6. Select 'Service-based Database' (name it "ServiceDB").
7. Click 'Add'.
8. Wait for 30 seconds.

RESULT:
Warning dialog titled "Local database file" with the following message:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

So the SQL Server service isn't running. Therefore, here's what I try:

9. Open SQL Server Configuration Manager.
10. Select 'SQL Server Services' in left pane. Note three services listed in right pane, all with the state 'Stopped'.
11. In right pane, right-click on 'SQL Server (SQLEXPRESS)' and select 'Start' from context menu.
12. Watch bar travel across window while reading "Starting service..." for 40 seconds.

RESULT:
Failure dialog titled "SQL Server Configuration Manager" with the following message:

"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

13. Open Properties on service to see where logs are located. (Fail.)
14. Google "sql server 2008 express log location" to find them. (Fail.)
15. Open cmd prompt, navigate to C:\Program Files\, type "dir/s *sql*log* > out.txt" to find all recent log files for sql. (Fail.)
16. Change directory to C:\Windows\ and try again. (Fail.)
17. Open a browser, navigate to [this forum], and ask the nice folks here.

Help?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-29 : 13:36:02

<START><RUN> type in "eventvwr" <OK>

Expand application and look for errors. Expand system and look for errors.

sbeecroft
Starting Member

3 Posts

Posted - 2010-07-29 : 13:52:41

quote:
Originally posted by russell

<START><RUN> type in "eventvwr" <OK>

Expand application and look for errors. Expand system and look for errors.

Thanks, Russell. The relevant error appears to be the following:

****************************

The MSSQL$SQLEXPRESS service was unable to log on as .\SQLSVR2008EXPDE with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.

To ensure that the service is configured properly, use the Services snap-in in Microsoft Management Console (MMC).

****************************

When I installed SQL Server 2008 Express, I followed the suggestion in the SQL Server 2008 Step by Step book and created a user (SQLSVR2008EXPDE) and password for the service. It worked fine after installation, but then died and wouldn't come back.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-29 : 13:59:31

if you're the only one using the laptop just change the login to the credentials you log into the laptop with -- assuming you're admin on the laptop.

sbeecroft
Starting Member

3 Posts

Posted - 2010-08-02 : 16:33:31

quote:
Originally posted by russell

if you're the only one using the laptop just change the login to the credentials you log into the laptop with -- assuming you're admin on the laptop.

Sorry to be dense, but I don't see how to change the logon credentials. SQL Server Management Studio wants me to log on before I do anything, but seeing as how I can't log on... Do I have to reinstall SQL Server 2008 Express -- again?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-04 : 14:06:01

start
control panel
administrative tools
services

double-click SQL Server (MSSQLSERVER)
go to logon tab
cahnge credentials

jitender153
Starting Member

1 Post

Posted - 2010-08-05 : 02:35:20

i m not able to even start the sql server management studio

the error in the event viewer log is as follows:-

Microsoft SSIS Service failed to start.
Error: The SQL Server Integration Services service requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.
----------------------------------------------------------------

jitender malik
systems analyst
hocl india

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources