Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 buy MS-SQL server
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

suona
Junior Member

Taiwan
121 Posts

Posted - 30 November 2003 :  10:56:03  Show Profile  Visit suona's Homepage
I've heard about that: If your server works for website running only(no need to act as LAN/print.... server), you can buy windows 2003 server it self, without buying CALs.

If SQL server's usage is website database only, what SQL server combination (including licence?) should buy ?

And the street price is ? (educational price)

Thanks!

I'm a amateur WWW site builder.

And Sorry for my poor english .....



Edited by - ruirib on 30 November 2003 12:31:26

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 November 2003 :  12:34:45  Show Profile  Send ruirib a Yahoo! Message
How many users do you expect? Up to 25 concurrent users MS seems to have changed minds and is recommended what they call MSDE 2000 release A and says it's the free version of SQL Server: http://www.microsoft.com/sql/msde/downloads/download.asp


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 30 November 2003 :  12:44:06  Show Profile  Visit dayve's Homepage
I am thinking of buying 2003 Web Server because it is extremely cheap right now, but it does not have all the benefits of a real 2003 server (obviously). However, it still sounds enticing.

quote:

Limitations
Windows Server 2003, Web Edition, is designed specifically for dedicated Web serving needs, and its functionality has certain limitations as follows:

Although computers running Windows Server 2003, Web Edition, can be members of a Microsoft Active Directory® service domain, Windows Server 2003, Web Edition, cannot be a domain controller. Consequently, organizations cannot use Windows Server 2003, Web Edition, alone to apply certain management features, including Group Policy, Software Restriction Policies, Remote Installation Services, Microsoft Metadirectory Services, Internet Authentication Service (IAS), and others.
Organizations cannot use Windows Server 2003, Web Edition, to deploy enterprise Universal Description, Discovery, and Integration (UDDI) services. UDDI is an essential component for enabling discovery and reuse of XML Web services.
Organizations cannot use Windows Server 2003, Web Edition, to deploy Microsoft SQL Server™.



Good info here:

http://www.microsoft.com/windowsserver2003/evaluation/overview/web.mspx

Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 30 November 2003 :  14:34:13  Show Profile
I was looking into this when looking for a dedicated server for the forum. It used Win2003 Web Edition. What are the legalities in using MSDE on a live site though? Is it allowed?

The UK MkIVs Forum
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 November 2003 :  18:17:25  Show Profile  Send ruirib a Yahoo! Message
In the link I posted above, Microsoft explicitly states that that is the free version of SQL Server. I didn't look for the License Agreement, but I had never seen such wording regarding MSDE before. Also, the previous MSDE version was set to diminish performance after 5 simultaneous connections, this one has 25 as a limit. Looks like MS is being more aggressive with their software, specially where they have competition. I had seem the same attitude elsewhere, so this looks a promising development.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 30 November 2003 :  18:24:07  Show Profile  Visit dayve's Homepage
I think MSDE also has a 2 gig limit. I don't think I'd ever use MSDE for any serious development, but that is just me.

Go to Top of Page

seahorse
Senior Member

USA
1075 Posts

Posted - 30 November 2003 :  22:15:10  Show Profile  Visit seahorse's Homepage
Does the 2003 Web server license prevent you from using MySQL instead of MS-SQL? If not, then that might be one way to go.

Ken
===============
Worldwide Partner Group
Microsoft
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 30 November 2003 :  22:45:45  Show Profile  Visit dayve's Homepage
quote:
Originally posted by seahorse

Does the 2003 Web server license prevent you from using MySQL instead of MS-SQL? If not, then that might be one way to go.


I don't see why it would, but then again, look at who we're talking about.. Microsoft.



We should have known he'd be a criminal from the start!

Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 01 December 2003 :  09:30:21  Show Profile  Visit suona's Homepage
"25 concurrent users " means "SQL user connection"?

I'm a amateur WWW site builder.

And Sorry for my poor english .....


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 December 2003 :  12:44:12  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by dayve

I think MSDE also has a 2 gig limit. I don't think I'd ever use MSDE for any serious development, but that is just me.


Yeah, that limit remains. 2 Gig looks like a reasonable limit for most sites, I'd say.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 December 2003 :  12:44:57  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by suona

"25 concurrent users " means "SQL user connection"?


Means 25 simultaneous connections to the database.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 01 December 2003 :  12:51:31  Show Profile  Visit HuwR's Homepage
quote:
Originally posted by ruirib

quote:
Originally posted by suona

"25 concurrent users " means "SQL user connection"?


Means 25 simultaneous connections to the database.



A standard Snitz forum should use at most about 3-6 connections depending what it is doing.
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 01 December 2003 :  16:16:54  Show Profile  Visit dayve's Homepage
quote:
Originally posted by ruirib

quote:
Originally posted by dayve

I think MSDE also has a 2 gig limit. I don't think I'd ever use MSDE for any serious development, but that is just me.


Yeah, that limit remains. 2 Gig looks like a reasonable limit for most sites, I'd say.



Is this per database though? Or is it 2 gigs max for all databases while using MSDE?

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 December 2003 :  19:32:44  Show Profile  Send ruirib a Yahoo! Message
It's 2 GB per database, with up to 16 databases per server: http://www.microsoft.com/sql/msde/productinfo/features.asp


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

snaayk
Senior Member

USA
1061 Posts

Posted - 02 December 2003 :  11:40:28  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
That MSDE is looking like an actual alternative to Access. Now hosts will have to support it of course.

The good news is that moving from that to MS SQL *should* be a lot less problematic than from Access to SQL Server.
Go to Top of Page

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 02 December 2003 :  11:48:28  Show Profile
quote:
Originally posted by snaayk

The good news is that moving from that to MS SQL *should* be a lot less problematic than from Access to SQL Server.



Why would it be any different?

The UK MkIVs Forum
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07