473,903 Members | 4,199 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database permission error

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_helpsrvrolem ember command on my drive. It's
not on the server.

Any ideas?

Do anyone have any suggestions?

Thanks for your help,
T

"Andy Svendsen" <an********@NOM ORESPAM.yahoo.c om> wrote in message
news:#3******** ******@TK2MSFTN GP10.phx.gbl...
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_helpsrvrolem ember 'sysadmin'
-- or --
sp_helpsrvrolem ember '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>.<d atabase name>.<loginnam e> or <DOMAIN>\<usern ame> (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
an********@NOMO RESPAM.yahoo.co m

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" <ta********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP10.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$NE TSDK\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.


Jul 20 '05 #1
11 14268
Taishi (ta********@hot mail.com) writes:
I tried to search for the sp_helpsrvrolem ember command on my drive. It's
not on the server.


Searching the drive? There you will not find it. This is not a command
you run Explorer or the Command-Line Window.

This is a command that you run in Query Analyzer that comes with SQL Server.
From Query Analyzer you can pass any T-SQL command to SQL Server and
ser the result from it.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2
I am using WIN XP Pro and the SQL is the MSDE.

How can I check my access?

How can I resolve the following error?

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NE TSDK\Data\pubs. mdf'.

Thanks,
T.

"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** **************@ 127.0.0.1...
Taishi (ta********@hot mail.com) writes:
I tried to search for the sp_helpsrvrolem ember command on my drive. It's not on the server.
Searching the drive? There you will not find it. This is not a command
you run Explorer or the Command-Line Window.

This is a command that you run in Query Analyzer that comes with SQL

Server. From Query Analyzer you can pass any T-SQL command to SQL Server and
ser the result from it.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #3
Taishi (ta********@hot mail.com) writes:
I am using WIN XP Pro and the SQL is the MSDE.

How can I check my access?

How can I resolve the following error?

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NE TSDK\Data\pubs. mdf'.


Exactly what command did you run?

How did you log into SQL Server?

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #4
I haven't ran any commands. I just installed it and tried to access the
dbase from a web form. The error is in my first post. I installed the MSDE
2000 from the following web site:

ww.microsoft.co m/downloads

Featured download
Microsoft SQL Server 2000
Desktop Engine(MSDE 2000) Release A

I don't have the SQL server disks.

Any ideas? What commands can I use to check access rights?

Thanks,
T.

"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** *************@1 27.0.0.1...
Taishi (ta********@hot mail.com) writes:
I am using WIN XP Pro and the SQL is the MSDE.

How can I check my access?

How can I resolve the following error?

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NE TSDK\Data\pubs. mdf'.


Exactly what command did you run?

How did you log into SQL Server?

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #5
Taishi (ta********@hot mail.com) writes:
I haven't ran any commands. I just installed it and tried to access the
dbase from a web form. The error is in my first post. I installed the
MSDE 2000 from the following web site:

ww.microsoft.co m/downloads

Featured download
Microsoft SQL Server 2000
Desktop Engine(MSDE 2000) Release A

I don't have the SQL server disks.

Any ideas? What commands can I use to check access rights?


Obviously then that web form tried run some commands. Exactly where
did this web form come from? Did you write it yourself, or was it included
in the download?

Is the web server on the same machine as MSDE? And what rights does the
account that web server is logged in have?

I would assume that the web form logs into MSDE with Windows authentication,
but it does not have sysadmin privileges. If you give the web-server account
administrator privileges in Windows, things might go better. You may have to
restart the web server for the change to have effect.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #6


"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** **************@ 127.0.0.1...
Taishi (ta********@hot mail.com) writes:
I haven't ran any commands. I just installed it and tried to access the
dbase from a web form. The error is in my first post. I installed the
MSDE 2000 from the following web site:

ww.microsoft.co m/downloads

Featured download
Microsoft SQL Server 2000
Desktop Engine(MSDE 2000) Release A

I don't have the SQL server disks.

Any ideas? What commands can I use to check access rights?
Obviously then that web form tried run some commands. Exactly where
did this web form come from? Did you write it yourself, or was it included
in the download?

Is the web server on the same machine as MSDE? And what rights does the
account that web server is logged in have?

I would assume that the web form logs into MSDE with Windows

authentication, but it does not have sysadmin privileges. If you give the web-server account administrator privileges in Windows, things might go better. You may have to restart the web server for the change to have effect.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp


I wrote the Web form myself. Everything is on the same machine.

I have to figure out your question about the Web Server account.

I am using IIS and ASP. (i feel dumb)

Is IIS my web server?

Thanks for help,
T.
Jul 20 '05 #7
Taishi (ta********@hot mail.com) writes:
I wrote the Web form myself. Everything is on the same machine.
Ah, but if you wrote the web form, you also included commands for
SQL Server one way or another.
I have to figure out your question about the Web Server account.

I am using IIS and ASP. (i feel dumb)

Is IIS my web server?


I don't know much about IIS (or ASP), but I believe it is a web server.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #8
Erland,

Do you know how to use Enterprise Manager?

I was able to find a trial version of the Enterprise Manager.

