I'm trying to learn how to manage a SQL server database on a shared server. I have XP Home. Everywhere I've looked for information assumes I have access to Windows Server. How can I manage a SQL Server DB on my computer? Can anyone point me to a good tutorial?
There is a .NET enterprise manager which you could install if you have a webserver on your local machine, or you can use access as a front end to your SQL database.
Just to clarify - you have access to a shared SQL server on some server out in internetland, and you want to control it from your PC (with no SQL Server install)? Using Access sounds like an easy win for you as a f/e. Remember on a shared server you will not (probably) have access to most of the server admin functions, so you will not be losing a lot by using Access as a f/e tool.
Otherwise, you will need to find a SQL Server Client of some kind - probably going to be text-based (I think I've seen some freebies online) and connect via that.
Did you ever look in to the MS SQL Server 2000 Developer Edition? $50.00 US retail price, and it includes all the SQL Server client tools. I picked it up at Fry's Electronics off the shelf, it installed flawlessly on XP Pro, and as far as I can tell all the same features as the full server version are present.
You could also try out the SQL Express 2005 trial I think thats publicly available, I've been using it a while now and quite like the updated enterprise manager.
Topic Locked
Posted - 29 September 2004 : 06:08:22
