|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > I'm getting error 7411 once trying to execute a store procedure
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]
| Author |
I'm getting error 7411 once trying to execute a store procedure
|
|
| Hanan Hit 2002-08-07, 1:23 pm |
| I'm getting a 7411 error once I'm trying to execute an
home grown store procedure, even with the usage of sa.
I tried to look on TechNet, and there is no explanations
about this.
In the BOL needless to mention that I didn't find any
explanations as well.
Here is the error:
Server: Msg 7411, Level 16, State 1, Line 1
Server 'EMCDB05' is not configured for DATA ACCESS.
Help is needed.
Hanan
| |
| Narayana Vyas Kondreddi 2002-08-07, 2:23 pm |
| If you are referencing a linked server, then you need to enable that linked
server for 'data access'. For example, the following should help:
EXEC sp_serveroption 'EMCDB05', 'data access', 'true'
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Hanan Hit" <hhit@merc-net.com> wrote in message
news:0a7e01c23e43$89c168c0$9ae
62ecf@tkmsftngxa02...
I'm getting a 7411 error once I'm trying to execute an
home grown store procedure, even with the usage of sa.
I tried to look on TechNet, and there is no explanations
about this.
In the BOL needless to mention that I didn't find any
explanations as well.
Here is the error:
Server: Msg 7411, Level 16, State 1, Line 1
Server 'EMCDB05' is not configured for DATA ACCESS.
Help is needed.
Hanan
|
|
|
|
|