Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Installing Microsoft SQL Server

[kellyboyce]

I recently purchased a windows 2003 web edition server. It came with standard installation. I have ASP support and ODBC connection to MS Access databases. However, i have just purchased a asp application that requires Microsoft SQL Server, how can i install that?

do i have to install the actuall Microsoft SQL Server software? or can i just create a system dsn like i did with MS Access?

Any help would be appreciated.

Cheers

[TDMWeb]

You cannot install SQL Server on Windows Server 2003 Web Edition. You need Standard Edition for that. You also need to purchase SQL Server. You may have a shock when you look at the price...

Best option is to see if your server provider can provide space on a shared SQL Server machine. Many do.

[elementip]

If the app actually requires SQL, a DSN won't cut it. You will have to install MSSQL on a non-webserver edition server.

[cptkoi]

Originally posted by elementip
If the app actually requires SQL, a DSN won't cut it. You will have to install MSSQL on a non-webserver edition server.

An odbc/dsn/named pipe connection will be all that is required. Find someone with an sql server offering that matches your requirements. To install and maintain your own instance of SQL is a big job and costly.

[Winkie]

Woah hold on, you actually can't install SQL server on certain OSs?

Oh god I hate you microsoft, I hate you more than I hate being punched in the face with a truck.

[elementip]

Originally posted by Winkie
Woah hold on, you actually can't install SQL server on certain OSs?

Oh god I hate you microsoft, I hate you more than I hate being punched in the face with a truck.

They do this so they can offer the web edition at a steep price break. You could always install MySQL on the box, but if an app requires MS SQL, you will have to have access to it on another platform.

This edition of Server 2003 seems to be the only one that does not follow the 'do more with less' slogan.. you need another server depending on your SQL requirements.

[JTY]

Web Edition was geared towards web servers. Besides, MS SQL was always geared towards being installed on a dedicated server.

[Shannara]

Ive been told by several people, they have successfully installed MSSQL Server on Win2k3 WE. The actual "restriction" is the Microsoft License for Win2k3 WE. If you were not presented with the license when ordering the server, or in the welcome email, then you are NOT restricted by the license. The law is VERY clear on this.

Unless, of course, the company you are renting the server from included such a thing in their AUP/TOS or some such. Believe it or not, some very popular ones do not

[Jake Weg]

yea today is a good day to screw your host !

[Shannara]

Nah I believe it is the host's responsibility to pass on to their customers the license. SM does that wonderfully on their site. I use SM. RS (EV1) Did not for the longest time. I signed on w/ them under the old agreement where there were no such limitations. I have since moved to SM. From what I understand now, RS fixed their TOS/AUP.

Anyways, as I said above, the host who agree to this license have the responsibility to attach the license to their AUP/TOS for new and existing customers (if such a clause is there). This will keep the Host out of trouble, if one of their clients broke the agreement. The host can simply cancel the account due to breach of agreement.

It wouldnt be "screw your host day". More like "The host screwed themself over".