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 register new SQL server by name?

I got some problem when I try to register new SQL Server. It cannot connected by server name. However, if I connect it by IP Address it can. How can I register new SQL server to Enterprise Manager by name?In Client Network Utility, add name as an alias for that IP address using TCP/IP...|||Thank You.

How can I Query Analyze DB Greater than 128MG

I have a 300MG DB and Query Analyzer gives me the "... DB larger than configured..." error when I try to connect to it...

What is the work around?

Thanks in advance

JEK

If you have sql server 2005 you can use the sql server management studio to connect to your sql ce (.sdf) database.
|||In SQL Server Management Studio, in the Connect To Server dialog, click "Options >>", and you will be able to increase the max db size from the default of 128 MB.|||I need to use Query Analyzer 3.0 on the Handheld|||There is no workaround this "bug". Await the next version or move the SDF file to your desktop and use one of the tools mentioned above.

How can I Query Analyze DB Greater than 128MG

I have a 300MG DB and Query Analyzer gives me the "... DB larger than configured..." error when I try to connect to it...

What is the work around?

Thanks in advance

JEK

If you have sql server 2005 you can use the sql server management studio to connect to your sql ce (.sdf) database.
|||In SQL Server Management Studio, in the Connect To Server dialog, click "Options >>", and you will be able to increase the max db size from the default of 128 MB.|||I need to use Query Analyzer 3.0 on the Handheld|||There is no workaround this "bug". Await the next version or move the SDF file to your desktop and use one of the tools mentioned above.

How can i onnect Visual Basic Express 2005 to a remote SQL Server Express 2005?

Hi

Im trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.
In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express.

The XP with the SQL server that i want to connect to is on the local network.

Greatful for help!

You may check this link:

http://msdn.microsoft.com/vstudio/express/vb/features/data/

If you need a admin tool for the SQL Express databases, you can dowload Management Studio Express from here:

http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx

sql

HOW CAN I LINK TWO SQL SERVER

I had connect another SQL server VIA VPN , the server name is IP e,g
123.123.123.123
I can read the data sucessfully,
However, I want to insert some data from my local server.
sp_addlinked server '123.123.123.123'
sp_linkedserver (I can see it)
then select * from [123.123.123.123].database.dbo.myTable
I got an error said 'SQL Server does not exist or access denied'
Does any one can help , Thanks
Agnes,
Try sp_addlinked server '123.123.123.123', 'SQL Server'
See if that works.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Agnes" wrote:

> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.123'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>
|||sp_linkedservers
sp_addlinkedserver '123.123.123.123','SQL SERVER'
sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't specific
user, it will add everone
select * from [123.123.123.123].dts_master.dbo.port
I still got 'SQL Server does not exist or access denied.'
My EM had add this server succesfully , I can modify the structure ,preview
the data,
BUT still fail to link it up. That server got the firewall, Does the
firewall block me ?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> glsD:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...[vbcol=seagreen]
> Agnes,
> Try sp_addlinked server '123.123.123.123', 'SQL Server'
> See if that works.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Agnes" wrote:
|||If you can see the server in EM it's not your FW that's blocking the access.
It might be your login to the linked server that isn't correct, so I'd
suggest you to look sp_addlinkedserver and sp_addlinkedsrvlogin in Books On
Line. There are some examples in there that might be helpfull.
Regards
Steen
Agnes wrote:[vbcol=seagreen]
> sp_linkedservers
> sp_addlinkedserver '123.123.123.123','SQL SERVER'
> sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't
> specific user, it will add everone
> select * from [123.123.123.123].dts_master.dbo.port
> I still got 'SQL Server does not exist or access denied.'
> My EM had add this server succesfully , I can modify the structure
> ,preview the data,
> BUT still fail to link it up. That server got the firewall, Does the
> firewall block me ?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org>
> glsD:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...

HOW CAN I LINK TWO SQL SERVER

I had connect another SQL server VIA VPN , the server name is IP e,g
123.123.123.123
I can read the data sucessfully,
However, I want to insert some data from my local server.
sp_addlinked server '123.123.123.123'
sp_linkedserver (I can see it)
then select * from [123.123.123.123].database.dbo.myTable
I got an error said 'SQL Server does not exist or access denied'
Does any one can help , ThanksAgnes,
Try sp_addlinked server '123.123.123.123', 'SQL Server'
See if that works.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Agnes" wrote:

> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.123'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>|||sp_linkedservers
sp_addlinkedserver '123.123.123.123','SQL SERVER'
sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't specific
user, it will add everone
select * from [123.123.123.123].dts_master.dbo.port
I still got 'SQL Server does not exist or access denied.'
My EM had add this server succesfully , I can modify the structure ,preview
the data,
BUT still fail to link it up. That server got the firewall, Does the
firewall block me '
"Mark Allison" <marka@.no.tinned.meat.mvps.org> glsD:F3E2A330-5023-418C-A4C4-F114D2
292CB1@.microsoft.com...[vbcol=seagreen]
> Agnes,
> Try sp_addlinked server '123.123.123.123', 'SQL Server'
> See if that works.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Agnes" wrote:
>|||If you can see the server in EM it's not your FW that's blocking the access.
It might be your login to the linked server that isn't correct, so I'd
suggest you to look sp_addlinkedserver and sp_addlinkedsrvlogin in Books On
Line. There are some examples in there that might be helpfull.
Regards
Steen
Agnes wrote:[vbcol=seagreen]
> sp_linkedservers
> sp_addlinkedserver '123.123.123.123','SQL SERVER'
> sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't
> specific user, it will add everone
> select * from [123.123.123.123].dts_master.dbo.port
> I still got 'SQL Server does not exist or access denied.'
> My EM had add this server succesfully , I can modify the structure
> ,preview the data,
> BUT still fail to link it up. That server got the firewall, Does the
> firewall block me '
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org>
> glsD:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...

HOW CAN I LINK TWO SQL SERVER

I had connect another SQL server VIA VPN , the server name is IP e,g
123.123.123.123
I can read the data sucessfully,
However, I want to insert some data from my local server.
sp_addlinked server '123.123.123.123'
sp_linkedserver (I can see it)
then select * from [123.123.123.123].database.dbo.myTable
I got an error said 'SQL Server does not exist or access denied'
Does any one can help , ThanksAgnes,
Try sp_addlinked server '123.123.123.123', 'SQL Server'
See if that works.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Agnes" wrote:
> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.123'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>|||sp_linkedservers
sp_addlinkedserver '123.123.123.123','SQL SERVER'
sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't specific
user, it will add everone
select * from [123.123.123.123].dts_master.dbo.port
I still got 'SQL Server does not exist or access denied.'
My EM had add this server succesfully , I can modify the structure ,preview
the data,
BUT still fail to link it up. That server got the firewall, Does the
firewall block me '
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ¼¶¼g©ó¶l¥ó·s»D:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...
> Agnes,
> Try sp_addlinked server '123.123.123.123', 'SQL Server'
> See if that works.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Agnes" wrote:
>> I had connect another SQL server VIA VPN , the server name is IP e,g
>> 123.123.123.123
>> I can read the data sucessfully,
>> However, I want to insert some data from my local server.
>> sp_addlinked server '123.123.123.123'
>> sp_linkedserver (I can see it)
>> then select * from [123.123.123.123].database.dbo.myTable
>> I got an error said 'SQL Server does not exist or access denied'
>> Does any one can help , Thanks
>>|||If you can see the server in EM it's not your FW that's blocking the access.
It might be your login to the linked server that isn't correct, so I'd
suggest you to look sp_addlinkedserver and sp_addlinkedsrvlogin in Books On
Line. There are some examples in there that might be helpfull.
Regards
Steen
Agnes wrote:
> sp_linkedservers
> sp_addlinkedserver '123.123.123.123','SQL SERVER'
> sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't
> specific user, it will add everone
> select * from [123.123.123.123].dts_master.dbo.port
> I still got 'SQL Server does not exist or access denied.'
> My EM had add this server succesfully , I can modify the structure
> ,preview the data,
> BUT still fail to link it up. That server got the firewall, Does the
> firewall block me '
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org>
> ¼¶¼g©ó¶l¥ó·s»D:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...
>> Agnes,
>> Try sp_addlinked server '123.123.123.123', 'SQL Server'
>> See if that works.
>> --
>> Mark Allison, SQL Server MVP
>> http://www.markallison.co.uk
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602m.html
>>
>>
>> "Agnes" wrote:
>> I had connect another SQL server VIA VPN , the server name is IP e,g
>> 123.123.123.123
>> I can read the data sucessfully,
>> However, I want to insert some data from my local server.
>> sp_addlinked server '123.123.123.123'
>> sp_linkedserver (I can see it)
>> then select * from [123.123.123.123].database.dbo.myTable
>> I got an error said 'SQL Server does not exist or access denied'
>> Does any one can help , Thanks

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.