Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Proxy account for sql sever account Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 12:18 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135
Is it possible to create proxy account for sql server login/account or it could be only created for windows login/account
Post #1507280
Posted Tuesday, October 22, 2013 5:45 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:34 AM
Points: 320, Visits: 434
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.
Post #1507429
Posted Tuesday, October 22, 2013 10:29 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135
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
Post #1507460
Posted Wednesday, October 23, 2013 8:21 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:34 AM
Points: 320, Visits: 434
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.
Post #1507660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse