Question

Error=0x106 CREATE DATABASE permission denied in database 'master'

Laserfiche

Updated June 20, 2018

asked on June 18, 2018

Hi all,

I'm trying to create a repository but I can't.

At the end, I have an error.

The Laserfiche server encountered an error while attempting to create or attach the repository:
9025 - Error reading repository information or repository is misconfigured.

Under the Viewer event, I got this error :

There was an error creating the Laserfiche repository "repository". Function=CREATE DATABASE [repository] ON (NAME = 'Primary_dat', FILENAME = 'c:\REFERENTIEL repository\repository.mdf'); Error=0x106; [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Autorisation CREATE DATABASE refusée dans la base de données 'master'.

It looks like I don't have permission to create a database.

Next, under SSMS, I tried to create my database first then I tried to attach it but I still have the same result.

My question is : How can I resolve this?

Thanks in advance.

Regards

0 0

Answer

SELECTED ANSWER

replied on June 20, 2018

Hi all,

Just for information ; i couldn't "GRANT" my actually account.

I create a new one and give it the right to create database and use this new account to create my repository.

Have a good day all.

Regards

0 0

Replies

replied on June 19, 2018 • Show version history

It's probably the Laserfiche service account that doesn't have permission to create databases. Login to SSMS as a sysadmin and run this for whatever your service account's name is:

USE master;
GRANT CREATE ANY DATABASE TO LaserficheServiceLogin;

1 0

View 5 previous replies

replied on June 19, 2018

Hi Scott,

Thank you for your return. I'm not pretty good with SSMS.

You said to run the code above for whatever my service account's name is ; i'm not really understand. Do I just need to run the code or do I need to change "LaserficheServiceLogin" by something?

0 0

replied on June 19, 2018

Yes, you'll need to replace that with whatever you're using as the service account for the "Laserfiche Server" service (you may see it as "Log On As").

0 0

replied on June 19, 2018

Ok, so in my case...

This should be like that, right?

USE master;
GRANT CREATE ANY DATABASE TO USER1\Olivier;

0 0

replied on June 19, 2018

No, that's your personal login. You need the service account:

0 0

replied on June 19, 2018

Scott,

This is a local system

0 0

replied on June 19, 2018

Then I'm not sure how that works at all, unless you're running SQL on the same box and have given access to [NT AUTHORITY\SYSTEM] (which doesn't seem like a good idea).

Sorry, not sure how to help from there.

0 0

replied on June 19, 2018

Ok np.

I'm going to try like this.

Thank you for your help anymore.

0 0

SELECTED ANSWER

replied on June 20, 2018

Hi all,

Just for information ; i couldn't "GRANT" my actually account.

I create a new one and give it the right to create database and use this new account to create my repository.

Have a good day all.

Regards

0 0

You are not allowed to follow up in this post.

Question

Question

Error=0x106 CREATE DATABASE permission denied in database 'master'

Answer

Replies

Sign in to reply to this post.