Connect to a remote database using QA or EM *WITHOUT* ever creating CNU aliases first? (MS SQL 2000

27 Mar 2007 4:26 AM

"A_Michigan_User\

Accessing a hosting company's MS SQL 2000 server.

I don't have any problems connecting to a remote database with Query
Analyzer (QA) or Enterprise Manager (EM)... as
long as I first create "aliases" using the "client network utility" (CNU).

How would I connect to a remote database using QA or EM *WITHOUT* ever
creating any CNU aliases first?

QA and EM never seem to have a place to enter in the remote SQL machine's IP
address, port number, user name, password, database, etc.
(All the stuff that is needed to connect... that CNU allows me to enter.)

Thanks.

27 Mar 2007 11:43 AM

Sue Hoegemeier

In the server name drop down for connecting with Query
Analyzer, you can type the IP address followed by a comma
and then the listening port. If you select SQL Server
Authentication, you can type a User and Password.

-Sue

On Tue, 27 Mar 2007 00:26:59 -0400, "\"A_Michigan_User\""
<Michigan_RE_M***@ameritech.net> wrote:

Show quote

>Accessing a hosting company's MS SQL 2000 server.
>
>I don't have any problems connecting to a remote database with Query
>Analyzer (QA) or Enterprise Manager (EM)... as
>long as I first create "aliases" using the "client network utility" (CNU).
>
>How would I connect to a remote database using QA or EM *WITHOUT* ever
>creating any CNU aliases first?
>
>QA and EM never seem to have a place to enter in the remote SQL machine's IP
>address, port number, user name, password, database, etc.
>(All the stuff that is needed to connect... that CNU allows me to enter.)
>
>Thanks.
>

30 Mar 2007 2:18 AM

"A_Michigan_User\

Wow... thanks.

I was thinking that is a drop-down list-box... and that I could NOT type
directly into it... but I can.

I got things working with QA... now I'll have to try EM also.

Thanks again.

Show quote

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:rm0i039em6h6gtm73mh6qeqij54qpncb52@4ax.com...
> In the server name drop down for connecting with Query
> Analyzer, you can type the IP address followed by a comma
> and then the listening port. If you select SQL Server
> Authentication, you can type a User and Password.
>
> -Sue
>
> On Tue, 27 Mar 2007 00:26:59 -0400, "\"A_Michigan_User\""
> <Michigan_RE_M***@ameritech.net> wrote:
>
>>Accessing a hosting company's MS SQL 2000 server.
>>
>>I don't have any problems connecting to a remote database with Query
>>Analyzer (QA) or Enterprise Manager (EM)... as
>>long as I first create "aliases" using the "client network utility" (CNU).
>>
>>How would I connect to a remote database using QA or EM *WITHOUT* ever
>>creating any CNU aliases first?
>>
>>QA and EM never seem to have a place to enter in the remote SQL machine's
>>IP
>>address, port number, user name, password, database, etc.
>>(All the stuff that is needed to connect... that CNU allows me to enter.)
>>
>>Thanks.
>>
>