How to Move a Systems Insight Manager SQL 2008 Database from Local to Remote

11. In the Specify Table Copy or Query dialog window, select Copy data from one or more tables or
views, and then click Next.
If there is any error while connecting to the remote server of the Export Wizard such as Named
pipes provider could not open a connection to sql server, verify the following
steps:
a. Click Start  All Programs  Microsoft SQL Server 2008 R2  Configuration tools  SQL
Configuration Manager  SQL Native Client 10.0.
b. Right-click Client Protocols, and then click Properties  Promote TCP/IP ahead of named
pipes. Make sure this setting is enabled.
c. Check the network name of the remote server. To eliminate network resolution issues, try to
connect to the remote server from the local SQL Server machine through sqlcmd or try to set
up the linked server with the IP address of the remote machine instead of the name of the
remote machine.
Figure 17: Specify Table Copy or Query