Riverside

Create Database User

Discussion created by Riverside on Nov 22, 2011
Latest reply on Dec 18, 2012 by rwalker-esristaff
Dialog is all screwy.  Text is cut off at top.  Basically to dup, run add for a user but do not user a correct type of password.  See below at the bottom.


Executing: CreateDatabaseUser "Database Connections\Test2600@SQL2012@Denali@OS.sde" DATABASE_USER TedC ***** # #
Start Time: Tue Nov 22 17:31:34 2011
Error creating database user. [Failed to create the new login for the database. (ERROR: Failed to create sqlserver login TedC (-51).
Error: Underlying DBMS error (-51).
Extended error code: (15116)
Microsoft SQL Server Native Client 11.0: Password validation failed. The password does not meet Windows policy requirements because it is too short.
)]
Failed to execute (CreateDatabaseUser).
Failed at Tue Nov 22 17:31:35 2011 (Elapsed Time: 1.00 seconds)


Nice to have as part of this tool, is the ability to turn off Enforce Password Policy, along with perhaps User Must Change at next login.  Enforce Password Policy would be great to have especially for testing scenarios.


Dialog cut off for Enable Enterprise Geodatabase, too.  The dialog on the Results window, not the initial tool.

Attachments

Outcomes