Friday, February 17, 2012

database creation

hi

if i open the management studio express and trying to create a database by right clicking the server name and trying in the new query window,im getting error as

CREATE DATABASE permission denied in database 'master'.

can anyone help me in rectifying this error?

Thanks in advance

It seems as though your login does not have permission to create a new database.

Log in as the administrator, and give your login the appropriate priviledges.

|||

hi arnie

thank you for your answer

I found another error as

when i opened the management express in windows authentication mode and tried to create table thats also did'nt work

after that i saw that i did'nt install the service pack 2

now the problem is solved after installing the SP2

i created my login and its working fine

thank you for ur response

thanks,

Poorani

No comments:

Post a Comment