June 2, 2011 at 9:56 pm
Hi Guys,
I have a named instance in one server. I am trying to create a linked server in the named instance that has to be connected to another named instance created in another server.
I have tried creating alias as mentioned in the URL: http://www.nimbleuser.com/blogs/Developers/developers/SQL_Server_Linked_Server_by_Alias_with_SQL_Instances.aspx
I even tried with IP, still NO LUCK.
Any help would be appreciated, as I need this on a high priority.
June 3, 2011 at 1:56 am
In SQL Server Management Studio open Linked Servers and then 'New Linked Server'.
1) Select the General tab.
2) Specify alias name in "Linked server" field.
3) Select SQL Native Client as provider.
4) Add sql_server in "Product Name" field
5) In "Data Source" – specify name of the host to be used as linked server.
6) In Security tab – mentioned the appropriate security context
7) In Server Options tab – set true on "Data Access", RPC, "Rpc Out" and "Use Remote Collaboration"
----------
Ashish
June 3, 2011 at 4:47 am
I think that's what the link specifies.... Tried that still no luck.
I think there may be some issues of PORT NO, but again i have set it to dynamic port.
June 3, 2011 at 4:50 am
are both sql server on same version?
Give some more detail about your linked server and security you configuring.
----------
Ashish
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply