I have a website running in IIS 6 which is using a web.config file to access the database. The connection String is this:
<add name="Vision" connectionString="data source=VisionAlias; integrated security=True; initial catalog=DatabaseName; Application Name=Forcasting" providerName="System.Data.SqlClient"/>
This connects to a SQL Server 2005 database.
I need to change it to point to a new 2008 database.
I have tried Creating an Alias called "Forecasting" on the 2008 database, and then changing the "data Source=Forecasting;..... however it doesn't work.
I've also tried replacing it with a connection string in the format :
<add name="Apple" connectionString="data source=SQLServerInstance; integrated security=True; initial catalog=DatabaseName" providerName="System.Data.SqlClient"/>
That doesn't work either.
Is there something else I need to change? I have restarted IIS services after each change, and it does make a change (it breaks!), so I know I'm using the right file.