Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Unanswered: SQL Server does not exist or access denied. ConnectionOpen(Connect())

    The server that needs to be moved: SERVER A.
    The databases which need to be moved (present in SERVER A): DB-A, DB-B.
    The SERVER A machine is in X domain

    The target machines: Could be any of SERVER T1
    This machine is in Y domain.

    While we are trying to create a new server instance of the Server A in SERVER T1, we are getting an error message as shown below:

    Reason: SQL server does not exist or access denied. (ConnectionOpen (Connect())

    The server that needs to be moved SERVER A could not be mapped to SERVERT1.

    Problem: The tables concerned present in the SERVER A and the production server are same. These could be extracted to SERVERT1 using the SQL Enterprise Manager utility.
    Views and Stored Procedures concerned are only present in SERVER A. Problem lies in copying them. Manually doing so could pose great risks.
    What is the plausible work around for this?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Backup and restore?

    -PatP

  3. #3
    Join Date
    Aug 2006
    Posts
    2

    Backup and restore

    Thanks Pat, I have done it, its working fine


    Quote Originally Posted by Pat Phelan
    Backup and restore?

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •