var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: I have this error...."Login failed for user"(But sometimes only)
I have IIS Web server and SQL database server on my PC.
When I run my ASP page, sometimes I got the error....
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MYPC\IUSR_MYNAME'.
What puzzled me is that I don't get this error all the time. For the same program, and same configuration, sometimes it turned out okay but sometimes I got this error.
I used mix authentication for SQL database.
Please help me with this...(I am very new to sql database)
I would think it's a network issue, hows your network properties?
But I installed both servers in my standalone PC.
so your running both sqlserver as iis on the same system? would it be possible to reconfigure iis to use a sql-account instead?
It may be you are losing contact with the domain controller. Next time this happens, see if you can ping the DC from both your client, and the server.
Previously, I used local system account for bother servers and dsn file configurations.
After I changed to non-local system account for IIS server, the IIS server is not running anymore.
domain controller.... but both servers are in 1 PC. I am testing on my standalone PC(not in the network).