December 27, 2011 at 8:30 am
This is probably a stupid question, but I can't seem to locate it. I installed SQL Server 2008 R2 and have been granted access to the server, but I don't see how to connect to the server. I can access SQL Management Studio fine, but I need to access the server to restart some services.
Thank you.
December 27, 2011 at 8:33 am
Is the server local (same computer as Management Studio) or remote (different computer)?
If remote, is it on the same Windows domain as the computer with SSMS (Management Studio), or a different domain? If remote, is it in the same LAN, or are you connecting to a remote location?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 27, 2011 at 8:35 am
It is on the same local server as SQL Management Studio
December 27, 2011 at 9:05 am
If you want to restart SQL Server services (SQL Server, SQL Agent), you can do that from within SSMS, by right-clicking the appropriate item and selecting Restart.
Other services, you right-click Computer (My Computer in some versions of Windows), and selecting Manage.
If your accessing SSMS and SQL Server on the same machine (either a local workstation or via remote desktop), you should be able to get to either of those. Assuming you have the necessary rights on the machine.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply