How to install ASP.NET 2.0 Club / Personal Starter kit? [Archive]

bruce

12-10-2005, 02:07 AM

Hello all!!

We have received many questions as to how to install the ASP.NET 2.0 starter kits (Club / Personal) on our server. Below is a unofficial process that i used to install the kit.

Requirements:

VS.NET 2005 or VWD 2005
SQL Client (Query Analyzer, osql, sqlcmd, Management studio, etc..) for you to execute the SQL script that create the starter kit.

Procedure:

I am going to use the club starter kit here as example but the the personal starter kit should work the same way.

1) Download and install the starter kit if you do not already have it installed on your computer. Grap it at http://www.asp.net

2) Create a new website / project using VS.NET 2K5 or VWD 2005. Use the Club starter kit template.

3) Create the Application Services Database on the our SQL

a) navigate to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
b) execute this aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

You can also use the wizard by just running aspnet_regsql.exe, but i found couple bugs in the UI. So, just run the command line!!!

If do not see any error, you are good to go to next step. If you see errors, then you probably typed something wrong or you have some objects in your DB that conflicts w/ the Application Service DB Schema

4) Create the starter kit database schema (MS suggest you put it on a different Database, but i put both the Application Services Database on the same server and had no problem.. up to you!)

I am mystified w/ this step.. According to Microsoft, you will need to download a seperate script for SQL 2000 and MSDE. I compared the downloaded sql script w/ the one bundled w/ the starter kit (in App_data directory), they are exactly the same !!!!!

Anyhow, run either the bundled script or the downloaded script using any SQL client. I used osql.

osql -S <sql server name> -U <db_user> -P <DB_password> -d <DB_Name> -i club-add.sql

This should create the club starter kit schema.

5) Open the Web.config file in VS.NET / VWD.

Change the connection string to point to the remote SQL server.

Comment out the orginal connection string (or just delete it if you want). By default, the starter kit uses SQL Express.



Add the following lines

a) This configure the club starter kit use the remote SQL server
<add name='ClubSiteDB' connectionString='Data Source=<DB_Server>.discountasp.net;Integrated Security=false;Initial Catalog=<DB_Name>;User ID=<DB_User>;Password=<DB_password>' providerName='System.Data.SqlClient'/>

b) The next line overide the default setting on the server
<remove name='LocalSqlServer'/>

c) This line is for the membership provider. It tell asp.net to use the remote SQL server.

<add name='LocalSqlServer' connectionString='Data Source=<DB_Server>;Integrated Security=false;Initial Catalog=<DB_Name>;User ID=<DB_User>;Password=<DB_password>' providerName='System.Data.SqlClient' />

6) Now build the kit by hitting Ctrl-F5. This step will also create the Role in the SQL server.

7) Create the administrative user.

Bring up the ASP.NET Configuration Tool. IN VS.NET, website -> Asp.net configuration Tool

This will pop up a browser with the UI. Note that this configuration is pulled from the remote SQL server for the membership stuff.

Goto the security tab. Create an admin user for the starter kit. Make sure you give it administrative role.

8) Deploy your site to a subdirectory (or root if you prefer) using Copy Web Site function in VS.NET. If you don't know how, there is a kb article.. look it up yourself.

BTW, if you deploy to a sub directory, create the directory using FTP first. If the directory do not exist, VS.NET will crash. This is a bug!

9) Last step

Logon to the hosting control panel.

1) Navigate to IIS Manager -> Framework Version
2) Make sure you have version 2.0 selected.

3) Then navigate to the web application tool and mark the club SK as an application.

That is it!!! Enjoy!

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

Post Edited (bruce [DASP]) : 1/30/2006 8:42:47 PM GMT

fagnes

12-16-2005, 05:06 AM

http://community.discountasp.net/emoticons/smilewinkgrin.gifBonjour,

If you would have been in front of me, I would have kiss you !!!!
I've been trying to install these starter kits many times, without success ...

Your solution works perfect !

Thank you.

I only had 1 problem, with the command line :

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql -S sql2k501.discount
asp.net -U****** -P ***** -A -all -d SQL2005_203366
_faconsulting

It reply :
The specified feature is undefined.

I started the wizard, and then it worked ...

Strange, isn't it ?

Cordialement
F.AGNES

PS : I apologize for my poor English Language ... http://community.discountasp.net/emoticons/rolleyes.gif
I'm just a french guy that try to say things ....

tgbse

12-22-2005, 02:21 AM

I followed all the directions and got this running on localhost with no problems. When I deploy it to the hosted enviroment I keep getting the following......Any ideas? I'm new to ASP.NET 2 so maybe it's something obvious.

Server Error in '/pws' Application.

Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load type 'System.Web.Security.AccessRoleProvider'.

Source Error:

Line 48: <roleManager enabled="true">
Line 49: <providers>
Line 50: <add name="AspNetAccessProvider2" type="System.Web.Security.AccessRoleProvider" connectionStringName="AccessFileName" applicationName="/"></add>
Line 51: </providers>
Line 52: </roleManager>
Source File: E:\web\garysilcoxc\htdocs\pws\web.config Line: 50

QLN

12-22-2005, 09:23 AM

Hello,

I would be willing to pay someone to set up the Club Starter Kit on our DASP site.

We sometimes have other small projects to outsource. If anyone is interested please contact me.

Thank You!

Vincent

Aristotle

12-23-2005, 01:57 AM

The AccessRoleProvider was dropped from the .NET 2.0 framework. I believe at one point it was available (alpha?), but not in the newest release.

However, there is downloadable source code for a sample Access provider on the MSDN site.

Download the Sample Access Providers Starter Kit to get started.
http://msdn.microsoft.com/asp.net/downloads/providers/

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

luk1128

12-23-2005, 06:28 AM

Thank you for all of this helpful information! I've been working all day to get my starter kit up a nd running on the web servers! Now that I've got it all up, I have a new dilema. I'm working with the Personal Site Starter Kit. I used the site on my local machine and created albums and photos into the default SGL Express databases that were already created. Since I had to recreate the databases on the web server I no longer have the data I had inthe .mdf files. Is there any way I can import the album and photo datainto the new databases on the web server? I'd hate to have to start from scratch on buildingthosealbums again. Any help isMUCH appreciated!!

Thank you,

luk1128

bill burrows

12-23-2005, 12:43 PM

Gary,

The error you are getting relates to the Access Data Provider, but the starter kit uses the SQLProvider. Are you using MS Access on your development machine?

grandpadave

12-24-2005, 10:58 AM

I am getting the following error when I am doing setup number 5 (ctrl-f5) .... any suggestions...

Server Error in '/ClubWebSite2' Application.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +173
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1069
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +502
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +429
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +70
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +512
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +160
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +118
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments arguments) +1661
System.Web.UI.WebControls.Repeater.GetData() +50
System.Web.UI.WebControls.Repeater.CreateControlHi erarchy(Boolean useDataSource) +214
System.Web.UI.WebControls.Repeater.OnDataBinding(E ventArgs e) +54
System.Web.UI.WebControls.Repeater.DataBind() +62
System.Web.UI.WebControls.Repeater.EnsureDataBound () +55
System.Web.UI.WebControls.Repeater.OnPreRender(Eve ntArgs e) +13
System.Web.UI.Control.PreRenderRecursiveInternal() +88
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

Version Information:Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Aristotle

12-29-2005, 11:36 AM

grandpadave said...

I am getting the following error when I am doing setup number 5 (ctrl-f5) .... any suggestions...

Server Error in '/ClubWebSite2' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Your computer's default connection protocol is set to named pipes. Use TCP/IP instead. See this KB article:
http://kb.discountasp.net/article.aspx?id=10381

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

Post Edited (Aristotle [DASP]) : 12/29/2005 11:42:04 PM GMT

Aristotle

12-29-2005, 11:40 AM

luk1128 said...

Is there any way I can import the album and photo data into the new databases on the web server?

Yes, see this post: http://community.discountasp.net/default.aspx?f=16&m=8808

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

GBiggs

01-16-2006, 01:44 AM

I made it to Line (Item) 6 with no problem. However when I use Ctrl F5 to build the kit the page that opens is
http://localhost:4929/%20VSPersonal/ and of course it throws an error Parser Error Message:
'Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.'
that points to machine.config Line: 131

Gary

bruce

01-16-2006, 07:44 AM

You probably didn't do this step correctly

5) Open the Web.config file in VS.NET / VWD.

Change the connection string to point to the remote SQL server.

Comment out the orginal connection string (or just delete it if you want). By default, the starter kit uses SQL Express.



Add the following lines

a) This configure the club starter kit use the remote SQL server
<add name='ClubSiteDB' connectionString='Data Source=<DB_Server>;Integrated Security=false;Initial Catalog=<DB_Name>;User ID=<DB_User>;Password=<DB_password>' providerName='System.Data.SqlClient'/>

b) The next line overide the default setting on the server
<remove name='LocalSqlServer'/>

c) This line is for the membership provider. It tell asp.net to use the remote SQL server.

<add name='LocalSqlServer' connectionString='Data Source=<DB_Server>;Integrated Security=false;Initial Catalog=<DB_Name>;User ID=<DB_User>;Password=<DB_password>' providerName='System.Data.SqlClient' />

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

MichaelB

01-27-2006, 02:57 AM

Ok... I followed all of bruces directions to the letter however I cant get past the create application services database part.. I get the message:

An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlException message is: CREATE DATABASE permission denied in database 'master'.
Creating the SQL2005_215151_XXXX database...

I specifically changed my hoster to discountasp.net because i see that someone got there site up and running with you guys... any suggestions?

http://community.discountasp.net/emoticons/smhair.gif??????????????

bruce

01-27-2006, 08:13 AM

Mike,

'execute this aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]'

You probaably didn't type in this line correctly. specifically, the -d flag.

When you do not specify the database w/ the -d flag, aspnet_regsql will try to create the DB.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

MichaelB

01-27-2006, 11:03 AM

Bruce,

Your awesome!!! It worked great (once I learned how to spell!!http://community.discountasp.net/emoticons/lol.gif).DiscountASP.net is the 4th (YES THE FOURTH) hoster I have come to to get my site listed, and the ONLY one to sucessfully have it work!! All thanks to this forum and the excellent support from your technical support department. I have some users of the site that say the text is too small to read. Any ideas???

Thanks Again

Mike

bruce

01-28-2006, 03:57 AM

that's more like a starter kit issue. you probably want to post it to the asp.net forum.

good luck.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

MichaelB

01-29-2006, 04:38 AM

OK Next dumb question!! I have been told that unsing the ip instead of the domain name for the database in the web.config file will speed the web page loading time. What do you think??

Mike

bruce

01-30-2006, 07:34 AM

that's BS

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

negin_y

02-12-2006, 07:19 AM

I installed Time Tracker SK, but I faced error,
<H2>Compilation Error </H2>
<TD><CODE>
Line 16: <td vAlign='bottom'>
<asp:datalist id='tabs' SelectedItemStyle-CssClass='tab-active' ItemStyle-CssClass='tab-inactive' CellSpacing='0' CellPadding='0' runat='server' EnableViewState='false' RepeatDirection='horizontal'>
Line 17: <itemtemplate>
[color=red>Line></font>Line 19:
<%# CType(Container.DataItem, ASPNET.StarterKit.TimeTracker.BusinessLogicLayer.T abItem).Name %>
Line 20: </PRE>[/code]</TABLE>

Do anyone know what should I do?

Post Edited By Moderator (bruce [DASP]) : 6/9/2006 12:11:21 AM GMT

valtersnet0

02-12-2006, 08:44 AM

it cant find the function Global.GetApplicationPath()

did you upload Global.aspx?

joelnet

02-13-2006, 08:46 AM

In the IIS Manager section, you'll find the Framework chooser.

Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET

negin_y

02-13-2006, 12:04 PM

Actually Discount Asp.net support section installed it for me, I checked my ftp, Global.aspx is uploaded.
I was thinking maybe the problem occurs because of the .Net framework.
They installed ASP.NET1.1 Time Tracker Starter Kit which will not work with the .NET 2.0 framework on my site and theycurrently do not support installation of the ASP.NET2.0 Time Tracker Starter Kit.
I was wondering if I can change the framework from my control panel.Do you know how should I do that?

negin_y

02-14-2006, 11:42 AM

Well thank you so much, I changed my .NET Frame work to 1.1 and it works, I was looking in Control Panel but i dont why I didnt see .Net Framework Tab!!!!!
But now I have another problem,In the Registration page (Register.aspx) when I want to register a new user , after clicking on Register and Sign In Now (:{if (typeof(Page_ClientValidate) != 'function' || Page_ClientValidate()) __doPostBack('RegisterBtn','')}),

Server Error in '/TTWeb' Application.

Login failed for user 'DB_216235_dbcc_user'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DB_216235_dbcc_user'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Login failed for user 'DB_216235_dbcc_user'.]
System.Data.SqlClient.ConnectionPool.CreateConnect ion() +402
System.Data.SqlClient.ConnectionPool.UserCreateReq uest() +151
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) +386
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.TimeTracker.DataAccessLayer.SqlH elperParameterCache.DiscoverSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
ASPNET.StarterKit.TimeTracker.DataAccessLayer.SqlH elperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
ASPNET.StarterKit.TimeTracker.DataAccessLayer.SqlH elperParameterCache.GetSpParameterSet(String connectionString, String spName)
ASPNET.StarterKit.TimeTracker.DataAccessLayer.SqlH elper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
ASPNET.StarterKit.TimeTracker.BusinessLogicLayer.T TUser.Insert(Boolean checkUsername, Boolean& isUserFound)
ASPNET.StarterKit.TimeTracker.BusinessLogicLayer.T TUser.Save(Boolean checkUsername, Boolean& isUserFound, Boolean& isUserActiveManager)
ASPNET.StarterKit.TimeTracker.BusinessLogicLayer.T TUser.Save()
Register.RegisterBtn_Click(Object sender, EventArgs e)
System.Web.UI.WebControls.LinkButton.OnClick(Event Args e) +108
System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1292

Version Information:Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

This is my User name for SQL SERVER Database .

Is there any problem with the connection string provided in Time Tracker SK?? Or access permissions??...how should I fix it??
Thanxxxxxxxxxx

bruce

02-16-2006, 12:44 PM

well it looks like you used the wrong database username. Check your connection string.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

georgegrubb

03-10-2006, 04:03 AM

Super thanks for posting these instructions. I tested the Personal Starter Web site, and followed your directions. After discovering a few errors on my part, I successfully managed to get it to work.

George

bruce

03-10-2006, 09:33 AM

very cool!!

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

davidve5

03-26-2006, 05:06 AM

A little preface about me: I'm a complete beginner with SQL Server. I'm trying to put the Personal Website Starter Kit on discountasp. I have looked at tons of blogs,
messageboards, etc, including numerous ones within discountasp's site. A lot of the postings I find "assume" you know how to do things with SQL Server. I'm trying
to learn, but it hasn't been easy so far.

I amusing VS2005, SQL Server 2005 with the SQL Server Management Studio.

So here's the problem:
I think everthing is fine up until I try to run the aspnet_regsql step. I typed in the command line as instructed in this forum (see below):
<SUB>aspnet_regsql.exe -S sql2k501.discountasp.net -U {SQL2005_USERNAME} -P{MAIN SQL LOGINFromDiscASP.NET}-A all -d SQL2005_233643_ds
<SUB>
I must be missing a step (or steps) along the way because I keep getting permissions-like errors. I hope one of you guys will point out my mistake. Please remember, I am
new to the concepts of sqlserver (sqlserver 2005), so any help should take that into consideration.
Here is the message I get when doing the command above in a command-window while in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727> Directory:

Start adding the following features:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider
..
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlExcepti
on message is: CREATE PROCEDURE permission denied in database 'SQL2005_233643_ds'.
SQL Server: sql2k501.discountasp.net
Database: [SQL2005_233643_ds]
SQL file loaded:
InstallCommon.sql
Commands failed:
CREATE PROCEDURE [dbo].aspnet_Setup_RestorePermissions
@name sysname
AS
BEGIN
DECLARE @object sysname
DECLARE @protectType char(10)
DECLARE @action varchar(20)
DECLARE @grantee sysname
DECLARE @cmd nvarchar(500)
DECLARE c1 cursor FORWARD_ONLY FOR
SELECT Object, ProtectType, [Action], Grantee FROM #aspnet_Permissions where Object = @name
OPEN c1
FETCH c1 INTO @object, @protectType, @action, @grantee
WHILE (@@fetch_status = 0)
BEGIN
SET @cmd = @protectType + ' ' + @action + ' on ' + @object + ' TO [' + @grantee + ']'
EXEC (@cmd)
FETCH c1 INTO @object, @protectType, @action, @grantee
END
CLOSE c1
DEALLOCATE c1
END
SQL Exception:
System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'SQL2005_233643_ds'.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCo
pySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe
)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(Stri ng file, String server, String database, String dbFileName, SqlCon
nection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

CraftingCode

04-02-2006, 02:26 AM

Do I have to suscribe for the "MS SQL 2005" addon feature ($10/mo)to deploy the Club Starter Kit?

Thanks.

bruce

04-04-2006, 05:45 AM

either SQL 2k or 2k5 will work fine.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

fjlauer

04-09-2006, 06:11 AM

While I'm a patient man, I'm about to go back to a third generation language, at least I didn't have to consult the Dali Lama with these holistic error messages. <yeah, I'm old school, go ahead and laugh>

I've followed all these directions, site is running, but I have no control over the membership provider and am unable to administrate it when I connect to the site. I changed my connection strings, and gave it a local for the membership provider to be picked up.

No sterno in this cocktail, I swear. HELP?!?
http://community.discountasp.net/emoticons/turn.gif

bruce

04-10-2006, 09:42 AM

did you see this kb article?

http://kb.discountasp.net/article.aspx?id=10413

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

Buddha_V

04-11-2006, 12:57 AM

I am having similiar problems like Dave V. Just wondering if somebody that has came acrosss a problem like that with the same error, has figured it out yet?http://community.discountasp.net/emoticons/confused.gif
I've searched and have not found an answer. I apologize if this has been discussed elsewhere on the forum. Im also new to this. Probably going to get made fun of for asking stupid questions.
But here we go....
Is it because i dont have the rights to create new database. If so do I need to go into SQL server manager studio and configure so the rights are granted for me to create new database?
What can I say Asp.net 2.0is pimp.that iswhy I'm trying to learn it.http://community.discountasp.net/emoticons/tongue.gifThanks

jhonytangerine

04-25-2006, 09:11 AM

I am on the same boat as Budha V. Since Club Starter Kit comes free and also comple
running Application it is so easy to extend but how do you deploy it here since it comes
is SQL Server Express 2005 and not SQL SERVER 2005.http://community.discountasp.net/emoticons/burger.gif

bruce

05-24-2006, 05:51 AM

try put 'tcp:' (no quote) in front of the SQL server name

eg. tcp:mssql01.discountasp.net

If it still doesn't work, your ISP may be blocking port 1433. Try use port 14330 instead.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

alfilart

05-24-2006, 09:11 AM

Hi,

I'm doing step 3 on how to install ASP.Net 2.0 Club starter kit. I got the error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Here's some facts and I'm not sure if this is related to the problem:
In my local pc, I have sql server 2000. I checked SQL server client network utility and the TCP/IP is on top of the list in enable protocols.
I'm connected thru the internet via my company's firewall.

Any ideas how to solve this? thanks in advance

regards,
Al

alfilart

05-25-2006, 03:32 AM

Hi,

Thanks for the reply. Unfortunately that solution didn't work. After googling for a while, I realized I didnt have IIS installed. So after putting that on, seemed to work this time.
Now, I will proceed with to step 4, fingers crossed.

al

dmann

06-08-2006, 12:03 AM

Hey Bruce what about this one:

On step 4 I'm getting "cannot open input file - club-add.sql No such file or directory" I used your instructions successfully when setting up a prvious site, but I didn't use the club starter kit or the schema, just the membership databases. I've gotten ther the Application services Database creation fine, but it bombs ont on step 4...

adamstoc

06-09-2006, 12:47 AM

Hi Bruce,

Looks like I'm another in the long line of people struggling to get their Starter Kits up and running!

I have followed your directions as best I can, but I get the following error when trying to access the website. I have checked and made sure that I have TCP/IP pipes enabled in the SQL Configuration manager, as suggested in an earlier reply but it was already set correctly. Any help is appreciated!

Regards,

Adam

Server Error in '/adamstocV7' Application.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 141: Dim Filter As Boolean = Not (HttpContext.Current.User.IsInRole("Friends") Or HttpContext.Current.User.IsInRole("Administrators"))
Line 142: command.Parameters.Add(New SqlParameter("@IsPublic", Filter))
Line 143: connection.Open()
Line 144: Dim list As New Generic.List(Of Album)()
Line 145: Using reader As SqlDataReader = command.ExecuteReader()
Source File: C:\Documents and Settings\Adam Stockwell\My Documents\Visual Studio 2005\WebSites\adamstocV7\App_Code\PhotoManager.vb Line: 143

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +171
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1069
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +502
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +429
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +70
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +512
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +160
PhotoManager.GetAlbums() in C:\Documents and Settings\Adam Stockwell\My Documents\Visual Studio 2005\WebSites\adamstocV7\App_Code\PhotoManager.vb: 143

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Objec t target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Web.UI.WebControls.ObjectDataSourceView.Inv okeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +486
System.Web.UI.WebControls.ObjectDataSourceView.Exe cuteSelect(DataSourceSelectArguments arguments) +1869
System.Web.UI.WebControls.BaseDataList.GetData() +53
System.Web.UI.WebControls.DataList.CreateControlHi erarchy(Boolean useDataSource) +267
System.Web.UI.WebControls.BaseDataList.OnDataBindi ng(EventArgs e) +56
System.Web.UI.WebControls.BaseDataList.DataBind() +62
System.Web.UI.WebControls.BaseDataList.EnsureDataB ound() +55
System.Web.UI.WebControls.BaseDataList.CreateChild Controls() +62
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

bruce

06-09-2006, 05:42 AM

Looks like it's trying to connect using Named Pipe (which only work on local LAN)

Try put 'tcp:' in front of the SQL server name in the connection string.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

bruce

06-09-2006, 11:14 AM

You can try use our new SQL management tool's attach database feature.

Basically, you'll need to upload your club.mdf file into your site and run the attach DB.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

dmann

07-11-2006, 01:20 AM

Hi Bruce! ( or to whom it may concern!)

Well I'm back at it again, I'm putting together a new site and I just can't seem to clear the hurdles. I've tried everything in this thread, I've got my files

migrated and used the beta too to attach the club.mdf file, all went well, ran the command line to set up the membership data, but when I go to the security

tab of the application interface it still can't make the connection to the database. I tried adding the tcp; to the DB name but to no avail... Still getting:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I was able to successfully launch my other site that I built on the personal website starter kit, and have the membership and roles working fine, but this club site
is giving me some fits...
Thanks!
Dennis

bruce

07-11-2006, 05:16 AM

Same problem as the previous post.

Try put 'tcp:' in front of the SQL server name in the connection string.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

dmann

07-11-2006, 06:50 AM

Bruce;

Yeah, saw that and tried it, didn't work, it saw the "tcp:" and errored out, I can't remember the exact syntax, but something to the effect of "I don't know what "tcp:" is" ( unknown server?) I'm thinking it's still looking local, and not out to the remote server, even thought I updated my config file as per the instructions on updating the connection strings. I rechecked them, but when I open the ASP.NET configuration manager it still says starting on localhost at the bottom of the screen

bruce

07-11-2006, 09:49 AM

Well.. your application will always be running on your localhost but if you set the connection string to point to our server, any update should happen on the database on the hosted server.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

dmann

07-12-2006, 01:10 AM

That's what I thought, but at that point I wasn't wanting to make any assumptions, I was stuck... figured out though, rookie mistake, somehow or another my connection string had

"sql2k501.discountasp.net.discountasp.net" as the data source in both strings, and I just didn't see the error until I started to send you my code.... Good reason to always send a code example with the problem, saves everyone's time! Right? LOL

dmann

07-12-2006, 01:38 AM

OK, now what the heck is this all about?:

It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS

and the error page traps this from the web config:

Line 55: <system.web>
Line 56: 
Line 57: <authentication mode="Forms"/>
Line 58: <compilation debug="true" strict="true">
Line 59: <assemblies>

along with the same error references to lines 65 and 66 from the web config, which are:

<membership defaultProvider="AspNetSqlMembershipProvider"/>

<siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">

I didn't turn anything up on a search for that string, anything jump out at anyone?

bruce

07-12-2006, 05:35 AM

this error means that the directory where the kit is located is not setup as a web application. Goto the control panel's web app manager to mark the directory as an application.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

Chris cee

09-04-2006, 08:25 AM

Hi Guys

I'm unsure about number 3!

3) Create the Application Services Database on the our SQL

a) navigate to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
b) execute this aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

Do I need to buy/set something up on discountasp.net to get the Db Servername, login password and Database name?

bruce

09-08-2006, 01:27 AM

yes. you will need either the SQL or SQL 2005 addon.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

androoo

09-10-2006, 09:38 AM

Hi im installing Personal Website Starter Kit on sqlserver 2000
Have found this article http://www.edream.org/BlogArticle.aspx?RecordID=115very usefull in config of the remote sqlserver.

All i think would be working, but just need the admin user configured now.

I dont have admin permission on this sp so ithink this is the reason its failing.- see below
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

Is there a work around please ?

Thanks for your help!

Andy

androoo

09-11-2006, 06:29 AM

This error was because i missed a step. I had not told asp.net where to run the membership from. (my lack of knowledge in this area)

Step5 - Preconfigured SQL Server Providers

Run aspnet_regsql.exe from this location
C:\WINDOWS\Microsoft.NET\Framework\<versionNumber>\aspnet_regsql.exe

Enter your remote sql server address, user name, password and database name as prompt.

Again if your installing the personal starter it on a non SQL2005 datasource this link is really helpful:

http://www.edream.org/BlogArticle.aspx?RecordID=115

jpopesku

10-16-2006, 01:12 AM

Bruce, these directions worked perfectly for the ClubSK! Only problem I had with the setup was osql threw an error when I tried the command from the Framework/v2.xxxx directory (couldn't find add-club.sql) -- had to search for that file, change to that directory, and run the command. Then worked like a charm.

However, I'm having a (weird?) problem, that hopefully someone canhelp me out with. I was able to change my site's loginaccount to be in the Adminstrators role. But when I log into the site, I'm not seeing the Admin section menu. To confirm that I'm actually an "Administrators", I checked the dbase, and sure enough, my UserID is listed next to the RoleID for Administrators in the aspnet_UsersInRoles table.

Is this weird? Did I fubar something?
Thanks!

bruce

10-18-2006, 05:44 AM

I assumed you are using the ASP.NET Web Site Administration Tool.

Make sure it is pointing to our database server rather than you local database. See http://kb.discountasp.net/article.aspx?id=10413for more detail on how to administer the ASPNETDB database.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

paulc

11-19-2006, 11:54 AM

Hi, well after following numerous links i've suprised myself to get this far!
The advice has been thorough and explicit, which for a newbie like me is critical. But i'm now stuck at point 6 of Bruces' initial post (12/9/2005 6:07 PM (GMT -8) at the top of this thread.

Here's where i'm at...

I'm editing the web.config file as prompted:

I have replaced this line..


with this..
<add name="ClubSiteDB" connectionString="Data Source=<dbserver.com> ;Integrated Security=false;Initial Catalog="parkdb";User ID="*****";Password="*****" providerName="System.Data.SqlClient"/>

Hitting CTRL+F5 to build causes 17 errors in Visual Web Developer rererring to the above new line added.
Descriptions follow..

Error1Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52128D:\...\ThePar k\
Error2Missing quotes on attribute value 'Data Source=.\SQLB7.webcontrolcenter.com ;Integrated Security=false;Initial'.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52118D:\...\ThePar k\
Error3Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52119D:\...\ThePar k\
Error4Character ';', hexidecimal value 0x3b is illegal in an XML name.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52135D:\...\ThePar k\
Error5Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52136D:\...\ThePar k\
Error6Missing attribute value on attribute 'User'.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52136D:\...\ThePar k\
Error7Character ';', hexidecimal value 0x3b is illegal in an XML name.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52152D:\...\ThePar k\
Error8Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config52153D:\...\ThePar k\
Error9Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54131D:\...\ThePar k\
Error10Missing quotes on attribute value 'Data Source=.\SQLB7.webcontrolcenter.com;Integrated Security=false;Initial'.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54121D:\...\ThePar k\
Error11Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54122D:\...\ThePar k\
Error12Character ';', hexidecimal value 0x3b is illegal in an XML name.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54138D:\...\ThePar k\
Error13Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54139D:\...\ThePar k\
Error14Missing attribute value on attribute 'User'.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54139D:\...\ThePar k\
Error15Character ';', hexidecimal value 0x3b is illegal in an XML name.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54155D:\...\ThePar k\
Error16Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54156D:\...\ThePar k\
Error17Missing required whitespace.D:\Documents and Settings\Paul\My Documents\Visual Studio 2005\WebSites\ThePark\web.config54174D:\...\ThePar k\

Does anyone have any ideas on how I canresolve these?

Thanks, Paul

paulc

11-20-2006, 01:06 AM

Hi,

Yes, I have the appropriate sql server name.
I've since resolved my errors and i've setup an administrators account using ASP.NET Configuration successfully.

Only now when I CTRL+F5 to build and run I have a new problem..

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Do i need to start looking server side or client side to solve this?

Thanks, Paul.

vvsharma

11-20-2006, 12:53 PM

Wondering whether you have replaced (<dbserver.com> ) with an appropriate SQL Server Name(something like "Data Source=sql2k502.discountasp.net" )in your connection string.

Vikram

DiscountASP.NET
www.DiscountASP.NET (http://www.discountasp.net/)

bruce

11-28-2006, 10:28 AM

this is usually a problem with the connection string (where you configured the tool to use trusted connection rather than SQL authentication)

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

vandiermen

12-03-2006, 10:39 AM

I tried making a personal web starter kit, and followed your instructions, and received the following message, I thought Id put it here and see if anyone can help

Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 191:
Line 192: Public Shared Function GetRandomAlbumID() As Integer
Line 193: Using connection As New SqlConnection(ConfigurationManager.ConnectionStrin gs("Personal").ConnectionString)
Line 194: Using command As New SqlCommand("GetNonEmptyAlbums", connection)
Line 195: command.CommandType = CommandType.StoredProcedure
Source File: C:\Documents and Settings\admin\My Documents\Visual Studio 2005\WebSites\personaltest\App_Code\PhotoManager.v b Line: 193

vandiermen

12-07-2006, 07:03 AM

Thanks I fixed it. Thanks!

What I did:

In the web. config
I deleted this, oops: <add name="Personal" connectionString="Data Source=sql2k505.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_310941_2006;User ID=SQL2005_310941_2006_user;Password=xxxxxxxxxx" providerName="System.Data.SqlClient"/>

and just left this: <remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=sql2k505.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_310941_2006;User ID=SQL2005_310941_2006_user;Password=xxxxxxxxxx" providerName="System.Data.SqlClient"/>

and in the PhotoManager.vb and other files theconnection string referred to what was called name="Personal" connectionString=" in the webconfig file

I am so happy it worked http://www.budgetwebdesign.com.au/exampleAspx

bruce

12-07-2006, 12:32 PM

make sure you check the web.config file to see if set up the connection string properly.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

karfeef

01-22-2007, 07:56 AM

Hi. i have gotten further with this method than any other i tried on my previous host. however, i'm a little stuck.

when runing the command prompt string, i get an error 40 - even though tcp/ip is the only thing enabled - and running the gui aspnet_regsql.exe, i get this...

Setup failed.
Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 916 and the SqlException message is: The server principal "karfeef" is not able to access the database "SQL2005_327215_smiths" under the current security context.
----------------------------------------
Details of failure
----------------------------------------
SQL Server:
Database: [SQL2005_327215_smiths]
SQL file loaded:
InstallCommon.sql
Commands failed:
USE [SQL2005_327215_smiths]

SQL Exception:
System.Data.SqlClient.SqlException: The server principal "karfeef" is not able to access the database "SQL2005_327215_smiths" under the current security context.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(Stri ng file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

can anyone help with this?

many thanks

Karf

karfeef

01-22-2007, 11:12 AM

no matter - after much fettling and a sever headache. i got it sorted. was to do with using the 2nd user to log into the database rather than the primary.

jswin

01-27-2007, 04:03 AM

Hello, I am settin up the Personal Web Site Starter Kit.

What would typically cause the following error:

The type specified in the TypeName property of ObjectDataSource 'ObjectDataSource1' could not be found.

wisemx

01-27-2007, 04:08 AM

I've noticed many people in the asp.net forums having that same problem.

The most common cause seemed to be not copying the App_Code folder onto the server.

jswin

01-27-2007, 05:52 AM

How can I verify that the files are copied to the server?

wisemx

01-27-2007, 06:50 AM

Use the local to remote synchronization feature in your FTP client, if it's Visual Studio use the Copy Website option, connect to your site then use the options to verify, sync or copy.

If you use Dreamweaver just right click on the local folder and select the Sync option.

jswin

01-28-2007, 01:21 AM

Ok thanks for your help. For some reason the subfolders were not updating.

CodeOfGrayc

06-29-2007, 02:14 AM

Hi! I new to DiscountASP.net and have 9 months of ASP.Net 2.0 experience and newbie SQL knowledge.

I am using the ClubSK for a local robotics team It has all the bells and whistles we need. What I want to do, is have their web application as a subdomain. I saw the postings on enabling a subdirectory as a web tool and the script to handle subdomains, which I put in the Default.aspx in my root directory.

I can run my site, CodeOfGrayc (http://www.codeofgrayc.com/default.aspx).But I can not get to my subdomain(http://piperrobotics.codeofgrayc.com)! Instead what is in my root directory is displayed.

Is there anything special to run the Club Starter Kit as a subdomain that I may have missed in setting up my site?

Any help would be appreciated!
CodeOfGrayc

cbcwhitebea

06-29-2007, 04:49 AM

Hello, I'm brand newto to the VWD ASP.NET 2.0 and I have already created the website and have already made the modifcations to it that I want and have copied it all up and have tried to follow the "How to install ASP.NET 2.0 Club Site Starter kit but now I'm stuck at number 4 Create the starter kit database schema </o:p>
, I don't know how to do this step. </o:p>
I have tried the site in the browser and just shows the error page with out any error message in it.</o:p>
</o:p>
http://cbcwhitebea.web134.discountasp.net (http://cbcwhitebea.web134.discountasp.net/)</o:p>
</o:p>
What am I doing wrong or what did I not do, please help,</o:p>
</o:p>
Thank you!</o:p>

bruce

07-05-2007, 05:54 AM

Did you solve the problem? I tested your site and it is not throwing any error.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

bobmain

01-25-2008, 03:05 AM

Don't know if anyone is still reading this thread, but I have just uploaded the clubsite - but it is looking for the database ASPNETDB.MDF - does this mean I have to purchase two databses to run the package?

Post Edited (Bob Main) : 1/25/2008 1:01:48 PM GMT

wisemx

01-25-2008, 05:42 AM

You can't use Express DBs here but you can import the data to a SQL Server 2005 account if you have one.

coldfire

01-30-2008, 12:28 PM

Regarding Step # 7,

7) Create the administrative user.
Bring up the ASP.NET Configuration Tool. IN VS.NET, website -> Asp.net configuration Tool
This will pop up a browser with the UI. Note that this configuration is pulled from the remote SQL server for the membership stuff.
Goto the security tab. Create an admin user for the starter kit. Make sure you give it administrative role. said...

How can the ASP.Net website administration tool be opened to manage users online (after hosting on discountasp.net)

regards
Mozay (http://Mozay.com)

wisemx

02-29-2008, 03:07 AM

The proper connection string is listed in your control panel for whichever database server you added.
Is that the part you're having trouble with?

maxspeed

02-29-2008, 11:58 AM

a) navigate to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
b) execute this aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

The above is step 4

Can I confirm :

DB Server Name = n1.discountasp.net
DB Login = my given user name to log in to www.discountasp.net (http://www.discountasp.net)
Database name = my registered domain in whois such as www.acbdefgh.com (http://www.acbdefgh.com)

URGENT please help

I am getting an error massage

An error has occurred. Details of the exception:</o:p>
An error has occurred while establishing a connection to the server. When conne</o:p>
cting to SQL Server 2005, this failure may be caused by the fact that under the</o:p>
default settings SQL Server does not allow remote connections. (provider: Named</o:p>
Pipes Provider, error: 40 - Could not open a connection to SQL Server)
</o:p>

ramelllamar

06-14-2008, 04:51 AM

Bruse,

I followed your instructions to at 'T', but yet I'm still getting errors when I try to connect the remote server. Here is exactly what I did...

1) Download and install the starter kit if you do not already have it installed on your computer. Grap it at http://www.asp.net

2) Create a new website / project using VS.NET 2K5 or VWD 2005. Use the Club starter kit template.

3) Create the Application Services Database on the our SQL

a) navigate to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
b) execute this aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name] - when this ran it completed, but I didn't see anything happen

4) Create the starter kit database schema on the remote server by using the following script....osql. osql -S <sql server name> -U <db_user> -P <DB_password> -d <DB_Name> -i club-add.sql

5) Open the Web.config file in VWD 2005.

Change the connection string to point to the remote SQL server, and add the following lines..

<connectionStrings>
<add name='ClubSiteDB' connectionString='Data Source=tcp:sql2k506.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=*******' providerName='System.Data.SqlClient'/>

<remove name='LocalSqlServer'/>

<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k506.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=*******' providerName='System.Data.SqlClient' />
</connectionStrings>

6) Now build the kit by hitting Ctrl-F5. When I did this, I got the following error message?

Server Error in '/Greater_Mt_Olive' Application.
________________________________________
Invalid object name 'SiteSettings'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'SiteSettings'.

Source Error:

Line 2186: this.Adapter.SelectCommand = this.CommandCollection[0];
Line 2187: DataSet.SiteSettingsDataTable dataTable = new DataSet.SiteSettingsDataTable();
Line 2188: this.Adapter.Fill(dataTable);
Line 2189: return dataTable;
Line 2190: }

Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\greater_mt_olive\a8242ded\3582d7f7\App_Code. k6kyqc2w.9.cs Line: 2188

Stack Trace:

[SqlException (0x80131904): Invalid object name 'SiteSettings'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +98
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3430
System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() +52
System.Data.SqlClient.SqlDataReader.get_MetaData() +130
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +371
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1272
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +45
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method) +162
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior) +35
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior) +32
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +183
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +338
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +198
DataSetTableAdapters.SiteSettingsTableAdapter.GetS iteSettings() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\greater_mt_olive\a8242ded\3582d7f7\App_Code. k6kyqc2w.9.cs:2188
DevCowSiteSettings.GetSiteSettings() in c:\Documents and Settings\ramell-lamar\Desktop\Desktop Stuff\Personal Material\Web Site Portfolio\Greater_Mt_Olive\App_Code\SiteSettings.c s:49
DevCow.Web.UI.DevCowThemePage.Page_PreInit(Object sender, EventArgs e) in c:\Documents and Settings\ramell-lamar\Desktop\Desktop Stuff\Personal Material\Web Site Portfolio\Greater_Mt_Olive\App_Code\DevCowThemePag e.cs:20
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +31
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +68
System.Web.UI.Page.OnPreInit(EventArgs e) +96
System.Web.UI.Page.PerformPreInit() +32
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1437

________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

Please Help?..thanks
/emoticons/mad.gif /emoticons/mad.gif /emoticons/mad.gif /emoticons/mad.gif /emoticons/mad.gif

wisemx

06-14-2008, 11:07 AM

Hi,
Please watch this 3 minute video and see if it helps a bit:
http://iis7test.com/membershipprovider/SQLmembership.html
Salute,
Mark

ramelllamar

06-17-2008, 02:55 AM

I looked at the video, bit dosen't show me what I'm doing wrong. After following the steps, I still get the same error. Please help

wisemx

06-17-2008, 09:07 AM

I'll help you, no worries.
Did you add SQL Server 2005 to your account?
If so and you want me to take a look at the DB let me know, no charge.
Salute,
Mark

ramelllamar

06-17-2008, 10:54 AM

Yes I did actually. I purchased the MS SQL 2005 server service. My server name is SQL2005_508898, and login name is SQL2005_508898_aspnetdb_user. I was able to create the tables from the schema that was provided in the club starter kit. I just can't figure out the connection string needed to create the role that's needed. Below is a copy of the connection string used in the web.config file....the password is encrypted here

<connectionStrings>
<add name='ClubSiteDB' connectionString='Data Source=tcp:sql2k506.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=********' providerName='System.Data.SqlClient'/>
<remove name='LocalSqlServer'/>
<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k506.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=********' providerName='System.Data.SqlClient' />
</connectionStrings>

Thanks,
Ramell

Post Edited (Ramell L) : 6/18/2008 12:11:13 AM GMT

ramelllamar

06-18-2008, 01:52 AM

I don't have any code loaded to the server...only the tables. Could this be the problem. The site settings is being referenced by App_Code\SiteSettings.cs

wisemx

06-18-2008, 05:13 AM

That is what I was thinking, you seem to have missing code files.
Upload your local site to remote again, make sure those folders get created and the code files in them.
Salute,
Mark

wisemx

06-18-2008, 11:07 AM

OK, please try it exactly like this, just replace your password:

[quote]

<connectionStrings>
<clear/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=tcp:sql2k506.discountasp.net;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=********;" providerName="System.Data.SqlClient"/>
<remove name="ClubSiteDB"/>
<add name="ClubSiteDB" connectionString="Data Source=tcp:sql2k506.discountasp.net;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=********;" providerName="System.Data.SqlClient"/>
</connectionStrings></CODE>

ramelllamar

06-18-2008, 11:17 AM

Shouldn't It be looking at what's on the SQL Server. I did that and I received this error...

Server Error in '/Greater_Mt_Olive' Application.
--------------------------------------------------------------------------------

Invalid object name 'SiteSettings'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'SiteSettings'.

Source Error:

Line 2186: this.Adapter.SelectCommand = this.CommandCollection[0];
Line 2187: DataSet.SiteSettingsDataTable dataTable = new DataSet.SiteSettingsDataTable();
Line 2188: this.Adapter.Fill(dataTable);
Line 2189: return dataTable;
Line 2190: }

Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\greater_mt_olive\a8242ded\3582d7f7\App_Code. k6kyqc2w.9.cs Line: 2188

Stack Trace:

