SQL Enterprise Manager

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

SQL Enterprise Manager

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> SQL Enterprise Manager

Page: [1]


Patti Posts: 125 From: USA Status: offline	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 . 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 Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	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 _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to Patti)


Richard Dudley Posts: 668 Joined: 8/22/2002 From: Butler, PA Status: offline	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? _____________________________ I need to change my avatar--the puppy is full grown now! (in reply to Patti)

Spooky

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

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

<edit>
btw - its currently on special at 41.99

< Message edited by Spooky -- 3/17/2004 20:13:10 >

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

��k�

Database / DRW help Check out the Tutorials for Frontpage Databases

Forum FAQ' s

Developers Edition Spooky Login User Registration and Management tool

Personalized Frontpage Hosting

(in reply to Richard Dudley)

Richard Dudley

Posts: 668
Joined: 8/22/2002
From: Butler, PA
Status: offline

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.

_____________________________

I need to change my avatar--the puppy is full grown now!

(in reply to Spooky)


Richard Dudley Posts: 668 Joined: 8/22/2002 From: Butler, PA Status: offline	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. _____________________________ I need to change my avatar--the puppy is full grown now! (in reply to Richard Dudley)


Patti Posts: 125 From: USA Status: offline	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. I am at the moment a little less dazed and confused again....Thanks Patti (in reply to Richard Dudley)

Page: [1]

All Forums >> Web Development >> ASP and Database >> SQL Enterprise Manager

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts