Database permission error

Windows Pro
Receiving the following error:
CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK\Data\pubs.mdf'.
Here are some things done to try to resolve the problem:
Reboot 4-5 times
Shared out the folder
Web shared the folder
Thanks for your help,
T.Are you connecting with a trusted connection or as sa. It sounds like you
do not have the access required to create a database. Make sure you are
connecting in as a member of the Administrators group on that machine so you
become part of the sysadmin (aka System Administrators) role. At a minimum
you need the dbcreator role level access. Running
sp_helpsrvrolemember 'sysadmin'
-- or --
sp_helpsrvrolemember 'dbcreator'
will tell you who belongs to these roles. Looking at the Query window title
bar will tell you who you are logged in as.
<servername>.<database name>.<loginname> or <DOMAIN>\<username> (for Win NT
authentication)
Reboot and sharing the folder will not help. You might want to check the NT
permissions though.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:%23ZocZIy6DHA.2568@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Windows Pro
> Receiving the following error:
> CREATE DATABASE permission denied in database 'master'. Could not attach
> database 'pubs' to file 'D:\Program Files\Microsoft SQL
> Server\MSSQL$NETSDK\Data\pubs.mdf'.
> Here are some things done to try to resolve the problem:
> Reboot 4-5 times
> Shared out the folder
> Web shared the folder
>
> Thanks for your help,
> T.
>
>

---

|||Andy,
I am new to SQL. It was hard just to figure out how to install it.
I know I am logged in as a Admin. in Windows.
I have the little server box with the round circle on it in the bottom right
corner(toolbar). The SQL Server Service Manager.
I tried to search for the sp_helpsrvrolemember command on my drive. It's
not on the server.
Any ideas?
Thanks for your help,
T
"Andy Svendsen" <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:#3883ky6DHA.2628@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Are you connecting with a trusted connection or as sa. It sounds like you
> do not have the access required to create a database. Make sure you are
> connecting in as a member of the Administrators group on that machine so

---

you

quote:

---

> become part of the sysadmin (aka System Administrators) role. At a

---

minimum

quote:

---

> you need the dbcreator role level access. Running
> sp_helpsrvrolemember 'sysadmin'
> -- or --
> sp_helpsrvrolemember 'dbcreator'
> will tell you who belongs to these roles. Looking at the Query window

---

title

quote:

---

> bar will tell you who you are logged in as.
> <servername>.<database name>.<loginname> or <DOMAIN>\<username> (for Win

---

NT

quote:

---

> authentication)
>
> Reboot and sharing the folder will not help. You might want to check the

---

NT

quote:

---

> permissions though.
> --
> ****************************************
***************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> Always keep your antivirus and Microsoft software
> up to date with the latest definitions and product updates.
> Be suspicious of every email attachment, I will never send
> or post anything other than the text of a http:// link nor
> post the link directly to a file for downloading.
> This posting is provided "as is" with no warranties
> and confers no rights.
> ****************************************
***************************
> "Taishi" <taishi_bak@.hotmail.com> wrote in message
> news:%23ZocZIy6DHA.2568@.TK2MSFTNGP10.phx.gbl...
>

---