Post reply

create new database

  • August 16, 2012 at 5:06 am

    #392960

    TITLE: Microsoft SQL Server Management Studio

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

    Create failed for Database 'mydb'. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

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

    ADDITIONAL INFORMATION:

    Hi there i've got a problem,im trying to create new database and i cant.Help please:)

    Thats my problem:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

    CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

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

    BUTTONS:

    OK

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

  • August 16, 2012 at 5:09 am

    #1526477

    You need SysAdmin, explicit permissions to run CREATE DATABASE or the dbcreator fixed server roles assigned to the login trying to create the database in order for it to be able to create the database.

    Can you confirm the security rights of the user in question?

  • August 16, 2012 at 6:58 am

    #1526540

    hi again,thank you for help, but to be honest I dont know what are you talking about:)))

    I'm new with SQL, I have to create new database to work in BIDS. I'm in the same place for 4 hrs:(((

    angry!

  • August 16, 2012 at 7:05 am

    #1526545

    Speak to your DBA and ask them to create you a database and grant you the nessesary access to the database to perform your duties.

    Your permissions are not high enough to create databases.

  • August 16, 2012 at 7:08 am

    #1526547

    thank you:)

  • August 17, 2012 at 6:28 am

    #1527049

    I need to set permissions on the server to assign permissions to the account im loged on.

    no clue how to do this.

    Help!

  • August 17, 2012 at 6:37 am

    #1527052

    You need to grant the nessesary access to your account, so you will need to login as an account which has the right access to change user permissions.

    Typically your DBA would do this for you.

    Do you know of an account which you can login as like SA or something which has SysAdmin rights?

  • August 17, 2012 at 7:03 am

    #1527061

    I'm all alone with this:(

    I have to find out what to do, and do it..

    That's why I'm looking for some help in here.

    My boss have no idea what's SQL, so i can't ask for help.

    Thanks for help.

  • August 17, 2012 at 7:09 am

    #1527065

    Follow the instructions on this link http://technet.microsoft.com/en-us/library/dd207004.aspx

    Make sure you are a local admin of the server where SQL is installed.

    Then once the above has been done and SQL is in Single User mode, you can add in your account and give yourself SA rights.

  • August 17, 2012 at 9:30 am

    #1527136

    Thank you:))))

Viewing 10 posts - 1 through 9 (of 9 total)

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