SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Proxy account for sql sever account


Proxy account for sql sever account

Author
Message
anoop.mig29
anoop.mig29
Old Hand
Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)

Group: General Forum Members
Points: 381 Visits: 155
Is it possible to create proxy account for sql server login/account or it could be only created for windows login/account
Dawn W
Dawn W
SSChasing Mays
SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)

Group: General Forum Members
Points: 615 Visits: 606
Are you talking about application access to a database, an agent job, or ??? We generally create windows service accounts for both unless an application vendor has a specific need.

Give us some details, you'll likely get a better answer.
anoop.mig29
anoop.mig29
Old Hand
Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)Old Hand (381 reputation)

Group: General Forum Members
Points: 381 Visits: 155
dwilander (10/22/2013)
Are you talking about application access to a database, an agent job, or ??? We generally create windows service accounts for both unless an application vendor has a specific need.

Give us some details, you'll likely get a better answer.


actually at client side they are going to use third party software for aduit purpose.that 3 part has provided us with document according to which i have to carry down following steps

To collect events using a non-administrative SQL Server 2005/2008 database account:
1 Create a new database user account called sqlaudit.
2 Set the default database of this user to master (from the User Mapping tab, check the box in the Map column for the master database).
3 Grant this user (sqlaudit) Connect, Execute, and Select permissions.
4 Enable the proxy account to the same user (sqlaudit). (SQL Server -> Properties -> Security ->enable proxy account)
5 Go to SQL Server -> Properties -> Permissions and grant the user permission to Alter trace

can you plz guide on steps 3 and step 4

reagrds
Anoop
Dawn W
Dawn W
SSChasing Mays
SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)SSChasing Mays (615 reputation)

Group: General Forum Members
Points: 615 Visits: 606
Generally to get a third party app to work you need to follow their directions. It sounds like they want access to the Master database....? I would ask them why. If you google 'setting up sql server accounts and permissions' you will find lots of information on creating accounts.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search