You are viewing limited content. For full access, please sign in.

Question

Question

How to see my dababases in the workflow configuration wizard?

Workflow
Updated May 13, 2014
asked on May 12, 2014

I created previously the worfklow database in the database server and a user to log in the database, but when I am going through the wizard configuration manager and get to the part to config the database connection it does not show up the database in the list, and the user is db owner, i also gave the reading permition to master database to the user, but still no showing the database.

0 0

Answer

SELECTED ANSWER
replied on May 12, 2014

Prior to workflow version 9.1.1 I believe dbcreator was required to see if the database existed. 

 

After 9.1.1, one of these queries needs to find your database. 

 

exec sp_databases

 

SELECT name FROM sys.databases

 

 

0 0

Replies

replied on May 12, 2014

Can you try to use your SA username and password?  See if you get the drop down when using that account instead of Windows.  If you see it then, it has to be something with the rights of that user.  Can you try to manually type in the same of your DB?  

0 0
replied on May 12, 2014

Hi,

So i can´t use the sa username, but i replicate the same problem in my pc and with the sa user it did get the drop down with the databases in database server. I did think that being db_owner at least would show the database that its owner. I did try to type manually the database, however and goes by ok, but when i click to finish the operation it comes up an error saying that " Create Database permission denied on master", seems that the wizard did not find the database and than is trying to create! Does anyone know what kind of rights the user needs to see this list like the sa user?

0 0
SELECTED ANSWER
replied on May 12, 2014

Prior to workflow version 9.1.1 I believe dbcreator was required to see if the database existed. 

 

After 9.1.1, one of these queries needs to find your database. 

 

exec sp_databases

 

SELECT name FROM sys.databases

 

 

0 0
replied on May 13, 2014

Thanks a lot!, I was using an older version, 9.0.2 and only with dbcreator would show the list, and when a upgraded to 9.1.1 i didn't need the dbcreator!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...