Help Installing SQL Server 2000 Desktop Engine

[jason]

Alrighty, I am an web developer with most of my experience
bein in the Unix environment, php, perl etc..

I am trying to broaden my skills and have recently
installed windows 2000, IIS, .NET Framework, .Net SDK and
also installed SQL Server 2000 Desktop Engine which from
what I have read functions for the most part just like the
full version of SQL Server 2000 with an exception that
speed is considerably cut with simultaneious users
accessing the system as well as a size restriction on DB,
neither situations really matter to me seeing as how I am
developing just to learn the technology and will not be
building major applications that anyone other than myself
will be accessing.

My problem occured when installing the SQL Desktop Engine,
everything installed correctly with no errors, all
quickstart examples work fine, even the ones that utilize
db calls. However, my sql server manager always show up as
being "Not Connected -//" and no server or services are
listed in it. Also, none of the tools that I see most
people talking about were installed, enterprise manager
etc... the only thing I have is OSQL which I am not
familiar enough with the commands to create databases,
tables and stored procedures. I have tried using some
third party software to connect to the server so I can
create tables etc using a GUI but I always get an error
telling me that access is denied or the server doesn't
exist. I have reinstalled twice, I feel as though I have a
problem with SQL Server and feel like there should be some
tools or something that should have came with it to make
managing my db easier. Anybody have any idea?

THanks
jason

 

[Bhaskardeep Khaund]

Hi,

MSDE is a very crude version of SQL Server, and it sure does not have all the features and flexibility of the SQL Server. If you want it I would suggest you get hold of an SQL Server 2000 copy, mayit be a 60 day evaluation copy.

Well, if you database server is not registered, try doing it manually. Right click on 'MS SQL Server' and create a group if its still not made. Then right-click the group and click on 'New SQL Server Registration'. Enter your computer name and register your server, follow the on-screen instructions.

Well you can use OSQL, but for that you would need to learn those SQL commands like

create database MyDB
create table tablename (id int primarykey not null, ...

.......etc

Hope this helps

Regards,
Bhaskardeep Khaund

 

[jason]

Thanks for the reply, you will have to excuse me but I
know very little about this stuff. I haven't used windows
in years....where exactly do I right click on MS SQL
Server? I don't even have a program group or anything
like that for it.
THanks
jason

-----Original Message-----
Hi,

MSDE is a very crude version of SQL Server, and it sure

does not have all the features and flexibility of the SQL
Server. If you want it I would suggest you get hold of an
SQL Server 2000 copy, mayit be a 60 day evaluation copy.

Well, if you database server is not registered, try doing

it manually. Right click on 'MS SQL Server' and create a
group if its still not made. Then right-click the group
and click on 'New SQL Server Registration'. Enter your
computer name and register your server, follow the on-
screen instructions.