• A Guide to Disaster Recovery in the CloudLearn how VMware vCloud® Air™ Disaster Recovery provides an affordable cloud-based solution to protect your applications and data.
    Please register now for a free copy of this e-book.

    Download
  • EMC Elect 2015 EMC Elect 2015 

    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

  • Mikes AppMikes.eu App listed in Top Free Business App Windows Store. This simple but very clear app shows all the new posts from this site. Available for Windows 8 and 10. Try it out!

    Download
  • 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!
Download Free Designs http://bigtheme.net/ Free Websites Templates