Create database without admin privileges?

[Codename K]

Hello,

Is there a way to run SQL Scripts to create database in the SQL Databases section without admin privileges? Because, the installer needs to create databases in the SQL Server from standard users.

[Daniel]

Hello,

To do so you should make sure your setup project implements two settings:

1. has a "Per-user only" installation type set in "Install Parameters" page
2. has the [Impersonate User] toggle button enabled in the top toolbar section of the "SQL Databases" page

If you have any questions or doubts just let us know.

All the best,
Daniel

[Codename K]

Thanks. I tried this. But the installer ends prematurely. But works fine in administrator account.

[Daniel]

Hello,

There could be a SQL Server security roles (permissions) issue for the related Windows account. Could you try to manually run the same SQL script content you try to run within the setup package when logged in SQL Server under the related standard user account? For instance you could try this operation by using the SQL Management Studio.

If this is still of no help, then to further investigate this, can you please send us the .AIP (project file) and a verbose log of the installation to support at advancedinstaller dot com so we can investigate them?

All the best,
Daniel

[Codename K]

I get this error message when trying to run the SQL script in the SQL management Studio as standard user,

https://1drv.ms/u/s!An8X-C59SNlXg2y5kMlq8IUNRUD5

[Codename K]

Thanks for you help.

I think I found the issue. The installer was trying to run the SQL Script as Trusted Connection (Windows integrated authentication). I changed it to SQL Authentication and it works fine without admin access in standard user.

[Daniel]

Thank you for your follow up on this.

I am glad you got this solved.

All the best,
Daniel

[Codename K]

Thank you.

[Daniel]

You are always welcome.

All the best,
Daniel