[SqlException (0x80131904): Invalid object name 'SiteSettings'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
DataSetTableAdapters.SiteSettingsTableAdapter.GetS iteSettings() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\greater_mt_olive\a8242ded\3582d7f7\App_Code. k6kyqc2w.9.cs:2188
DevCowSiteSettings.GetSiteSettings() in c:\Documents and Settings\ramell-lamar\Desktop\Desktop Stuff\Personal Material\Web Site Portfolio\Greater_Mt_Olive\App_Code\SiteSettings.c s:49
DevCow.Web.UI.DevCowThemePage.Page_PreInit(Object sender, EventArgs e) in c:\Documents and Settings\ramell-lamar\Desktop\Desktop Stuff\Personal Material\Web Site Portfolio\Greater_Mt_Olive\App_Code\DevCowThemePag e.cs:20
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +33
System.Web.UI.Page.OnPreInit(EventArgs e) +2062504
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +663

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

wisemx

06-18-2008, 11:48 AM

See if you can find where 'SiteSettings' is being referenced.
The conn string I provided in my last post is correct.

wisemx

06-19-2008, 12:29 AM

What are you using to Sync the folders local to remote?

btw, if you can not get this resolved I am willing to do the installation for you, no charge.
Salute,
Mark

ramelllamar

06-19-2008, 12:41 AM

I used FTP. What do you need from me to do the installation?

wisemx

06-19-2008, 01:34 AM

I'd need Time and your Control Panel login.
Just e-mail that infoto me at wisemx@msftwise.com

The Time would not be today, my kids are driving me nuts. http://community.discountasp.net/emoticons/lol.gif
http://blogcastrepository.com/photos/marks_shots/default.aspx

You can trust me, I do this for a lot of DASP customers and have permission from the DASP crew.
Salute,
Mark

ramelllamar

06-19-2008, 01:41 AM

I put the files on the remote server and now I received the same error message.

ramelllamar

06-19-2008, 02:42 AM

I sent you an email....thanks

wisemx

06-21-2008, 11:55 AM

Hi,
I got your e-mail and have looked at your SK code files and the SQL DB.
Seems the Club SK site, if you use the SQL Server,is missing some site settings.
Apparently the original version assumed the user would be using SQL Express.
Salute,
Mark

UPDATE: Just sent you an e-mail message.

After digging into this I highly recommend anyone using the Club SK to get this updated Codeplex project:
http://www.codeplex.com/ClubStarterKit

Post Edited (wisemx) : 6/21/2008 12:57:25 PM GMT

ramelllamar

06-26-2008, 02:46 AM

I don't think I ever received the email that you sent earlier...do you mind resending it.

Thanks

wisemx

06-26-2008, 10:22 AM

Sure...Just sent it again to your yahoo.com address.

ramelllamar

07-11-2008, 12:37 AM

I?m trying to figure out how to go about modifying the graphics and text for the club site starter kit. I know that I would need to update the default.master file so that all of my pages look the same, but I can?t figure out where in the code to make the change or to change the pic that?s displayed in the header. Then I thought that the style sheet would be the place, but again I was wrong. Can someone let me know where in the code to make the change so the I can delete the pic (soccer ball) that?s in the header of every page? Below is the code to the default.master file and the style sheet

Default.master file

<%@ Master Language='VB' %>

<%@ Register TagPrefix='ClubSite' TagName='HitCounter' Src='~/UserControls/HitCounter.ascx' %>

<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Strict//EN'
'http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd'>
<script runat='server'>

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)

If Not (IsPostBack) Then
ActivateUsers.Text = Application('activeUsers').ToString

Dim ClubName As String = ConfigurationManager.AppSettings('ClubName')
Dim ClubSlogan As String = ConfigurationManager.AppSettings('ClubSlogan')
Dim ClubAddress As String = ConfigurationManager.AppSettings('ClubAddress')
Dim ClubCopyright As String = ConfigurationManager.AppSettings('ClubCopyright')

If Not (ClubName Is Nothing) Or ClubName <> '' Then
Label_ClubName.Text = ClubName
masterhead.Title = ClubName
Else
Label_ClubName.Text = 'My Club Site'
masterhead.Title = 'My Club Site'
End If

If Not (ClubSlogan Is Nothing) Or ClubSlogan <> '' Then
Label_ClubSlogan.Text = ClubSlogan
Else
Label_ClubSlogan.Text = 'My Club Site tag line or slogan'
End If

If Not (ClubAddress Is Nothing) Or ClubAddress <> '' Then
Label_ClubAddress.Text = ClubAddress
Else
Label_ClubAddress.Text = 'Club Address here'
End If

If Not (ClubCopyright Is Nothing) Or ClubCopyright <> '' Then
Label_Copyright.Text = ClubCopyright
Else
Label_Copyright.Text = 'Copyright © 2007 My Club Site. All Rights Reserved.'
End If

End If

If Page.User.Identity.IsAuthenticated Then
Membership.GetUser(Membership.GetUser.ProviderUser Key(), True)
End If
End Sub
</script>
<html xmlns='http://www.w3.org/1999/xhtml' xml:lang='en' lang='en' >
<head id='masterhead' runat='server'>
<title>Greater Mt Olive Overcoming Church of GOD</title>

<link rel='alternate' type='application/rss+xml' title='News' href='~/RSS/NewsRss.aspx' />
<link rel='alternate' type='application/rss+xml' title='Events' href='~/RSS/EventRss.aspx' />
<link rel='alternate' type='application/rss+xml' title='Blog' href='~/RSS/BlogsRss.aspx' />
<link rel='alternate' type='application/rss+xml' title='Forums' href='~/RSS/AllPostsRss.aspx' />
<link rel='alternate' type='application/rss+xml' title='Photo Albums' href='~/RSS/AlbumsRss.aspx' />
</head>
[b]
<div id='poster'>
<h1>

******Here is the Text I need to add in the header ********************
<asp:Label ID='Label_ClubName' runat='server' >Welcome to Greater Mt Olive
Overcoming Church of GOD</asp:Label>
</h1>
<h2>
<asp:Label ID='Label_ClubSlogan' runat='server' >'WHERE WE'RE GOING PLACES IN
GOD WE'VE NEVER GONE BEFORE....TOGETHER'</asp:Label>

************************************************** *********************

</h2>
</div>
<div class='none'>
<a href='#content_start'>Skip Repetitive Navigational Links</a></div>
<div id='navtop'>
<asp:SiteMapDataSource ID='SiteMapDataSource1' runat='server' ShowStartingNode='false' />
<asp:Repeater ID='TopNavRepeat' runat='server' DataSourceID='SiteMapDataSource1'>
<HeaderTemplate>
<ul>
</HeaderTemplate>
<ItemTemplate>
<li>
<asp:HyperLink ID='HyperLink1' runat='server' Text='<%# Eval('Title') %>' NavigateUrl='<%# Eval('Url') %>'
ToolTip='<%# Eval('Description') %>' />
</li>
</ItemTemplate>
<FooterTemplate>
</ul>
</FooterTemplate>
</asp:Repeater>
</div>
<form id='form1' runat='server'>
<asp:ContentPlaceHolder ID='ContentPlaceHolder1' runat='server'>
</asp:ContentPlaceHolder>
</form>
<div id='navbottom'>
<asp:Repeater ID='BottomNavRepeat' runat='server' DataSourceID='SiteMapDataSource1'>
<HeaderTemplate>
<ul>
</HeaderTemplate>
<ItemTemplate>
<li>
<asp:HyperLink ID='HyperLink1' runat='server' Text='<%# Eval('Title') %>' NavigateUrl='<%# Eval('Url') %>'
ToolTip='<%# Eval('Description') %>' />
</li>
</ItemTemplate>
<FooterTemplate>
</ul>
</FooterTemplate>
</asp:Repeater>
</div>
<div id='footer'>
<asp:Label ID='Label_ClubAddress' runat='server' Text='Label'/>
[b]
<asp:Label ID='Label_Copyright' runat='server' Text='Label'/>[b]
Number of users on the site (<asp:Label ID='ActivateUsers' runat='server'></asp:Label>)[b]
<ClubSite:HitCounter ID='HitCounter' runat='server' />
</div>
</body>
</html>

Style Sheet Code
div.foot{ text-align:center; }

.eventmonth h3
{
padding-left: 20px;
padding-right: 20px;
}

.eventlist label
{
font-weight: bold;
padding-right: 4px;
}
.eventmonth
{
width: 694px;
margin-right: auto;
margin-left: auto;
margin-bottom: 10px;
padding-left: 15px;
padding-right: 15px;
padding-top: 10px;
}

/* used as the cssclass of the actual calendar */
.eventmonthtable
{
width: 694px;
margin-right: auto;
margin-left: auto;
position: relative;
margin-bottom: 15px;
border: 1px solid #DBDB79;
border-collapse:collapse;
}

.dayNumber
{
float: right;
border-bottom: 1px solid #C7C272;
border-left: 1px solid #C7C272;
clear: none;
padding: 2px;
}

.calcurrentmonth
{
/* no styles needed at this time */
}
.calothermonth
{
background-color: #DCD78E;
}
.calcurrentday
{
background-color: #FFFFC1;
}
.calweekend
{
background-color: #FEEB95;
/* width: 15%; */
}

.calcurrentmonth , .calcurrentmonth , .calothermonth , .calcurrentday , .calweekend
{
text-align: left;
border: 2px solid #C7C272;
height: 60px;
vertical-align: top;
/* needed for positioning the dayNumber part */
position:relative;
border-collapse:separate;
border-spacing: 5px;

}
.eventlistdate
{
padding-right: 4px;
}
.eventlisticon
{
text-align: center;
}
.eventlisttime
{
text-align: center;
width: 95px;
}
.eventlistevent
{
font-weight: bold;
}
.eventlistlocation
{
/* no styles needed at this time */
}
.eventlist td
{
padding-bottom: 4px;
}
.button
{
cursor: hand;
background: transparent url('../images/button.png') no-repeat 0% 0%;
padding: 0;
width: 123px;
height: 40px;
border: none;
overflow: hidden;
font: corbel;
font-size: 17px;
color: #454545;
padding-bottom: 5px;
}
.button:hover {
background: transparent url('../images/button.png') no-repeat 0% -40px;
}
[b]

wisemx

07-11-2008, 01:23 AM

Hi,
You see the DIV with ID of "poster"?
It loads a class from the App_Themes\ClubSite folder, Format.CSS
In that CSS file the DIV "poster" is:

[quote]

#poster
{
background: url('images/poster.jpg') no-repeat;
margin-right: auto;
margin-left: auto;
width: 726px;
height: 139px;
margin-top: 17px;
}</CODE>You can remove the DIV, or alter that class.
Salute,
Mark

ramelllamar

07-12-2008, 12:19 AM

Thanks Mark. Now can you tell me how to get the text to show up in the header. Even when I take the pic out, my text still isn't displaying in the header as I would like. Can you tell me how to get around this. Also when I try to log into my site online, I get the following error.

Server Error in '/' Application.
The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.]
System.Web.Util.SecUtility.CheckSchemaVersion(Prov iderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +589
System.Web.Security.SqlMembershipProvider.CheckSch emaVersion(SqlConnection connection) +85
System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.Validate User(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

wisemx

07-12-2008, 12:38 AM

How did you get the data on the DASP SQL Server up until this point?
Please be as specific as possible, including which SQL Server addon you have here.

Something I'd also like to know is, are you aware that there are two data files scripted for this kit?
(Data.sql and Schema.sql)

As for the text, you can place text in that same area just by using normal html.
For example:
[quote]

<div> My text is here. </div></CODE>

ramelllamar

07-12-2008, 01:14 AM

Honestly, I can't remember exactly what I did to install the site. I know I found a form on this site that gave me the instructions on what to do. What I do remember is that I used the data.sql file that was in the starter kit files to create the schema on the MS 2005 Sql Server....and I also updated the connection string in the web.config file with the following code.

<connectionStrings>
<add name='ClubSiteDB' connectionString='Data Source=tcp:sql2k506.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=******' providerName='System.Data.SqlClient'/>
<remove name='LocalSqlServer'/>
<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k506.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_508898_aspnetdb;User ID=SQL2005_508898_aspnetdb_user;Password=******' providerName='System.Data.SqlClient' />
</connectionStrings>

wisemx

07-12-2008, 01:30 AM

If you only ran the Data.sql file you also need to run the Schema.sql file.
Open them in any text editor and you can see what they do.

If you haven't created a backup of your DASP database do it before doing this.

I am scheduled for Memorial services this weekend, U.S. Military Officers.
Other than that I'll be around to help if you need it.
Salute,
Mark

ramelllamar

07-12-2008, 01:34 AM

I did run the scheme file when setting this up on the server. The more I look at the code, the more I think that the problem may be that problem is that I don't know where the 'ClubName') is located. Can you tell me where to look to update this

Default.Master
Dim ClubName As String = ConfigurationManager.AppSettings('ClubName')
Dim ClubSlogan As String = ConfigurationManager.AppSettings('ClubSlogan')
Dim ClubAddress As String = ConfigurationManager.AppSettings('ClubAddress')
Dim ClubCopyright As String = ConfigurationManager.AppSettings('ClubCopyright')

If Not (ClubName Is Nothing) Or ClubName <> '' Then
Label_ClubName.Text = ClubName
masterhead.Title = ClubName

Post Edited (Ramell L) : 7/12/2008 5:18:07 AM GMT

wisemx

07-12-2008, 11:38 AM

Hi,
Please consider starting a new thread for your help topics concerning this starter kit.
This original thread was provided to help everyone with the kit but now it's branching into general code help.

At any rate, you don't need to be concerned about where the control may be getting that info...
You can very easily replace that string with anything you want.

i.e.

[quote]

Label_ClubName.Text = "This is my site."
masterhead.Title = "This is my site."</CODE>

ramelllamar

07-14-2008, 11:51 AM

If I wanted to add a few new links to the header file where would i make this change?

wisemx

08-10-2008, 01:28 AM

Hi,
How did you create the roles on the remote DASP SQL Server?
All the best,
Mark

wisemx

08-10-2008, 03:02 AM

Express? Give a few details about what you are using locally and I can post some suggestions.
Salute,
Mark

vashistha

08-10-2008, 06:52 AM

I have created roles in my own local server not in DASP.

vashistha

08-10-2008, 11:39 AM

Hi,
I got a new error msg, PLEASE HELP ME

Server Error in '/' Application.
________________________________________
The 'System.Web.Security.SqlRoleProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlRoleProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:
[ProviderException: The 'System.Web.Security.SqlRoleProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.]
System.Web.Util.SecUtility.CheckSchemaVersion(Prov iderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +589
System.Web.Security.SqlRoleProvider.CheckSchemaVer sion(SqlConnection connection) +65
System.Web.Security.SqlRoleProvider.GetRolesForUse r(String username) +771
System.Web.Security.RolePrincipal.IsInRole(String role) +272
System.Web.Security.Roles.IsUserInRole(String username, String roleName) +533
System.Web.Security.Roles.IsUserInRole(String roleName) +16
admin1.form1_Load(Object sender, EventArgs e) +66
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434

</font>[b] </font>