MS SQL Server - SQL Server ODBC Connection Almost right

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server ODBC Connection Almost right

2006-12-06, 7:12 pm

I have an SQL Server Express 2005 setup on a networked machine about 5
feet from me. I'm trying to log-in from another machine. I have allowed
remote connection and set-up a login/pass on the server and I can
log-in successfully.

NOW what is happening is that when I log-in to link a table with an
access 2k2 front-end I can see all of the 'master' tables (e.g.
INFORMATION_SCHEMA.CHECK_CONSTRAINTS) but not the database/tables that
I have created on the server.

I have set the properties of the user to access the desired
database/table by default but I literally cannot see it at all - except
for when i'm on the server itself.

Sponsored Links