Re: Newbie - Help!
From: Taishi (taishi_bak_at_hotmail.com)
Date: 02/10/04
- Next message: Francisco: "connecting to MSDE from Laptop"
- Previous message: Jim: "Re: error in attaching database"
- In reply to: William \(Bill\) Vaughn: "Re: Newbie - Help!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Feb 2004 15:13:19 -0600
Bill,
I am slowly getting there. I have another post that maby you can assist me
with. This is my error message:
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'.
My post --Permission denied 2nd post:
After reading it today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'
There are also some comments from the group:
---microsoft.public.sqlserver.odbc-- subject: Permission Denied -- Thanks
for help guys
I was able to find a trial version of the Enterprise Manager.
It was suggested to make the post over in dotnet.framework. I am new to
SQL. I can see the following in the MSDE manager:
sql server(my machine name\??SDK)
after I right click on 'PUBS'
---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
"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:O1yu5YO7DHA.1504@TK2MSFTNGP12.phx.gbl...
> I use the SQL Enterprise Manager for this.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Taishi" <taishi_bak@hotmail.com> wrote in message
> news:uuTs2jN7DHA.1716@TK2MSFTNGP10.phx.gbl...
> > I earned my grade and figured it out.
> >
> > I have another post called "Database Permission error".
> >
> > Do you know how I can check my rights to MSDE/SQL?
> >
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> > news:u3geTUF7DHA.3704@tk2msftngp13.phx.gbl...
> > > Hummm... tell your prof that I'm a DeVry graduate too.
> > >
> > > --
> > > ____________________________________
> > > William (Bill) Vaughn
> > > Author, Mentor, Consultant
> > > Microsoft MVP
> > > www.betav.com
> > > Please reply only to the newsgroup so that others can benefit.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > __________________________________
> > >
> > > "Taishi" <taishi_bak@hotmail.com> wrote in message
> > > news:e1UQSUD7DHA.2924@tk2msftngp13.phx.gbl...
> > > > DeVry.
> > > >
> > > >
> > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in
message
> > > > news:uDxODH84DHA.2432@TK2MSFTNGP10.phx.gbl...
> > > > > No, not really. The little icon on the tool tray is the SQL Server
> > > > "Service
> > > > > Manager". It's a tool used to start, stop or pause the server. If
> you
> > > > right
> > > > > click on this icon you'll see that it can be opened and you can
try
> to
> > > > > choose the instance of MSDE that you installed from the Server:
> > dropdown
> > > > > list. You choose the instance name when you installed MSDE. Since
> > there
> > > is
> > > > > no "Setup" that just installs MSDE as there is for other
> applications,
> > > > > you're going to have to earn your grade by researching how to run
> the
> > > > setup
> > > > > from the command prompt with the proper arguments. There are lots
of
> > > > > whitepapers and help on this subject at www.microsoft.com/sql/msde
> > > > > or check out this whitepaper.
> > > > >
> > > > >
> > > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
> > > > tsql_7b91.asp
> > > > >
> > > > > You never did tell me what school you're going to.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > ____________________________________
> > > > > William (Bill) Vaughn
> > > > > Author, Mentor, Consultant
> > > > > Microsoft MVP
> > > > > www.betav.com
> > > > > Please reply only to the newsgroup so that others can benefit.
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > __________________________________
> > > > >
> > > > > "Taishi" <taishi_bak@hotmail.com> wrote in message
> > > > > news:u33e0N74DHA.2412@TK2MSFTNGP09.phx.gbl...
> > > > > > It's my first time. I know it's installed because the server is
> on
> > > the
> > > > > task
> > > > > > bar(bottom right corner). There is a circle with no arrow in
it.
> > > > > > Downloaded/installed it from the following web site:
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
> > > > > > 8aa8-bf12261a303a&DisplayLang=en
> > > > > >
> > > > > > Bottom line. I don't know how to set it up. I know it is
> installed
> > > > > because
> > > > > > the server with the circle is on the task bar. right?
> > > > > >
> > > > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in
> > message
> > > > > > news:uGjeIU44DHA.2740@TK2MSFTNGP09.phx.gbl...
> > > > > > > How did you setup MSDE? What options did you use? How do you
> know
> > > it's
> > > > > > > installed? What is the SA password set to? (Don't tell me, but
> did
> > > you
> > > > > > leave
> > > > > > > it blank?) What version did you setup? Did you use the version
> > that
> > > > has
> > > > > > SP3a
> > > > > > > installed or did you apply SP3a post install?
> > > > > > >
> > > > > > > Where is this class being held? I have not heard of a lot of
> > schools
> > > > > > > teaching VB.NET and especially not with MSDE.
> > > > > > >
> > > > > > > --
> > > > > > > ____________________________________
> > > > > > > William (Bill) Vaughn
> > > > > > > Author, Mentor, Consultant
> > > > > > > Microsoft MVP
> > > > > > > www.betav.com
> > > > > > > Please reply only to the newsgroup so that others can benefit.
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > > rights.
> > > > > > > __________________________________
> > > > > > >
> > > > > > > "Taishi" <taishi_bak@hotmail.com> wrote in message
> > > > > > > news:%23dHZhA44DHA.2496@TK2MSFTNGP09.phx.gbl...
> > > > > > > > WinXP Pro
> > > > > > > > VS.NET
> > > > > > > > 3 labs due Monday night been trying to complete this for a
> week.
> > > > > > > >
> > > > > > > > It's my first time. I just installed MSDE or SQL server on
my
> > > > laptop
> > > > > > for
> > > > > > > my
> > > > > > > > VS.NET class.
> > > > > > > >
> > > > > > > > I have the icon on the tool bar.
> > > > > > > >
> > > > > > > > I don't know how to configure it or set it up. When I right
> > click
> > > > and
> > > > > > > open
> > > > > > > > the Server Service Manager, the Server and Services are
blank.
> > > The
> > > > > > bottom
> > > > > > > > of the box says "Not connected -\\".
> > > > > > > >
> > > > > > > > Am I suppose to key in a Server Name and Service?
> > > > > > > >
> > > > > > > > Why do I have a round white circle with know error like the
> book
> > > > has?
> > > > > > > >
> > > > > > > > What is the "Current Service on \\"?
> > > > > > > >
> > > > > > > > How do I get the Server Explorer to show the SQL Server
node?
> > > > > > > >
> > > > > > > > Thanks for your help,
> > > > > > > > T.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Francisco: "connecting to MSDE from Laptop"
- Previous message: Jim: "Re: error in attaching database"
- In reply to: William \(Bill\) Vaughn: "Re: Newbie - Help!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
