Bring up Windows Services on the SQL Server - Start | Administrative Tools (which may be in Control Panel) | Services, scroll through the list until you find "SQL Server...

Have you verified the service is running? SQL Server FullText Serach (MSSQLSERVER) or whatever instance name you are working with

I don't want to step on dbaduck's toes, but if you are like me and working in a "mom and pop" environment, the funds are a bit tight.

Below is the...

Have you investigated running the Upgrade Advisor Tool to get a clearer picture of what will/will not fail?

Have you tried to do a search on manually removing an installation of SQL 2005? More than likely there is a registry holding a key.

In your case, it is more than likely that the firewall on the 2008 server is stopping incoming. Turn off the firewall and test.

.

You may have a bad DNS, try changing the protocols, use the IP address to test.

If you want to do it with brute force, for the last db, can't you do something like:

Use Master

Alter Database DB_NAME

SET SINGLE_USER With ROLLBACK IMMEDIATE

And include the...

If you are struggling with space on the source server, as you mentioned AND do not have all of the transaction log files for a full and complete restore on...

The only issue(s) I can come up with on the backup/restore method is

1. You will need to modify the file name on the new database otherwise SQL will tell you...

Have you attempted to reregister the .dll?

For the SQL 2000 installation, can you take a look at the following:

http://support.microsoft.com/kb/870617

As for the SQL 2005/2008 installations, the registry key, if turned on prior to installation, is...

You will need to use a command line installation. Please review the following document from Microsoft

http://support.microsoft.com/kb/2020443

Like John, (I am not promoting this particular product) we use a third party application called Apex SQL Diff to keep our DEVSQL and SQLQA servers in check. Extremely...