Forum Discussion
Deployment pipelines Parameters Invalid Rule
I have parameters set for my server and database for my data source
Im attempting to change to my test database
I know that this is correct and I have made sure I can log in to the data source in Service. All the credentials are OK. I cant work out why its saying Invalid Rule. Any help would be appreciated. the same thing happens when you do it through creating a database rule.
I have figured out the issue. Before you set up the rule, you need to go to the data set settings in your new App workspace. there you can ensure the correct parameters are in place and you have signed into the data source.
10 Replies
I have done everything the document says and its still failing
it sounds like it should work.
can you share more info on the datasource type and connection type,
or how are you using the param as part of the connection?
I have created these in desktop
And I have 3 sql databases on the server as a test
I have changed the database parameter in desktop. the last one wasnt working because of the table name. This is now resolved.
Back in the Pipeline...
No still saying invalid rule to both. I cant see any issues at all so Im currently very stuck. Am I doing something wrong?
Exactly the same issue when I try it as a data source rule.
The data source is an Azure SQL database.
So I cant do either at the moment.
Thanks for the thorough information.
regarding data source rules- this can't work if you already parameterized the server and DB,
it can only work with parameters now.
regarding parameters- please opena support ticket so we can further investigate.
if you have pipeline ID and error IDs, please provide them.
