Connecting to a clustered SQL server with "localhost" as server name

• 問題

• 

  

  0

  登入以投票

  Hi everyone, I get the following problem:

  I have 2 sites, production site and backup site. The config of backup site is the same as production site, except the server name which is different. In the SSIS package, I use "localhost" to connect to the SQL server, instead of the SQL server instance name (which is different between 2 sites), so that the source in these two sites are the same. I found it does not work in clustered environment, with 2 servers in each site, and setup cluster for SQL server.

  My question is, is there any way to connect to the clustered SQL server with "localhost" as server name? If not, is there any way to connect to SQL server, so that I don't need to connect with the SQL server instance name? Thanks.

  2010年7月12日 上午 07:28

  回覆

  |

  引述