remote accee SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben - 24 Jul 2003 02:11 GMT

hi all,
I am trying to access Sql server remotely through Server
explorer... is that possible?
I thank you for your help

Reply to this Message

Richard Cook [MSFT] - 24 Jul 2003 17:41 GMT

Yes.

Just select "Add Connection" on the Data Connections node.

Supply the server name, instance name (if used), user name and password.

Regards

Richard

> hi all,
> I am trying to access Sql server remotely through Server
> explorer... is that possible?
> I thank you for your help

Reply to this Message

Ben - 25 Jul 2003 03:21 GMT

thanks Richard
it's not working , my remote SQl Server is at 68.65.85.69
it seems I can only add connection localy. what am I doing
wrong? I thank you for your help

>-----Original Message-----
>Yes.
[quoted text clipped - 13 lines]
>
>.

Reply to this Message

Richard Cook [MSFT] - 30 Jul 2003 22:49 GMT

I am not sure what the problem is, perhaps the following suggestions may
help.

1) Make sure you have permission to access the SQLServer.
2) Can you ping the machine? ping 68.65.85.69
3) Do you have the server location correct / doesnt the server have a name?
4) Does the server have an instance name? If so then you should attempt to
connect to the server in the following way: 68.65.85.69\<instance name>

It really sounds like you should speak to your administrator.

Richard

> thanks Richard
> it's not working , my remote SQl Server is at 68.65.85.69
[quoted text clipped - 19 lines]
> >
> >.

Reply to this Message

remote accee SQL

Free Magazines