asked on

Can't connect to database from outside the network

I did forward the port on the router.

what else I need to set in sql server?

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)

ASKER CERTIFIED SOLUTION

Reza Rad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mr_Ezi

ASKER

Where do I set the first one?
the sql browser will not start for some reason a error comes up that it didn't respond in a timely manner.
the firewall is turned off for now.

Reza Rad

first one:
in server machine, go here:
in SSMS
right click on server name in object explorer
select properties
go to connection tab
check the ALLOW REMOTE CONNECTION be enable.

for second one:
could you go to controlpanel->administrative tools->event log
and paste the exact error message here?

Mr_Ezi

ASKER

the first one was enabled

the error is this:
SQLServerAgent could not be started (reason: Error creating a new session).

Reza Rad

try this work around for the error :
http://support.microsoft.com/kb/955763

Mr_Ezi

ASKER

Now the error changed to: The SQLBrowser service port is unavailable for listening, or invalid.

Reza Rad

is this service disabled?
go to :
control panel-> administrative tools->services
find the sql browser service and if this is set as disable, set it to automatically

Mr_Ezi

ASKER

I just realized that the link is for sql agent not sql browser,

Which one need's to be running?

Reza Rad

sql browser should be started,
I found that before, I thought that there maybe a relation between agent and browser for the error.

now could you start browser service now? is it enable?

Mr_Ezi

ASKER

No I can't start it, it is set to automatic

Reza Rad

do you get same error in event log?

Mr_Ezi

ASKER

The SQLBrowser service was unable to establish SQL instance and connectivity discovery.

Mr_Ezi

ASKER

Now I see in the list of services that at sql browser is doesn't say my server name as it is with agent service, maybe that's the cause?
Untitled.png

Mr_Ezi

ASKER

Will reinstalling the server help?

Reza Rad

>>Now I see in the list of services that at sql browser is doesn't say my server name as it is with agent service, maybe that's the cause?<<
maybe,

go here:
start
programs
microsoft sql server 2008
configuration tools
sql server configuration manager
select sql services in left panel
and list of services will show in right panel
double click on sql browser service
go to advance tab,
see what written front of InstanceID ??? is it the same sql server instance you work with or not?

Mr_Ezi

ASKER

Yes its the same.

I reinstalled the server but didn't help

Reza Rad

did you ever tried to reinstall?
if you have other instances of sql server and you could uninstall all of them before , this can be helpful too.

Mr_Ezi

ASKER

OK I'll try

Mr_Ezi

ASKER

Ok it works it was the surface configuration manager

Thanks for all your help

Reza Rad

ok, good,
Glad to help,
Regards,