Skip to main content
To homepage To homepage
Solved

Connect instances to existing SQL Server databases for storage

oscarcleve
Contributor
Forum|alt.badge.img+1

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?

Best answer by Thomas Lind

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.

View original

4 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 658 replies
  • August 19, 2024

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.

anders.e.jonsson
oscarcleve
2 people like this
  • anders.e.jonsson
    anders.e.jonsson
  • oscarcleve
    oscarcleve
oscarcleve
Contributor
Forum|alt.badge.img+1
  • oscarcleve
  • Author
  • Contributor
  • 15 replies
  • August 21, 2024

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:

 

 

oscarcleve
Contributor
Forum|alt.badge.img+1
  • oscarcleve
  • Author
  • Contributor
  • 15 replies
  • August 22, 2024

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.

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1029 replies
  • Answer
  • August 22, 2024

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


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings