BI Documenter

Welcome to BI Documenter Sign in | Join | Help
in Search

SQL 2005 Connection Problem

Last post 05-20-2008, 5:53 AM by durk. 2 replies.
Sort Posts: Previous Next
  •  05-16-2008, 6:00 AM 235

    SQL 2005 Connection Problem

    I received the following error when attempting to connect to a SQL 2005 Developer Edition (9.00.3200.00) database:

    Preparing for snapshot creation...
    The following error occurred while making the snapshot: [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).

    Is anyone else experiencing this problem?

  •  05-20-2008, 1:47 AM 236 in reply to 235

    Re: SQL 2005 Connection Problem

    A SQL Trace shows the following:

    if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null)

    exec master.dbo.sp_MSSQLDMO80_version

    else

    if (object_id('master.dbo.sp_MSSQLDMO70_version') is not null)

    exec master.dbo.sp_MSSQLDMO70_version else

    select 0

    It is executing the master.dbo.sp_MSSQLDMO80_version procedure, and fails with the following message:

    Msg 55555, Level 16, State 1, Procedure sp_MSSQLDMO80_version, Line 16

    To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).

  •  05-20-2008, 5:53 AM 237 in reply to 236

    Re: SQL 2005 Connection Problem

    And to close out my own thread... the solution was to install the Microsoft SQL Server 2005 Backward Compatibility Components linked to from this page: http://www.microsoft.com/downloads/details.aspx?FamilyID=D68DE3C9-60A9-49C9-A28C-5C46BBC3356F&displaylang=en
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems