Solved

Vmware SRM 5.1 SQL setup

Posted on 2014-12-10
11
239 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
  • 6
  • 5
11 Comments
 
LVL 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
Comment Utility
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
Comment Utility
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 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
if the database is on the vCenter Server this is correct.

where is your database ?
0
 

Author Comment

by:Matt
Comment Utility
Ah I see.

I installed the SQL express on the SRM server. So I have to point it to itself then.
0
 
LVL 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
That is correct.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:Matt
Comment Utility
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 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
could be incorrect user id, setup incorrect, permissions issue
0
 

Author Comment

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

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
0
 

Author Comment

by:Matt
Comment Utility
Thats the one I followed!
0
 

Author Comment

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This Tutorial covers a very basic and common question asked on Experts Exchange, "How Do I Clone or Copy a virtual machine in VMware vSphere Hypervisor ESX/ESXi 4.x, ESXi 5.0?" Using the following method, no third party tools are required or need…
David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
Teach the user how to install vSphere Update Manager  Console to Windows system:  Install vSphere Update Manager: Configure vSphere Update Manager plug-in in vSphere Client: Verify vSphere Update Manager settings in vSphere Client:
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:

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now