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 day on this tried everything.

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

Regards
Simon
 
Simon,

In the DotNet newsgroups, we use mostly the tool Visual Studio Net.

There is one newsgroup (group of) that is an exception for that where is
everything used including the notebook and that is the newsgroup.

microsoft.public.dotnet.framework.aspnet.

Although that you have a lot of crosspost (no problem), do I not see that
one.

In my opinion do you have with a tool as Dreamweaver the most change in that
newsgroup.

I hope this helps,

Cor
 
I am logging in as Administartor because I couldnt find the password for sa,
is that the problem?

If so, what do I log in as ?

Regards
Simon
 
I am betting your sa password is blank (shudder). Try leaving the password
blank.

Your login needs to be granted permissions to access databases.
Administrators on the machine do not automatically have rights unless
assigned specifically.
 
Thanks for this help before i forget,

I tried that but comes back Login Failed for user sa, see blow config

Tried this first

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

Then

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

Any suggestions?

Simon
 
Do this and let me know if it works.

To reset the sa password, you can make the following:

1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose 'Edit SQL Server Registration
properties'.
4. Choose 'Use Windows authentication' and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab.
 
Thank you problem solved.

Regards
Simon


vbnetdev said:
Do this and let me know if it works.

To reset the sa password, you can make the following:

1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose 'Edit SQL Server Registration
properties'.
4. Choose 'Use Windows authentication' and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab.
Click to expand...
 
Back
Top