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!
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:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider
.......
Finished.
Shifty001
Member
78 Points
182 Posts
Failing to connect using aspnet_regsql
Nov 25, 2012 03:14 PM|LINK
Hi people,
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!
Shifty001
Member
78 Points
182 Posts
Re: Failing to connect using aspnet_regsql
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......
Shifty001
Member
78 Points
182 Posts
Re: Failing to connect using aspnet_regsql
Nov 25, 2012 05:12 PM|LINK
Think ive found the answer:
https://support.isqsolutions.com/article.aspx?id=10352&cNode=3L7Q2A
You may receive this error:
Failed to query a list of database names from the SQL server. Invalid object name sysdatabases.
If that happen you must type the dbname in the input of the database. This is a known problem related to aspnet_regsql.