June 8, 2010 at 2:26 pm
I am not able to connect to SSMS in one of my prod server.
But i am able to connect to this SSMS from another server .
If i go start->Al Programs->Microsoft Sqlserver 2005->here only 'Configuration tools' are available, no SSMS.
I need to connect the SSMS in the same server.
please help me to resolve this.
June 8, 2010 at 2:49 pm
Looks like you haven't installed "client tools". Try installing them, you need these for SSMS
June 9, 2010 at 3:17 am
But i am able to connect to this SSMS from another server .
You are not connecting to SSMS, you are connecting to SQL Server.
Think client tool is not installed in your server.
June 11, 2010 at 1:38 pm
thanks for the information.
Client tools means again i need run setup.exe?
June 26, 2010 at 3:17 am
On teh Components to install dialog during the setup select the option : Workstation tools, Books Online and development tools and click on the Advanced tab at the bottom.
Under the Client Components node, select the client tools which you want to install and proceed further.
June 26, 2010 at 5:30 am
There's no good reason to install client tools on a server at all. Connect to the server from your workstation, put the client tools on the workstation, not the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply