Skip to main content
Nintex Community Menu Bar

K2 can connect to another sql server?

  • November 23, 2020
  • 5 replies
  • 36 views

Mootoon

I want to know > K2 can connect to another sql server? (Besides config sql server specified when installing k2 server.)

Thanks.

5 replies

  • November 23, 2020

Hi 992,

This is possible but a new instance of a service instance (SQL) needs to be created.

 

Regards,
Kevin Zhou


Mootoon
  • Author
  • Novice
  • November 23, 2020

Do you mean..... 
I can new service instance specified other sql Servers name  (not the main SQL Server)

Example:

Main sql server name :DB_PRO

The second database to use : DB_Temp 

I Can new the service instance in K2 management > service type : sql service specified Database name, server name?

Is there anything I need to do or set up any additional things?

Thanks.


  • November 23, 2020

Hi 992,

Yes as long as you’ve got permission and the login to the DB that you want to connect it, you should be able to create the new service instance to that DB.

As far as I know, there’s nothing additional that needs to be set up.
But if you run into problems, do come back to this post so that I can assist.

Regards, 
Kevin Zhou


Mootoon
  • Author
  • Novice
  • November 23, 2020

Thank you, I'll a give it try.


  • November 23, 2020

It’s a pleasure.