VMware Cloud Community
chan82
Contributor
Contributor

two tier installation with SQL server listening on non-default port

Hi guys,

I am deploying VCM 5.7.1 and have installed an SQL server 2012 instance in my database server listening on TCP 1434. On my web and collector server, I run the setup and when prompted to specify the database server and instance, I input servername for server and instance,1434 for database instance. I got a verification failure.

May I check with you guys if I am specifying in the correct format or it is a requirement that the database instance has to be listening on default port, 1433?

Thanks

Reply
0 Kudos
4 Replies
admin
Immortal
Immortal

Does the format you used to specify the SQL Server work from tools like SQL Server Management Studio?

You may need to use the SQL Server Client Utility to create 32 and 64 bit aliases for your SQL Server.

Reply
0 Kudos
chan82
Contributor
Contributor

The format does work from SQL Server Management Studio and I can access the database using the tool remotely and locally.

Do we need to create aliases then?

Reply
0 Kudos
kramsen
Contributor
Contributor

AUTO: Matthias Brückner ist nicht im Haus und hat nur sporadisch Zugriff auf E-Mail.

Bitte wenden Sie sich an meine freundlichen Kollegen unter 034205 759 0.

Reply
0 Kudos
chan82
Contributor
Contributor

Hi guys,

I have managed to complete the installation using SQL server alias.

thanks.

Reply
0 Kudos