Linked server error: Access denied

Hello everybody,
I have created a linked server(from SQL server 7 to 2000) like this:
Provider: Microsoft OLEDB Provider fro SQL server
Data Source: NameOfTheServer
Catalog: NameOfTheDatabase
On the second tab(security) I have specified
Remote login : UserName
Password: Password
Where UserName with the password is SQL server user and this user exist on
both servers (with the same password).
However when I try to run sql server query:
SELECT @.ExchRate = field1 FROM
[NameOfTheServer].[NameOfTheDatabase].dbo.table WHERE ...
I get the error
Server: Msg 2, Level 16, State 1, Line 12
Access denied.
Any suggestions would be appreciated, thanks
Diana MSounds like you are using sql server authentication, so make sure servers ar
e
operating in mixed-mode security.
Phillip MacPherson-Cox
"Diana M" wrote:

> Hello everybody,
> I have created a linked server(from SQL server 7 to 2000) like this:
> Provider: Microsoft OLEDB Provider fro SQL server
> Data Source: NameOfTheServer
> Catalog: NameOfTheDatabase
> On the second tab(security) I have specified
> Remote login : UserName
> Password: Password
> Where UserName with the password is SQL server user and this user exist on
> both servers (with the same password).
> However when I try to run sql server query:
> SELECT @.ExchRate = field1 FROM
> [NameOfTheServer].[NameOfTheDatabase].dbo.table WHERE ...
> I get the error
> Server: Msg 2, Level 16, State 1, Line 12
> Access denied.
> Any suggestions would be appreciated, thanks
> Diana M
>|||Yes, they are
"Phillip MacPherson-Cox" wrote:
[vbcol=seagreen]
> Sounds like you are using sql server authentication, so make sure servers
are
> operating in mixed-mode security.
>
> Phillip MacPherson-Cox
>
> "Diana M" wrote:
>