StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>It turned out to be a permission issue.</p> <p>I changed in php.ini the option fastcgi.impersonate to 0 and try with different application pool identities. It worked as Local System. This is an account with more user rights than the Network Service or Local Service account. However, be mindful that running an application pool under an account with increased user rights presents a high security risk. For further references on the accounts and how to configure check out this articles:</p> <p><a href="http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/f05a7c2b-36b0-4b6e-ac7c-662700081f25.mspx?mfr=true" rel="nofollow">Configuring Application Pool Identity with IIS 6.0 (IIS 6.0)</a> <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms684188%28v=vs.85%29.aspx" rel="nofollow">Service User Accounts</a> <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms685981%28v=vs.85%29.aspx" rel="nofollow">Service Security and Access Rights</a></p> <p>I decided to set it back to Network Service and downloaded Process Monitor *. I then used it to monitor the process w3wp, which showed me this was getting access denied on a registry key where the path to sqlncli.dll is stored.</p> <p>HKLM\Software\ODBC\ODBCINST.INI\SQL Native Client 10.0</p> <p>So I opened RegEdit and located that key</p> <p>I did right click - > Permissions and added Network Service to the list and gave it Read permissions.</p> <p>Recycled the app pool and it is now working!</p> <p>Hope this helps! Federico </p> <p>*There's a very good step by step article on how to use process monitor here.</p> <p><a href="http://www.iislogs.com/articles/processmonitorw3wp/" rel="nofollow">http://www.iislogs.com/articles/processmonitorw3wp/</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload