making a web server

[EternalOptimist]

We have a server that is running sql server 2005. What do we have to do to make it into a web server, can it be made purely local (for testing).

I know nothing...

[Sockpuppet]

Install Apache. http://httpd.apache.org

If your really lazy go here: http://www.apachefriends.org/en/index.html

[themistry]

We have a server that is running sql server 2005. What do we have to do to make it into a web server, can it be made purely local (for testing).

I know nothing...

Add Remove Programs -> Windows Stuff -> Internet Application Server

Sorry, forgot the exact names of things.

Immediately run windows update. You now have a web server.

Sounds like you want to run SQL Reporting Services,

Be advised, I hope this is a test/dev box. You really don't want to be exposing your database servers directly in this way.

TM

[EternalOptimist]

Add Remove Programs -> Windows Stuff -> Internet Application Server

Sorry, forgot the exact names of things.

Immediately run windows update. You now have a web server.

Sounds like you want to run SQL Reporting Services,

Be advised, I hope this is a test/dev box. You really don't want to be exposing your database servers directly in this way.

TM

Its the main database server for the cabinet office in downing street.
No its not, I just made that up.


I suppose there are ways to prevent everyone and his dog getting onto the server ?

[lilelvis2000]

Yes. you will need turn off anonymous access on IIS and then specify which security group (Administrators, Local Users etc..) that you want to have access.

[DimPrawn]

Okay, to make a webserver, you will need:

some string.
coloured paper or card.
2 old yoghurt pots.
a cotton reel
glue
glitter (optional - only if you need https)


Step 1.

http://www.microsoft.com/technet/pro....mspx?mfr=true

Step 2.

Ask for more help when step 1 does not work.

HTH

[EternalOptimist]

Thanks guys, we now have the server but cant make a connection to an MSACCESS database. They want me to investigate in half an hour or so

using IE6, IE5 worked apparently

[lilelvis2000]

How is the connection being made? As I recall processes within IIS are run under the IIS account..IUSR_<machine name>. You need to make sure
this account has access to the folder of the mdb file and exe and dlls.

[EternalOptimist]

How is the connection being made? As I recall processes within IIS are run under the IIS account..IUSR_<machine name>. You need to make sure
this account has access to the folder of the mdb file and exe and dlls.

excellent

stand by, I am going in.

[EternalOptimist]

getting this


general error unable to open registry key 'temporary (volatile) for jet



we have an mdb, jet ole but not msaccess installed.