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?
Do anyone have any suggestions?
Thanks for your help,
T
"Andy Svendsen" <an********@NOMORESPAM.yahoo.com> wrote in message
news:#3**************@TK2MSFTNGP10.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_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 an********@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" <ta********@hotmail.com> wrote in message news:%2****************@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.
11 14241
Taishi (ta********@hotmail.com) writes: I tried to search for the sp_helpsrvrolemember 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
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$NETSDK\Data\pubs.mdf'.
Thanks,
T.
"Erland Sommarskog" <so****@algonet.se> wrote in message
news:Xn**********************@127.0.0.1... Taishi (ta********@hotmail.com) writes: I tried to search for the sp_helpsrvrolemember 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
Taishi (ta********@hotmail.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$NETSDK\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
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.com/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*********************@127.0.0.1... Taishi (ta********@hotmail.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$NETSDK\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
Taishi (ta********@hotmail.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.com/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
"Erland Sommarskog" <so****@algonet.se> wrote in message
news:Xn**********************@127.0.0.1... Taishi (ta********@hotmail.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.com/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.
Taishi (ta********@hotmail.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
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$NETSDK\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\aspnet
---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\aspnet 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********@hotmail.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
Taishi (ta********@hotmail.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$NETSDK\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
Erland,
The web form is using a listbox to list items from SQL.
Here is my code:
Dim drStores As SqlClient.SqlDataReader
If Not IsPostBack Then
conPubs.Open()
drStores = cmdStores.ExecuteReader()
ddlStores.DataSource = drStores
ddlStores.DataTextField = "stor_name"
ddlStores.DataBind()
drStores.Close()
conPubs.Close()
End If
I didn't close my conPubs()-->MyConnection. That's one reason why I was
receiving the error before. But now my problem is that the ListBox is not
populating. The form just has a box that is empty. Seems simple for an
experienced programmer but I'm not at the level, yet.
In the Properties for MyConnection I have the following as my Connection
String:
workstation id=MyMachineName;packet size=4096;integrated security=SSPI;data
source="MyMachineName\vsdotnet";attachdbfilename=" D:\Program Files\Microsoft
SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security info=False;initial
catalog=pubs
In the Properties for MyCommand I have the following as my Connection
String:
workstation id=MyMachineName;packet size=4096;integrated security=SSPI;data
source="MyMachineName\vsdotnet";attachdbfilename=" D:\Program Files\Microsoft
SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security info=False;initial
catalog=pubs
I'm trying to grasp the concept but it's frustrating.
So, now you should know all about my web form.
Any ideas on how to fix my problem?
I will pay a million dollars for the answer to this problem. :-)
Thanks,
T.
End Sub
"Erland Sommarskog" <so****@algonet.se> wrote in message
news:Xn*******************@127.0.0.1... Taishi (ta********@hotmail.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$NETSDK\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
Taishi (ta********@hotmail.com) writes: I didn't close my conPubs()-->MyConnection. That's one reason why I was receiving the error before. But now my problem is that the ListBox is not populating. The form just has a box that is empty. Seems simple for an experienced programmer but I'm not at the level, yet.
In the Properties for MyConnection I have the following as my Connection String:
workstation id=MyMachineName;packet size=4096;integrated security=SSPI;data source="MyMachineName\vsdotnet";attachdbfilename=" D:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security info=False;initial catalog=pubs
In the Properties for MyCommand I have the following as my Connection String:
workstation id=MyMachineName;packet size=4096;integrated security=SSPI;data source="MyMachineName\vsdotnet";attachdbfilename=" D:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security info=False;initial catalog=pubs
Ah, we're on to something here. Take out that "attachdbfilename" from
your Connection string. I see in MSDN Library, that this property is
actually supported for SqlClient, although I cannot understand the point
with it. Anyway, since pubs is already attached, you have no reason
to meddle with 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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...
|
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...
|
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...
| |
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.
...
|
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...
|
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....
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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 ...
| |