CONNECTing to SQL Server

Question

CONNECTing to SQL Server

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
February 2, 2016 at 8:12 pm

#74804

Comments posted to this topic are about the item CONNECTing to SQL Server
February 2, 2016 at 11:43 pm

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 1

At first I had the server option selected as well.

Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so I removed that tickmark.

Oh well. Apparently my mindreading skills are still not good enough.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 2

Hugo Kornelis (2/3/2016)
At first I had the server option selected as well.
Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so I removed that tickmark.
Oh well. Apparently my mindreading skills are still not good enough.

Yeah, agonized over that for a moment, and ended up guessing he wanted CONNECT SQL as well. Just a lucky guess, though. C'est la vie.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Heh - I was so busy thinking about the endpoint that I forgot to click the database. A lesson to always think about the whole problem and not just focus on the part you're not sure about. :hehe:

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

Hugo Kornelis (2/3/2016)
At first I had the server option selected as well.
Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so I removed that tickmark.
Oh well. Apparently my mindreading skills are still not good enough.

There's also the CONNECT ANY DATABASE which seems to be the same as the CONNECT at the database level. Or am I wrong?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 5

Luis Cazares (2/3/2016)
Hugo Kornelis (2/3/2016)
At first I had the server option selected as well.
Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so I removed that tickmark.
Oh well. Apparently my mindreading skills are still not good enough.
There's also the CONNECT ANY DATABASE which seems to be the same as the CONNECT at the database level. Or am I wrong?

You are absolutely right. CONNECT ANY DATABASE at the server level grants permission to conenct to each and every database on the server as if CONNECT permission had been granted in each individually. See http://www.sqlservercentral.com/articles/Security/111116/[/url] for an article published on this site about the feature when it was introduced.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Hugo Kornelis (2/3/2016)
At first I had the server option selected as well.
Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so I removed that tickmark.
Oh well. Apparently my mindreading skills are still not good enough.

I wondered about it to, and thought that CONNECT SQL would be considered as a variant of CONNECT (with SQL meaning "the instance to whose MASTER database I am currently connected" or something like that). That ws of course pure guesswork - I lay no claims to mindreding skills.

Now if the option had been "SQL" instad of "server" (and maybe that should be "instance" anyway?) it would have been quite clear and also utterly wrong.

Tom

webrunner SSC-Dedicated Points: 31862 More actions · Answer 7

Steve Jones - SSC Editor (2/2/2016)
Comments posted to this topic are about the item <A HREF="/questions/Security/137165/">CONNECTing to SQL Server</A>

Nice question, thanks. I missed Endpoints.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

Stewart "Arturius" Campbell (2/2/2016)
Nice question, thanks Steve
Knew about Server and database, had to check up on endpoints, though.
Learned something new...

So did I.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 10

Good question but I have read it too quickly so I gave only Database as answer. Bad luck...but I would have forgotten Endpoint...