Can't See SQL Databases in pull down when using the SQL Data Event

  • 26 November 2007
  • 3 replies
  • 0 views
J
Badge +2

Looked to see if someone else asked this already, but did not find it.  Sorry if it is a dup question.


 I have made a successful connection to SQL, but when I click the down arrow for select a database it is a blank/empty pull down.


 


Any ideas?


 


Thanks.


 


Jim

3 replies

B
Badge +3
Are you connecting to SQL2005?  I have found this to be a problem also.  The workaround I came up with was to generate the code by connecting to a SQL2000 database, then editing the code manually.  The code works fine with SQL2005, but the wizard does not.
D
Badge +6

Also check rights on the MASTER database.


A stored procedure exists there which K2 uses to inventory the databases on the machine. If the user does not have rights (like DBO), the list will not be loaded.

J
Badge +2

I am using SQL2005.  I had it working on my dev box, but not on my QA box.  What I have found is that if I don't have the DBcreator role set on the SQL account it cannot see the databases.


I will check the DBO rights also.


 thanks.


Jim

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings