Linked server in a cluster environemnt

My instance name on one server in a cluster is 'PSPSQL1\PSP1_INST1'. I have
a linked server with another instance on another server -
'PSPSQL2\PSP2_INST2'. When I query a a table across server referenceing it
as follows - PSPSQL1\PSP1_INST1.databasename.dbo.tablename - I get an error
that the server name is incorrect because of the '\'. If the server name is
PSPN2, I get no errors. Please help!!!!
Solution #1 Use [] to delimit the servername
Solution #2 Create a client alias using the Client Network Utility to alias
a short name to the long name. Link the servers using the short name.
Remember to apply this to each node in the cluster.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:70012C8F-1208-4629-AD9C-DF11E7558060@.microsoft.com...
> My instance name on one server in a cluster is 'PSPSQL1\PSP1_INST1'. I
have
> a linked server with another instance on another server -
> 'PSPSQL2\PSP2_INST2'. When I query a a table across server referenceing
it
> as follows - PSPSQL1\PSP1_INST1.databasename.dbo.tablename - I get an
error
> that the server name is incorrect because of the '\'. If the server name
is
> PSPN2, I get no errors. Please help!!!!
|||Just want to add that as a matter of personal preference, I'd go with
Solution #1. It's traightforward and self-documenting.
Linchi
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%237wlvvt5EHA.3124@.TK2MSFTNGP11.phx.gbl...
> Solution #1 Use [] to delimit the servername
> Solution #2 Create a client alias using the Client Network Utility to
> alias
> a short name to the long name. Link the servers using the short name.
> Remember to apply this to each node in the cluster.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "spoons" <spoons@.discussions.microsoft.com> wrote in message
> news:70012C8F-1208-4629-AD9C-DF11E7558060@.microsoft.com...
> have
> it
> error
> is
>
|||Strangely enough, I use option #2. That way I can replace servers without
rewriting applications. I also have a parallel development environment that
is periodically refreshed from the production systems. I have the aliases
set differently on development and everything works without a lot of
hand-patching. Your choice should depend on what you need.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:%23l1Gnux5EHA.3336@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Just want to add that as a matter of personal preference, I'd go with
> Solution #1. It's traightforward and self-documenting.
> Linchi
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%237wlvvt5EHA.3124@.TK2MSFTNGP11.phx.gbl...
referenceing[vbcol=seagreen]
name
>
|||Fair enough, Geoff, that's why I had the 'foresight' to qualify my statement
as " a matter of personal preference." :-)
Linchi
"Geoff N. Hiten" wrote:

> Strangely enough, I use option #2. That way I can replace servers without
> rewriting applications. I also have a parallel development environment that
> is periodically refreshed from the production systems. I have the aliases
> set differently on development and everything works without a lot of
> hand-patching. Your choice should depend on what you need.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:%23l1Gnux5EHA.3336@.TK2MSFTNGP11.phx.gbl...
> referenceing
> name
>
>
|||My personal preference is using linked server name alias, this is simple and
will equally work.
Kola Bolarin
Senior DBA
Kaplan University
"Linchi Shea" wrote:
[vbcol=seagreen]
> Fair enough, Geoff, that's why I had the 'foresight' to qualify my statement
> as " a matter of personal preference." :-)
> Linchi
> "Geoff N. Hiten" wrote: