I believe it is sql server 2005, and I have management studio locally yes
>>Hi all,
>>
>>I have never tried to connect to a local / default instance of sql server remotely? I know about making sure it is configured to allow remote uses, but I always name my instances so am not familiar with this. This is ok is it not? I've got "\\ServerName\(local)" in my connection string but it comes back with error 87 - fails to make the connection.
>>
>>Any feedback much appreciated
>
>What is the SQL Server version on the other SQL Server? Do you have Client Tools (SSMS) installed locally?
Mathias Banda
Time is longer than a rope.