Monthly Archives: October 2013

How to enable mixed mode authentication in MS-SQL server

Open the SQL server configuration studio Login with appropriate admin-level privileges In the main console, right-click your server and choose “Properties” Click on “Security” Under “Server authentication”, ensure that “SQL Server and Windows authentication mode” is selected Choose OK You … Continue reading

Posted in Microsoft SQL Server | Leave a comment

Enable MS-SQL server to listen on IP addresses

Open SQL server configuration manager Click into “Protocols for <SQL_INSTANCE>” Right-click TCP/IP and choose Properties (ensure it’s set to enabled) Click into the “IP Addresses” tab There will be a section for each IP address that the machine has – … Continue reading

Posted in Microsoft SQL Server | Leave a comment

How to enable TCP/IP on MS-SQL server

Open the “SQL Configuration Manager” Expand “SQL Server Network Configuration” Click into “Protocols for <SQL_INSTANCE>” Right-click “TCP/IP” and choose “Properties” Choose “Enabled” Click OK Restart the SQL server instance – this can be done from the “SQL server services” item … Continue reading

Posted in Microsoft SQL Server | Leave a comment

How to add a dedicated SQL backup service account

Open SQL management studio Connect to the session as an appropriate admin user (this can be done using either Windows or SQL authentication) to the SQL instance Expand Security->Logins Right-click Logins and choose “new Login” Add the backup service account … Continue reading

Posted in Microsoft SQL Server | Leave a comment

[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database ‘XXXX’.

Error [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database ‘XXXX’. Cause The user connecting does not have appropriate SQL permissions to access the database (scheduled backups use SQL authentication NOT Windows authentication). TCP/IP is not enabled on the … Continue reading

Posted in MS-SQL Errors | Leave a comment

No database file found for ‘Microsoft SQL Server\SERVER\INSTANCE\Database’

Error No database file found for ‘Microsoft SQL Server\SERVER\INSTANCE\Database’ Cause This means that the database was attempted to be backed up but the backup file does not exist. It can be caused by the spooling location holding previous SQL backup … Continue reading

Posted in MS-SQL Errors | Leave a comment

SQL Server Driver][SQL Server]Cannot open backup device XXXX Operating system error 3(error not found)

Error [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device ‘XXXX’.  Operating system error 3(error not found) Cause This is likely due to corrupted/incorrect data within the spooling location. Resolution Ensure CyberSecure Advanced is on the latest version. Clear the spooling … Continue reading

Posted in File backup: Server: general issues | Leave a comment