Hi All,
I'm new to VCM and now i got stuck at the SQL DB and Report server portion.
I'm running the vcm server on VM and the SQL is a physical server, both are sitting on the same LAN.
I have create the SQL DB but VCM just fail to validate the DB and report server.
I login to VCM using a Domain account for installation, and i tried to testing the DB using ODBC from the window, result fail.
Error message as attach.
I'm now totally lost on SQL portion.
My Question:
Is there any configuration needed on SQL DB?
How to get the reporting server to working?
What port is needed to it all working??
VCM server Ms Win2012.
SQL version 2012.
Many thanks to all who reply.
Hi Simonhoo79,
For SSRS, first check whether the report server link is accessible from your browser : "http://s01-fes-vcm1:80/ReportServer" . If you continue to get 404 error there also, then you need to reconfigure you report server first before proceeding to vcm installation. Follow the steps on below link on how to reconfigure report server using report services configuration Manager for 404 error.
For SQL server ODBC connection,
Dont create ODBC connection for SQL Native Client. Create ODBC connection for SQL Server.
1. Open ODBC Data Source Administrator
2. Click User DSN tab and Click Add button.
3. Select SQL server and click finish
4. Give name and description and Give the SQL server name (with instance name if your using named instance) or IP in the Server text box.
5. Click Next and select either Windows authentication or sql authentication based on your SQL server authentication mode and click next.
6. If the details given are correct then it will proceed further and check "Change the dafault database to" to your VCM database
7. Click next and finish and try test data source.
VCM 5.7.2 and below will support installation only on windows server 2008 R2 and it doesn't support windows server 2012 but it support both 2008 and 2012 sql servers.
The SQL validation error message is basically saying that the SQL Server can't be reached at all using the information provided. There are a lot of reasons why this might happen, like firewalls blocking SQL Server ports, SQL Server configured on a custom port but the custom port not provided in the connection information in the install Wizard, incorrect name, incorrect format of the name, DNS not configured for your VCM VM...
Also, you do not need to (and cannot) pre-create the VCM databases in SQL Server. The VCM installer will create the databases during the install process. Please follow the Installation Guide for these steps.
To install VCM you need to be logged on to the domain as a user that has sysadmin rights on the SQL Server. Those rights are not needed after installation or to use VCM, but are needed for the installing user.
Hi Nandhak,
Thanks for the link and advise will give it a try.
Cheers
Hi PChambre,
Yes, i'm using custom port for the SQL TCP/IP,but will check with my network team over the firewall end.
As for the DNS part, i don't think is a problem as ping and DNS records are all correct and working.
Anyway will try it out and post on the result.
Thanks.
Hi Nandhak,
I have try out your step on creating the SQL ODBC connection, result fail to connect to SQL DB.
I have attach the error message, even with input of user names and password, it's not able to connect.
Both my users are sysadmin in the sql instance, i have even create a new DB within the instance and set that with only vcmadmin as the sysadmin (odb).
Anyway advise for me to work through this problems.
Thanks.
