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 |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2001-11-30 : 13:09:56
|
| We wanted to put service pack 2 for window 2000.So we stopped sql server 2000. After installing service pack we tried to run sql server but it does not start.I could get connected to sql server for an hour from my machine but we didn't see any thing on server console that shows it's running. Now it's totally stopped.What should we do.Any help is appreciated.Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-11-30 : 13:23:49
|
| Have you tried rebooting the server, and then manually stopping and starting SQL Server?Edited by - robvolk on 11/30/2001 13:25:12 |
 |
|
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
Posted - 2001-11-30 : 17:53:34
|
| Thanks.We somehow lost one file for sql server agent that's why it was giving problem.We put it back.The sql server started and working fine but we cannot run enterprize manager on the server computer.When we tried to connect it gives this error: Connection to hht-sql couldn't be established Reason: invalid attribute/options identifier. Check your registration properties.Need help. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-11-30 : 17:56:33
|
| If you haven't re-registered the server in EM, delete the old one and create a new one. If that doesn't work, you may need to re-install the service pack.You might be able to start EM in author mode, that might clear it up. The Help menu for EM will describe how to use it. |
|
|
|
|
|
|
Sql server does not Restart