469,643 Members | 2,036 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Installing ASP.Net 2.0 onto sql2000 web server, App_Data, SQL2005 problem

I've just upgraded our WIndows 2003 (with SBS server) web server
to .Net framework 2.0

(it had 1.1 before)

As I have been working on a web parts page on my laptop, hosting it
there, working perfectly. I want to transfer it now, so I upgraded it.
Created a new application pool for .net2.0 stuff, then used Visual
Studio 2005 from my laptop to connect to Http://Bw-online/ProjectPoint
and make a new website. Bw-online is our intranet at the moment.

It created it, I dragged the files across into it, then went to that
address in the browswer and I get
Server Error in '/ProjectPoint' 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: 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:
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.
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.
Sql Server Express must be installed on the machine.
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.
I know this has to do with the app_data directory which has a data
base that stores all the customizations people make. Its an intranet
website, I want people to be able to customize by windows account.

I've checked permissions on the directory and gave full control to all
the groups there.

On my laptop, I can go to Visual Studio, click website and go to
ASP.net configuration and it comes up with a web based web.config
editing, when I open the website I made remotely, I can't see htat
option, why is it gone? Is that where I can fix the error ?

Help is appreciated! I've googled but everyone just says to turn off
the login, but I need that for web parts.

May 16 '07 #1
2 1733
Sounds like you've got a local file-directory based SQLExpress connection
string. That won't work with a remote machine. Attach the MDF database file
and fix the connection string.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"it******@gmail.com" wrote:
I've just upgraded our WIndows 2003 (with SBS server) web server
to .Net framework 2.0

(it had 1.1 before)

As I have been working on a web parts page on my laptop, hosting it
there, working perfectly. I want to transfer it now, so I upgraded it.
Created a new application pool for .net2.0 stuff, then used Visual
Studio 2005 from my laptop to connect to Http://Bw-online/ProjectPoint
and make a new website. Bw-online is our intranet at the moment.

It created it, I dragged the files across into it, then went to that
address in the browswer and I get
Server Error in '/ProjectPoint' 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: 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:
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.
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.
Sql Server Express must be installed on the machine.
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.
I know this has to do with the app_data directory which has a data
base that stores all the customizations people make. Its an intranet
website, I want people to be able to customize by windows account.

I've checked permissions on the directory and gave full control to all
the groups there.

On my laptop, I can go to Visual Studio, click website and go to
ASP.net configuration and it comes up with a web based web.config
editing, when I open the website I made remotely, I can't see htat
option, why is it gone? Is that where I can fix the error ?

Help is appreciated! I've googled but everyone just says to turn off
the login, but I need that for web parts.

May 16 '07 #2
thanks, I've replaced the connection string with a string to our
sql2000 database, it seems to be working fine storing the data there
now.

Cheers!

May 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by polinaskulski | last post: by
2 posts views Thread by somequestion | last post: by
2 posts views Thread by PointMan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.