Did you try something like below?

ALTER DATABASE dbName SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

Did you try to add MOVE option in your RESTORE clause?

Or did you try to create necessary folders for your restore?

Check the database setting. If it is set to single-user mode, change it multiple user mode.

If it is set in the multiple user mode, check whether or not there is...

A database server is designed for multiple users. I do not think it will automatically be changed to a single-user mode.

Yes, we can set it in the single-user mode...

You may use the same method to migrate data from SQL Server 7.0 or from SQL Server 2000. See the link below.

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

No. Your new password will take effect only after restarting your SQL services.

Here is an article comparing Named Pipes and TCP/IP

http://msdn2.microsoft.com/en-us/library/aa178138(SQL.80).aspx

May it help.

Did you try to use other account to login?

Did you add his account in the local machine?

Did you try the Profiler? Remember to add filter if you decide to use it.

Did you have any chance to read the following article?

http://msdn2.microsoft.com/en-us/library/aa937532(SQL.80).aspx

You may try this one in the following link:

http://www.sqlservercentral.com/articles/Administering/migratingloginstoanotherserver/1140/

Could you use xp_cmdshell command to copy the file directly to your local machine?

Just my input for your reference.

I would like to say, snapshot is not a good candidate. You can use export data to your target server by selecting desired objects. Replication...

It may not be SQL Server-related. You may add an alert using master..xp_fixeddrives in your alert.