SQL Server does not exist after moving to new Sql Server

  • Thread starter Thread starter Geoff
  • Start date Start date
G

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.
 
Geoff,
Ensure that the new SQL Server is set up for "Mixed Mode" authentication -
both Windows and SQL server logins.
Peter
 
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.
 
Maybe try re -registering your new database name.
And make sure you have the right permissions set
Patrick
 
Back
Top