Solved

Vmware SRM 5.1 SQL setup

Posted on 2014-12-10
11
252 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 121

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 121
ID: 40491035
if the database is on the vCenter Server this is correct.

where is your database ?
0
Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

 

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 121
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 121
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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…
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.
Suggested Courses

624 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