Tuesday, March 27, 2012

AddlinkServer Problem with SQL Server 2003

Hello,
I have a laboratory server with SBS 2003 (Sql Server 2003), and I have 3
PC's linked to that server.
PC 1 and PC 2 has Sql Server 7.0 Personal Edition with SP4, the query to
link is:
exec sp_dropserver 'Server2003'
go
exec sp_addlinkedserver 'Server2003', 'Sql server'
go
exec sp_serveroption 'Server2003', 'collation compatible', true
go
exec sp_serveroption 'Server2003', 'data access', true
go
Runs OK, but when I run a query to data access to the linked server, sample:
select top 1 no_impuesto from Server2003.Tienda.dbo.CRIMP
--
result:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
Note: I don't have any problems to link and access data with SBS 2000.
PC 3 Have Sql Server 2000 Personal Edition wiht SP4, the query to link is
the same avove,
the sample query to access data to the linked server,:
select top 1 no_impuesto from Server2003.Tienda.dbo.CRIMP
--
result:
no_impuesto
--
0
(1 row(s) affected)
Works fine.
So, I need upgrade SBS 2000 Production Server to SBS 2003 Server, but the
app uses in some cases linked server to data access,
and all the Work Stations have W2000 Pro with SQL Server 7.0 SP4.
Any help would greatly be appreciated.
RobertoI'm sorry, the laboratory server with SBS 2003 have Sql Server 2000 sp3.
Any help would greatly be appreciated.
Roberto
"Roberto C. Hernandez Bernal" <rhb@.microsis.com.mx> wrote in message
news:uUyt3yHCFHA.1524@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have a laboratory server with SBS 2003 (Sql Server 2003), and I have 3
> PC's linked to that server.
> PC 1 and PC 2 has Sql Server 7.0 Personal Edition with SP4, the query to
> link is:
> exec sp_dropserver 'Server2003'
> go
> exec sp_addlinkedserver 'Server2003', 'Sql server'
> go
> exec sp_serveroption 'Server2003', 'collation compatible', true
> go
> exec sp_serveroption 'Server2003', 'data access', true
> go
> Runs OK, but when I run a query to data access to the linked server,
sample:
> select top 1 no_impuesto from Server2003.Tienda.dbo.CRIMP
> --
> result:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> Note: I don't have any problems to link and access data with SBS 2000.
> PC 3 Have Sql Server 2000 Personal Edition wiht SP4, the query to link is
> the same avove,
> the sample query to access data to the linked server,:
> select top 1 no_impuesto from Server2003.Tienda.dbo.CRIMP
> --
> result:
> no_impuesto
> --
> 0
> (1 row(s) affected)
> Works fine.
> So, I need upgrade SBS 2000 Production Server to SBS 2003 Server, but the
> app uses in some cases linked server to data access,
> and all the Work Stations have W2000 Pro with SQL Server 7.0 SP4.
> Any help would greatly be appreciated.
> Roberto
>

No comments:

Post a Comment