Just updating the thread to show my solution

Not the most elegant solution, but it works....

-- For the sake of testing I have used table variables

DECLARE @Table1 TABLE ( ID INT...

Thanks for the reply's.

Wayne's solution looks closest to what i am after, but i think it'll need a little tweaking. I'll keep you all updated with how I get...

A few of things you can try;

- Try changing the default tcp port from 1433

- Disable windows firewall     Control panel => Administrative tools => Services    and stop windows firewall.  Or if...

The script I am using is as follows;

if not exists (select * from dbo.sysusers where name = N'User' and uid < 16382)

EXEC sp_grantdbaccess N'User', N'User'

GO

Seems like the problem is with the server being on a different 'Domain'

I will post more info when I finish troubleshooting it

Im using an 'alias' with a hard coded IP and port so I have the browser service disabled.

Although saying that,  I started off by using the Browser service, but didn't...

Just to clarify where I am and what I have tried

Basically on the remote computer I log in with "sa" and it says it connects, but it doesn't look/behave like...

 Surface Area Configuration is setup correctly (on the server):

Database Engine/Remote Connections => Local and Remote Connections - using both TCP/IP and named pipes.