ADODB SQL Server connection not working only in IE

问题:

Got a bit of an odd problem.

This code works fine in every other browser, just not in IE9. Standard ADODB connection string being used:

Provider=sqloledb;Server=localhost\sqlexpress;Database=DB;uid=DBuser;password=DBPassword;MultipleActiveRecordSets=true;

Executed thus:

Dim dbGlobal
Set dbGlobal = Server.CreateObject("ADODB.Connection")
dbGlobal.Open sConnectionString

In every browser this works and the application then goes on to load, in IE9 I get the following error message back:

-2147467259: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

回答1:

Well with the help of the following answer on SO (http://stackoverflow.com/a/260861/418151), I managed to get a work around. As per that answer I tried running IE as admin and now it connects fine to the SQL Server!

I can only assume that in the last week or two I've installed some Windows Update that has slightly altered the permissions of SQL Server and/or IE9.

Still got no idea why exactly I now have to run IE as admin in order to connect to SQL Server!?