var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: IIS SQL Server connection error (urgent)
I keep getting this error when I try to connect to my SQL Server DB
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.
when I installed SQL Server I set username and password to windows default which is Administrator and no password
the asp files are on IIS (localhost)
connstr = "Provider=SQLOLEDB;" &_
"Data Source=(local);" &_
shouldn't this work?
Do you have a SQL Server Standard account called Administrator? Or you're trying to use Windows account with the same name? If it's the latter, - remove User ID and Password attributes and replace them with Integrated Security=SSPI.
And in connection string you should specify TRUSTED_CONNECTION=TRUE and try using servername instead of specifying local.
KBA to more about it.