| Author |
Topic |
|
Abid
110 Posts |
 Posted - 2013-05-28 : 01:48:37
|
| 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
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2013-05-28 : 01:50:45
|
| Check Sql server Error Log. If new installation, check the installation Log.Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-28 : 01:59:50
|
| Sounds like installation was not succesful (if you cant find the service itself). Try reinstalling sql server and client tools.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Abid
110 Posts |
Posted - 2013-05-28 : 02:14:44
|
| @ Senthil nagore:how do i check the Error Log, please guide me.@ Visakh16I 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-28 : 02:29:31
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2013-05-28 : 02:35:06
|
| it should be by default inc:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOGSenthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
|
|
|
Abid
110 Posts |
Posted - 2013-05-29 : 02:07:01
|
| @ 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-29 : 02:20:18
|
| that does mean database engine and desktop tools were not installed properly. Can you try reintalling this?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Abid
110 Posts |
Posted - 2013-05-29 : 04:44:34
|
| 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-29 : 04:59:05
|
| have you installed preqreuisites and also have latest service pack been installed for the os?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Abid
110 Posts |
Posted - 2013-05-29 : 11:32:29
|
| 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-30 : 01:32:56
|
| i was suggesting in SP for the OS not SQL Server. Also .NET frework etc which are prerequisites------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Abid
110 Posts |
Posted - 2013-05-30 : 03:32:40
|
| .NET frame is 3.5 and no SP is download so far for OS. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-30 : 03:39:36
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Abid
110 Posts |
Posted - 2013-05-30 : 09:45:27
|
| Okay Sir. |
|
|
|
Abid
110 Posts |
Posted - 2013-05-31 : 00:03:55
|
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 MVPhttp://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. |
|
|
|
|
SQL Server service failed to start