BR initial install remote SQL

Availability for the Always-On Enterprise

BR initial install remote SQL

Veeam Logoby AlanRaczek » Thu Apr 13, 2017 1:25 pm

Server2012 R2, SQL 2012

I have been trying to troubleshoot an initial install of BR and not finding much documentation. The first thing I am interested in are the requirements for
getting this done to include:
1. Should the database already exist in remote SQL or will setup create it?
2. What requirements are needed on the SQL server for the service account
- I gave the service account local admin on SQL, created a login to SQL
- DNS is working fine, nslookup shows correct machine
- Default SQL instance, SQL Browser is running
- ODBC connection works fine
Error is:
Unable to connect to SQL Server machine\mssqlserver. A network-related or instance-specific error occurred while establishing
a connection to SQL Server. More follows, shows error: 25 .

Running out of ideas. If I look in the SQL logs I don't see that the machine is even trying to hit the SQL server, no errors specific to what I am
doing.

ty in advance.

...Alan
AlanRaczek
Influencer
 
Posts: 13
Liked: never
Joined: Tue Apr 11, 2017 12:56 pm
Full Name: Alan Raczek

Re: BR initial install remote SQL

Veeam Logoby Mike Resseler » Fri Apr 14, 2017 6:12 am

Hi Alan,

1) The database should not exist already. If it already exists, it will notify you from it (could be from a previous installation)
2) Error 25 means that there is a problem, most likely permissions. Are you using Windows authentication for the service account to connect to the remote server? If you are, how exactly did you gave those rights on SQL. I can read it wrong, but it looks like you gave the service account local admin rights on the windows box, and created a SQL login for it through the SQL management studio. If that is the case, that won't work. That service account needs to be added and then given specific permissions.

From our manual:
The account used to run Veeam Backup Service requires db_datareader and db_datawriter roles as well as permissions to execute stored procedures for the configuration database on the Microsoft SQL Server. Alternatively, you can assign db_owner role for this database to the service account.
Mike Resseler
Veeam Software
 
Posts: 2984
Liked: 354 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: BR initial install remote SQL

Veeam Logoby AlanRaczek » Mon Apr 17, 2017 7:23 pm

Mike-

Could you tell me what manual this is in? I have been looking for this info. But, anyway, tell me if I am wrong. Don't I need a database to actually assign those rolls?
Or do I assign them to the Master db.
AlanRaczek
Influencer
 
Posts: 13
Liked: never
Joined: Tue Apr 11, 2017 12:56 pm
Full Name: Alan Raczek

Re: BR initial install remote SQL

Veeam Logoby Mike Resseler » Tue Apr 18, 2017 5:51 am

The manual can be found here: https://helpcenter.veeam.com/docs/backu ... tml?ver=95

For the permissions, just assign the permissions on the SQL server instance for the service account.

Thinking of it, it seems that those rights are not enough for the installation since a DB needs to be created and the reader and writer permissions are probably not enough. Need to verify that. I will verify with the technical writers team. So if you can, give the service account full rights on the SQL server during installation and change it afterwards to the db_datareader and db_datawriter (+ permissions to execute stored procedures) for the specific database.

Mike
Mike Resseler
Veeam Software
 
Posts: 2984
Liked: 354 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: BR initial install remote SQL

Veeam Logoby AlanRaczek » Tue Apr 18, 2017 12:24 pm

Okay-

To assign roles I assume we are using the master db. Tell me if I am wrong. I also tried SQL authentication and same error, like it can't reach the SQL server.
I tried using a text file saved as a *.UDL and it worked. When I purposely put in an NT account in the SQL login credentials I DID get an error in the SQL log so to a point
the veeam machine is getting to the SQL server. Currently I gave the service account db owner.

...Alan
AlanRaczek
Influencer
 
Posts: 13
Liked: never
Joined: Tue Apr 11, 2017 12:56 pm
Full Name: Alan Raczek

Re: BR initial install remote SQL

Veeam Logoby AlanRaczek » Tue Apr 18, 2017 6:58 pm

As an FYI error is:
Unable to connect to SQL Server name\instance. A network-related or instance-specific error occurred while establishing a connection to SQL server. The
server was not found or was not accessible. Verify that the instance name is correct and that the SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

SQL server is a production server running perfectly well with other applications having remote connections.
AlanRaczek
Influencer
 
Posts: 13
Liked: never
Joined: Tue Apr 11, 2017 12:56 pm
Full Name: Alan Raczek

Re: BR initial install remote SQL

Veeam Logoby AlanRaczek » Tue Apr 18, 2017 7:26 pm

For SQL rights- I gave the service account (domain\svc-veeam) dbo on the mater database. I would think that would be plenty of rights. There are no SQL tools installed on the veeam machine.

...Alan
AlanRaczek
Influencer
 
Posts: 13
Liked: never
Joined: Tue Apr 11, 2017 12:56 pm
Full Name: Alan Raczek

Re: BR initial install remote SQL

Veeam Logoby Mike Resseler » Wed Apr 19, 2017 6:07 am

Hi Alan,

Sorry for my late reply. Did that fix it? I am not sure if I understand it from your message?
Mike Resseler
Veeam Software
 
Posts: 2984
Liked: 354 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: BR initial install remote SQL

Veeam Logoby AlanRaczek » Wed Apr 19, 2017 11:25 am

Unfortunately no. I am having the ePo SA's turn off all HBSS (HIPS) components to make sure that is not blocking anything.
AlanRaczek
Influencer
 
Posts: 13
Liked: never
Joined: Tue Apr 11, 2017 12:56 pm
Full Name: Alan Raczek

Re: BR initial install remote SQL

Veeam Logoby foggy » Wed Apr 19, 2017 2:41 pm

Time to ask support for assistance, I think.
foggy
Veeam Software
 
Posts: 14482
Liked: 1057 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: BR initial install remote SQL

Veeam Logoby Mike Resseler » Thu Apr 20, 2017 12:01 pm

Alan,

Foggy is right. Best is to create a support call.

In the meantime, as promised, I have talked to some teams to figure out what exactly is needed and we realized that the "install" rights should be added to the manual, and not only the rights needed during day-to-day running.

For a new database, the rights that the account that you use to install (so your loginaccount on the server) are: CREATE ANY DATABASE permission on the server level.

As said, we are going to look how we can adapt our manual for the next version to include all of this information.

Thanks for bringing this to our attention!

Cheers
Mike
Mike Resseler
Veeam Software
 
Posts: 2984
Liked: 354 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: Google [Bot], Yahoo [Bot] and 18 guests