Central Management Server Security

Question

Central Management Server Security

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
December 23, 2013 at 8:26 pm

#302582

Comments posted to this topic are about the item Central Management Server Security
December 24, 2013 at 1:32 am

This was removed by the editor as SPAM

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Nice question

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

Thanks Steve for a nice question. Have to do a little reading before attempting this 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 3

Nice question, I even did a test to ensure myself.

Note: Even though there is possibility to register a server with SQL Authentication to the CMS, on executing a query against the CMS there is an error message "The server is not connected".

Thanks,

IgorMi

Igor Micev,My blog: www.igormicev.com

steve.jacobs SSCommitted Points: 1830 More actions · Answer 4

steve.jacobs

SSCommitted

Points: 1830

December 24, 2013 at 6:19 am

#1675765

Nice one. Thanks.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 5

Good question. I confess that I saw Central Management Server, and dismissed it as a dummy name for the servers related to SQL Server CENTRAL. Sigh.

At least I learned something. Thanks Steve.

Merry Christmas to all!

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

sestell1 SSChampion Points: 10230 More actions · Answer 6

Argh, found information on the internet that is wrong!! Can you believe it? :crazy: :hehe:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

sestell1 (12/24/2013)
Argh, found information on the internet that is wrong!! Can you believe it? :crazy: :hehe:

Blasphemy - everything on the net is true:hehe::hehe:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ken SSCoach Points: 17191 More actions · Answer 8

Nice question. Had to do a bit of research on this one. Happy holidays all!

Revenant SSC-Forever Points: 42467 More actions · Answer 9

A good one. Thanks, Steve, and Merry Christmas to all.

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 10

PChiragS

SSCarpal Tunnel

Points: 4965

December 24, 2013 at 11:30 am

#1675810

Nice question..Steve.

Happy Holidays to all.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 11

Maybe with my poor understanding of the English language I missed something , but what about the following link ?

http://connect.microsoft.com/SQLServer/feedback/details/381185/doc-central-management-server-does-not-require-windows-auth

It was a Microsoft Connect feedback created by Aaron Bertrand who wrote

Microsoft closed the connect as someone of the SQL Server Team has modified the documentation

"I have removed the content that incorrectly documented the requirements for use of Windows Authentication. The change will be published in Books Online for SQL Server 2008 R2"

Unless there is a novelty with 2012 or 2014

Have a nice day

PS : I have forgotten : happy Christmas for everybody ( I am in the 25th of December now )

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

Nice question, thanks.

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 13

Had to do some R&D to figure this out, as I tried to test it myself, found that I can register CMS with both Windows or SQL Authentication, so I went Google it.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant