SQL Server does not exist after moving to new Sql Server

[Geoff]

All my pages come up with "SQL Server does not exist or access denied" after
moving to a new Sql Server with a different name. None of my pages come up
even though I am addressing the servername by IP Address. I can access the
Server through Enterprise Manager and Query Analyzer using the same IP. I've
also made sure the changes were made in Web.config. It worked fine before
the switch.

 

[Guest]

Geoff,
Ensure that the new SQL Server is set up for "Mixed Mode" authentication -
both Windows and SQL server logins.
Peter

 

[Geoff]

It is set up for mixed mode and I can access the server through Query
Analyzer, Enterprise Manager and my .asp pages are still able to connect
through ODBC without a problem.

 

[Patrick.O.Ige]

Maybe try re -registering your new database name.
And make sure you have the right permissions set
Patrick