This forum is read-only - Please use our new Citavi Forum instead.
Dieses Forum dient nur zur Recherche - Bitte nutzen Sie das neue Citavi Forum für Ihre Fragen.

Unable to create database connection Topic is solved

Got questions about Citavi 5? The Citavi team and other users are happy to help.

Unable to create database connection

Postby bcoppens » 2016-08-01 15:02

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
bcoppens
 

Re: Unable to create database connection

Postby Sebastian Pabel » 2016-08-02 13:26

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.

Sebastian Pabel
Site Admin
 

Re: Unable to create database connection

Postby bcoppens » 2016-08-02 14:00

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
Attachments
1.png
Entering connection details
2.png
Successful connection test
3.png
Unable to select existing DB
bcoppens
 

Re: Unable to create database connection

Postby bcoppens » 2016-08-02 14:01

Adding the 4th attachment
Attachments
4.png
DB details from SQL Server Studio
bcoppens
 

Re: Unable to create database connection  Topic is solved

Postby bcoppens » 2016-08-04 09:22

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
bcoppens
 


Return to Citavi 5 Support (English)



cron