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 are
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:
> Sounds like you are using sql server authentication, so make sure servers are
> 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
> >