sql server msde:
Hi All,
I have two servers with the following detail:
Server #1
Server Name: SQL2005WIN2003SERVER
Windows: Win 2003 Server
SQL DB: SQL Server 2005 ('sa', 'pswd123')
MS.NET: .NET Framework 1.1 and 2.0
Firewall: NO
Server #2
Server Name: OLDMSDE\WIN2000SERVER
Windows: Win 2000 Server
SQL DB: MSDE ('sa', '') - no sa password
MS.NET: NO
Firewall: NO
I am trying to install an ASP.NET 2.0 web application on Server #1.
Everything was working fine and running smoothly. However, I got a problem
when I tried to connect my Server #1 ASP.NET stored procedure to Server #2
database table to get some data.
First and foremost, both Servers are connected to each other perfectly
through LAN. So the first task I need to do is by registering the Server #2
into my Server #1 via sp_addlinkedserver as below:
USE master;
GO
EXEC sp_addlinkedserver
@server='OLDMSDE\WIN2000SERVER',
@srvproduct='',
@provider='SQLNCLI',
@datasrc='OLDMSDE\WIN2000SERVER'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname=N'OLDMSDE\WIN2000SERVER',
@useself=N'False',
@locallogin=NULL,
@rmtuser=N'sa',
@rmtpassword=''
GO
EXEC sp_serveroption 'OLDMSDE\WIN2000SERVER', 'RPC', 'ON'
GO
After executing the query, I try to execute the stored procedure with the
following select statement:
SELECT * FROM [OLDMSDE\WIN2000SERVER].dbTestDatabase.dbo.tblTestTable
Unfortunately I got the following error message even though I have set the
RPC to ON:
Server 'OLDMSDE\WIN2000SERVER' is not configured for RPC.
Please advise how to solve this issue.
Many Thanks,
Samuel Lee
