Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 25, 2012 05:12 PM by Shifty001
Nov 25, 2012 03:14 PM|LINK
I am building an ecommerce site and I am trying to connect and setup my db using aspnet_regsql.exe, but am having a few problems.
SQL Server Auth. is setup and working in SQL Management Studio, but when I try to locate my db using the regsql wizard I enter my details and select the Database dropdown, and receive the following error:
Failed to query a list of database names from the SQL server. invalid object name 'sysdatabases'.
If I try using Windows authentication it works fine, all my db's are available in the dropdown for selection.
Also, I have tried to do this in the cmd, which is the prefered way I think, using the following:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql –U balloonshop –P ecommerce -S MY_MACHINENAME\MY_SqlExpressName -A all -d BalloonShop
But again receive an error stating that: The argument –U is invalid.
I have made sure that my server's port is open and setup in my firewall settings (Inbound Rules)
I have made sure that the server allows remote connections in SQL Manageemnt studio, Server properties.
I have Enabled TCP/IP in sql server config manager.
I have seen in the sql config manager, myServer / properties / Log On tab - I can enter logon info but am not sure I understand what this is all about. It looks like Logon as system user, which is not what I want and it does that anyway if I use Windows
Auth instead of sql server Auth. FYI: my setting in here are: Log on as - "Local System".... other option are Local Service or Network Service.
I really dont know what else to try, without messing everything up!
Any help from my superior developers will be very much appreciated, thank you!
Nov 25, 2012 04:42 PM|LINK
I dont know if this will help, but I am following an Apress book to build this BallonShop ecommerce website (Beginning ASP.Net ECommerce - from Novice to Professional).
I am currently on Chapter 11 - Catalog Admin: departments and categories, exercise 1......
1. The first step is to prepare the BalloonShop database for storing the ASP.NET membership data structures.
The tool we use for this task is aspnet regsql.exe; it can be executed at the Windows command
prompt, where you can include various parameters to configure it instantly for your database. Alternatively,
it can be run in Wizard mode, allowing you to set those options one at a time.
Execute the tool from C:\Windows\Microsoft.NET\Framework\v2.0.nnnnn\ with the following
parameters. Note that the parameters are case sensitive and that we assume that your BalloonShop
database has the balloonshop user with the ecommerce password. Make sure to replace MACHINENAME with
the name of your local machine. (To find more about each parameter, simply execute aspnet regsql /?.)
aspnet regsql –U balloonshop –P ecommerce -S MACHINENAME\SqlExpress -A all -d BalloonShop
The output should resemble this:
C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet regsql –U balloonshop -P ecommerce -S
MACHINENAME\SqlExpress -A all -d BalloonShop
Start adding the following features:
Nov 25, 2012 05:12 PM|LINK
Think ive found the answer:
You may receive this error:
Failed to query a list of database names from the SQL server. Invalid object name
If that happen you must type the dbname in the input of the database. This is a known problem related to