August 29, 2007 at 8:57 am
When I run a query that accesses a database on a remote server, the query runs but takes 1.5 minutes as opposed to seconds it would take if I ran it on the server where the database is located. After running profiler, it states that '20% of consumed workload has syntax errors. Check tuning log for more information' The tuning log states: '[Microsoft][SQL Native Client][SQL Server]Access to the remote server is denied because the current security context is not trusted.'
The query actually runs and works. Trying to figure out why it takes so long and any help on these messages would be appreciated.
September 3, 2007 at 11:32 pm
Check what security context are you using in the link server in case you are using one
Try to create a same login on the other server and give required permissions to execute the context.
September 5, 2007 at 12:25 am
Do you include the login column in the profile trace?
If so, the tuning log may be using this login ...
http://www.eggheadcafe.com/aspnet_answers/SQLServertools/Jun2006/post27098374.asp
September 5, 2007 at 6:22 am
It was bringing all the data back to the calling server and then applying the where clause. This is why the query execution time increased significantly.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply