Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how to reach SQL Server management studio from another computer

Posted on 2014-10-28
4
Medium Priority
?
126 Views
Last Modified: 2014-10-28
Hi,

I have Sql Server installed on one computer on a small network, I will call it computer a,
I have full admin rights to SQL Server and I want to start Management Studio from another computer (computer b) which is on the same network.

Is this possible...?

Thank you
0
Comment
Question by:adamtrask
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Assisted Solution

by:Peter Drespel
Peter Drespel earned 800 total points
ID: 40408689
You will first need to enable remote connectivity to the SQL server you wish to connect to.

Read this articles where it speaks about the steps and also provides how to mitigate issues with this type connectivity,

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
0
 

Assisted Solution

by:Peter Drespel
Peter Drespel earned 800 total points
ID: 40408693
If both the machines are on the same network, you can just add the SQL Sever Instance name in you SQL Management Studio
0
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 1200 total points
ID: 40408710
SSMS (SQL Server Management Studio) it's only a GUI and can be installed in any computer. Then you need to register the SQL Server instances that you want to connect to, so what you need is to install SSMS in the computer B and then register the SQL Server instance that exists in computer A.
0
 

Author Closing Comment

by:adamtrask
ID: 40408766
Thank you
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question