meravkn
asked on
SQL server
Hi,
If I have a dedicated server that's hosting my site, and I would like to have the sql server inside the server (right now it's on a shared sql server), what kind of software/license do I need to buy?
Thanks,
Meravkn
If I have a dedicated server that's hosting my site, and I would like to have the sql server inside the server (right now it's on a shared sql server), what kind of software/license do I need to buy?
Thanks,
Meravkn
Licence for the operating system, ie: Windows 2000 Server, which include IIS and a licence for Microsoft SQL Server.
You can run IIS and SQL Server on the same machine as long as you dont require top performance or don't expect much hits/queries. It also depends on the hardware ofcourse.
You can run IIS and SQL Server on the same machine as long as you dont require top performance or don't expect much hits/queries. It also depends on the hardware ofcourse.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I tend to agree with Stuart,
I operate many dedicated servers that run both Win2000 and MsSQL2000 for Internet sites. The licencing for MsSQL requires us to go with per processor licences as it starts to get difficut (rather impossible) to estimate the number of licences to buy for the Internet.
DanSolo
I operate many dedicated servers that run both Win2000 and MsSQL2000 for Internet sites. The licencing for MsSQL requires us to go with per processor licences as it starts to get difficut (rather impossible) to estimate the number of licences to buy for the Internet.
DanSolo
It's generally a good practice to separate web servers and database servers, so you shouldn't change anything.
Anyway, if you want to do this you don't need to buy any software or any licence.