June 4, 2014 at 10:50 am
Hi,
My company provide me laptop. I took the trace for a SP.
SELECT * INTO MyTraceTemp
FROM ::fn_trace_gettable('C:\Users\username\Downloads\MYtrace.trc', default).
It is showing that File 'C:\Users\username\Downloads\MYtrace.trc' either does not exist or there was an error opening the file. Error = '5(Access is denied.)'.
I am the admin for this system. If I want to provide permissions for this file how can I give permissions.
I am connecting to the SQL Server from my local SSMS. I don't have remote desktop access.
I am not able to save the trace file in C-drive
June 4, 2014 at 11:14 am
Whatever account that is running SQL Server on your laptop does not have permissions on the directory you mention. Look in Services to see what the account you need to grant permissions on the directory to, and grant them read rights. Remember, you are connected to SQL Server as your login, but SQL Server is not proxying your credentials to any other service (Filesystem in this case).
June 4, 2014 at 1:16 pm
Thanks for you quick reply.
I am using windows 8. So from the task manager I can check the services. From that service tab I am able to see that SQL Server is running but it is not showing any further details under the group column. For some services, I can see that local service & for some Local system like under group column but there is nothing for SQL service.
I tried to check from the SQL Server configuration manager but I am not able to see. I am attaching that error msg here
Msg: Can't connect to the WMI provider. You don't have permission or the server is unreachable
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply