JnavarroMc
asked on
IIS 6.0 Wrong user/password
Hello!
I have an IIS 6.0 server based on Windows 2003 Enterprise SP2. We have cloned the server because we need a controlled testing environment but when trying to change the connection string in the application to redirect to another database name (the database is only being renamed in another environment). There is a login problem with the application
Working:
Not working:
Not working:
The app's website always loads but when I make changes to the connection string I always have the same problem with the login: Wrong user/password or no access to the system
I'd really appreciate it if you could help me find out where the mistake might be
Regards,
JN
I have an IIS 6.0 server based on Windows 2003 Enterprise SP2. We have cloned the server because we need a controlled testing environment but when trying to change the connection string in the application to redirect to another database name (the database is only being renamed in another environment). There is a login problem with the application
Working:
<add name="CC_DBAUSA_SOL2" connectionString="Data Source=SERVER1;Initial Catalog=DB1_A;User ID=test;Password=test1" providerName="System.Data.SqlClient"/>
<add name="CC_DBAUSA_SOL3" connectionString="Data Source=SERVER1;Initial Catalog=DB1;User ID=test;Password=test1" providerName="System.Data.SqlClient"/>
Not working:
<add name="CC_DBAUSA_SOL2" connectionString="Data Source=SERVER1;Initial Catalog=DB1_A;User ID=test;Password=test1" providerName="System.Data.SqlClient"/>
<add name="CC_DBAUSA_SOL3" connectionString="Data Source=SERVER1;Initial Catalog=ALIAS;User ID=test;Password=test1" providerName="System.Data.SqlClient"/>
Not working:
<add name="CC_DBAUSA_SOL2" connectionString="Data Source=SERVER2;Initial Catalog=DB1_A;User ID=test;Password=test1" providerName="System.Data.SqlClient"/>
<add name="CC_DBAUSA_SOL3" connectionString="Data Source=SERVER2;Initial Catalog=DB1;User ID=test;Password=test1" providerName="System.Data.SqlClient"/>
The app's website always loads but when I make changes to the connection string I always have the same problem with the login: Wrong user/password or no access to the system
I'd really appreciate it if you could help me find out where the mistake might be
Regards,
JN
ASKER
The servers are on the same network. When I use the SQL profiler and put the string in without reconfiguring, I was able to audit the login.
When I reconfigure the connection chain I don't have any kind of event. No login failure or successful login. (I've even backed up the databases and hosted them on another server with the same permissions but I haven't managed to log any audit events on the other server.)
Is there any type of configuration in the IIS that is not specified in the web.config?
When I reconfigure the connection chain I don't have any kind of event. No login failure or successful login. (I've even backed up the databases and hosted them on another server with the same permissions but I haven't managed to log any audit events on the other server.)
Is there any type of configuration in the IIS that is not specified in the web.config?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Double check the user you are using can login via ssms and access the new catalog.
Double check you granted the user in the new environment the same rights on the database as this user has in production.
Look at the SQL server logs if you audition login/logout access to db.