SQL Server services are not starting

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 services are not starting

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2011-04-21 : 10:49:44

Hi Experts
i've a old dump with me of sql server 2008 R2, and i copied to the required server and installed successfully. but the probelm once the istallation is done, the services are not starting, and stating that sccess denied.

i'm trying with the service account, even then i'm getting the same error. i'm thinking there is some problem with the dump.

while installing, it is showing as enterprise edition, and there is another radio button, which has another three options as evaluation edition, express edition, express edition with advanced features.

not sure how my DBA downloaded (i'm new here) previously. is there any time period that the dump will work only till this time? and for installation, service is running, but not able to connect.

pretty new to 2008 R2.

please guide me.

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-21 : 12:59:08

Please post the error.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-21 : 13:02:43

Open the latest error log, read from the end backwards, it'll say why SQL failed to start. If you're unsure, post the entire thing here.

--
Gail Shaw
SQL Server MVP

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-21 : 14:00:03

try to connect with the user which one using at the time of installation a windows user

Regards,

Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-21 : 14:04:11

quote:
Originally posted by Jahanzaib

try to connect with the user which one using at the time of installation a windows user

How would that help if the service won't start? You have to get the service started before you can connect.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-21 : 14:13:26

he has clearly mention
service is running, but not able to connect.

did you read the question

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-21 : 14:15:06

His post is very confusing then because it says services are not running too.

We still need the error to help him.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-21 : 14:15:34

Yes. Did you?

quote:
but the probelm once the istallation is done, the services are not starting, and stating that sccess denied.

The question is confusing, it's not clear what state anything it in.

--
Gail Shaw
SQL Server MVP

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-21 : 14:22:58

yes he has mentioned both statement

running and not running

agreed

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources