How can I remote my sql server?

How do I get access to my server.
It keeps saying this.
I set yes to tcp
What port is it suposto be on?

Code Snippet

TITLE: Connect to Server

Cannot connect to gv.ns1.name.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

BUTTONS:

OK

Verify that you have followed all the steps in these articles.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

|||Where is an FAQ I wrote on troubleshooting connection problems to SQL Server http://www.tek-tips.com/faqs.cfm?fid=5481|||I can't connect even to localhost.
So it has nothing to do with firewall.
Something in setting but i have no clue about this....|||Verify that the SQL Server is actually running. Check in the Services applet.|||I can connect though the computer.
Not though remote though.|||

So, if you can connect through the local computer, and not the remote computer, and you are certain that the configurations for remote connections are set correctly,

... and you say that you

can't connect even to localhost

what computer are you attempting to connect to remotely. (Clue: The remote computer is NOT known as 'localhost'.)

Please post your entire connection string.

|||Did you edit your lmhosts or hosts file? Doing remote connections, you need to resolve the IP address into a name.|||

Can you verify that you followed the instructions in this posting. Quick check list:

Make sure that TCP/IP is enabled for the instance (Use SQL Server Configuration Manager) If using a named instance, make sure that the SQL Server Browser server is running (Use SQL Server Configuration Manager) If using a named instance and you're running a firewall, make sure sqlservr.exe and sqlbrowser are added to the exception list.

How can I Port Driver and OAL code of Windows CE 5.0 to Windows CE 4.2

How can I Port Driver and OAL code of Windows CE 5.0 to Windows CE 4.2?

If anybody have idea about this, kindly give me suggestions.

I think you are posting to the wrong forum. This is T-SQL forum...sql

How can I know my remote ms sql server is listening on port 1433

Hi,
I really can not connect to our remote MSDE database running under Ms 2003
server web edition. I am thinking that it might be the problem of firewall
which block port 1433,but my ISP don't think so.
How can I check that my server is listening on port 1433 or not'
Met vriendelijke groet,
Guoqi Zheng
Tel: +31 (0) 23 5343545
http://www.meetholland.comCheck the SQL Errorlog on the server. It will show what port it is
listening on.
Check the NT Application Event logs. The same information is there.
Run netstat -an
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

How can I get the port of a named instance of SQL Server

Thanks for Microsoft's Windows XP Service Pack 2 and Windows Server 2003 that make the security much stronger. However, besides the invisible benefit so far, I have become the victim of this security policy.

I have several named instances of SQL 7/2000 installed in my machine. They are not visible out of the Microsoft new fire wall. I need to access the instances from outside the fire wall, but I don't know which port I should open for the instances.

From SQL online, the default instance of SQL server is connected through TCP/IP by default port 1433. I could successful open that port and made the default instance visible to outside. However, the port 1433 doesn't work for the named instances. SQL online said, the port for named instance is dynamically (by default) chosen the first time the instance is started. So, actually, I have no way to know the port.

Is there anyway that I can check the database or somewhere to get the port that is used by the named instance?

Thanks for any input and recommendation.> I am the first victim of this security policy.

don't kid yourself. a lot of people have been caught out - many by inadequate preparation or by a simple naivete. your problem seems more of an actual gotcha though.

try turning off the firewall and doing a netstat -a|||Hi, Atrax, thanks for your input. But, ...|||wtf? I didn't follow that at all.|||Never mind.

By the way, I got the solution for the original question. Using SQL Server Network Utility can find all ports for default and named instances.