Solved

Vmware SRM 5.1 SQL setup

Posted on 2014-12-10
11
243 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 119

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

where is your database ?
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
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…

832 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