2

Closed

Can not configure to use non-SQL Express DB

description

I changed all the connection strings I could find but the applicaiton is still looking for SQL Express. I am running the full version of SQL 2008.
 
Here is my connection string: Data Source=(local);Initial Catalog=ClassifiedsDB;Integrated Security=True
 
In addition, the AspNetSqlMembershipProvider is looking for a connection string named: connectionStringName="LocalSqlServer". It does not exists anywhere, is it being used?
 
Looks like a good app. Would love to help develop it further.
 
Thank you,
Frank Galarraga
Closed May 3, 2010 at 12:32 PM by SpiderMaster
No Response from frank.. Can not help any further.. Thanks :-)

comments

SpiderMaster wrote Jan 8, 2010 at 4:54 AM

Hello Frank, Yes the starter kit is a great kit and we have a version that has had a lot more gone into it!
Over time we will be upgrading this kit with a lot of controls and more options such as our auction system that we will be intergrated into the kit.
Sorry your experience with the kit to date is not so satisfying how ever I wish this to be resolved as soon as possible.

Usefull Information to help resolve this issue as follows:
-The LocalSqlServer is called by default in aspnet when it can not find a valid connection to the membership provider.
-The kit is using the default SqlMembershipProvider.
-The membership provider is a seperate database from the TradingCenterDB and by default SqlServerExpress will create and connect the AspNetDB.mdf automatically when the application starts however the full version does not.
-If you need to create a new membership database this is easily done using aspnet_regsql.exe, Details found here on using this http://msdn.microsoft.com/en-us/library/ms229862(VS.80).aspx
-The first call that requires this connection happens as the application starts, it is testing to ensure the correct administrative Roles exist in the database.
-The Membership connectionStringName for the current Beta version is "SpiderMaster.Communities.InternalSqlMemberShipDB", The LocalSqlServer name is removed in the provider configuration found here with the membership connection file found at ~/App_Data/System/ConnectionStrings.config in the main Application.
-The Trading Center connection string is defined in the app.config file found in the assembly SMOS.AspNet.TradingCenter, When you update this connection string it is a must you navigate to ~/Properties/Settings.settings and simply open the settings accept changes save and close.

Once the above is verified and/or corrected select clean solution from the solution explorer menu and click rebuild all.
I know its a big blob :) but if you work through it and do what needs to be done all should be well in a short space of time.
Let me know if you have any more problems and If everything works out please let me know so I can mark this as resolved and update the documentation.

Regards Regan.

wrote Jan 8, 2010 at 4:59 AM

wrote Jan 8, 2010 at 5:00 AM

SpiderMaster wrote Jan 8, 2010 at 5:10 AM

Hello again Frank, I have just been informed that there is a duplicate Settings file that should not be in the SMOS.AspNet Assembly. Please remove this and rebuild that solution first if you can and try run the app but you will probably also need to create the database as above.

Regards Regan :)

wrote May 3, 2010 at 12:32 PM

wrote Feb 14, 2013 at 12:15 AM

wrote May 16, 2013 at 5:16 AM