|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Error 7411:
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| ddebow 2002-10-31, 4:23 pm |
| Creating the following stroed procedure that pulls data
from two different servers on my network (See stored
procedure below). I keep getting the following error:
MICROSOFT SQL-DMO (ODBC SQLState:42000)
Error 7411: Server 'MCS-WEBDB' is not configured for DATA
ACCESS.
Any suggestions?
(Stored Procedure)
CREATE PROCEDURE SP_AUTHNOSENDREQ_UPD2 AS
UPDATE MCS_AUTHLETTERS
SET SEND2REQ=0
FROM MCS_AUTHLETTERS A INNER JOIN
[MCS-WEBDB].MCSKCONL.DBO.ONL_PROV B ON
A.REQID=B.PROVID
WHERE A.SEND2REQ=1 AND A.AUTH2REQ=0 AND
A.AUTHNO>'2002010100100001' AND B.ONLAUTH=1
| |
| Jasper Smith 2002-10-31, 5:23 pm |
| On the server the store procedure runs on execute the following
exec master..sp_serveroption '[MCS-WEBDB]','data access','true'
--
HTH
Jasper Smith (SQL Server MVP)
Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm
"ddebow" <ddebow@mcskc.com> wrote in message
news:008e01c28128$b4a8c6f0$39e
f2ecf@TKMSFTNGXA08...
> Creating the following stroed procedure that pulls data
> from two different servers on my network (See stored
> procedure below). I keep getting the following error:
>
> MICROSOFT SQL-DMO (ODBC SQLState:42000)
> Error 7411: Server 'MCS-WEBDB' is not configured for DATA
> ACCESS.
>
> Any suggestions?
>
>
> (Stored Procedure)
> CREATE PROCEDURE SP_AUTHNOSENDREQ_UPD2 AS
> UPDATE MCS_AUTHLETTERS
> SET SEND2REQ=0
> FROM MCS_AUTHLETTERS A INNER JOIN
> [MCS-WEBDB].MCSKCONL.DBO.ONL_PROV B ON
> A.REQID=B.PROVID
> WHERE A.SEND2REQ=1 AND A.AUTH2REQ=0 AND
> A.AUTHNO>'2002010100100001' AND B.ONLAUTH=1
>
>
>
| |
| ddebow 2002-10-31, 6:23 pm |
| Jasper---
That worked!! Thanks a lot man~Your awesome!
>-----Original Message-----
>On the server the store procedure runs on execute the
following
>
>exec master..sp_serveroption '[MCS-WEBDB]','data
access','true'
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>Check out the PASS Community Summit - Seattle, the
largest and only user
>event entirely dedicated to SQL Server, November 19-22.
>http://www.sqlpass.org/events/seattle/index.cfm
>
>"ddebow" <ddebow@mcskc.com> wrote in message
> news:008e01c28128$b4a8c6f0$39e
f2ecf@TKMSFTNGXA08...
>> Creating the following stroed procedure that pulls data
>> from two different servers on my network (See stored
>> procedure below). I keep getting the following error:
>>
>> MICROSOFT SQL-DMO (ODBC SQLState:42000)
>> Error 7411: Server 'MCS-WEBDB' is not configured for
DATA
>> ACCESS.
>>
>> Any suggestions?
>>
>>
>> (Stored Procedure)
>> CREATE PROCEDURE SP_AUTHNOSENDREQ_UPD2 AS
>> UPDATE MCS_AUTHLETTERS
>> SET SEND2REQ=0
>> FROM MCS_AUTHLETTERS A INNER JOIN
>> [MCS-WEBDB].MCSKCONL.DBO.ONL_PROV B ON
>> A.REQID=B.PROVID
>> WHERE A.SEND2REQ=1 AND A.AUTH2REQ=0 AND
>> A.AUTHNO>'2002010100100001' AND B.ONLAUTH=1
>>
>>
>>
>
>
>.
>
|
|
|
|
|