Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Just a thought -
Inside this procedure:
[DK_SQL_01].SimpleDayFeeder.dbo.SimpleDaysUpdateOnHand
Does your login have privileges to all the tables views, etc. contained within?
>I have linked a Sql2005 server in a multi server environment in order to run remote queries.
>
>I did setup security, so that
>
>Select Top 10 * From [DK_SQL_01].Fleet.dbo.Inventory
>
>works and returns results
>
>But:
>
>EXEC [DK_SQL_01].SimpleDayFeeder.dbo.SimpleDaysUpdateOnHand
>
>Returns:
>Server: Msg 7416, Level 16, State 1, Line 1
>Access to the remote server is denied because no login-mapping exists.
>
>I believe I have set up correct login mappings, since the query works, but I keep getting this error.
>
>TIA
>
>Peter
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement