Jump to content
Software FX Community

simple connection problem


jsk144
 Share

Recommended Posts

For some reason I cannot connect to SQL Server. The database names do not populate even tho i can see the sql server in the server name dropdown list. I am using windows authentication login and typing in a known database on the server and get "invalid object name 'sys.sysdatabases'".

I can connect using ODBC and  OLEDb connection strings. And oddly enough the databases appear in the "use data source name" drop downlist, in the connection tab of the data link properties, but not in the main SQL Server - "connect gadget to data".

Any one have any ideas?

 - JK

 

 

 

Link to comment
Share on other sites

For some reason I cannot connect to SQL Server. The database names do not populate even tho i can see the sql server in the server name dropdown list. I am using windows authentication login and typing in a known database on the server and get "invalid object name 'sys.sysdatabases'".

I have SQL Server Express 2005.  Seems this is the path to that object: "Databases\System Databases\master\Views\System Views\sys.databases".  You may want to confirm that exists, and what the permissions are on it.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...