Migrating a classic ASP's MS SQL database from a server 2003 to a 2008r2 server
-
I have a situation where a classic ASP's MS SQL database has been moved from a server 2003 to a 2008r2. The classic asp application stills resides on a server 2003. Now because I have never done a migrating the only thing I thought I needed to change is the SQL server named IP address in the application's IIS deployed ini file. Currently am using anonymous authentication and the default application pool. The application render's to the browser fine. The problem is the application is not pulling any data for the database. It seems that I have missed something in the configuration process. Has some done this type of migration and if so provide me a list of thing that they have done to configure the application correct and other settings for the migration? Thanks, Steve Holdorf