I am developing a web app that connects to a SQL 2000 database, everything works perfectly on my database (Which is actually SQL 2008), but when I try to migrate it to another server (which is actually running SQL 2000) I find some weird errors.
The username that uses the web app, so I did my normal troubleshooting steps ...
I reset the password to what it should be, It was ensured that the user is mapped to the database that is trying to connect to it. I was connected to the database using the username and password via enterprise manager and was able to run the queries. I reset the SQL Server
I can be a place in my app, apart from the other ideas, because the password is being changed for some reason to see whether SQL Server knows what the password is Used to be? I just want to narrow down my search.
This or someone has any other suggestions on how I can fix it?
EDIT: Besides, the web app can talk to the database, it hits the database to get the login credentials and it can login with no problem.
Thank you in advance!
First of all, the problem is not that The login user has failed. From your statement, the login succeeded, however, you have said that you have got an exception later when trying to reach some things. The database looks like an authorization / permission problem with the user in which the login is associated and the object that is trying to access it. Have you tried to add the database using the same credentials used by the enterprise manager and the site and execute similar queries to the web application?
Comments
Post a Comment