Comprehensive data protection for all workloads
Post Reply
ssrjazz
Influencer
Posts: 10
Liked: never
Joined: Aug 10, 2011 7:51 pm
Full Name: Jeff Schoby
Contact:

installing db to SQL server w/o Windows Integrated Auth

Post by ssrjazz »

Ok,

Has anyone ever installed veeam using an MSSQL server that does NOT use Windows integrated authentication, just internal SQL accounts? I'm not seeing a way to do it and support hasn't been clear on their answer of "You would have to match the Veaem service account the the SQL server account."

?
Vitaliy S.
VP, Product Management
Posts: 27375
Liked: 2799 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: installing db to SQL server w/o Windows Integrated Auth

Post by Vitaliy S. »

Hello Jeff, SQL authentication is not supported, you need to use Windows integrated authentication to deploy Veeam B&R. Thanks!
ssrjazz
Influencer
Posts: 10
Liked: never
Joined: Aug 10, 2011 7:51 pm
Full Name: Jeff Schoby
Contact:

Re: installing db to SQL server w/o Windows Integrated Auth

Post by ssrjazz »

Well, then what's the maximums for using sql express then?

Who do I have to pester to get you guys to support sql auth (or just regular darn odbc) ?
Vitaliy S.
VP, Product Management
Posts: 27375
Liked: 2799 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: installing db to SQL server w/o Windows Integrated Auth

Post by Vitaliy S. »

ssrjazz wrote:Well, then what's the maximums for using sql express then?
If we are talking about SQL Express 2005, then 4GB database limitation is more than enough to use with any infrastructure.

SQL Veeam database contains only configuration tables for your backup jobs and not the actual backup files, so it won't grow large. Here is existing topic talking about the limits of our database: VBR 4.1 New Install - database question (nevermind the title)
ssrjazz wrote:Who do I have to pester to get you guys to support sql auth (or just regular darn odbc) ?
Product Managers... on this very forum :wink:
ssrjazz
Influencer
Posts: 10
Liked: never
Joined: Aug 10, 2011 7:51 pm
Full Name: Jeff Schoby
Contact:

Re: installing db to SQL server w/o Windows Integrated Auth

Post by ssrjazz »

Consider yourselves pestered!!!! :)

Same hold true for Veeam Monitor vs SQL express?
Vitaliy S.
VP, Product Management
Posts: 27375
Liked: 2799 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: installing db to SQL server w/o Windows Integrated Auth

Post by Vitaliy S. »

Not really, Veeam Monitor does support SQL authentication and stores all performance metrics and event gathered from your virtual environment in SQL Server database. So if you're a pretty large VMware shop then you definitely want to use existing/remote full blown SQL Server to deploy Monitor database to.
Post Reply

Who is online

Users browsing this forum: AdsBot [Google], d.artzen, Semrush [Bot] and 109 guests