No tables visible in SQL Server connection

[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

 

[vbnetdev]

are you logging in as an id that is not sa? Are you able to create a new
database?

 

[Cor Ligthert [MVP]]

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

 

[SIMON GARE]

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

 

[vbnetdev]

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.

 

[SIMON GARE]

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

 

[vbnetdev]

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.

 

[SIMON GARE]

Thank you problem solved.

Regards
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.