Is this a SQL remote connection?

At work Friday, I used Terminal services to connect to client machine. I then started SSMS and connected to a DIFFERENT server server.

Is this called a "remote connection"? What are the rules in terms of how I am authorized to access that SQL server.

The server server I connected to was in the same domain and the domain I logged into.

more ▼

asked Dec 02, 2012 at 10:56 AM in Default

avatar image

10 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The phrase "remote connection" could mean a lot of things, simply having SSMS installed on your Client PC and connecting to a different computer with SQL Server installed is remote, rather than local where the SSMS and the SQL Server components are on the same computer.

you could also use the term remote connection when connecting to a SQL Server via RDP or Terminal Services, as in you scenario. Whether this then connects to a SQL Server on the computer you are connected to or you then make another hop to another computer is yet another alternative.

At all times when you connect SSMS to SQL Server you have the option to connect using Windows Authentication or SQL Server authentication. This choice is what affects the authorisation process and if/how you get access.

you could connect your TS/RDP session as a windows user and then start SSMS and use SQL Server authentication (supplying the username and password of the user you want to connect as) or if you choose windows authentication then the user credentials that you are using for the TS/RDP session will be passed to the SQL Server to control your access privileges.

It is your choice.

more ▼

answered Dec 02, 2012 at 11:26 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

Thanks!! I was VPN'ing in to a network using terminal services and then using Remote Desktop to launch SSMS. I am setup with a windows user I'd and password but when in SSMS, I connect to not the local but SQL on a server w in domain, how does it validate that I have access? Thanks for answering my questions!!

Dec 02, 2012 at 11:35 AM YYCGIRL99

It doesnt matter which SQL Server you are connecting to,it it the authentication method that you choose when you start SSMS that controls your authentication. If you select Windows then the SQL Server will confirm your logged on account for AD credentials and assign permissions accordingly. If you choose SQL Server authentication then it references the security settings in Master and give those permissions.

Dec 02, 2012 at 11:41 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 02, 2012 at 10:56 AM

Seen: 825 times

Last Updated: Dec 02, 2012 at 12:03 PM

Copyright 2018 Redgate Software. Privacy Policy