Newb here - so pleae be warned ;)

When trying to run on a non-express server - should I first attach the project DB and modify the connection sting?

Also the asp membership DB - is there one that should be used for all the membership functions/projects or should I be connecting to two databases for every project

I hope the question is clear.

thanks

Hi there,

Are you referring to a specific chapter of the book?

In general, you *can* shared the Membership databases. It all depends on what you want, and whether you want to share the users in it or not.

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.

Imar,

I'm trying to get CH2 to run on a standard edition of sql server which also happens to be the IIS server.

My connection string looks like:
<add name="aserver" connectionString="server=aserver\SQL2005;user id=uxx;password=pxxx;database=fileshare"/>

The server is also running SQL 2000 - which I am not using

I've attached the fileshareDB to sql and it looks ok - I also ran the aspnet_regsql.exe utility on the database - can that be done in place of using the aspnetdb.mdf - to me it would seem much more logical to have the project in a single DB if possible. - I could be going off on a tangent here

I'm still getting the dreaded "error: 26 - Error Locating Server/Instance Specified"

Any insight is appreciated - thanks for your help:D

The error in the server event log is as follows:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 5/3/2007
Time: 11:41:06 AM
User: N/A
Computer: ASERVER
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/3/2007 11:41:06 AM
Event time (UTC): 5/3/2007 3:41:06 PM
Event ID: 670a847405e443888125962b0aaefca4
Event sequence: 2
Event occurrence: 1
Event detail code: 0

Application information:
    Application domain: /LM/W3SVC/1/ROOT/FileShare-1-128226804474350048
    Trust level: Full
    Application Virtual Path: /FileShare
    Application Path: C:\inetpub\wwwroot\FileShare\
    Machine name: ASERVER

Process information:
    Process ID: 3848
    Process name: aspnet_wp.exe
    Account name: GETHERE\IWAM_ASERVER

Exception information:
    Exception type: SqlException
    Exception message: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Request information:
    Request URL: http://xxxx.dyndns.tv:8887/fileshare/login.aspx
    Request path: /fileshare/login.aspx
    User host address: 71.175.x.x
    User:
    Is authenticated: False
    Authentication Type:
    Thread account name: GETHERE\IWAM_ASERVER

Thread information:
    Thread ID: 1
    Thread account name: GETHERE\IWAM_ASERVER
    Is impersonating: False
    Stack trace: 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.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)
   at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context, Boolean revertImpersonate)
   at System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String connectionString, Boolean revertImpersonation)
   at 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)
   at System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
   at System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved)
   at System.Web.Security.SqlMembershipProvider.Validate User(String username, String password)
   at System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e)
   at System.Web.UI.WebControls.Login.AttemptLogin()
   at System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e)
   at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
   at System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

Hi there,

You may want to take a look here:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

It explains how to configure a remote SQL Server to work with ASP.NET.

You can use a single database, if you want. Some of the chapters use two, others only one. It just depends on your personal preference and whether you want to reuse the same user data across different applications.

So see how to prepare and configure a remote SQL Server for the providers, look here: http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Scott shows you how to override the LocalSqlServer connection string. If you want to see how to override the entire provider settings, including a different ConnectionStringName, look in the web.config file for the BugBase application.

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.

Yes, I've been reading and trying to apply your article since last night but I'm still getting this error - do I have to allow iwam account access to the database - or set ntfs ermission somewhere?

FYI - if I setup a connection via the gui in visual studio - I can test the DB connection without a hitch

Normally, you'd configure the ASPNET or Network Service account.

However, as the article describes this depends on your own configuration. The article describes a number of different scenarios and only you can see what applies to you.

If the server is on a different machine, you may need to set up SQL Server authentication, or use a domain account and use impersonation.

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.

Can anyone tell me a general step by step way to connect to 2 databases (one project the other the membership) for the fileshare project?

I can't believe how much time I have spent on this :( and I bet its something simple

Hi there,

It should be really easy, generally. All providers use a connection string called LocalSqlServer. So, as long as you create a separate connection string for your own stuff and use that in your code, you should be fine.

You can optionally override the LocalSqlServer string as per the articles I posted earlier.

Are there specific areas you're having problems with?

Imar