No tables visible in SQL server connection

  • Thread starter Thread starter SIMON GARE
  • Start date Start date
S

SIMON GARE

Hi,

i am setting up an ASP.NET site and have connected to the SQL Server
successfully.

When I click on the connection it shows tables 'none' ?? I know there are
tables just cant see them.

When I set up an ASP site and connect to the SQL with DNS all tables are
visible.

I have spent a whole weekend on this tried everything.

Tools Dreamweaver MX
Server Windows Small Business Server 2003
DB SQL Server 2005
Language ASP.NET VB
ASP ASP.NET V2.0

Regards
Simon
 
What is this DNS?
Can you connect using Query Analyzer?
Write a simple SQL statement and see if you can connect
be more specific..
Patrick
 
Thanks Patrick,

see SQL config below in ASP.NET

"Persist Security Info=False;
Data Source=SBS2003;
Initial Catalog=TobiasNET;
User ID=tobias;
Password=tobias"

After testing connection it reads connection made successfully, when i go to
view the tables it reads 'none'. Even tried administrator account same thing
happens.

I think it has something to do with the User ID, somebody suggested using
'sa' account but i dont know the password.

Any help you could suggest would be greatful.

Simon
 
Have you checked the ownership of the tables? Your user should either
be the owner of the tables or be granted access rights to the tables.

We once had an old database that we hooked up against where we
encountered some of the same issues. Not against tables, but against
stored procedure. Even the administrator account could not locate some
of the procedures. The reason was that the procedures where created
with a user that no longer existed --> not even the administrator could
see them. The answer was to access the database through Enterprise
Manager and reset ownership.

Hope this helps.

Rune
 
Thanks Patrick,

see SQL config below in ASP.NET

"Persist Security Info=False;
Data Source=SBS2003;
Initial Catalog=TobiasNET;
User ID=tobias;
Password=tobias"

After testing connection it reads connection made successfully, when i go
to
view the tables it reads 'none'. Even tried administrator account same
thing
happens.

I think it has something to do with the User ID, somebody suggested using
'sa' account but i dont know the password.

Any help you could suggest would be greatful.
Click to expand...

Well, at the risk of sounding extremely patronising, are you absolutely
certain you're looking at the correct database?

Run the following SQL query:

SELECT * FROM sysobjects WHERE xtype = 'U'

Does that return what you're expecting?

If not, run the following SQL query:

SELECT * FROM <database>.dbo.sysobjects WHERE xtype = 'U'

substituting <database> for the name of the database which contains the
tables in question.

Does that return what you're expecting?

If not, try creating a new table with the same name as one of the tables
which you know already exists - what happens?
 
Any reason for this or does this table appear automatically for each
Database? See below.
Click to expand...

That's the sysobjects table - it is indeed one of the system tables which
are part of every SQL Server database.
 
Back
Top