November 11, 2008 at 10:09 am
As I have yet to actually see the DE in person, I have a question related to connectivity. I've read on the Microsoft site that DE has the same feature set as Enterprise Edition, but that it's for one user. However, how, exactly, does this apply to connectivity? I could not determine from the information I could find just what that "one user" limitation actually entails. If I wanted to create an ASP.NET web page on my server that references SQL Server data and then have any given PC on my home network make use of that website, would it work? I need to know before I spend money on Developer Edition. Thanks in advance for any/all assistance.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 11, 2008 at 12:03 pm
I believe that the "One User" restriction is a license restriction, but is not implemented as a software restriction. In other words, you are constrained by the legal agreement of the license, but there is no software that I know of that tries to enforce that constraint.
For instance, on mine, I have logged-in without two or three different Logon names without a problem. This is legal, according to the license (because I am still only one person), but is generally beyond the capabilities of most enforcement software to figure out (they would almost always incorrectly prevent me from doing this).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 11, 2008 at 12:06 pm
On the other hand, if two or more different people logged-on to my DE SQL Server, that would be a violation of the license. This is true, even if we all used the same logon account (which most enforcement software will not be able to pick up on).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 11, 2008 at 12:11 pm
Thanks very much for that info, as I'm hoping to start my Vista x64 build this evening on an 8GB Quad-Core machine, and then I'll be looking to put both SQL 2005 64-bit and SQL 2008 64-bit Developer Editions on it. I have four SATA II 160GB drives to work with, and the objective is to be able to model a large database and teach myself the basics of backup and restore and all manner of testing. Any other guidance you can offer would certainly be appreciated. I always prefer to learn first and then NOT make the mistakes, whenever possible.
EDIT: I'm especially interested in any preferences with regard to installation order of the two SQL Server products, and any potential gotchas along the way...
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 11, 2008 at 12:19 pm
smunson (11/11/2008)
I'm especially interested in any preferences with regard to installation order of the two SQL Server products, and any potential gotchas along the way...
I cannot help you much here, except to say that installing them in chronological order seems like it should certainly work OK.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 12, 2008 at 7:04 am
Well, I WAS planning to get Vista Ultimate 64-bit installed... now I seem to be stuck trying to find a device driver for my optical drive, a Panasonic LF-PB271 (Blu-Ray Read & Write as well as DVD and CD-ROM read and write) ... the OEM version of this SATA attached drive. I spent 3 hrs on the web last night checking both Panasonic's sites and every Google result that had even a remote chance of being a candidate, and turned up empty. Anyone?
Steve
(aka smunson)
:w00t::w00t::w00t:
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 13, 2008 at 8:14 am
UPDATE:
I called Microsoft on the driver problem last night, and all they could suggest was to try a different drive. I have one on order, so I guess I'll find out. I've also since discovered that when you look at the actual drive, the model number shown is NOT the LF-PB271-OEMBK that was listed as what I was buying, but instead is SW-5583. Further searches on the new model number showed it in the list of drives in the Industrial/Business section of the Panasonic website, but not by any direct search for the model number, and there were NO drivers for any of the drives listed there. Also, the vendor for this drive has suggested that Vista may be searching for an SATA controller driver, but if that were really necessary, it seems to me that the install would never have gotten as far as it did. Thus, if anyone knows of a Blu-Ray write-capable DVD drive for PC's that is working in Vista Ultimate 64-bit, I'd love to hear about it.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 14, 2008 at 1:04 pm
UPDATE: I found an article on Microsoft's website late yesterday afternoon that described my problem rather accurately, and although it referred to systems with Vista already installed, the basic gist of it was that without that hotfix or a service pack that includes it, configuring your SATA controller for AHCI in the BIOS is what causes the problem.
Since I need to have AHCI for the hard drives, the only viable solution was to acquire a regular IDE DVD drive, which I did last night via a quick run to the local computer store. $35 later, I installed it and was able to then successfully install Vista Ultimate 64-bit.
Next steps:
1.) Re-connect the other 3 hard drives that I had disco'd at MS's behest, and partition and format them.
2.) Install the drivers that came with the motherboard, and the video drivers, and re-boot.
3.) Install all available opsys updates, and then check to see that my Panasonic DVD drive is functional.
4.) Figure out where to get IIS and get it installed along with the .NET frameworks. Back in XP, this was an available choice during the install process, but Vista has almost NO choices to make. Sure simplified the install, but wow, where is everything?
5.) Configure the network, and set up the machine as a domain member - I couldn't even find where to do this last night, so this one might take a while.
6.) Install SQL Server 2005 Developer Edition
7.) Install SQL Server 2008 Developer Edition
8.) Configure my SQL Server instances to ensure I can use Reporting Services and SSIS / SSAS.
9.) Create a Tally table (aka auxiliary table of numbers).
10.) Install Roxio Creator 2009 Ultimate
11.) Hook up my fire-wire capable video camera and import some of my Hi-8 video tapes and burn them to Blu-Ray discs.
12.) Acquire and install the multi-processor version of Fritz (a chess-playing program).
More TBD...
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 9, 2008 at 10:04 am
Just an update on progress to date:
Having actually listened to MS at the time of reporting the initial problem to them, I had ordered another SATA DVD drive (ROM instead of Blu-Ray), but by the time I was ready to install, I had decided that was a bad idea anyway, and had set up the IDE DVD drive and successfully installed. Unfortunately, that installation crapped out in short order, and it may have been BIOS config, but hard to tell. Anyway, the net result is that I got MS to send me a "replacement" set of DVD's for Vista Ultimate, that contained SP1 integrated into the install media. Then I installed the SATA DVD-ROM, having removed the IDE one, and bingo, I was in business. I was then able to re-attach the additional hard drives AND the Blu-Ray DVD writer, and all are working. The only untested piece is playback of commercial Blu-Ray discs and actually writing to Blu-Ray media. I know that it can detect Blu-Ray discs as Blu-Ray discs.
I decided to go with Visual Studio 2008 Professional, and just SQL Server 2005 DE for right now, and all the updates I asked about in a different thread do apply, and Vista took care of downloading and installing them in the proper sequence. Also, I found that the Adaptec 2940U2W SCSI Controller that came with my tape backup unit does NOT have any drivers for Vista Ultimate 64-bit, so I'm awaiting an Adaptec 29320LPE which is due to arrive tomorrow. With a little luck, I'll be fully installed with backups running by the end of this weekend.
FYI, my contract for employment ends Friday, so if there are any employers needing an SQL Developer DBA, I'm available on 12/15.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply