Skip to main content
To homepage To homepage

Instead of creating a database from within the TimeXtender interface with the Create Storage option suggested in the standard procedure, I want the TX instances to be connected to exisiting databases on an SQL server. I want to do this for ODX as well as MDW instances.

 

The SQL login to be used by Timextender is not allowed to have sysadmin or dbcreator privileges on the SQL Server, and can therefore not be used to create the databases.

 

If I press Create storage with the name of the existing database specified for the instance in the portal, I get an error message saying the database already exist, but with no visible option to utilize the database.

 

Application
Portal
SSMS Database

How can I connect to existing databases for instance storage instead of creating new ones?

Hi,

for the ODX storage you should be able to use an existing one. I have not tried for a DWH instance yet. If that does not work, I would have your DBA log in with credentials that are allowed to create a database and perform the creation from there.

Thank you. I could indeed connect the ODX instance to an exisiting database.

 

Is there a way to connect the MDW instance without involving the DBA? This would be considerably simpler in my case.

 

Without dbcreator privileges I get this error message when pressing Create storage for the MDW, targeting an existing database:

 

 

The MDW instance connected successfully to the database when I tested the connection and it seems like TX is able to utilize the database without the Create storage procedure.

Hi 

I would like to add that while you can’t create a DW instance database in this menu if it does already exists. You can use it. So you do not have to click Create first, if it already exists, is empty and you can test the connection successfully it will be usable.

Reply


Terms and ConditionsCookie settings