I have a sqlserver2008 database on server2003, which only Admin can login on it. I have create a small report program with MSaccess. I have linked tables with ODBC from sqlserver. Then I have put Access file in sharing folder that other users could run/get report. But, of course first of all I was need to open ODBC also on client computers. But, here it stops. Because ODBC shows only System Tables from SqlServer, and not actual tables with data.
As Admin, I can linked, and get/see all tables, but users not. At this point I know it should something with permissions. With Sql Management Studio I open sql server without authentification.
Any idea? It would be really helpfull if someone could help me, advise,...
Thank you in advance for help.