Friday, February 24, 2012

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]

No comments:

Post a Comment