No tables visible in SQL Server connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SIMON GARE - 19 Feb 2006 23:15 GMT

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

Reply to this Message

vbnetdev - 19 Feb 2006 23:22 GMT

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

Signature

Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

> Hi,
>
[quoted text clipped - 16 lines]
> Regards
> Simon

Reply to this Message

SIMON GARE - 20 Feb 2006 11:16 GMT

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

> are you logging in as an id that is not sa? Are you able to create a new
> database?
[quoted text clipped - 19 lines]
> > Regards
> > Simon

Reply to this Message

vbnetdev - 20 Feb 2006 12:04 GMT

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.

Signature

Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

>I am logging in as Administartor because I couldnt find the password for
>sa,
[quoted text clipped - 30 lines]
>> > Regards
>> > Simon

Reply to this Message

SIMON GARE - 20 Feb 2006 12:10 GMT

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

> I am betting your sa password is blank (shudder). Try leaving the password
> blank.
[quoted text clipped - 37 lines]
> >> > Regards
> >> > Simon

Reply to this Message

vbnetdev - 20 Feb 2006 13:42 GMT

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.

Signature

Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

> Thanks for this help before i forget,
>
[quoted text clipped - 63 lines]
>> >> > Regards
>> >> > Simon

Reply to this Message

SIMON GARE - 20 Feb 2006 15:08 GMT

Thank you problem solved.

Regards
Simon

> Do this and let me know if it works.
>
[quoted text clipped - 75 lines]
> >> >> > Regards
> >> >> > Simon

Reply to this Message

Cor Ligthert [MVP] - 20 Feb 2006 07:56 GMT

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

Reply to this Message