November 23, 2016 at 1:27 pm
I have a few SQL servers 2008 R2 2012 and 2014 all with production databases on work fine.
On My windows 10 computer I installed the SQL 2014 Management tools
I can access all the SQL servers no problem.
I also have VMware vCenter with two (2) ESXi 6.0 hosts.
On one host I have a Windows 2008 R2 running Veeam B&R v9 it installed SQL 2012 Express.
Made changes to the firewall for port 1433 TCP port 1434 UDP and the Service of SQLSERVER
from my Management Studio on my Windows 10 computer I can access the SQL 2012 Express \\tgcs001\veeamsql2012
I use windows authentication and I get connected but the circle by the server is white not green
When I look at security /logins sa has a red arrow which means it is disabled.
I can not modify any settings can not add another login etc.
on the Veeam server I have sqlcmd available
in the registry on the veeam server I have two entries SqlLogin and SqlSecurePassword both of which are blank.
If I do not have the sa account available how can I get this to work?
How can I enable to sa account? or another account with elevated permissions
Thanks in advance
November 29, 2016 at 4:11 am
Check Server Properties to see if server authentication is set to "SQL Server and Windows Authentication mode".
If not change it and restart SQL Server service.
November 29, 2016 at 4:19 am
You shouldn't be using the sa account at all. If Veeam requires login and password then, after checking the authentication modes as Paul suggested, create a new account for Veeam and give it the permissions it requires.
sa should remain disabled.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply