• EMC Elect 2014 EMC Elect 2014 

    EMC Elect represents an unprecedented opportunity for members to receive exclusive access, privileges, and status in appreciation for their contributions to the EMC community.

    Read more

  • Demo Image Everything you need and nothing you don’t. EMC MOBILE is the essential tool for those of us who live EMC. Now your documentation library is available and in-sync online or off direct from the EMC Cloud

    Download

  • FreeWhether you're looking to broaden your awareness of emerging technologies, learn new skills for news roles, EMC Education offers free e-Learning Fundamentals courses to help you redefine your skills. 

    Read more
  • FreeVMware Fusion 6 Professional delivers improved IT controls, unsurpassed platform support, more powerful virtual machines, and enhanced usability. VMware Fusion 6 Professional is optimized for the latest Macs and ready for OS X Mavericks and Windows 8.1 to deliver the ultimate Windows on Mac experience.

    Read more
  • Demo ImageWhy Advertise on Mikes.eu

    Mikes.eu traffic varies depending on the post. We have a VERY focused audience in the Virtualization, Storage and Cloud Marketing space. We have been ranked in the top 5 of Favorite Independent Blogger and one of the most visited website.

Print

Setup failed to connect to the database pointed to by the given DSN

Written by on . Posted in How to

When you are try to upgrade Virtual Center 2.5.0 to vCenter 2.5 update 4 with a Microsoft SQL 2000 ODBC data source you receive the folowing error:

setup failed to connect to the database pointed to by the given DSN. Please make sure that you have the proper permissions to acces the database.

 

  1. To resolve this error you have to give the user that is used for the Virtual Center database access db_owner rights on the msdb database within Microsoft SQL
    • Login to the SQL server
    • Start the SQL Enterprise Manager by clicking on "Start >> Programs >> Microsoft SQL Server >> Enterprise Manager"
    • Go to and expand "Security "
    • Go to and expand "Logins "
    • Right click on the VirtualCenter database user and hit properties. In my example the user is called "VirtualCenter"

    • Mark the msdb database and klick "OK"
    • This should do the trick
  2. After these steps you can proceed with your vCenter update!