SQL Enterprise Manager (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Patti -> SQL Enterprise Manager (3/17/2004 16:26:20)

Hi All,

I did a search here on Enterprise Manager and read a post that Spooky made and I think understood it to say that to get enterprise manager I could download sqleval.exe and just load the client tools. I am in the process of downloading this from microsoft. My question now is this...

I am having my host set up an sql database, they offer no support for it and say I must have enterprise manager to connect to the database.

I have purchased and asp package for classified ads. The classifieds package has 2 scripts to run to set up their database tables and permissions for SQL.

Will the client tools that I install with sqleval.exe allow me to run the scripts using Enterprise Manager. Will I eventually need to purchase Enterprise Manager somehow? This is all very confusing to me at this point [:o]. I am running Windows 2000 pro. I don't believe I have Enterprise Manager already. Any help to clarify this would be appreciated. Do you think that I may run into problems that I cant handle without an SQL expert to help me set the database up? The classifieds software offers support for a fee?

Thanks Patti



Spooky -> RE: SQL Enterprise Manager (3/17/2004 16:46:59)

Yes, the tools will do what you need.
Give me a yell if you need a hand to step through it for the first time



Richard Dudley -> RE: SQL Enterprise Manager (3/17/2004 20:03:11)

What you're downloading is an evaluation of the full SQL Server 2000 product, including the Enterprise Manager client tools. It is technically a license violation to continue to use the tools after the evaluation period expires, although they will function.

To make yourself legit, you'd do well to plunk down the $50 for the Sql Server 2000 Developer Edition. It's available from Amazon at http://www.amazon.com/exec/obidos/ASIN/B000050AVL/103-0246600-3826200.

If your host doesn't support SQL Server, how are they setting it up for you?



Spooky -> RE: SQL Enterprise Manager (3/17/2004 20:11:52)

quote:

If your host doesn't support SQL Server, how are they setting it up for you?

I guess they assume you know how to administer it.
I would say its probably a bit rough saying that - but I guess I can see their point in not wanting to support 'new' users.
They should have at least basic instruction for connecting to your database online I would have thought.

Thanks for the link Richard, I tried to refind it for Patti [:D]

<edit>
btw - its currently on special at 41.99



Richard Dudley -> RE: SQL Enterprise Manager (3/18/2004 11:22:15)

quote:

They should have at least basic instruction for connecting to your database online I would have thought.


I agree 100%--SQL Server is so self-explanatory (NOT!). I would think that newbies could be quite a danger to themselves. I have concerns about hosts that offer something they don't support. At what level don't they support SQL Server--just user help, or do they not patch the thing, either? I hope I'm getting the wrong impression here.

quote:

btw - its currently on special at 41.99

Dig that! I have paid for more for lesser things. Technically, you're only supposed to use this edition and tools for dev purposes, but when you're DIY, everything is dev. [;)]



Richard Dudley -> RE: SQL Enterprise Manager (3/18/2004 12:18:40)

There are several other options for the Enterprise Manager also--a Google search for "Sql Server 2000 Enterprise Manager" will turn them up. Some are actually pretty good.

There's a freebie available from MS at http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.

That catch here is twofold. First, this is an MSI file, so you'll have to convince your host to install this for you. This is unlikely, and also you need to secure this tool if you were to put this on your website. I recommend instead you install this on your local machine and make database connections to your remote databases.

The second catch is that you need to have IIS installed, as well as the .NET Framework. The .NET Framework is available from asp.net.



Patti -> RE: SQL Enterprise Manager (3/23/2004 22:39:16)

Hey Guys,

Thanks for the information and thanks to some additional tips from Spooky and some "minimal support" from my host I have the connections set up with the eval copy of enterprise manager and was able to run the scripts that set up the database tables without any problems.

Spooky is right the host is saying that if you want to use the SQL server you need to know how to administer it yourself and they only charge an extra 25.00 a year for the sql database, so I can understand that. I could of course have paid an expert to do it for me but why do that when I can come here and get help.

And 50.00 is a fantastic price. I thought I had to spend 300.00 and the site I found it on said that was a sale price from 499.99. That is why I always check things out here.... I have always found the answers I need or at least I get pointed in the right direction.

[:D] I am at the moment a little less dazed and confused again....Thanks

Patti



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875