I can't create a database T__T

Question

I can't create a database T__T

Viewing 4 posts - 1 through 5 (of 5 total)

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

Lowell SSC Guru Points: 323741 More actions · Answer 1

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: 234065 More actions · Answer 2

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: 2170 More actions · Answer 3

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 · Answer 4

😀 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