June 10, 2003 at 2:30 am
I have this problem
I execute a stored procedure by Query Analyzer.
The execution of stored procedure failed with message:
Server: Msg 7411, Level 16, State 1, Line 1
Server <SERVER NAME> is not configured for DATA ACCESS.
What means??
Help me please.
Thanks
Flavio
June 10, 2003 at 5:15 am
Are you referencing a linked server? It has a property you have to enable to allow data access.
Andy
June 10, 2003 at 6:45 am
Thanks AW, but....
I don't understand like resolving the problem!
I execute the stored procedure in local SQL Server.
In the code of the stored procedure, I use (for example), to reference a table:
INSERT INTO TABLE_NAME_1
select ....FIELDS_NAME, .... from [SERVER_NAME].[DB_NAME].[dbo].[TABLE_NAME_2]
SERVER_NAME is the name of my local SQL Server.
Executing the procedure the errore message is the same
Can You help me??
Thanks
Flavio
June 10, 2003 at 6:48 am
Hello Flavio,
quote:
select ....FIELDS_NAME, .... from [SERVER_NAME].[DB_NAME].[dbo].[TABLE_NAME_2]
does SELECT * FROM [dbname].dbo.table_name_2 also not work?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 10, 2003 at 7:03 am
Hello Cheers and thanks for your attention
Now
If I execute by Query Analyzer the statement:
SELECT * FROM [dbname].dbo.table_name_2
work, It's OK!
instead
SELECT * FROM [serverName].[dbname].dbo.table_name_2
not work!
Bye bye
Flavio
June 10, 2003 at 7:05 am
Ops!!
Frank, not Cheers!!!
Excuse me, pardon!
June 10, 2003 at 7:14 am
Hello Flavio,
de niente, buoa fortuna!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 10, 2003 at 7:28 am
OK Frank, but
Do you know, because
SELECT * FROM [dbname].dbo.table_name_2
work
instead
SELECT * FROM [serverName].[dbname].dbo.table_name_2
not work ??
Bye
Bye bye
Flavio
June 10, 2003 at 7:36 am
Hello Flavio,
quote:
SELECT * FROM [dbname].dbo.table_name_2work
SELECT * FROM [serverName].[dbname].dbo.table_name_2
not work ??
see BOL, syntax conventions, Transact-SQL for details. [serverName] is only used when you try to access a linked or remote server, which isn't the case for you.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 10, 2003 at 8:00 am
Thanks Mimorr (Michelle)
I executed your code by Query Analyzer
and then, I tried to execute one SELECT statement like example.
The problem is resolved!!
Now, I think I'll execute my stored procedure, and I'm going to see in the Books on line
the procedure sp_serveroption.
Thanks Michelle
I can offer you a pizza?
Thanks at all !!
Bye bye
Flavio
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy