Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heliang
Starting Member
38 Posts |
 Posted - 2010-04-28 : 11:49:55
|
| I have create a linked server with SA account, but when I login with a different user, I am not able to use it. What permission should I grant to this user? |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-04-28 : 12:11:43
|
| Does the user exist on the linked server and have appropriate rights to the database(s)? What's the error message you receive?Terry-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher |
 |
|
|
heliang
Starting Member
38 Posts |
Posted - 2010-04-28 : 13:43:18
|
| select * from mysqlserver.mydb.test.t_personMsg 7314, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "mysqlserver" does not contain the table ""mydb"."test"."t_person"". The table either does not exist or the current user does not have permissions on that table.not sure how to add user to existing linked server in 2005. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-04-29 : 08:53:26
|
quote:
Originally posted by heliang
Msg 7314, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "mysqlserver" does not contain the table ""mydb"."test"."t_person"". The table either does not exist or the current user does not have permissions on that table.not sure how to add user to existing linked server in 2005.
You don't add it to the linked server definition but the server you are linking to. Once added, assign the appropriate rights for the user (datareader, datawriter, whatever) and give them access to the appropriate database(s) and/or objects.Also, and I may be wrong here, but I believe you need a four part naming convention such as mysqlserver.mydb.test.t_person, assuming test is the schema owner???Terry-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher |
|
|
|
|
|
|
|
|
permission to use linked server