Newbie - Help!

Newbie - Help!

Post by Taish » Tue, 27 Jan 2004 05:16:33


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.
 
 
 

Newbie - Help!

Post by Bil » Tue, 27 Jan 2004 05:51:39

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.
__________________________________



my
open

 
 
 

Newbie - Help!

Post by Taish » Tue, 27 Jan 2004 11:23:57

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.yqcomputer.com/
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?



leave
SP3a
rights.


for
bottom
 
 
 

Newbie - Help!

Post by Bil » Tue, 27 Jan 2004 13:06:22

o, 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/distsql_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" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
task
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
because


 
 
 

Newbie - Help!

Post by Taish » Sat, 07 Feb 2004 07:11:55

eVry.


"William (Bill) Vaughn" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
"Service
right
setup
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
tsql_7b91.asp
rights.
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
has
laptop
and
has?


 
 
 

Newbie - Help!

Post by Bil » Sat, 07 Feb 2004 11:01:02

ummm... 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" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
is
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
the
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
it's
you
The


 
 
 

Newbie - Help!

Post by Taish » Sun, 08 Feb 2004 02:45:07

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" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
rights.
dropdown
there
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
message
that
schools
no
click


 
 
 

Newbie - Help!

Post by Bil » Sun, 08 Feb 2004 04:20:03

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" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
you
to
applications,
the
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
on
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
installed
know
did
week.
book


 
 
 

Newbie - Help!

Post by Taish » Thu, 12 Feb 2004 06:13:19

ill,

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" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
rights.
message
try
of
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/dis
no
it.
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-
confers
my
blank.
node?