up vote 2 down vote favorite
1
share [g+] share [fb]

Is there a way to register a server to your CMS and use SQL Authentication?

link|improve this question
75% accept rate
feedback

2 Answers

up vote 1 down vote accepted

No, you can't use SQL authentication with the CMS. It's Windows authentication only. It doesn't store any authentication data inside the CMS - it's only a list of registered servers.

link|improve this answer
and no possible workaround? – SQLRockstar May 27 '09 at 18:35
Yeah, sadly no. Same problem with multiple domains without a trust between 'em too. – Brent Ozar May 27 '09 at 19:42
found this connect item, can we get people to vote? connect.microsoft.com/SQLServer/feedback/… – SQLRockstar May 28 '09 at 15:43
feedback
up vote 0 down vote

When you register your CMS there's a drop down with Authentication. Change that to SQL Server Authentication (if I'm understanding you correctly)

link|improve this answer
thanks, but that is just for the connection to the CMS. I am looking to register instances to the CMS, and the option for authentication is disabled. i tried an import/export, but the option was changed (and disabled) upon import. – SQLRockstar May 27 '09 at 17:45
and how the hell do you have 186 points and three badges already? where have i been? – SQLRockstar May 27 '09 at 17:45
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.