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.
*******************************************************************
[quoted text, click to view] "Taishi" <taishi_bak@hotmail.com> wrote in message
news:%23ZocZIy6DHA.2568@TK2MSFTNGP10.phx.gbl...
> 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.
>
>
>
