Hello, I've bougt your book and I've installed SqlServer2005 express, I've attached Bugbase database and changed the web.config as you see:

<connectionStrings>
    <add name="BugBase" connectionString="Data Source=derivados;Initial Catalog=BugBase;User Id=DERIVADOS\Administrador;Password=;" />
  </connectionStrings>

I validated this user against the data base when I connect.
And the database Bugbase exists and I can see all tables...

but when in my browser I write:
http://localhost/bugbase/default.aspx

I get this error (in spanish. sorry) telling me that there's an error in line number 18:

Error de servidor en la aplicación '/BugBase'.
--------------------------------------------------------------------------------

Error de configuración
Descripción: Error durante el procesamiento de un archivo de configuración requerido para dar servicio a esta solicitud. Revise los detalles de error específicos siguientes y modifique el archivo de configuración en consecuencia.

Mensaje de error del analizador: Sección de configuración 'connectionStrings' no reconocida

Error de código fuente:


Línea 16: </appSettings>
Línea 17:
Línea 18: <connectionStrings>
Línea 19: <add name="BugBase" connectionString="Data Source=derivados;Initial Catalog=BugBase;User Id=DERIVADOS\Administrador;Password=;" />
Línea 20: </connectionStrings>

Archivo de origen: C:\inetpub\wwwroot\BugBase\web.config Línea: 18


--------------------------------------------------------------------------------
Información de versión: Versión de Microsoft .NET Framework:1.1.4322.2300; Versión de ASP.NET:1.1.4322.2300



Do you know what I'm doing wrong?
Thanks.

Hi Marcel,

Take a look at the bottom of the error message:

Información de versión: Versión de Microsoft .NET Framework:1.1.4322.2300; Versión de ASP.NET:1.1.4322.2300

Your site is running against version 1.x of the framework. To fix the problem, open up the IIS MMC, locate your site and open its Properties. On the ASP.NET tab select framework version two and apply the changes.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks a lot!
now it works.. but I have two more questions:

1) Which is the user/passw to login (I see the table aspnet_users but not the passwords)

2) when it validates any login, it sends me a message like this: TITLE: Connect to Database Engine

Login failed for user 'marcel'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Also, I try to connect to SqlSever2005 and it doesn't works, do you know what could I do to trusting a Sql Server coonnection?)

Thanks a lot for your help!

The default setup assumes you're using SQL Server Express.

Are you using that, or are you using a full version of SQL Server 2005? How does your connection string look like?

You can find the passwords on page 392.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks!

I saw the passwords!

I find a solution for the invalid login in sql, I must have marked SQL Server and Windows Authentication Mode. Now I can connect.. but (sorry) I have a new problem when I introduce the user/passw:


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

Unable to open the physical file "C:\Inetpub\wwwroot\BugBase\App_Data\BugBase.m df". Operating system error 32: "32(El proceso no tiene acceso al archivo porque está siendo utilizado por otro proceso.)".
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\BugBase\App_Data\BugBase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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: Unable to open the physical file "C:\Inetpub\wwwroot\BugBase\App_Data\BugBase.m df". Operating system error 32: "32(El proceso no tiene acceso al archivo porque está siendo utilizado por otro proceso.)".
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\BugBase\App_Data\BugBase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

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): Unable to open the physical file "C:\Inetpub\wwwroot\BugBase\App_Data\BugBase.m df". Operating system error 32: "32(El proceso no tiene acceso al archivo porque está siendo utilizado por otro proceso.)".
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\BugBase\App_Data\BugBase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
   System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +735107
   System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
   System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context, Boolean revertImpersonate) +84
   System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String connectionString, Boolean revertImpersonation) +197
   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) +5102




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


Any idea...? thanks!

Do you still have a database in the App_Data folder?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Yes... but now it works!!!!!

Maybe by restarting the sql services... I'm not sure, but now it works perfect!!

Now it's time to learn...

Thanks a lot!

Regards.

Great. Have fun with it.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Imar,

You mentioned in tihs post that the password is on page 392. I am using the online version at books24x7. Can you let me know where the password is because there are no page numbers in the online version :).

Or you can email me the password at [email protected]

Many thanks

Tahir

It's on the second page of the BugBase chapter. Right above the screen shots that explain what the BugBase does you see a table with a number of user accounts and passwords.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.