June 29, 2007 at 1:27 pm
Please advise me how to do this, if it's possible.
June 29, 2007 at 2:37 pm
Are you having trouble doing it? for me, it just a bunch of "Next" buttons in a row....the enterprise edition dummied itself down to the developer version, because the operating system is not a Server version, but it worked fine on my laptop....
after that, i installed 2000 as a named instance, and that went just fine as well.
let us know if you are having trouble, or just confirming it's possible. dunno if it makes a difference, but I installed everything as a local administrator, and not a "user" of the machine.
Lowell
June 29, 2007 at 3:24 pm
When I first downloaded the eval version, a month or more ago, I installed it by just hitting the next buttons, as you did. I couldn't get anything to work. I was never able to use it at all. What I'm trying to do now is to reinstall it, without the mistakes I made. The problem is, I'm not aware that I made any. There must be somewhere in the installation process where the default "next" is not the right answer for me.
You already alluded to the "user" as opposed to "administrator". I will pick "administrator" if I see that choice offered. Can you think of anything else that I might need to know?
My purpose is to have SQL Server running so I can teach myself more about programming Stored Procedures and Triggers, because that is being asked of me more and more. I am an Access/Excel/VBA developer by trade. I have had to pass on a couple of clients because of my lack of experience in this regard. It had never been a requirement before. All I had to know was how to connect, via ado, to the db and RUN the procedures, not actually write them. What's a "named instance" and do I need to do something similar? Is there a site that has clear, comprehensive, and concise directions as to how to install SQL Server on an XP laptop? It seems to me that would be an ideal use of the web. Just put succinct, accurate instructions in one place rather than having hundreds of folks like myself spending hours in frustration, and bugging good people like yourself!
I'm hoping to get some guidance on what choices, if any, I should make during installation. Also, do I have to delete any registry keys or other files on my computer before attempting to reinstall? I removed it through the control panel.
June 29, 2007 at 3:39 pm
Why don't you install SQL Server 2005, instead of SQL Server 7?
You can buy the SQL Server 2005 Developer Edition for under $50 US, and it has all the functionality of the SQL Server Enterprise Edition.
June 29, 2007 at 5:38 pm
I wasn't aware of that possibility, especially the reasonable price!
Is that easier to install and use as a back end for my VBA projects? Can I write triggers and stored procs in it?
June 29, 2007 at 8:10 pm
You can do everything in SQL Server 2005 that you can do in SQL Server 7, and much more. It's basically the same database server engine as SQL 7.0 with 7 years of enhancements, and a lot more add on tools. And yes, you can write stored procedures and triggers.
June 30, 2007 at 9:18 am
What should I look out for during installation in order to ensure that I will be able to use it? I need to no anything and everything. I'm a "stranger in town" and don't know any of the "landmarks", if you know what I mean. Besides the administrator as opposed to user option, what do I need to know?
June 30, 2007 at 10:11 am
My laptop is XP Media Center SP2. It's not XP Pro. Is that a problem?
June 30, 2007 at 10:17 am
Would Express work just as well for my VBA dev purposes as Developer Edition?
July 3, 2007 at 8:31 am
If I were you, I would look for a copy of SQL 2000 Developer Edition; mine cost about $50 US. Since you're teaching yourself, there are a lot more books & experts available, simply because 2000 has been around for so long. Coming from Access/VBA, using Enterprise Manager and Query Analyzer in 2000 should feel very familiar & comfortable.
Also, 2000 does have the original version of Reporting Services so you can work that feature as well.
BTW the Developer Edition (any version) has all the features of the Enterprise Edition, except that it is licensed only for development & testing.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply