create database failed

  • I try to create database in sql server(logon as windows authentication).

    GOT ERROR : "User does not have permission to create database".

    Then i tried to enable 'sa' account.but it also failed .

    i think 'sa' account have admin privilege.other users with admin privilege are removed from domain.

    when i goes to the sql server configuration manager-> sql server services,

    got error" Remote procedure call failed"

    what want do to enable 'sa' account and add privilege to user ?

  • Do you know a login for anyone with sysadmin, securityadmin or dbcreator?

    If not you will need to add yourself as a local admin on the Windows host where SQL is installed, start SQL in single user mode, add yourself as a sysadmin and then you can go from their.

  • sumith1andonly1 (2/13/2013)


    I try to create database in sql server(logon as windows authentication).

    GOT ERROR : "User does not have permission to create database".

    Then i tried to enable 'sa' account.but it also failed .

    i think 'sa' account have admin privilege.other users with admin privilege are removed from domain.

    when i goes to the sql server configuration manager-> sql server services,

    got error" Remote procedure call failed"

    what want do to enable 'sa' account and add privilege to user ?

    Have you tried contacting your database administrator?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • what want do to enable 'sa' account and add privilege to user ?

    I think the 'sa' account is due to be deprecated in future versions of SQL Server but has the same privileges as sysadmin so you'd be better off using sysadmin but as Perry has said - if you're not the DBA for the server/DB then you'd need to contact them first rather than granting yourself access and then incurring the wrath of a scorned DBA!! :crazy:


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • Not trying to be ignorant here, but if you don't have access to create databases on that server, then maybe you shouldn't be creating databases on that server. Instead, contact the DBA and have them do it for you, have the db_owner database role granted to you and go from there.

    There may be reasons why you can't create a database. There may be a specific backup schedule that needs to be updated. There may be maintenance scripts/jobs that should include your database. I would definitely contact the DBA instead of having a "rogue database" show up on one of his reports with your name on it.

  • Ed Wagner (2/14/2013)


    I would definitely contact the DBA instead of having a "rogue database" show up on one of his reports with your name on it.

    +1 on the above.

    As part of my daily SQL Server checks I run a script that lists logins created in the last 48 hours which includes permission types and permission states along with checking each database on the SQL instance. If I find a rouge login or a new database that I'm not aware of I go on the prowl for a culprit!! It's security 1-0-1 and I'm deeply possessive of my SQL Servers!! 😀


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • actually , there are 5 logins including 'sa' login. none of them have the privilege to create database or change privilege except 'sa' login.

    but 'sa' login is disabled.

    when i tried to enable it using other user , it will fail( reason current login doesn't have privilege to change/add privilege).

    i think there is login with syssdmin privilege ,only can assign privilege to other login....

    i was trapped in all means.

    i dont know how......?

  • I think your first step should be to speak with your DBA.

  • its my challenge to to solve it myself...

  • sumith1andonly1 (2/14/2013)


    its my challenge to to solve it myself...

    Question not asked, are you the DBA on this server?

  • no im just a developer. but im trying to be a DBA

  • sumith1andonly1 (2/14/2013)


    no im just a developer. but im trying to be a DBA

    Polite tip: if you're after access to a sysadmin style login and you're not the DBA looking after the database server but you want to get into the DBA side of things, I'd suggest getting in touch with your DBA and getting to know him/her rather than circumventing them and trying to solve the issue yourself (an admirable but flawed action when you ignore the expertise of the one person that can help and guide you), plus we're generally an approachable bunch that when buttered up the right way will help anyone!! 😀


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • thanks

  • Here's another thread on the forum regarding moving from a developer role to a DBA that you may want to have a look at: http://www.sqlservercentral.com/Forums/Topic1419857-391-1.aspx

    There's a post on there from ScottPletcher that gives some good starting points.


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • sumith1andonly1 (2/14/2013)


    no im just a developer. but im trying to be a DBA

    All I am going to say is this, stop trying to circumvent the DBA. His (or her) job is to protect the database system. You need to enlist the help of your DBA. If you want to become one, approach one, in this case yours. Start working with him (or her). All I can tell you is if you keep going in the direction you are currently treading, it won't end pretty.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply