clarion
|
| Posted: 05/06/2002, 6:50 AM |
|
I have a site running on a local intranet on NT4 and SQL Server2000 on the same server. This has been running fine for some time. Now I am getting the following error:
------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'MICS\IUSR_MICS'.
/ads/ar/Common.asp, line 29
------------------------------------------------------------
The IUSR_MICS login is defined in SQL Server and has the appropriate rights to access the database just as it was before this error occurred.
What should I do?
I appreciate your advice on this....
Thanks & Regards...
|
|
|
 |
Nicole
|
| Posted: 05/07/2002, 4:15 AM |
|
Clarion,
what is your SQL Server authentication settings? Is it set to 'Windows NT Authentication' or to 'SQL Server authentication'? On this setting depends connection to db established in CC project.
In case you use 'Windows NT Authentication' the connection settings in CC should be like described below. In Data Link Properties window on Providers tab select 'Microsoft OLE DB Provider for SQL server', on Connection tab select 'Use Windows NT Integrated security'. Click 'Test Connection' to verify connection. Is it successful? If yes, then you can return to Site Properties/Database tab.
Check you have logged in correctly.
If you use 'SQL Server authentication' the settings in Data Link Properties window on Providers tab are the same, on Connection tab select 'Use a specific User name and Password' option and enter login and password. Verify connection. Is it successful? Try to use this approach.
Once connection is successful for server part connection select "Same as design".
Also keep in maind that you need to give the IUSR_MISC account access to the database. The ASP pages are logging in using that account.
|
|
|
|
clarion
|
| Posted: 05/07/2002, 8:10 AM |
|
I have the SQL Server authentication set to 'Windows NT Authentication'. The IUSR account is defined as a login with enough rights in SQL Server.
I somehow managed to fix the situation by disabling 'Password Synchronization' from the Internet Services Manager and setting it manually. Now it works.
The problem now is that users on Win98 machines can connect and browse ok. When Windows 2000 Professional users connect, they are prompted for a password. What gives?
Thanks & Regards...
|
|
|
|
|
