Hi Adam,

thanks mate i just found this myself. not that easy to find. I opened up the tcpip and udp ports for 1433-1435 to be sure and...

Additioanlly.

If i put an entry in my hosts file as below.

62.49.61.233homeserver/sql2005

i can connect via isqlw (sql2000) but still unable via 2005 managementstudio.

Cheers

Tim

Erm it is running at work yes. Do i need to open some more ports? i have (before anyone mentions it) put a rule in my firewall to only allow...

AFter restoring the database to a new database did you change the logical filenames for the database and log files?