"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:Oh**************@TK2MSFTNGP06.phx.gbl...
The clients use integrated security.
data source='SQLSERVER\SQLEXPRESS';initial catalog=tbrPData;integrated
security=SSPI
The problem is on the third client I get
Exsecute perimission denied on sp message.
It also uses integrated security.
How do I find out what user this client is accessing the DB with???
If you are using integrated security, the user that is used to access the
database is the same one that is logged in to Windows and executes the
program.
If you need to find who the user is from the point of view of the Sql
Server, download from Microsoft "Sql Server Management Studio Express". Run
it and connect to your server, and in Object Explorer expand the node
"Management" and then right-click on "Activity Monitor" and select "View
Processes". You will see all the connections to your server, and one of the
columns shows the user that opened each connection.