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.
| Author |
Topic |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2011-05-25 : 05:06:18
|
| Hi there,I am trying to set up a new SQL 2005 Standard ed. X64 server and I have installed the first named instance with no problem. I then repeated the process to install the second instance and got the following error:The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."When I go to services.msc there is no SQL Server service listed for the new instance so I can't start it manually either - it would appear it just hasn't been installed. Apart from the instance name, all the details are identical to the first instance I installed, including the account running the services etc. All I can find from Google are posts regarding CPU compatability issues, which it clearly isn't because A) The first instance worked fine and B) We are running a virtual environment and have other SQL Servers running on the same kit with no problems......confused!Any ideas?Thanks |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-25 : 05:16:17
|
| For log file you need to search log folder it is located [YourDriveName"Where you installed sql"]\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOGand Check Errorlog open with notepad.Ok If you don't have sql server service in services.msc (I don't know what happened it may be you not installed your sql properly)If your installation is correct then you must have sql server(services) Try this you can check sql services UnderStart Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager.If its not there then your installation is not correct.In Love... With Me! |
 |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2011-05-25 : 06:00:03
|
Well that's just it, clearly it hasn't installed the second instance properly, but I used exactly the same process as the first instance which I had no problem with.......so the question is, why would it not work the second time?!There is no sign of the SQL Server Service in the Configuration Manager either, so it has obviously just not installed. There doesn't appear to be anything helpful in the error logs either  |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-25 : 06:05:37
|
| Ok what you gave your second instance name Note:During installation you have selected named instance radio button and gave name or you left that without selecting.In Love... With Me! |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2011-05-25 : 07:21:48
|
| I selected named instance. The first instance was called NOR and the second was going to be called NOR2. I have installed SQL plenty of times but never had this issue before, so I can't see it's anything I've done wrong during the setup wizard.... |
|
|
|
|
|
|
|
|
SQL Server Install Problem