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...
Showing posts with label vpn. Show all posts
Showing posts with label vpn. Show all posts
Monday, March 19, 2012
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...
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
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
Friday, February 24, 2012
How can I get Enterprise Manager to see my remote server?
I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>> I need to manage a SQL Server installation over the internet via a VPN
>> connection.
>>
>> Enterprise Manager can't see the server, when I put in the name, EM times
>> out.
>>
>> How can I Register this server if EM can't see it from here?
>>
>> If I Register the server while I'm at that site, should it then work from
>> my
>> remote office?
>>
>> Thanks
>>
>> Kelvin
>>
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>> I need to manage a SQL Server installation over the internet via a VPN
>> connection.
>>
>> Enterprise Manager can't see the server, when I put in the name, EM times
>> out.
>>
>> How can I Register this server if EM can't see it from here?
>>
>> If I Register the server while I'm at that site, should it then work from
>> my
>> remote office?
>>
>> Thanks
>>
>> Kelvin
>>
Subscribe to:
Posts (Atom)