Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Question Unanswered: Snap-in failed to initialize

    Workstation Office 2000 - Installed SQL Server 2000 component tools only. After install open Enterprise Manager to set up the servers under Server groups - click on the +next to Microsoft SQL Servers and receive the following error:

    Snap-in failed to initialize
    Name: Microsoft SQL Enterprise manager
    CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}

    We did a search on Microsofts knowledge base and was told that this situation occurs because SQL Server 2000 was released at a later date than Office 2000, and the Office 2000 Server Extensions installation routine does not recognize the SQL Server 2000 installation.

    Suggested fixes:
    run Setupse.exe with /nd extension - no setupse.exe file on Office 2000 installation CD.

    Set properties security tab of SQL server to SQL Server and Windows authentication method.

    These suggested fixes have not worked. We then uninstalled Office 2000 and installed Win 98 since we do not get this error on workstations having Win 98. We still receive the same error.

    Any suggestions would be appreciated.
    Thanks.

  2. #2
    Join Date
    Apr 2003
    Posts
    1

    snap in solution - odbcbcp.dll

    I had this exact same problem with SQL Server 2000. Also, when I tried to open the Query Analyzer, it gave an error concerning the file odbcbcp.dll. Somehow in the install this file and never been installed on my system. I just had to get this file from the CD (x86/system folder) and place it in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ folder. Problem solved.

Posting Permissions

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