After reading my error today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NE TSDK\Data\pubs. mdf'.

I can see the following in the MSDE manager:

sql server(my machine name\??SDK)
after I right click on 'PUBS' the following pops up.
---Users/Roles/Public
---public
---machine_name\as pnet
---guest

guest is the only one with 5 check marks going across from left to right for
the following:
Create Table, Create View, Create SP, Create Default, Create Rule

the following 3 are blank:
Create Function, Backup DB, and Backup Log

public has just 1 check mark on
Create SP

machine_name\as pnet is blank from left to right.

CREATE DBASE right is not displayed.

How can I solve my Permission denied error problem?

Thanks for the help,
Taishi

"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** **************@ 127.0.0.1...
Taishi (ta********@hot mail.com) writes:
I wrote the Web form myself. Everything is on the same machine.


Ah, but if you wrote the web form, you also included commands for
SQL Server one way or another.
I have to figure out your question about the Web Server account.

I am using IIS and ASP. (i feel dumb)

Is IIS my web server?


I don't know much about IIS (or ASP), but I believe it is a web server.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #9
Taishi (ta********@hot mail.com) writes:
Do you know how to use Enterprise Manager?
Barely. :-) I prefer to carry most of my task by submitting T-SQL
commands from Enterprise Manager.
I was able to find a trial version of the Enterprise Manager.

After reading my error today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NE TSDK\Data\pubs. mdf'.


But you still have not told us what that web form is doing! Sorry, I
cannot give much precise help if you don't explain what you are trying
to do.

But for the record, master and pubs are both databases that comes with
SQL Server, but they are very different. pubs is a regular user database,
and is there for demonstration and training purposes. master on the
other hand, is, as the name, indicates the master database. In this
database, SQL Server stores all server-wide information, for instance
which databases there are.

So the permission error applies to the master database, not to pubs.
I can't tell why you get this error, because I don't know what you
are doing (and you refuse to tell me). But since pubs already exist,
you cannot attach it anyway.

Anyway, what I tried to tell you last time, is that the web server
needs to connect to SQL Server with sysadmin privileges to create
databases, and to do that it must either log in as "sa" using SQL
Server authentication, or log using Windows authentication with an
account that has Administrator rights in Windows, or which have been
added to the sysadmin role in SQL Server.

So the rights you should are those that the IIS account has.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
2642
by: Anthony Best | last post by:
I'm working on an idea that uses sequences. I'm going to create a table like this: id serial, sequence int, keyword varchar(32), text text for every keyword there will be a uniq sequence for it eg:
4
2203
by: Jozef | last post by:
Hello, I'm trying to check for and add a field to a table to a back end database through code. The problem I've been faced with is changing permissions, because I have to use administer permissions to change the design, then remove the delete permissions when the design has been changed. I have to do it in code because there are several sites that need an automated update (as opposed to manually adding the field). The platform is...
3
7909
by: Russell Read [MSFT] | last post by:
Hi all, I am using VB script in ASP to access a MS Access database. This works fine until I want to access the same db placed on a file share. The code I am using is... 'create connection object Set db = Server.CreateObject("ADODB.Connection") 'specify the database provider
3
1416
by: MW de Jager | last post by:
I'm having endless problems with gaining access to an Access Database that sits on a different server. My ASP.NET app cannot gain control. The errror message I get is: The Microsoft Jet database engine cannot open the file '\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively by another user, or you need permission to view its data. I have setup the connection string to have the username = admin and the password is...
2
2125
by: Enska | last post by:
I have problems connecting my access database I get information .. I cant use my database and I'm administrator on my computer so permission shutnot bee problem, but I dont know Where is the problem. Can enybody help me!!!! Server Error in '/Koulu/tietokannat' Application. -------------------------------------------------------------------------------- The Microsoft Jet database engine cannot open the file...
2
2167
by: le0 | last post by:
guys, this is my first time to deploy website to the server, but every time i access the page this error always appears. --------------------------------------------------------------------------------------------- Server Error in '/sample' Application. -------------------------------------------------------------------------------- The Microsoft Jet database engine cannot open the file
3
6201
by: Rajendran | last post by:
Hi all, I've installed pyodbc module to access my database (MS Access). I've setup a User level DSN to the database.mdb file. When I run my python code in the command prompt it is retrieving the database contents and displaying it (HTML output). But when I run that python from webserver (http://localhost/cgi-bin/ database.py) there comes an entry in the error log of Apache server that says:
3
5650
by: Nathan Sokalski | last post by:
When I attempt to access a Microsoft Access database from my website, I recieve the following error: Server Error in '/' Application. -------------------------------------------------------------------------------- Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the...
12
6048
by: godiva | last post by:
Hi, Last week one client had errors caused by another program which led the IT guys to wipe out and rebuild the hard drive on one particular computer. Prior to this happening, the people in this department were using a 2000 format database through Access 2007 without any issues. Since IT rebuilt said hard drive, one user now gets a message when attempting to open the same database that 2007 cannot open older format databases. The...
0
9997
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9845
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10872
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10499
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9675
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5893
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4725
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4307
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3323
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.