Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Vmware SRM 5.1 SQL setup

Posted on 2014-12-10
11
Medium Priority
?
255 Views
Last Modified: 2014-12-10
Hi all,

Trying to setup SRM 5.1 in my vmware enviroment. I have found some helpful guides but im struggling with the SQL setup. Im going to install SRM on a different VM (not on the vcenter server)  with SQL express installed locally. The bit I dont understand is setting the DSN and where they should point to? Does the DSN have to configured on the SRM server to point to itself or does it have to point to the Vcenter server?

Thanks
0
Comment
Question by:Matt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 40491008
The DSN is pointed to the database, where ever the database is located.

So you will need to create the System DSN on the SRM Server, pointing to itself.
0
 

Author Comment

by:Matt
ID: 40491028
OK, but if I look at this guide - step 14. It looks like he is configuring the DSN to look at the Vcenter server? Is this incorrect?
0
 
LVL 123
ID: 40491035
if the database is on the vCenter Server this is correct.

where is your database ?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:Matt
ID: 40491058
Ah I see.

I installed the SQL express on the SRM server. So I have to point it to itself then.
0
 
LVL 123
ID: 40491085
That is correct.
0
 

Author Comment

by:Matt
ID: 40491111
When I try and configure DSN I cannot choose the database. I t get the following error: I appreciate I may need to post this in the SQL section.


sql.JPG
0
 
LVL 123
ID: 40491119
could be incorrect user id, setup incorrect, permissions issue
0
 

Author Comment

by:Matt
ID: 40491131
Care to elaborate on that or perhaps point in the direction of a guide? My SQL knowledge is very limited.
0
 

Author Comment

by:Matt
ID: 40491286
Thats the one I followed!
0
 

Author Comment

by:Matt
ID: 40491377
Sorted. Needed to put in teh server\sqlinstance rather than choosing local. Also had to enable named pipes protocal.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question