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.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Sql Server Instance 2012

Author  Topic 

satishmen66
Starting Member

6 Posts

Posted - 2014-03-02 : 07:27:17
I have installed Sql Server 2012 on two servers running Windows Server 2012 which are joined to the Domain. I want to use Copy Database Wizard to transfer data from one instance to another. When I reach the Destination Server I am not able to see the Sql Server instance on the other server. When I click on Network Servers it shows me the name of the current server only.
How do I solve this problem.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-03-02 : 09:19:13
Does your account have access to both servers?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

satishmen66
Starting Member

6 Posts

Posted - 2014-03-03 : 05:32:20
Yes


quote:
Originally posted by visakh16

Does your account have access to both servers?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs


Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-03-04 : 01:50:23
As a test , are you able to connect to the Destination server via a standard route - such as straight to the database engine or via sqlcmd?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -