Suggested Articles
Search found 7 matches
- Fri Mar 26, 2021 3:38 pm
- Forum: Common Problems
- Topic: Database created without privileges
- Replies: 4
- Views: 3038
- Jump to post
Re: Database created without privileges
Hello Catalin, just to let you know, after some tests we found out what the issue is. As soon as we enabled the option 'Run as administrator' under 'Install Parameters' the user could create a database despite his privileges. This seems to be a SQL Server feature and not an Advanced Installer proble...
- Tue Mar 23, 2021 9:31 am
- Forum: Common Problems
- Topic: Database created without privileges
- Replies: 4
- Views: 3038
- Jump to post
Re: Database created without privileges
Hello Catalin, yes, that is exactly our scenario. I double checked now, and the owner is indeed the user in question. I checked user's privilige directly on the database server by simply executing a 'CREATE DATABASE' statement, and it tells me: "CREATE DATABASE permission denied in database 'ma...
- Mon Mar 15, 2021 2:34 pm
- Forum: Common Problems
- Topic: Database created without privileges
- Replies: 4
- Views: 3038
- Jump to post
Database created without privileges
Hi, in our setup we allow the users to use a trusted connection to perform the database operations. Now using this, we have one user which actually has no rights to create databases on the database server, but the setup finishes successfully, also creating the database. Our predefined connection set...
- Mon Mar 15, 2021 2:05 pm
- Forum: Common Problems
- Topic: Check previous version upon new installation
- Replies: 5
- Views: 31487
- Jump to post
Re: Check previous version upon new installation
Hi, we're also trying to fetch the number of the currently installed version during an update. The search 'Product Version (identify by Upgrade Code)' returns '1' when we pass the Upgrade Code. (Expected would be something like '2.0.0'...) Are we doing it wrong? Also, is there an example on how to u...
- Mon Mar 08, 2021 2:58 pm
- Forum: Building Installers
- Topic: SQL connection test successful without username and password?
- Replies: 2
- Views: 2251
- Jump to post
SQL connection test successful without username and password?
When you don't check the option 'Trusted Connection' in the database dialog, AND don't provide any credentials (username, password), the operation 'Test SQL Connection' passes successfully.
Is this by design, and can you change that behaviour? It leads to a bit of confusion...
Is this by design, and can you change that behaviour? It leads to a bit of confusion...
- Mon Mar 08, 2021 10:02 am
- Forum: Building Installers
- Topic: Check SQL privileges on database connection dialog
- Replies: 1
- Views: 1838
- Jump to post
Check SQL privileges on database connection dialog
In our setup we have a dialog to configure the database connection, either to connect to an existing database, or to create a new one. If the SQL user provided doesn't have enought rights to do so, the setup fails at the installation step with an appropriate error message. Is it possible to move tha...
- Fri Oct 02, 2020 10:04 am
- Forum: Common Problems
- Topic: Error building project
- Replies: 6
- Views: 16279
- Jump to post
Re: Error building project
For us it has been also a problem with the names of SQL scripts. It seems that they contained invalid characters when autogenerated. After changing the names building was successful once again.