Post reply

SQL Security

  • March 19, 2009 at 10:40 am

    #136019

    Hi,

    Can any body clearify that why would a SQL Server services account and cluster services account have to use a SQL Logins and not a Window login.

    Thanks

  • March 19, 2009 at 12:40 pm

    #963015

    😀

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • March 19, 2009 at 5:26 pm

    #963228

    soofy21 (3/19/2009)

    Hi,

    Can any body clearify that why would a SQL Server services account and cluster services account have to use a SQL Logins and not a Window login.

    Thanks

    I am not sure what you mean? If you are talking about the service account which runs the MSSQLServer service on your computer it must be a window account it cannot be a SQL Account.

    For a cluster it actually has to be a DOMAIN account or it will not work.

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

Viewing 3 posts - 1 through 2 (of 2 total)

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