Welcome to SQLDBcontrol Forums Sign in | Join | Help
in
Home Forums
SQLDBcontrol Forums » SQLDBcontrol Forums » SQLDBcontrol Support » Add Object from Differences.

Add Object from Differences.

Last post 09-17-2009, 15:41 by admin. 3 replies.
Sort Posts: Previous Next

  •  09-16-2009, 14:35 301

    Add Object from Differences.

    I am trying to add a view to a database after running a difference reprot and get the error

    Cannot open database requested by the login. The login failed.

    Login failed for user 'mcs'.

    The issue I believe is its using the user from the destination database to get access the source database.  The source database uses windows authentication to connect while the destination uses the mcs user as it not on the same domain. 

    If the objects already exist then updating them works fine.

     

     

  •  09-16-2009, 15:00 302 in reply to 301

    Re: Add Object from Differences.

    Thanks for pointing this out.  I can confirm the same behaviour so we'll work on getting this fixed..
    SQLDBcontrol Support

    support@sqldbcontrol.com

  •  09-17-2009, 15:20 303 in reply to 302

    Re: Add Object from Differences.

    When you've fixed and tested it would it be possible to get hold of a patch as i have to create all objects on the remote server from a script rather than using SQLDBcontrol.

    Thanks

  •  09-17-2009, 15:41 304 in reply to 303

    Re: Add Object from Differences.

    Sure.  We'll let you know once we've got an updated build - should be next week some time.
    SQLDBcontrol Support

    support@sqldbcontrol.com
View as RSS news feed in XML
Copyright Voltex Data Systems Limited, 2006. All rights reserved.
Powered by Community Server, by Telligent Systems