servers

I have been working with only one server up till now and I guess I don't
understand the process of linking (or using) a second SQL server
Situation:
We have one SQL 2000 server on our network called SQLMain and another that
we have added called SQLACC. Both are on the same network.
I need a view on SQLMain that will include one table from a database on the
SQLACC server and one on the SQLMain server..
create view vwServices as
select * from SQLACC.corData.dbo.tblVendor v
join tblservices s on v.vendorid = c.vendorid
... in the SQLMain.services database and got this error...
error 7411: server 'SQLACC' is not configured for DATA ACCESS
I then figured that I needed to set SQLACC up as a linked server, but when I
tried with
sp_addlinkedserver @.server='SQLACC', @.svrproduct='SQL Server'
I got...
server 'SQLACC' already exists.
I tried 'SQLACCLINK as the @.server parameter but there was no place to
indicate the real name of the server so it didn't seem to be 'linked' to
anything.
I have read the help files on setting up linked servers and also "SQL Server
unleashed" and still don't know what I am doing. Can anyone help or at
least describ the process in the context of the above?Probably the easiest solution would be to fire up Enterprise Manager
Navigate to Security | Linked Servers
Right click on the linked server that you are having problems with
On the Server Options tab make sure that 'RPC' and 'RPC Out' are checked
Hit Apply and then OK.
Try your query again
-- Keith, SQL Server MVP
"CRChisholm" <Charlie.Chisholm@.goodwill-suncoast.com> wrote in message =news:SisYa.18879$qg3.1185355@.twister.tampabay.rr.com...
> I have been working with only one server up till now and I guess I =don't
> understand the process of linking (or using) a second SQL server
> > Situation:
> > We have one SQL 2000 server on our network called SQLMain and another =that
> we have added called SQLACC. Both are on the same network.
> > I need a view on SQLMain that will include one table from a database =on the
> SQLACC server and one on the SQLMain server..
> create view vwServices as
> select * from SQLACC.corData.dbo.tblVendor v
> join tblservices s on v.vendorid =3D c.vendorid
> ... in the SQLMain.services database and got this error...
> > error 7411: server 'SQLACC' is not configured for DATA ACCESS
> > I then figured that I needed to set SQLACC up as a linked server, but =when I
> tried with
> sp_addlinkedserver @.server=3D'SQLACC', @.svrproduct=3D'SQL Server'
> > I got...
> server 'SQLACC' already exists.
> > I tried 'SQLACCLINK as the @.server parameter but there was no place to
> indicate the real name of the server so it didn't seem to be 'linked' =to
> anything.
> > I have read the help files on setting up linked servers and also "SQL =Server
> unleashed" and still don't know what I am doing. Can anyone help or =at
> least describ the process in the context of the above?
> >|||You could also fix this thru a system SP (sp_serveroption) as follows,
sp_serveroption 'linked server name', 'rpc', 'True'
sp_serveroption 'linked server name', 'rpcout', 'True'
Cheerz,
Denzil
----
"Keith Kratochvil" <keith.kratochvil.back2u@.novusprintmedia.com> wrote in message news:<eIqQPfOXDHA.2360@.TK2MSFTNGP12.phx.gbl>...
> Probably the easiest solution would be to fire up Enterprise Manager
> Navigate to Security | Linked Servers
> Right click on the linked server that you are having problems with
> On the Server Options tab make sure that 'RPC' and 'RPC Out' are checked
> Hit Apply and then OK.
> Try your query again
> --
> Keith, SQL Server MVP
> "CRChisholm" <Charlie.Chisholm@.goodwill-suncoast.com> wrote in message
> news:SisYa.18879$qg3.1185355@.twister.tampabay.rr.com...
> > I have been working with only one server up till now and I guess I
> don't
> > understand the process of linking (or using) a second SQL server
> >
> > Situation:
> >
> > We have one SQL 2000 server on our network called SQLMain and another
> that
> > we have added called SQLACC. Both are on the same network.
> >
> > I need a view on SQLMain that will include one table from a database
> on the
> > SQLACC server and one on the SQLMain server..
> > create view vwServices as
> > select * from SQLACC.corData.dbo.tblVendor v
> > join tblservices s on v.vendorid = c.vendorid
> > ... in the SQLMain.services database and got this error...
> >
> > error 7411: server 'SQLACC' is not configured for DATA ACCESS
> >
> > I then figured that I needed to set SQLACC up as a linked server, but
> when I
> > tried with
> > sp addlinkedserver @.server='SQLACC', @.svrproduct='SQL Server'
> >
> > I got...
> > server 'SQLACC' already exists.
> >
> > I tried 'SQLACCLINK as the @.server parameter but there was no place to
> > indicate the real name of the server so it didn't seem to be 'linked'
> to
> > anything.
> >
> > I have read the help files on setting up linked servers and also "SQL
> Server
> > unleashed" and still don't know what I am doing. Can anyone help or
> at
> > least describ the process in the context of the above?
> >
> >