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.
Re: Access 97 to a more powerfull platform!? ...Moving to SQL Server is common when a database "outgrows" ...Design problems are far and away the usual reason why a database ... (microsoft.public.access.gettingstarted)
Re: Copy database ... Best way is either do backup and restore or attach it. ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving... http://www.support.microsoft.com/?id=168001 User Logon and/or Permission... for SQL Server... (microsoft.public.sqlserver.tools)
Re: best method for switching to a new server ... I can get the moving the db thing, no prob, but it's the in between part ... > a Restore... > for SQL Server... >> to move the Sql Server 2K database from the old to the new. ... (microsoft.public.sqlserver.setup)
Re: MOVING SQL 2000 to a different computer, and domain ... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving... http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore... for SQL Server...articles on how to do a SQL move, but I cannot find one specific to my ... (microsoft.public.sqlserver.setup)
Re: Cant read from database ?? ... You also may need to worry about some permissions.... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving... Issues When a Database Is Moved Between SQL Servers ... for SQL Server... (microsoft.public.sqlserver.connect)