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 » Nov 17, 2011 4:12 pm

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.
Product Manager
Posts: 22301
Liked: 1414 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. » Nov 17, 2011 4:28 pm

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 » Nov 17, 2011 4:30 pm

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.
Product Manager
Posts: 22301
Liked: 1414 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. » Nov 17, 2011 4:39 pm

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 » Nov 17, 2011 4:54 pm

Consider yourselves pestered!!!! :)

Same hold true for Veeam Monitor vs SQL express?

Vitaliy S.
Product Manager
Posts: 22301
Liked: 1414 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. » Nov 17, 2011 7:38 pm

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: Baidu [Spider], Bing [Bot], Google [Bot], Karinne, Pavel.Tyurin and 54 guests