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)
Mr_EziAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Reza RadConsultant, TrainerCommented:
did you set server as Allow Remote Connections?
is the sql server browser service started on server?
is the ports 1433 tcp and 1434 udp are open on firewall?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mr_EziAuthor Commented:
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.
0
Reza RadConsultant, TrainerCommented:
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?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Mr_EziAuthor Commented:
the first one was enabled

the error is this:
SQLServerAgent could not be started (reason: Error creating a new session).
0
Reza RadConsultant, TrainerCommented:
try this work around for the error :
http://support.microsoft.com/kb/955763

0
Mr_EziAuthor Commented:
Now the error changed to: The SQLBrowser service port is unavailable for listening, or invalid.
0
Reza RadConsultant, TrainerCommented:
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
0
Mr_EziAuthor Commented:
I just realized that the link is for sql agent not sql browser,

Which one need's to be running?
0
Reza RadConsultant, TrainerCommented:
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?
0
Mr_EziAuthor Commented:
No I can't start it, it is set to automatic
0
Reza RadConsultant, TrainerCommented:
do you get same error in event log?
0
Mr_EziAuthor Commented:
The SQLBrowser service was unable to establish SQL instance and connectivity discovery.
0
Mr_EziAuthor Commented:
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
0
Mr_EziAuthor Commented:
Will reinstalling the server help?
0
Reza RadConsultant, TrainerCommented:
>>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?


0
Mr_EziAuthor Commented:
Yes its the same.

I reinstalled the server but didn't help
0
Reza RadConsultant, TrainerCommented:
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.


0
Mr_EziAuthor Commented:
OK I'll try
0
Mr_EziAuthor Commented:
Ok it works it was the surface configuration manager

Thanks for all your help
0
Reza RadConsultant, TrainerCommented:
ok, good,
Glad to help,
Regards,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.