Geoff Lilley


I'm using SQL Server 2005 Express, Windows XP SP2. I connect using Windows authentication.

The data source that I'm trying to hit is on a remote server. It's an OpenLink ODBC Data source, and the server is in another location. SQL Server 2005 Express and the ODBC connection are both installed/configured locally on my machine.

I can connect to the remote server. The DSN exists as a System DSN.

The DSN has its own proprietary configuration utility, which I can configure so that the server name is XPLILLEYG\SQLEXPRESS\. The configuration utility doesn't care; I connect successfully one way or the other.

When I open Management Studio Express, I can see my database (CMS) listed under the "Databases" folder, but there's no tables in there, other than the system tables.

So my question is, what am I missing

Thanks
Geoff Lilley



Re: SQL Server Express 2005 and a Remote Data Source

Jens K. Suessmeyer


Did you connect with a user which has permissions on the objects which you want to see


Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---