Install for first time with remote SQL2014 Database

Availability for the Always-On Enterprise

Install for first time with remote SQL2014 Database

Veeam Logoby geekgirl » Wed Nov 02, 2016 8:21 pm

Does anyone have any explicit directions for initial installation using a remote database. The documentation leads me to believe I can do it however when I use the browse button my ODBC connector (Sql 10 native) doesn't come up in the list and if I just hand jam the name and instance it never finds the database. I've tested with both the service account I made for veeam who is the db_owner in SQL and also just trying to connect via the sa account. This is the error I get:

Image

My test using the ODBC connector comes up successfully. Any assistance would be appreciated.

:D :D
geekgirl
Lurker
 
Posts: 2
Liked: never
Joined: Wed Nov 02, 2016 8:07 pm
Full Name: Angie

Re: Install for first time with remote SQL2014 Database

Veeam Logoby Gostev » Thu Nov 03, 2016 12:32 am

Well, to be honest no special directions are needed as it is super straight forward and just works all the time.
May be in your case some client components are broken or missing, please open a support case to investigate.
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Install for first time with remote SQL2014 Database

Veeam Logoby Mike Resseler » Thu Nov 03, 2016 7:22 am

Hi Angie,

Error 26 is a common error when trying to connect remotely. It basically means that you cannot receive an SSRP (SQL Server Resolution Protocol) response UDP packet from the SQL Browser. Unfortunately, it can have many reasons :-(

So the normal troubleshooting (by MSFT) would be:
* Make sure your server name is correct.
* Make sure your instance name is correct and there is actually such an instance on your target machine. (I can't see from the error message if you are using a named instance or not but I can actually not remember this error coming up with the default instance...)
* Make sure the server machine is reachable (DNS)
* Make sure SQL Browser service is running on the server.
* If your firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception. Also, don't forget to put 1433 TCP in it if it is the default instance, and if not the default instance, use the correct port defined in SQL server...

I know you said that ODBC connection works to the server, but (believe it or not) that can actually work because you just make a connection...

OK, to make a long story shorter...

SQL Browser on the SQL server must be enabled, UDP port 1434 needs to be open if you are connecting to a named instance... That would be my first tests....

Let us know

Mike
Mike Resseler
Veeam Software
 
Posts: 3150
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Install for first time with remote SQL2014 Database

Veeam Logoby geekgirl » Thu Nov 03, 2016 12:22 pm

Thanks so much Mike! It was SQL Browser.
geekgirl
Lurker
 
Posts: 2
Liked: never
Joined: Wed Nov 02, 2016 8:07 pm
Full Name: Angie

Re: Install for first time with remote SQL2014 Database

Veeam Logoby Mike Resseler » Thu Nov 03, 2016 1:35 pm

Awesome!

Good to hear everything is OK now.

Cheers
Mike
Mike Resseler
Veeam Software
 
Posts: 3150
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 49 guests