When I started at my current company, they had the ALL of the development and system test SQL servers setup on VM. 

They were having connectivity issues. ...... but I noticed that the...

SOLVED!

OK, it was not a linkserver issue, but a 64bit to 32bit issue.  

Ran the instcat.sql file in the SQL Server 2000 Service Pack 4.  It upgraded my master databases...

Thanks for the final post.....this solves the problem of Microsoft hard coding the location of the Master/Model/tempDB in the program files directory on my C drive.    While I could change...

Tried it and it didnt work. 

Also tried to set remote transactions

sp_configure 'remote proc trans', 1

and that didnt work either. ...

Acutally I was able to define a view on the information schema, then access it using a synonym on the remote server

It is the down grade that I am really worrying about, but if they are still using the same backup architecture, it just reads disk so it shouold theoreticaly be...

Thanks

That does work for problem number 1.

Problem number two is trying to use information_schema.columns across the link server?

Eric

My 2 Cents.....

Both would work for you.  

Taking just one administration class, will leave you with minor gaps, as the majority of the concepts like backups and recovery are the same.  

2005 adds...

Did you setup your hosts file to point to the secondary server?

also, sqlserver2005 dosent have remote access setup by default.  you have to enable it thru the configuration manager under...

Thanks

It is good to know that we can change the file location.   We are using a Virtual Machine for the testing, and there is always a problem or two with...

After I change the database file location the system returns the new location.

then reboot.....

and I cannot get back in to the SQL Server

I am wondering if anyone has actually changed...

Thanks for the reply.

The above commands were executed.   The database was shutdown and restarted. 

The problem is that the Server dosent restart with the error message: The server has...

Here are some things that I track in a few triggers

select

getdate() , host_name()