Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
craminder
Starting Member
4 Posts |
 Posted - 2009-07-09 : 06:10:41
|
| Hi,I have created a service and given an identity to run under. Now, Whenever service code tries to connect to database an exception 'Access Denied' is thrown. I have added the identity user to a group which have proper access rights on the database.How can I find that which user identity is actually trying to access the database so that I can trace the problem? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-07-09 : 15:11:16
|
| Do a SELECT SUSER_SNAME()--------------------------------------------Brand yourself at EmeraldCityDomains.com |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-07-10 : 10:30:33
|
| You can monitor login failed events by using SQL Profiler. |
|
|
|
|
|
|
SQl Server Security: User Identity