Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
how to disable windows authentication in sql...
14 posts, Page 1 of 2
1
2
»»
how to disable windows authentication in sql server 2005 Active active cluster
Rate Topic
Display Mode
Topic Options
Author
Message
forsqlserver
forsqlserver
Posted Wednesday, November 25, 2009 12:08 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
how to disable windows authentication in sql server 2005
I know Disabling is not possible but I want to prevent the windows authentication...in Active active cluster of sql server 2005 and I cannot delete anything just check uncheck the properties...
Please Help...
Thanks
Post #824324
joeroshan
joeroshan
Posted Wednesday, November 25, 2009 12:20 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 573,
Visits: 1,169
windows is recommended authentication for SQL server.
However you must have your own reason to opt not to do so.
In SQL server only users / groups that are granted access explicitely can connect to the server.(bultin\admininistrators are added default, but you can revoke this also)
But be careful with credentials that are used by the services . Do some researches before doing so.
-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #824333
forsqlserver
forsqlserver
Posted Wednesday, November 25, 2009 12:26 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
(bultin\admininistrators are added default, but you can revoke this also)
How Can I revoke it....?
Thanks
Post #824336
joeroshan
joeroshan
Posted Wednesday, November 25, 2009 12:37 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 573,
Visits: 1,169
http://support.microsoft.com/kb/263712
-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #824344
forsqlserver
forsqlserver
Posted Wednesday, November 25, 2009 1:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
I have read it , it is very well.
How to create the cluster service account as a login in SQL Server...?
Thanks
Post #824369
joeroshan
joeroshan
Posted Wednesday, November 25, 2009 2:07 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 573,
Visits: 1,169
Find out which is the cluster service account from services.
Sp_grantlogin 'domain\account'
use master ;
sp_adduser 'domain\account'
-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #824376
Schadenfreude-Mei
Schadenfreude-Mei
Posted Wednesday, November 25, 2009 4:11 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, March 21, 2013 8:40 AM
Points: 1,099,
Visits: 1,320
Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.
You also ask about adding users which you should know how to do if you are doing stuff like this. But want to add the type of user (AD) that you say you want to disable; and are now talking about cluster service users.....
Be very careful you know what you are doing and have authorisation otherwise your future might not be so rosey.
What exactly do you want to accomplish and why?
Adam Zacks
-------------------------------------------
Be Nice, Or Leave
Post #824410
Eduard
Eduard
Posted Wednesday, November 25, 2009 4:23 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, November 20, 2012 5:00 AM
Points: 103,
Visits: 213
Schadenfreude-Mei (11/25/2009)
Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.
You also ask about adding users which you should know how to do if you are doing stuff like this. But want to add the type of user (AD) that you say you want to disable; and are now talking about cluster service users.....
Be very careful you know what you are doing and have authorisation otherwise your future might not be so rosey.
What exactly do you want to accomplish and why?
my interpretation is that his/her question is clumsy formulated and he/she wants to know if it is possible to keep a sql server in a windows cluster environment clean from windows system administrators and keep it for dba's "only". i'll read the proposed solution link later but the issue i had (and perhaps is solved in the ms article) is that the health check needs in the standard setup sysadmin rights. and the health check is done with an account to which system administrators have access.
Post #824417
Schadenfreude-Mei
Schadenfreude-Mei
Posted Wednesday, November 25, 2009 4:31 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, March 21, 2013 8:40 AM
Points: 1,099,
Visits: 1,320
Eduard (11/25/2009)
Schadenfreude-Mei (11/25/2009)
Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.
You also ask about adding users which you should know how to do if you are doing stuff like this. But want to add the type of user (AD) that you say you want to disable; and are now talking about cluster service users.....
Be very careful you know what you are doing and have authorisation otherwise your future might not be so rosey.
What exactly do you want to accomplish and why?
my interpretation is that his/her question is clumsy formulated and he/she wants to know if it is possible to keep a sql server in a windows cluster environment clean from windows system administrators and keep it for dba's "only". i'll read the proposed solution link later but the issue i had (and perhaps is solved in the ms article) is that the health check needs in the standard setup sysadmin rights. and the health check is done with an account to which system administrators have access.
I understand that for what ever reason he/she wants to keep other AD users out but what i dont get is why? This person obviously isnt the main dba as they dont have delete rights and so why are they doing this?
We (the dba's) dont own our boxes, we are responsible for them yes , but we cant lock out other IT admins (though it is tempting).
My point was, why is a junior dba undertaking a task which could have serious repercussions on a production server.
Adam Zacks
-------------------------------------------
Be Nice, Or Leave
Post #824420
joeroshan
joeroshan
Posted Wednesday, November 25, 2009 4:47 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 573,
Visits: 1,169
Ajay,
What others are telling is right. If you are just looking at the possibility its fine. But you have plan to do it right out on a production database, I recommend other wise.
-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #824427
« Prev Topic
|
Next Topic »
14 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.