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 |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2012-02-16 : 10:56:14
|
| I've just installed SQL Server 2005 with SP2 on a windows 2008 sp1 server, however I've noticed that I'm unable to stop and start the services from within SSMS and the normal green arrow is not there and is just blank.I'm a system admin on both and the services both run under admin domain account (currently, in an attempt to get this started).Any ideas people?-----------------------------------------------Learning something new on SQL Server everyday. |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-02-17 : 15:09:07
|
| check in start->run->services.msc that sql server service is running. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-02-18 : 11:23:53
|
| if it's stopped - use from the command line : NET START MSSQL$INSTANCE_NAME Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-02-22 : 11:24:35
|
| The green arrow indicates that you are allowed to control the services remotely. Try to "register" the server and see if the green arrow appears when you re-connect.=================================================Men shout to avoid listening to one another. -Miguel de Unamuno |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-02-25 : 08:43:06
|
| Try running SSMS as an administrator - on Windows Server 2008 you are probably running into an issue with UAC which can be fixed if that is the case.Jeff |
|
|
|
|
|
|
Unable to Stop or start sql server from SSMS