15 replies to this topic

[jvk]

Anyone put SQL Server on their Windows Home Server? I'm wondering if there would be any conflicts if I loaded it on my machine.

[ebkayes]

Works just fine.

Just make sure to put the DB containers on the network folders.

[Alvin Ramard]

That's encouraging news. I hope to give that a try over the weekend.

[diehard]

For an easy install, I suggest Nigel Wilks addin http://www.mediasmar...d-ins/#WHSMySql

[jvk]

Thanks ebkayes - when you say database containers I assume you mean that during the setup process you set it to store the datafiles on the Network drives so that a large database won't accidently fillup the system partition.

AlvinRamard If you put SQL Server on you box, can you let me know how it goes?

Diehard I think that mediasmartserver.net article is about putting MySQL on WHS. I have never thought of doing that but it makes sense since WHS has a web piece to it. SQL Server is a little different than MySQL but at any rate, they are both database software. Thanks for the Link!

jvk

[ebkayes]

The other item for SQL server is the memory setting. Two installs for whs are wasu server install and tekradius. Both these installs document the memory setting. Also tecradius document the user rights options avalable within win 2003. Some users are not clear on the options.

I am a die hard DB2 user. But you are correct a database is a database. SQL Server has some nice features, but I miss recersive SQL in a dml structure or in nest set struchture for ...climing a hiercrchy, when work in db2. You just can't beat the math allalabe in the db2 prodect vs SQL server.

I love see a descripton on using ldap and active directory setting in a data bace. may be we need a dedicated section to rdms packages that are alalabe for ease of use in whs. Many of the produck are just just over kill. Do you need full rdms tool or will access do?

If you can write the erd diags in Access you can move then any where, showind the referental integritise. The pick of the database become a function in the final chose.
Forexample Db2 gives poewrfull modeling structures that just do not exsist in our other common choises. SQl server giver nice way two creat er diagraim at all the common three representitive levels.

[Alvin Ramard]

jvk: Yep, I'll let you know. I'll be trying SQL 2008 Dev Edition. I'll try SQL 2005 Dev Edition if that does not work.

[jvk]

Sweet! Looking forward to good news!

[jam3ohio]

Microsoft makes this brain-dead easy with the Web Platform Installer:

http://www.microsoft...rt/default.aspx

I used this to load Gallery 2.3, IIS 7.0 Extensions, SQL Server Express, and some other web server tools. The installation is really easy to use to get these web tools on your home server.

Hope this helps.

Jim

[Alvin Ramard]

jam3ohio, I'm not sure how that relates. We're talking SQL Server, not SQL Server Express.

Thanks for the info anyway.

Alvin

[Alvin Ramard]

Well, it took a few hours but I now have WHS running in a test environment. I only had 1 problem with the installation, LAN driver.

I tried installing SQL Server 2008 Developer's Edition and I'm happy to report that it seems to be working properly. I created a directory on the D drive and pointed all the files to that directory. I installed everything except the SDKs and BOL. The only warning I got during the installation was the reminder about having the firewall enabled.

I still can't connect from my laptop. I've had that problem before. I'll tackle that, and more testing, tomorrow.

Knowing I can run SQL Server on WHS makes me very happy.

I'll update this thread later.

Alvin

[ebkayes]

Alvin,

Good news. If you have problems connecting from the laptop make sure that you have the firewall port that SQL server is listening to enabled.

You may also want to set the make memory foot print for SQL server DB.

Regards,

Ethan

[Alvin Ramard]

Well, I finally got the chance to look into the remote connection problem. Both TCP/IP and Named Pipes were disabled. After I enabled those and restarted the service the remote connection problem went away.

WHS, you just passed another test.

[jvk]

That is great AlvinRamard. I had the same problem connecting to SSAS cubes from MS excel when I installed SQL Server 2008 on windows server 2003. I eventually go it to work though. Thanks for the update.

jvk

[ikon]

out of curiosity, how powerful are the WHS boxes you're running SQL Server on? It just seems to me you would need some decent CPU & RAM to make it truly viable.

[Alvin Ramard]

out of curiosity, how powerful are the WHS boxes you're running SQL Server on? It just seems to me you would need some decent CPU & RAM to make it truly viable.

I have it installed on a new machine, running Vail, with an i3-540 (3.06 GHz) and 5 Gigs of RAM.

Whether or not it needs decent CPU & RAM depends on it's use. I'm not using it as a production server. It's only intended to be use as a personal development box. My setup should powerful enough for that.

Alvin