Discussion Locked

Link SQL servers - Access denied

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When Linking two networked SQL V7 servers for data replication: SQL issued queries works from Database on PC Windows 95&98 to the main NT server; however, when try to access the "remote" PC (win 95/98) Database
from the Main NT server - get a server error "Access denied" tried to map users logins.
How to fix, were to look to trouble shoot.

5 replies

by donq

It sounds as though you have User Level security enforced across a network within the ODBC database??? If so insure every user requiring access to the Tables (or queries/procedures) has been granted read/write permissions. Each user MUST have access permissions to each part!

by james_randy

That was a very thoughtful and thorough first answer. Why don't you go ahead and accept that answer and close the question.

This discussion is closed to new replies.