Page 1 of 1

Unable to create database connection

PostPosted: 2016-08-01 15:02
by bcoppens
System information: [ Citavi Version 5.2, Windows 7, English, Internet Explorer 10-11, -, - ]

Hi,

I try to create a DB connection.
Our DBA created a database for us (called CitaviDB) and setup a user who has the db_owner role.

When I want to create the connection, I got the following error message:

CREATE DATABASE permission denied in database 'master'

Could you please help?

Thanks,
Beonit

Re: Unable to create database connection

PostPosted: 2016-08-02 13:26
by Sebastian Pabel
Dear Benoit,

I'm not entirely sure at which step in the process the issue occurs. Is it right that your admistrator has set up the database using the Citavi DB Manager on a full size Microsoft SQL Server according to this procedure and you now want to create one or more Citavi Projects in that database ("CitaviDB")?

According to the error message you are trying to create a whole new database. Could you please quickly specify at which step exactly the error occurs and if user management is handled through Active Directory or through individual SQL users? Thanks.

Best regards
Sebastian

Did we answer your question completely? If so, please click the green check mark in the upper-right corner of this post. This helps other users find the solution to their questions.


Re: Unable to create database connection

PostPosted: 2016-08-02 14:00
by bcoppens
Hi Sebastian,

The error happens when I want to create a connection.
But the behavior a little bit different compared to yesterday.

I enter the connection details - see screenshot 1.
I test the connection via the "Advanced" button - see screenshot 2 - connection is successful
I want to select the already existing DB but not working today - the list is empty - see screenshot 3
But I know the DB exists - see screenshot 4

Rgds,
Benoit

Re: Unable to create database connection

PostPosted: 2016-08-02 14:01
by bcoppens
Adding the 4th attachment

Re: Unable to create database connection  Topic is solved

PostPosted: 2016-08-04 09:22
by bcoppens
Issue has been solved with support.
The DB must be created by Citavi DBServer Manager using a user having the DBCreator role or by a DBA using the script available on https://www.citavi.com/sub/manual5/en/server_configuring_sql_server.html