Can i use SmartObject with exist Database?

You can use the SQL Server Service to create SmartObjects from existing databases. Have a look at the following location in the Help File:

K2 Workspace > K2 Management Console > SmartObject Services > SmartObject Services > The SQL Server Service

Thanks! but i have tried many times with many ways but i found error as below.

"A connection was successfully established with the server, but could not connect to the database supplied or database could not be found. "

i don't know why it couldn't connect DB, pls kindly advise and show me the sample.

Thanks a lot!

Jack

Hi,

Create the service Instance for that datbase and provide the connection string correctly with database name.

It will Work......:)

Regards,

Seeshil 

Thank you everyone, now i can add this service... but i cannot find it when i browse at workflow (found only old smartobject)

how to use it?

You can refer to the below blog post. Very informative.

http://www.k2underground.com/blogs/johnny/archive/2010/08/04/k2-4-5-tip-of-the-day-using-the-sql-service-broker.aspx

Goto SQL -> Security - >> Login >> ( choose your User ) >> Right Click >> Propperetis >> User Mapping >> choose your Database And make it  Db owner
 Db reader, writer, admin