Administer a remote sql server?

nero120 · 31 Oct 2007 at 13:53

Hey guys,

I need to connect to a remote sql server 2000 instance, can I do this via sql server management studio 2005? The database has been set to allow remote connections.

I've been given the address (MSSQL*******.sql.netbenefit.com) the database number and the username and password.

Any help would be much appreciated.

therubble · 31 Oct 2007 at 14:51

yes u can I do it all the time, just need to makesure the correct ports are open.

nero120 · 31 Oct 2007 at 15:25

Hmm, whenever I try I get the message:

Code:

Cannot connect to *****.sql.netbenefit.com.

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Could it be a problem on my end or on the remote server?

Stelly · 31 Oct 2007 at 15:32

Have you enabled remote management on the server?

On the server!

Stelly

nero120 · 31 Oct 2007 at 15:42

Stelly said:
Have you enabled remote management on the server?

On the server!

Stelly

Actually, it's not my server! But the guy said it was enabled, I don't believe him though!

therubble · 31 Oct 2007 at 16:30

Can you access TCP 1433?

Stelly · 1 Nov 2007 at 09:41

nero120 said:
Actually, it's not my server! But the guy said it was enabled, I don't believe him though!

I wouldnt believe him either, its definately not enabled

Stelly

huppy · 1 Nov 2007 at 11:12

Are you sure the address is correct?

The message you've got 'An error has occurred...... allow remote connections' is the default error message for any connection issue - not just if the server is set to disallow remote connections.

nero120 · 1 Nov 2007 at 12:58

huppy said:
Are you sure the address is correct?

The message you've got 'An error has occurred...... allow remote connections' is the default error message for any connection issue - not just if the server is set to disallow remote connections.

Thanks for the help guys, I'm chasing the issue up with the guy as I think the problem is on his end.