Client Utility syntax

Client utility asks for the Server Alias name, and the server name.
If the computer-name is Location1, and the SQL-Server instance
name = BOB, and say the ip-adress is 1.2.3.4
Then,
Server Alias Name would = Location1\BOB
Server Name would = 1.2.3.4\BOB
Is this correct?
Yes!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" wrote:

> Client utility asks for the Server Alias name, and the server name.
> If the computer-name is Location1, and the SQL-Server instance
> name = BOB, and say the ip-adress is 1.2.3.4
> Then,
> Server Alias Name would = Location1\BOB
> Server Name would = 1.2.3.4\BOB
> Is this correct?
>
>
|||I am having trouble connecting:
server doesn't exist or access denied
ConnectionOpen (connect() )
I can connect via XP remote desktop to the public ip 207.x.x.x .
In doing so and checking tcp/ip properties, I see that the setting is NOT to
obtain an IP automatically, rather it is "use this ip address". And the
local address is 192.x.x.x
How does this effect my connection setup?
thank you,
bob
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:9F58DE4A-569D-4561-8252-DABFDE6AFC99@.microsoft.com...[vbcol=seagreen]
> Yes!
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Robert A. DiFrancesco" wrote:
instance[vbcol=seagreen]
Location1\BOB[vbcol=seagreen]

Client Network Utility - tcp/ip

what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?
You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>

Client Network Utility - tcp/ip

what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>