Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-09-16 : 21:37:57
|
| Hi,I am creating linked server between two sql server 2008 EE say ServerA and ServerB. I want to access 3 databases on ServerB through linked server from ServerA. There is a request from user to create linked sever. User has domain account on serverA but not on ServerB which is also on the same domain. My question is should I create new account on both servers for this linked server or how you guys setup linked server security for this kind of request.Thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-17 : 01:46:32
|
| The normal method we use is a separate account on the target server. There is no requirement to set up an account on the source server (in your case Server A). The reason we set up separate accounts is to manage the Lnked Servers.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-09-18 : 13:54:51
|
| I am facing difficulty to create linked server on sql server 2008. I want to access data on sql server 2005. There is error:"The linked serer has been created but failed a connection test. Do you want to keep the linked server?""Named Pipes provider: could not open a connection to sQL Server [5]. OLE DB Provider "SQLNCLI10" for linked server ...... returned message "a network related or instance specific eror has occurred while establishing a connection to sql server. Server is not found or not accessable. Check if instance name is correct and if sql server is configured to allow remote connections. Fore more information see sql server books online." (Microsoft SQL Server, Error: 5)".I am stuck up with this error for couple of days. Did not find any solution on net. Please help.Thanks |
|
|
|
|
|
|
Linked Server Login