locked
Transfer logins package using VS BI 2005 RRS feed

  • Question

  • Hi All,

    I'm trying to build a package to transfer the logins from a server running SQL 2000 to a server running SQL 2008. I'm using the Business Intelligence dev environment 2005. When testing the connection to the destination server specified(A server running 2008) it fails with the following error:


    This SQL Server version (10.0) is not supported. (Microsoft.SqlServer.ConnectionInfo)

    I've seen something mentioned about libraries and classes but wasn't sure if it applied in this case.

    Thanks in advance
    Scott

    I've also included message text... Hope it helps...

    ===================================

    This SQL Server version (10.0) is not supported. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.Common.ConnectionManager.CheckServerVersion(ServerVersion version)
       at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
       at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()

    Monday, July 27, 2009 11:42 AM

Answers

  • I've never been a fan of moving logins using SSIS, unless you need to rinse and repeat a lot of times. Do you need to move them once, or many times?

    There are some canned scripts in KBs which may be able to help you for a one time move.
    http://support.microsoft.com/kb/246133/
    http://support.microsoft.com/kb/918992/

    I'm guessing that the SMO objects used to script the logins in your SSIS 2005 package don't know how to deal with SQL 2008 logins, so the connection fails as you mention. Its just that anything SMO will not allow connections to 2008. SMO is the object model used when Microsoft coded the Transfer Logins task, and it can be used by custom apps as well to simulate actions in management studio for example. That 2005 SMO object model is backward compatible but not forward compatible to 2008.
    http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/d5762c31-1409-4b14-8ed3-5ea7ae95045a

    If you need SQL 2008 logins to be transferred, you'd have to use SQL 2008 SSIS which will have a Transfer Logins Task based on the SQL 2008 server managmenet objects (SMO).

    Thanks, Jason
    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
    Tuesday, July 28, 2009 5:08 AM

All replies

  • I've never been a fan of moving logins using SSIS, unless you need to rinse and repeat a lot of times. Do you need to move them once, or many times?

    There are some canned scripts in KBs which may be able to help you for a one time move.
    http://support.microsoft.com/kb/246133/
    http://support.microsoft.com/kb/918992/

    I'm guessing that the SMO objects used to script the logins in your SSIS 2005 package don't know how to deal with SQL 2008 logins, so the connection fails as you mention. Its just that anything SMO will not allow connections to 2008. SMO is the object model used when Microsoft coded the Transfer Logins task, and it can be used by custom apps as well to simulate actions in management studio for example. That 2005 SMO object model is backward compatible but not forward compatible to 2008.
    http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/d5762c31-1409-4b14-8ed3-5ea7ae95045a

    If you need SQL 2008 logins to be transferred, you'd have to use SQL 2008 SSIS which will have a Transfer Logins Task based on the SQL 2008 server managmenet objects (SMO).

    Thanks, Jason
    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
    Tuesday, July 28, 2009 5:08 AM
  • Hi,

    BIDS 2005 can't be used on SQL 2008. I suggest you upgrading the SQL version.

    Thanks.
    Yao Jie Tang -Microsoft Online Community
    Thursday, July 30, 2009 9:17 AM