Linked Server - login trying to access database that is not default
I would also change the parameters as follows:


@srvproduct = 'sql_server'
@provider = 'SQLNCLI' if you're coming from 2005 (and 'SQLNCLI10' from 2008/8R2, and 'SQLNCLI11' from 2012, etc.)
@provstr can be removed entirely; it's not necessary with this product and provider; your linked server logins will handle that.


Whatever SQL Server login is being used by the linked server probably has an offline/removed default database.  Change the default database for that login to one that exists and that the user has permissions to and try again.

This is a guess, as you didn't post the CREATE USER script that generated the particular username logging in.