SETSPN

Question

SETSPN

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
October 16, 2014 at 11:08 pm

#100896

Comments posted to this topic are about the item SETSPN
October 17, 2014 at 3:32 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 21 total)

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

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 1

+1

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

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

Nice one to end the week, thanks.

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

Stuart Davies SSCoach Points: 19505 More actions · Answer 3

Took a chance and answered this before my second coffee of the day - got a point - nice end to the week. Thanks Steve

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Umer Akram SSC-Insane Points: 22209 More actions · Answer 4

Umer Akram

SSC-Insane

Points: 22209

October 17, 2014 at 1:47 am

#1753049

Nice question. Thanks for sharing

edwardwill SSCertifiable Points: 5851 More actions · Answer 5

A little bit too server-y, not enough SQL-y. But I got a point anyway.

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 6

Thanks for the question,

easy if you've been messing up with kerberos authentication...:hehe:

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Thank you for the post, Steve, nice one. 🙂

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 8

Oh good I finally got a point this week. A few tough questions this week.

Ashish Kumar Mehta Old Hand Points: 362 More actions · Answer 9

More information on "How to Verify and Register SPN for SQL Server Authentication with Kerberos Connections[/url]"

Xavon SSCrazy Points: 2280 More actions · Answer 10

SETSPN? Isn't that the newest ESPN child network? :hehe:

Nice question to end a troublesome week of QotDs.

OCTom SSChampion Points: 11785 More actions · Answer 11

Xavon (10/17/2014)
SETSPN? Isn't that the newest ESPN child network? :hehe:
Nice question to end a troublesome week of QotDs.

I believe you are correct. It is an all-tennis network. 😉

Tom

Dave62 SSCertifiable Points: 7459 More actions · Answer 12

The connection to SQL Server for this question where I work is that we use the SETSPN utility to solve the double-hop issue. We have ASP.NET applications on a web server and the SQL databases on another server. The web applications use integrated authentication and SPN's must be set so that the users permissions in AD are passed on from the web server where they are authenticated to the database server where the objects they can access are controlled by AD groups.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 13

Thanks so much for the question. Good one to end the week on.

Everything is awesome!