October 22, 2013 at 12:18 pm
Is it possible to create proxy account for sql server login/account or it could be only created for windows login/account
October 22, 2013 at 5:45 pm
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.
October 22, 2013 at 10:29 pm
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
October 23, 2013 at 8:21 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply