none
user does not have permission (error 15247) RRS feed

  • Question

  • Hi,

    I have security admin role, but still I can not able to create login.

    Error: user does not have permission (error 15247)

    What is the issue here

    Thanks

    Shashikala


    Shashikala

    Friday, March 28, 2014 5:19 AM

Answers

All replies

  • The login you are trying to create another Login is a sysadmin? Try with sysadmin login.
    Friday, March 28, 2014 6:23 AM
  • No, I am not giving any role, just I tried to create 'sql server login'

    If I have security admin role, I should be able to create login, Am I right?


    Shashikala

    Friday, March 28, 2014 6:41 AM
  • Are you sure you have connected as security admin?

    Permissions              

                  
                

    In SQL Server and SQL Server PDW, requires ALTER ANY LOGIN permission on the server or membership in the securityadmin fixed server role.

    In SQL Database, only the server-level principal login (created by the provisioning process) or members of the loginmanager database role in the master database can create new logins.

    If the CREDENTIAL option is used, also requires ALTER ANY CREDENTIAL permission on the server.


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Friday, March 28, 2014 7:29 AM
  • Hi,

    I have security admin permission


    Shashikala

    Friday, March 28, 2014 9:20 AM
  • Hi,

    I have security admin permission


    Shashikala

    SecurityAdmin will be able to create login.

    BTB, Do you have any DDL Trigger?

    Select * from sys.server_triggers

    Friday, March 28, 2014 9:35 AM
  • No...

    Shashikala

    Friday, March 28, 2014 10:11 AM
  • Hi,

    I have security admin permission


    Shashikala


    Hi Shashikala K Bhat,

    According to your description, I do a test in SQL Server 2012. If the SQL Server login account has security admin permission, when you log in the SQL Server via this account, you can create a new login in the SQL Server. About the error message 15247, I recommend you use windows authentication mode and go to security then try create new login. If the error still exists, you can try reinstall your SQL Server.  

    There is similar issue about error 15247, you can review the following article.
    http://stackoverflow.com/questions/9185142/sql-server-2008-r2-express-permissions-cannot-create-database-or-modify-users

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, March 31, 2014 9:28 AM
    Moderator