CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




Can Reply:  No Members Can Edit: No Online: Yes
Zone: > Asp.Net Forum > starter_kits_and_source_projects.personal_site_starter_kit Tags:
Item Type: Date Entered: 7/30/2006 5:28:22 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 2 Views: 25 Favorited: 0 Favorite
3 Items, 1 Pages 1 |< << Go >> >|
"cuongvt" <>
NewsGroup User
Personal starter kit with sql 2005 for developer7/30/2006 5:28:22 AM

0

I used personal starter kit with sql 2005 express with no problems.
Now I unistalled express version in installed sql 2005 for developer.
I deleted my old personal starter kit then created new personal starter kit on my local
machine, then hit ctrl+F5, a error appeared like below. I think should I change sqlserver name
in web.config file? Should I change from "Data Source=.\SQLExpress;" to "Data Source=.\ASUS;"? (ASUS is my local server name)
THanks. Below is error content:

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)

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.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

  1. If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
  2. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
  3. Sql Server Express must be installed on the machine.
  4. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.


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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +173
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +219
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +49
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +160
System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +67

[HttpException (0x80004005): Unable to connect to SQL Server database.]
System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +123
System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +89
System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +26
System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +388


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

"[email protected]"
NewsGroup User
Re: Personal starter kit with sql 2005 for developer7/30/2006 2:26:15 PM

0

You need the appropriate connection string for the database you use.  Look at connectionstrings.com for samples.

Jeff


Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue.
"cuongvt" <>
NewsGroup User
Re: Personal starter kit with sql 2005 for developer7/31/2006 7:44:52 AM

0

Thanks for the reply.
But could you teach me more in detail? I'm really stuck.
If you need more information, pls ask me.
I need your help. Thank you.
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:













server error in '/' application.

anybody using sqlite database with this kit ?

how do you test pwsk under iis ??? **** need some help ****

creating albums for specified users

q. on extending the admin. abilities: where is "webadmin.axd"?

creating personel web site !! help

css for default master

icons in manage.aspx

asp.net wiki starter kit??

processrequest in handler.ashx

finally my pws is working

how to create personal.mdf in sqlserver2005 ?

problem copying website to iis with visual web developer

wadsworth psk and gmail...

adapting pws to small business sk (css problems)

aspnetdb.mdf used by another process

using the personal website starter kit

migrating from my sql server in my machine to my host sql server

completely lost

record navigation question

could not load type 'system.web.security.accessroleprovider'.?????

microsoft personal web site starter kit

is it just me, or ???

create paging in the photoalbum?

how do you change "your name here" ?

problems with personal site

disable photo download via right click

aspnet account and hosting company

create database script

login to personal website kit

photos doesn't show on either the default.aspx nor the photoalbum page

show off your personal site

can't login as admin after publish website

how to install & use starter kits...

roles

shrink images as they are uploaded to the pws

starter kit

is it possible to have a sitemapnode (i.e. the resister node) only visible to the anonymous users?

lytebox support for jeremy wadsworth's personal website kit

extended version...where are the graphics?

database issues

rowstyle-cssclass="rowstyle"

how do i manage users?

firefox: why do all the hyperlinks keep blinking?

how do i change the text at the top of the pwsk?

go daddy help...!!!!!!!!! can't figure this out...connection string??

where do i ...

submit buttons no longer work - help please :-)

possible incorrect settings in config file?

importing photos & timeout

   
  Privacy | Contact Us
All Times Are GMT