SQLAzure: Creating Database User from Dacpac

Is it possible to create custom Database users with post deployment steps, and get it deployed as part of Dacpac ?

February 26th, 2015 6:06pm

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


Free Windows Admin Tool Kit Click here and download it now
February 27th, 2015 9:29am

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


February 27th, 2015 9:29am

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


Free Windows Admin Tool Kit Click here and download it now
February 27th, 2015 9:29am

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


February 27th, 2015 9:29am

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


Free Windows Admin Tool Kit Click here and download it now
February 27th, 2015 9:29am

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


February 27th, 2015 9:29am

Hi,

It seems that the SqlPackage.exe Import action does not have any parameters that you want use to specify the database version or MAXSIZE of target server.
You can refer to the following article about Import Parameters and Properties of SqlPackage,exe
http://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx

Ref: https://social.msdn.microsoft.com/Forums/en-US/e5fef831-7f52-4626-8923-0aa493efc2a8/sqlserver-2012-partially-contained-database-user-created-by-dacpac-cannot-login?forum=ssdt

Hope this helps you.

Girish Prajwal


Free Windows Admin Tool Kit Click here and download it now
February 27th, 2015 9:29am

Thanks Girish for the reply. I wonder if your reply is meant for my question.

To be more specific, in sql projects we can have post deployment steps to create user in the database, which works perfectly fine in on- premises.

Will this work the same way in SQL Azure deployment. Can we have post Deployment steps to create database users ? Can this be part of the project output - DACPAC ?

February 27th, 2015 5:10pm

Could someone please help me with the answer for this one! Thanks

Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2015 5:24pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

  • Proposed as answer by Mukesh(MSFT) 18 hours 45 minutes ago
March 10th, 2015 8:22am

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

  • Proposed as answer by Mukesh(MSFT) 18 hours 54 minutes ago
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 8:23am

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

  • Proposed as answer by Mukesh(MSFT) Tuesday, March 10, 2015 12:22 PM
March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

March 10th, 2015 12:22pm

Hello Pradebban,

Just check if it helps.

http://weblogs.asp.net/gunnarpeipman/using-visual-studio-database-projects-in-real-life.

let me know your thoughts.

Regards,

Mukesh

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 12:22pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

March 17th, 2015 4:22pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 4:23pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

March 17th, 2015 8:21pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 8:21pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

March 17th, 2015 8:21pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 8:21pm

This is not the one which am looking for and this does not solve the problem.

Answer is, we cannot publish a user from Dacpac on SQL Azure.

Instead we would need to do the following.

  • Create a Login (Same as the user name) before deployment
  • Deploy the database - Publish Dacpac
  • Associate the Login to create a new user
  • Provide permission for the user to access specific database objects

March 17th, 2015 8:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics