Howdo i Backup my SQL 2014 Database

[JuergenB]

Hi,

i can´t backup or even connect to my sql server 2014 Std Edition?
What i did ...

I disabled the firewall at the remote server.
I added the service logon account to the security login of the sql 2014 server.
I added the system account sysadmin rights.

I installed the BE 2014 Agent

Is there any whitepaper, howto add and configure the agent on the remote server?
 

[CraigV]

Hi Juergen,

Check the TN below to make sure your BESA has the correct rights:

http://www.symantec.com/business/support/index?page=content&id=TECH130255

Can you connect to the RAWS agent from the media server by browsing it? If not, make sure that port 10000 is open on any firewall running on that SQL server.

Thanks!

[JuergenB]

Hi,

Firewall has been disabled on the remote Windows 2012 R2 server.
The Port 10000 should be open for SQL 2014

service account has local admi rights and has sysadmin right in SQL 2014 RTM

[CraigV]

...any AV installed on that server that might be blocking the RAWS agent?

[JuergenB]

No AV installed.

This is the error message.

Browse Failure

Failure to browse 'MSSQLSERVER'.

A network connection to the server could not be established.

QueryMetaData: MDQ_BackupResourceBrowsing_View
ResourceContainerID = '0b32966a-f313-4a2c-8340-29f943d81cba'
MDS_BackupResourceBrowsing_View_Parameter_ConnectionLogon = '10011001-1001-1001-0101-010101010101'
MDS_BackupResourceBrowsing_View_Parameter_QueryMode = '5'
MDS_BackupResourceBrowsing_View_Parameter_DeviceName = 'srv-j2v-hyp03.ghana.mbi.de\MSSQLSERVER'
MDS_BackupResourceBrowsing_View_Parameter_DsType = 'Sql2Server'
MDS_BackupResourceBrowsing_View_Parameter_OsId = 'Sql2Id'

[JuergenB]

If i TEST the logon account against the SQL 2014 i can select the System Logon Account and the remote server (that one with SQL 2014) and i have a Successful test against this server.

But i can`t Browse for the SQL database.

[JuergenB]

Is the SQL Version wrong?

Microsoft SQL Server Enterprise: Core-based Licensing (64-bit)
Version 12.0.2000.8

I can browse the Remote C: Drive and System State for item selection.

[pkh]

1. Is the SQL Server option licensed and installed on the media server? 2. Is Windows authentication enabled on the SQL instance?

[JuergenB]

Problem (mostly) solved, maybe a bug ...:

The user (me) that works with the BE 2014 console
needs to have sysadmin rights on the database for browsing the sql server 2014 and it´s content.

And the user needs to have local admin rights on the remote server.

Strange ..

The system logon account (BESA) doesn´t need any rights on the SQL server 2014 NOT for browsing and NOT for taking backups!

works without BESA in the sql 2014 (security / login)

@pkh

SQL 2014 is a VLK, onyl windown authentication enabled.

BE 2014 is taking backups of 4-5 SQL Servers (2005,2008,2012) in my network.