MS SQL Enterprise Manager?

[invitro]

Ok, I just signed up witha hosting company and would like to use the MS SQL database they provide. However, I require MS SQL Enterprise Manager. ***?

After some searching, this tool is apperently only avaiable from the MS SQL CD rom. So, as a developer, I am screwed since I'm not going to go purchase MS SQL for a couple of K just so I can remotly access and admin a Database.

I am using WinXP Pro, VS 6 (2005 soon i hope).
Is there any way i can get around this? Any help would be appriciated... thanks

[brucevde]

You can purchase the SQL Server Developer Edition for $50. There is also the free Web Data Administrator tool, not sure if it is what you need.

Goto the SQL Server download section at the MS website.

[invitro]

50$, ah that sounds more like a deal to me! Wonderful, thanks for the reply

[szlamany]

The developers edition also gives you a personnal copy of FULL BLOWN SQL SERVER for you own workstation or laptop.

That way you can copy of production data and work on it locally - it's a great thing...

[invitro]

sold

[Danial]

Originally posted by invitro
Ok, I just signed up witha hosting company and would like to use the MS SQL database they provide. However, I require MS SQL Enterprise Manager. ***?

After some searching, this tool is apperently only avaiable from the MS SQL CD rom. So, as a developer, I am screwed since I'm not going to go purchase MS SQL for a couple of K just so I can remotly access and admin a Database.

I am using WinXP Pro, VS 6 (2005 soon i hope).
Is there any way i can get around this? Any help would be appriciated... thanks

There are also other Non MS alternatove apps which can connect to remote SQL Server and allow you do adminstrative task like Enterprise Manager. If you are strapped of cash you can always try one of those

[dglienna]

MSDE 2000 is a free download

[invitro]

Great, a free version would come in handy at this time... however, after downloading and attempting to install it... it sais a strong SA password is required for security reasons.

I follow the steps it tells me to do in order to change the SA password... however, when I go into MS Prompt, after typing
osql -U sa

it gives me an error that osql does ntot exist.
*sigh* why cant anything ever be easy...

So, my question is... is it because I am running WinXP pro that these options are not avail. to me.
Also, why does the setup prompt me to change my SA password in the first place if I dont even have a SQL database installed on my machine.

[techgnome]

Originally posted by dglienna
MSDE 2000 is a free download

MSDE is the DATA ENGINE (that's the DE of MSDE)...... it is NOT query analyzer nor is it the Enterise Manager.

TG

[invitro]

I see, so I suppose I'm back to square 1. Well, better get my ass in gear and buy the Developers Edition.

Unless anyone knows any free alternatives?

Thanks a bunch, you've all been a great help.

[dglienna]

I thought that I saw something about the SA password on the website while I was downloading. I haven't installed it, so if you find the answer, please post it for future reference.
I thought that MSDE lets you access MS SQL databases using the same query that you use if you *had* MS SQL Server.
There is also a version that only runs on Windows Server. Haven't installed that one either.

[Danial]

Originally posted by invitro
I see, so I suppose I'm back to square 1. Well, better get my ass in gear and buy the Developers Edition.

Unless anyone knows any free alternatives?

Thanks a bunch, you've all been a great help.

There is another ways!If you have broad band then download SQL Server Evaluation vertion. When you install SQL Server evaluatio verstion and un-install it, Ent Manager is not un-installed, so after that you can install MSDE and use SQL Manager with it.

Here are two alternative for EM, if you search you will find more..

http://www.aspenterprisemanager.com/
http://www.visendo.com/en/sqladmin.aspx

[vb_dba]

Originally posted by dglienna
I thought that MSDE lets you access MS SQL databases using the same query that you use if you *had* MS SQL Server.

This is a true statement, however, MSDE does not contain the client tools (Enterprise Manager, Query Analyzer, etc) that invitro is looking for.

[invitro]

Just to let you all konw
http://www.visendo.com/en/sqladmin.aspx

is really buggy. Havent tried the other one yet, but visendo keeps crashing and messing up.

Getting Eval edition right now. I wonder if microsoft knows about it? Is it a bug or was it done intentionaly.

[szlamany]

Really - for $50 you can have a $10000+ dollar software application...

Why have a buggy product, when you can buy Bill's bugs for $50!

Get MS Dev Ed - it's worth it - learn MS T-SQL - forget about ANSI SQL - it's all gonna be Bill anyway...