Solved

Vmware SRM 5.1 SQL setup

Posted on 2014-12-10
11
247 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 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 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 120
ID: 40491035
if the database is on the vCenter Server this is correct.

where is your database ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 120
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 120
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
 
LVL 120
ID: 40491159
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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

726 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