Error message when connected to the server

Version 4 V4 Question
1

image.jpg750×1334 219 KB
I get the following error message when I am connected to my server and try to backup my data base. Is this something I did wrong?

2

May I assume your running SambaPOS4? Using a CE database. Why not SQL Server. Need some more info about your configuration and setup.

3

Yes sorry sambapos4. I set up the 2014 sql server. I then converted my ce over to sql. I was able to open and run sambapos4 but am not able to backup the database

4

Can you do a screenshot of you database connection settings - just to confirm?

5

image.jpg750×1334 222 KB

6

image.jpg750×1334 129 KB
image.jpg750×1334 272 KB

This is my connection string and the server name

7

Which version of Windows are you running 8.1??
Try just to create a new folder on the C drive [c:\backup] and have there your backup placed. Give the folder R/W rights.

8

Yes windows 8.1. I created a file in c drive and this is what it said

image.jpg750×1334 245 KB

image.jpg750×1334 228 KB

9

Are you sure you have R/W permissions on this folder, Windows 8.1 is strange with there securities.
You have to create the folder first in Windows.

10

You can use any location if you add permissions, see this post

11

It says full access.

image.jpg750×1334 142 KB

12

OK you have full access but - as sql server service taking backups- the user account running sql server service should also have access to that folder. It is a little tricky. The best solution will be setting up your backup folder somewhere under [MyDocuments] folder.

13

I am still getting the same error message.

image.jpg750×1334 147 KB

14

Self explanatory SQL server does not have permission. Try another hard drive if you have it or try external media.

1 Like