Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Denied Permissions etc

Author  Topic 

cidr2
Starting Member

28 Posts

Posted - 2008-07-09 : 08:52:42
Hi There, This is my first post so hope everyone is well,

I've got a problem at work. The IT dept has installed SQL Server 2005 express on my XP Desktop computer and i'm trying to attach a DB to have a look at.
When I go to attach the DB I get the following message:

CREATE DATABASE permission denied in database 'master'.

Infact, when I try most things I get a permissions denied related message including trying to grant DB permissions in properties, creating DBs etc.

Now, I'm pretty sure this is a Permissions related error, however, i'm not sure how to go about resolving it. Should I tell my IT dept? would it be the Windows permissions I have? or is it something else?

Hope there's help out there!

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-09 : 09:43:44
Its permission issue.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-09 : 22:51:29
You need proper permission in sql server to do those things, ask your IT guys to grant you permission.
Go to Top of Page

cidr2
Starting Member

28 Posts

Posted - 2008-07-30 : 03:58:34
Hi there, sorry fot the delay in getting back, you're right, permissions and everything's ok now,

cheers:)
Go to Top of Page
   

- Advertisement -