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"?
>
No comments:
Post a Comment