Comprehensive data protection for all workloads
Post Reply
ndolson
Influencer
Posts: 13
Liked: 2 times
Joined: Jan 08, 2015 3:56 pm
Full Name: Neal
Contact:

Feature request: Custom SQL port for database connection

Post by ndolson »

Our policy is to use a custom / alternate port for SQL database connections instead of the default 1433. After speaking with support, it appears it is not possible to specify an alternate port. I figure it's pretty common for people to use a non-standard port for SQL and being able to specify a custom port would make our DBA's happy.

Thanks!
Gostev
Chief Product Officer
Posts: 31460
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Feature request: Custom SQL port for database connectio

Post by Gostev »

Hi, Neal. What functionality are you talking about here? SQL Server for configuration database our product is using? Thanks!
42dlx
Lurker
Posts: 1
Liked: never
Joined: May 15, 2016 10:02 am
Full Name: Andre
Contact:

Re: Feature request: Custom SQL port for database connectio

Post by 42dlx »

Hi Anton,

I have the same problem.

I'd like to use the Veeam Explorer for SQL and need to connect to a different port. In the MS SQL Server Management Studio, you can do this via ip-address, port-number (e.g 192.168.254.42, 4848).

Is this possible with the SQL Explorer?

Thanks!
scdor_bsmith
Lurker
Posts: 2
Liked: never
Joined: Oct 20, 2017 2:56 pm
Full Name: Billy Smith
Contact:

Re: Feature request: Custom SQL port for database connectio

Post by scdor_bsmith »

We had the same issue of not using standard SQL port numbers. First we had to address the database restore as a restore to a new database and/or server. We would list the [server name],[port #] , this was good for single node SQL servers. Our next problem was 90% of our SQL servers were clustered in Availability Groups. Even though you could direct the restore over the custom port number through the SQL Explorer Wizard, when the wizard reached the Availability Group settings, it would show "not connected" to the other nodes in the cluster. This would cause the restore not to be written into the AG setting. We found that using SQL aliases would solve this issue. You can find the it here; https://support.microsoft.com/en-us/hel ... 4-bit-vers.
We created a .reg file with all the aliases instead of using cliconfg.exe which looked like this;

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]
"[Server Name]"="DBMSSOCN,[Server Name],[Port#]"


This solved our issues and allows all restore communication to talk to the restore target servers via the custom port we have designated for SQL traffic
MCH_helferlein
Expert
Posts: 108
Liked: 9 times
Joined: Nov 21, 2017 7:18 am
Full Name: Peter Helfer
Contact:

Re: Feature request: Custom SQL port for database connection

Post by MCH_helferlein »

We just fall into the same problem actually since we use also different ports for every sql instance.

Where this reg file was created? On every SQL Server itself or on the Veeam VBR Server?
Gostev
Chief Product Officer
Posts: 31460
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Feature request: Custom SQL port for database connection

Post by Gostev »

I would assume the VBR server, because the registry key refers to "Client" and backup server is where a connection to the SQL Server is established from.
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 211 guests