Connecting a remote SQL instant

Is there anyway I can connect to a SQL instant on a remote SQL server from my desktop? (for example: for AD, without login into a server, I can connect to AD using administrative tool)
dongocdungAsked:
Who is Participating?
 
John EastonConnect With a Mentor DirectorCommented:
You can install the SQL Server Management Studio on a PC.  As long as there is no firewall in the way (or the relevant ports are allowed) then you can administer that server remotely.

When you load the management studio you will be prompted for Server Name / IP and logon credentials.  If you are on a domain you can use Windows Authentication (assuming your SQL instance is set up to allow it.
0
 
Mohammed KhawajaConnect With a Mentor Manager - Infrastructure:  Information TechnologyCommented:
Yes you can.  Install SQL Server Management Studio (SMSS) and then connect to the server remotely.  If you have issue connecting then it could be due to the firewall.  Give it a shot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.