how to use process monitor to find access denied

This means that the SQL Server instance will listen on all the IP Addresses that the server/machine is configured to listen on. Now there is a catch here! If you see the screenshot, you will notice that the Listen All property is set to YES. Or you could even use SQL Server Configuration Manager (SQL Server 2005 and above) to figure out the TCP/IP settings of the SQL instance. You could look into the SQL Server Errorlog and quickly look up the phrase “ is listening on” and find lines of the following nature: And this is one of those scenarios where the adage “ There are multiple ways to skin a cat” holds true. This is probably the easiest question to answer for any SQL Server DBA. I thought this would be a good issue to blog on in case some one else ran into a similar issue! And which is why we got the weird error listed above. Since the registry key could not be read, the object was not created. I found that there were Access Denied messages in the Process Monitor trace but they were not being bubbled up to the user (see screenshot below)!Īs you can see above, the access denied was on the SQL Server TCP/IP registry key and the WBEM keys. I used Process Monitor to trace the registry activity of cscript.exe and wmiprvse.exe which actually works in the background to perform the tasks mentioned in the VBscript. Now let us look under the hood a bit! I naturally was curious as to why the access denied message was not being thrown back to the user. So when running such VBscripts, do not forget to use RunAs Administrator option! With a little bit of troubleshooting, we figured out that the RunAs Administrator (it can really catch you off-guard) option was not used to launch the command prompt.

Now the above error is not the most intuitive of error messages considering the fact the object is being assigned a value in my VBscript.

SQL_PortChange.vbs(52, 1) Microsoft VBScript runtime error One of my colleagues told me that the script was failing due with the following error message: doing the same tasks in Powershell is much easier! Phew… Now let me get back to my story! Powershell was not in existence in those days and yes…. Before you start throwing brick bats at me…. I had written a script a while back which would set the TCP/IP port for a SQL Server instance.

How to use process monitor to find access denied