I am testing a website (that was developed with SQLExpress) against SQL2005 Enterprise. I have created a new connection string to connect the site to a new SQL2005 database. But the site's Login.aspx seems to still call a hidden SQLExpress database to check permissions and generates the following error:
Server Error in '/TestDB' Application.
Cannot open database "[TestDB]" requested by the login. The login failed.
Login failed for user 'Test\Tester'.
How I declare in Web.config to move the hidden SQLExpress security/membership/role management to the new SQL2005 Enterprise database?
Thanks for any help.
...
Go to the complete details ...