We have an environment with SQL 2005 and SQL2008 instances - failover 2 node cluster 64 bit.
We installed a new web application and we cannot connect to the databases on the SQL2005 instance.
We are able to connect to the database using the same credentials used by the web site using a udl file and using SQL Management Studio. However, the web site tells that we do not have authorisation to access the web site.
I wonder whether there is something to do with the fact that we have the two SQL versions on the same environment.
We had a similar problem on another mixed environment. On that particular case the connection failed on a SSIS package. We tried the same package on a SQL2005 and the package ran.
If the mixture of the two versions is affecting new applications to connect to the databases, is there a way around to resolve this problem? Unfortunately, the environments contain live databases.
Thank you in advance for your help.
View Complete Post