Last post Dec 19, 2009 01:14 AM by Rakeshkr
Dec 18, 2009 09:49 AM|Nanduzzo|LINK
i'd tried to install my web application on 2 different pc:
1. Win XP, IIS6, SQL Server 2008 Express
2. Win XP, IIS6, SQL Server 2005 Express
I had created a new user "MYUSER" in windows and i give to it the correct access role to the DB.
In the web.config i had also specified the identity with the right tag <identity impersonate="true" userName="MYUSER" password="password" />.
But now I have a problem. My application works only on the first pc! In the second one (with SQL2005) the application generate the error "Cannot open database "DATABASE" requested by the login. The login failed. Login failed for user "PCNAME/MYUSER ."
Have you got any ideas?
Thank you very much (and sorry for my english )
Dec 19, 2009 12:40 AM|Waqar_ali|LINK
This user dont have rights to access sql server instance from outside, provide proper permissions, or add aspnet user and IUSR user in your application directory secutriy.
You are using windows Windows authentication for sql server connection,
you have to use sql server authentication( provide username and password in your connection string).
Dec 19, 2009 01:14 AM|Rakeshkr|LINK
i think u have to use sqlserver authentication mode.
check ur sqlserver database security Authentication mode and change is to mixed mode
create login for sql server mode like userId sa and password pwd and assign it to asp.net config file where u r setting connection configuration