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 Link to a Table in a Different Database?

Hi all,

We have lookup tables we share on 6 database servers. We keep copying these very large tables to every database we use on each server, obviously a great waste of space. We don't mind copying these tables onto each of the servers but we want to be able to link to these tables from each database from within our servers. How is this done? Thanks in advance.

ddavesp_addlinkedserver?|||Brett,

The Sr. Analyst here mentioned that if we used a function to go across the network he was concerned about increased network traffic. Does what you suggest play into that concern?

ddave|||Brett,

The Sr. Analyst here mentioned that if we used a function to go across the network he was concerned about increased network traffic. Does what you suggest play into that concern?

ddave

You could always test it with one...and set up profiler...

I guess it all depends on how the sprocs are written...

Ask him to check out the Network when he's copying all that data to the 6 servers...I would think that's a lot of traffic...

And what about data syncronicity? (Is that a real word?)

I guess you could set up replication and/or build your own with triggers...

One of the databases would need to be a publisher and the rest subscribers...

I've never implemented a production level linked server strategy...but from my tests, I haven't seen a problem...

6 servers...you must be getting a lot of hits a day....

how big are the code tables and the db in general?|||This looks like what I need to do as well. Joins on two tables in different DBs on different servers. Will this work?|||I have one caution for all of this. I do not think you can set up an alias for a linked server, unless maybe in DNS. If you move a database from one server to another, you could end up with a large amount of re-coding. This may not be a problem for your shop, but it is something to watch for.|||The databases are anywhere from 400MB to 22,000 MB. I mean I look under properties and I see 400 MB, a couple at about 1,000 MB, another at 7,000 MB and so forth. It is not for a web site. It is an internal system for medical data. I would say an average table we read off of is 600,000 records with 90-110 fields. We don't have an in-house DBA as you may have guessed.

ddave

"6 servers...you must be getting a lot of hits a day....

how big are the code tables and the db in general?"|||Actually,

this seemed to work:

SELECT TOP 100 *
FROM pfc_Premera_BC_Rx..pfc pfc1
LEFT JOIN SQL_Server_Training_DB..pfc
on pfc1.pfc_pkid = pfc.pfc_pkid
ORDER BY pfc1.pfc_pkid

ddave

How can I launch a report without generating it automatically?

I am accessing a report in IE by typing the following link in the address field:

http://localhost/ReportServer/Pages/ReportViewer.aspx?/Reports/TheNameOfMyReport

When the page is loaded, the report is generated automatically because all report parameters have default values.

How can I modify my report so that it is not automatically generated? I would like to wait until the user clicks on "View Report" before rendering the report.

As a temporary solution, I removed the default value of one report parameter but I would like to get it to work even if I leave all default values in.

I have seen sites where they describe a list of extra parameters you can include in the url to modify the behavior of the report like:

&rs:Command=Render

&rs:Format=Excel

&rc:NoHeader=true ...

but I haven't seen anything to tell the reporting engine not to render a report.

Any help would be appreciated, thx.

Is this not possible. I am also looking forward to a way to do the same?|||This appears to be only possible with your workaround above or by using the Reportviewer control in Visual Studio.

How can I get another copy of RS2000? Need help ASAP!

I need another enterprise RS2000 CD. What is the quickest way to get one?
If you have a link or contact number please post. I am located in Atlanta
GA. I can't seem to find it on the website.
thanks in advance
OSOn Nov 26, 10:30 am, OriginalStealth
<OriginalStea...@.discussions.microsoft.com> wrote:
> I need another enterprise RS2000 CD. What is the quickest way to get one?
> If you have a link or contact number please post. I am located in Atlanta
> GA. I can't seem to find it on the website.
> thanks in advance
> OS
This link might be helpful.
http://technet.microsoft.com/en-us/sqlserver/bb331729.aspx
Regards,
Enrique Martinez
Sr. Software Consultant