IIS Hosting and SQL Server 2008 R2 not available online

Question

I have succeeded in hosting my applications locally but when i try to view it through a network outside it fails.

Same goes for my SQL Server, I am able to connect locally.

I have tried to open my port but it keeps failing, Is the port the cause of the problem? Server Manager is also not found in my IIS

PS. I am using windows 8

Please help, it would benefit my school project alot

IrishChieftain · Answer 1 · 2013-06-01 05:51:06Z

up vote 2 down vote

You need to open port 1433 for access to SQL Server:

Similar question here.

You will also need to enable Named Pipes and TCP/IP in the SQL Server Configuration Manager.

edited Jun 1 at 5:51

answered Jun 1 at 5:39

IrishChieftain
9,98031447

	I followed some of the instructions in the link enabling port 1433, sqlserv, and the command to open the port. Have not tried to connect remotely but when i open up my Sql Server Configuration Manager, my SQL Server Services gives The remote procedure call failed. [0x800706be]. Do i have to reinstall Sql Server? – Bloopie Bloops Jun 1 at 8:09
	Hi, installed the Sql service pack, i tested my port again, this time 1433 is opened thanks! Is there any similar guides to opening port for IIS? – Bloopie Bloops Jun 1 at 8:31
	Port 80 is open by default - what error message are you getting? – IrishChieftain Jun 1 at 13:53

1 Answer