how to config connection for sqlwriter (missing sql writer)

Hyper-V specific discussions

how to config connection for sqlwriter (missing sql writer)

Veeam Logoby fussel » Thu May 04, 2017 3:04 pm

Job reports warning "SQL VSS Writer is missing: databases will be backed up in crash-consistent state and transaction log processing will be skipped"
(https://www.veeam.com/kb2095)
- no databases with space characters
- account for guest processing is in sysadmin-role
- SQL VSS Writer is in valide state
but:
the sql writer fails to connect to the sql-server because it uses for DBPROP_INIT_DATASOURCE: MyHostName
the sql-server has activated TLS1.2 encrypt&sign. the issuer for the used server-certificate is "MyHostName.somedomain.com" (FQDN) -> not "MyHostName":
this causes a error by SQLWRITER (in win-logs) service principalname is incorrect
as a security issue it works as designed -> the server is unable to authenticate as "MyHostName" and sql writer refuses to connect

where can i configure the correct connectionstring (with DATASOURCE=MyHostName.somedomain.com) for sql writer in guestprocessing?
fussel
Novice
 
Posts: 7
Liked: 1 time
Joined: Wed Apr 13, 2016 12:02 pm
Location: Magdeburg - Germany

Re: how to config connection for sqlwriter (missing sql writ

Veeam Logoby Vitaliy S. » Mon May 08, 2017 6:38 pm

Since SQL VSS Writer is part of SQL Server itself, I would try to ask this question to the Microsoft tech support. Once the VSS snapshot within the guest is successfully triggered, then Veeam backup job would be able to successfully utilize this.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: how to config connection for sqlwriter (missing sql writ

Veeam Logoby Mike Resseler » Tue May 09, 2017 5:25 am

Hi Fussel,

Can you run (in an elevated command prompt)
Code: Select all
vssadmin list writers


If my thinking is correct, you would get errors or a delay message or similar. (That is at least if you haven't rebooted the server recently because then all writers will show healthy state.)

By default, DBPROP_INIT_DATASOURCE is set to Computer name for default Instance and , [computer name\instance name] for a named Instance.

(I had to look it up again ;-)) but the SQLwriter gets the information from here:

Code: Select all
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL


Can you check and see what it says?

Mike
 
Mike Resseler
Veeam Software
 
Posts: 3151
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: how to config connection for sqlwriter (missing sql writ

Veeam Logoby fussel » Tue May 09, 2017 8:00 am

Hi Mike

in "vssadmin list writers" the sqlserverwriter is missing. can't be there as long as it tries to connect with computer name instead of FQDN.
we use a unnamed instance -> so the reg-value says "MSSQL13.MSSQLSERVER" (mssql 2016)

Is there a way to get sqlwriter to use FQDN instead of computer name?

Vitaliy S. wrote:Since SQL VSS Writer is part of SQL Server itself, I would try to ask this question to the Microsoft tech support. Once the VSS snapshot within the guest is successfully triggered, then Veeam backup job would be able to successfully utilize this.

Yes, that is right. i thought there is a option for this in veeam
fussel
Novice
 
Posts: 7
Liked: 1 time
Joined: Wed Apr 13, 2016 12:02 pm
Location: Magdeburg - Germany

Re: how to config connection for sqlwriter (missing sql writ

Veeam Logoby Mike Resseler » Tue May 09, 2017 9:20 am

To be honest, no, I have no idea how to do that with the unnamed instance. Unless others can respond to it, I would follow Vitaliy's suggestion now and talk to Microsoft.

Sorry for not being able to further help you :-(
Mike Resseler
Veeam Software
 
Posts: 3151
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: how to config connection for sqlwriter (missing sql writ

Veeam Logoby fussel » Tue May 09, 2017 9:31 am

no matter, i found a solution working for me right now...

the sql-writer is using the SQL Native Client settings, so i created a alias for MyHostName pointing to MyHostName.somedomain.com and it worked

after i struggle around with this for days, this sounds a little bit to easy :oops:

thank you
fussel
Novice
 
Posts: 7
Liked: 1 time
Joined: Wed Apr 13, 2016 12:02 pm
Location: Magdeburg - Germany

Re: how to config connection for sqlwriter (missing sql writ

Veeam Logoby Mike Resseler » Tue May 09, 2017 9:33 am

Easy... but maybe effective. Anyway, it would be good if you could let us know in a few days that it works indeed. I'm sure in the future this could help others if they would face the same problem!
Mike Resseler
Veeam Software
 
Posts: 3151
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: how to config connection for sqlwriter (missing sql writ

Veeam Logoby fussel » Tue May 09, 2017 9:38 am 1 person likes this post

first transact-logs comming in, i have a look on this for the next week and give you a feedback
fussel
Novice
 
Posts: 7
Liked: 1 time
Joined: Wed Apr 13, 2016 12:02 pm
Location: Magdeburg - Germany

Re: how to config connection for sqlwriter (missing sql writ

Veeam Logoby fussel » Tue May 16, 2017 8:47 am

hi mike

until today this workarround works fine in our scenario, backups are running + sql-server works fine.
the only thing i don't like at this, is that i do not really know why this happens. in the event-logs the errors in app-logs are gone, the one in syslog are still there. may be there comes a solution with some updates for mssql-server.

but for know this is ok.
fussel
Novice
 
Posts: 7
Liked: 1 time
Joined: Wed Apr 13, 2016 12:02 pm
Location: Magdeburg - Germany


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 4 guests