I can't create a database T__T

• Quatrei.X

  SSCrazy

  Points: 2697

  More actions

  December 25, 2008 at 6:54 am

  #125992

  Hi there,

  Merry Christmas you al!!!

  I just downloaded and installed sql server 2005 management studio express on my new laptop... (Vista OS with SP 1) i haven't configured or altered any settings yet but i can't create a simple database.

  I used windows authentication

  and just run something like this

  CREATE DATABASE TestDB

  and this is what I get

  Msg 262, Level 14, State 1, Line 1

  CREATE DATABASE permission denied in the database 'master'

  I usually work with XP... is that the problem??? Vista???

  T___T Any suggestions would be greatly appreciated

  Thanks Everyone and have a merry Christmas and a joyful new year.

  _____________________________________________
  [font="Comic Sans MS"]Quatrei Quorizawa[/font]
  :):D:P;):w00t::cool::hehe:
  MABUHAY PHILIPPINES!

  "Press any key...
  Where the heck is the any key?
  hmmm... Let's see... there's ESC, CTRL, Page Up...
  but no any key"
  - Homer Simpson

• Lowell

  SSC Guru

  Points: 323518

  More actions

  December 25, 2008 at 8:10 am

  #917632

  i think it's Vista;

  compared to XP, where every login was also an admin, didn't Vista remove some rights you might expect by default for security purposes? so your login has rights to a lot of stuff, but not an admin.

  Since you are connecting via login and not as a SQL user, I think that's the issue.

  if your login on your vista machine is not in the Administrators group, you can probably connect, and the missing admin rights prevent you from creating a database(and probably backup and restore as well)

  try

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  December 25, 2008 at 11:49 am

  #917657

  Vista users run as low privelege normally, what does sql authentication produce running the same statement?

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

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

• sqlizer

  SSCrazy

  Points: 2120

  More actions

  December 25, 2008 at 7:59 pm

  #917676

  I haven't used vista so far but i have seen other ppl using it and what they were doing is they were opening application like SSMS as Administrator. Basically what they did was Right Click on SSMS and select open as Administrator or something similar to it.

• Quatrei.X

  SSCrazy

  Points: 2697

  More actions

  December 25, 2008 at 9:47 pm

  #917681

  😀 Man, I love you guys!!!

  Thanks!

  :)Hi sqlizer, i tried the rightclick then open as administrator... :w00t:IT WORKED ^__^ Wohooo!!! Thanks!!!:hehe:

  Thanks Guys!!! ^__^

  :w00t:Merry Christmas and a Happy New year to you all!!!:w00t:

  _____________________________________________
  [font="Comic Sans MS"]Quatrei Quorizawa[/font]
  :):D:P;):w00t::cool::hehe:
  MABUHAY PHILIPPINES!

  "Press any key...
  Where the heck is the any key?
  hmmm... Let's see... there's ESC, CTRL, Page Up...
  but no any key"
  - Homer Simpson