July 29, 2011 at 12:05 pm
Why did i have no management studio on production server? But i can connect to mgmt studio of that(production) server through logging to other server.whats the reason for not having mgmt studio in production server?
July 29, 2011 at 12:13 pm
There can be a couple of reasons
1. The person installing SQL didnt select the option to install SSMS.
2. It was not installed for a specific reason. Some Org's dont allow RDP therefore SSMS on the server is not needed.
Oh, one more
3. It was uninstalled?
July 29, 2011 at 1:18 pm
RDP is allowed for that server. If it is not installed how can i able to connect to mgmt studio of that server through other server
July 29, 2011 at 1:22 pm
yes you'll be able to connect to that server from another install of ssms.
July 29, 2011 at 1:26 pm
clarification (7/29/2011)
RDP is allowed for that server. If it is not installed how can i able to connect to mgmt studio of that server through other server
If SSMS is installed on another PC/Laptop/Server then you can connect to it buy entering the SERVERNAME\INSTANCE .
If you can not connect, it maybe worth checking the configuration setting.
July 29, 2011 at 1:33 pm
SSMS ALWAYS connects remotely to SQL Server instances as a client. Even if you run it from the server, it is making a connection to the service running on that machine. It isn't a part of the SQL Server instance.
You connect from a remote system the same as from a local system. Enter the server (and instance) name in the connection dialog.
July 29, 2011 at 3:52 pm
My question why dont they install SSMS on that server.what is the reason may be?
July 29, 2011 at 4:04 pm
There are companies that don't want administration done from the server, so no client tools are installed.
July 29, 2011 at 4:07 pm
ok got u. my understanding is they dont want to overload the server
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply