SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server service failed to start
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/28/2013 :  01:48:37  Show Profile  Reply with Quote
Hi. I started to install Sql Server 2005 on Windows 7 32 bit OS. When it was installing the services to it gave me a message that "Sql Server Service failed to start" and do it manually, some kind of message with Retry and Cancel button. I Retried again and again but not working, so i cancelled it. The installation completed but i can't see any SQL Instance in my local PC. SQL Server Management Studio did not install.

Please guide me What to do?

senthil_nagore
Flowing Fount of Yak Knowledge

India
1007 Posts

Posted - 05/28/2013 :  01:50:45  Show Profile  Visit senthil_nagore's Homepage  Send senthil_nagore a Yahoo! Message  Reply with Quote
Check Sql server Error Log. If new installation, check the installation Log.

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/28/2013 :  01:59:50  Show Profile  Reply with Quote
Sounds like installation was not succesful (if you cant find the service itself). Try reinstalling sql server and client tools.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/28/2013 :  02:14:44  Show Profile  Reply with Quote
@ Senthil nagore:

how do i check the Error Log, please guide me.


@ Visakh16

I uninstalled the entire SQL Server and then reInstalled it but on the same point, it gives error that service failed to start. I also checked the SqlServer (MSSQLSERVER) from services, that is running too. Please guide me.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/28/2013 :  02:29:31  Show Profile  Reply with Quote
Ok...if MSSQLSERVER services is running then you should be able to connect to server. Can you try connecting it from Management studio? Also which edition you installed?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

senthil_nagore
Flowing Fount of Yak Knowledge

India
1007 Posts

Posted - 05/28/2013 :  02:35:06  Show Profile  Visit senthil_nagore's Homepage  Send senthil_nagore a Yahoo! Message  Reply with Quote
it should be by default in

c:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/29/2013 :  02:07:01  Show Profile  Reply with Quote
@ visakh16:

I'm working sql Standard. Secondly, SQL Management Studio is not here in my start menu. In my start menu, under SQL Server 2005 folder, there are only 2 folders the CONFIGURATION TOOLS and DOCUMENTATION AND TUTORIALS. Nothing else. I selected Sql Server Configuration Manager and then selected services, so it shows only 3 services i.e. SQL Server Integeration Services, Sql Server analysis Services (MSSQLSERVER) and SQL Server Browser. All running except integration services that is stopped. Please guide me for this.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/29/2013 :  02:20:18  Show Profile  Reply with Quote
that does mean database engine and desktop tools were not installed properly. Can you try reintalling this?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/29/2013 :  04:44:34  Show Profile  Reply with Quote
it would be 4th time that i will re-Install it. But if there is anything important to do during installation so please guide me.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/29/2013 :  04:59:05  Show Profile  Reply with Quote
have you installed preqreuisites and also have latest service pack been installed for the os?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/29/2013 :  11:32:29  Show Profile  Reply with Quote
What preRequisites Visakh?

I have SP3 of SQL Server, but it only works after the installation of SQL. If i try to install it so first it finds the instance of SQL, when i does not find it so it gives error that no instance of SQL has been dectected.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/30/2013 :  01:32:56  Show Profile  Reply with Quote
i was suggesting in SP for the OS not SQL Server. Also .NET frework etc which are prerequisites

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/30/2013 :  03:32:40  Show Profile  Reply with Quote
.NET frame is 3.5 and no SP is download so far for OS.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/30/2013 :  03:39:36  Show Profile  Reply with Quote
quote:
Originally posted by Abid

.NET frame is 3.5 and no SP is download so far for OS.


check and download latest sp for os as recommended by SQL server setup

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/30/2013 :  09:45:27  Show Profile  Reply with Quote
Okay Sir.
Go to Top of Page

Abid
Posting Yak Master

Pakistan
109 Posts

Posted - 05/31/2013 :  00:03:55  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

quote:
Originally posted by Abid

.NET frame is 3.5 and no SP is download so far for OS.


check and download latest sp for os as recommended by SQL server setup

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs



It is not asking for any SP version to install. My time is wasting and burden of work is increasing upon me. I made an screen shot of the error but this forum doesn't attach the image, its not working.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000