I set up a workload group with a resource pool associated who limits cpu usage to 30 % in a sql 2008 r2 environment.
When I start now 1 session in...
Just set up a Win 2008 ent. sp2 server with sql 2008 r2 ent. with large pages on and traceflag -T834 set. Server has 32 GB RAM, SQL instance...
Yes I am sure
Hmm, no, my installation os and sql server 2008 r2 is x64 ????
Removed instant client and installed x86 client (user defined, odbc, oledb + odbc 4 .net) added TNS_ADMIN variable and all works like a charme...
Want to import data from oracle to sql server 2008 r2.
Therefor I installed oracle instance client (11gr2 x64) on the server.
How to find out with profiler what rights are missing for e specific user?
What kind of events do I have to trace ?
I granted a Domaingroup rights in a DB.
If users from this AD group try to connect they geting the above mentioned error.
(Login failed for...
Does the server (not the client) ever closes a connection to a client cause of inactive session (timeout) ?
Separate names with a comma.