unable to create database with windows authentication login

• srinivas.mukkanti

  SSC Veteran

  Points: 288

  More actions

  September 12, 2014 at 11:52 pm

  #296100

  hi i am connecting to my laptop thru windows authentication with my machine\sqlexpress and i am able to login, if i try to create new database it gives me an exception no 262: create database permissions denied in database master,

  i could not create fresh users under logins option also, i tried different options in google but could not resolve this,

  i tried restarting sql service in single user mode also ,

  can someone guide me on this.

• karthik babu

  Hall of Fame

  Points: 3335

  More actions

  September 15, 2014 at 12:33 am

  #1745367

  1) Login using sa

  2) Grant create database permission to your windows user

  3) Now try with windows authentication

  ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

• Eirikur Eiriksson

  SSC Guru

  Points: 182631

  More actions

  September 15, 2014 at 1:33 am

  #1745379

  Another option if the sa login is not available is to run SSMS as Administrator and make the necessary changes.

  😎