473,378 Members | 1,468 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Keep getting this error when trying to use Web Parts in VS2005 Beta 2. Why?

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
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 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. Note that 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 SQL Server Express attempts to create a duplicate of an
already existing database.
3.. SQL Server Express must be installed on the machine.
4.. If the application services database does not already exist, the SQL
Server Express service account must have read and write access to the
applications App_Data directory. This is necessary because the SQL Server
Express service account will create the application services database.
5.. The web server account used to connect to SQL Server Express must have
rights to create a new database.
1.. When using the local web server(Cassini) installed with Visual
Studio, the logged-in user needs the dbcreator privilege in the appropriate
SQL Server Express instance.
2.. When using IIS, the process account needs the dbcreator privilege in
the appropriate SQL Server Express instance. Only consider granting a
process account dbcreator privilege on secure development machines. Do not
grant the dbcreator privilege on production machines without fully
investigating and understanding the security ramifications of running a
production web server with the dbcreator privilege. The process account
requiring dbcreator privilege varies depending on operating system platform
and ASP.NET configuration settings:
a.. For IIS5, and IIS6 running in IIS5 isolation mode, the default web
server account is the local ASPNET machine account.
b.. For IIS6 native mode, the default web server account is NETWORK
SERVICE.
c.. If application impersonation is enabled, then the application
impersonation account requires the dbcreator privilege.
d.. If an explicit account was specified for the web server process
(either in the <processModel> element for IIS5 and IIS5 isolation mode, or
the application pool account on IIS6), then the explicit account requires
the dbcreator privilege.
Nov 19 '05 #1
2 2093
This is telling you that SqlExpress can't create the database automatically.
Did you not install SqlExpress when installing VS.NET 2005? You can also
use SqlServer by running the aspnet_regsql.exe utility to setup another database.
This then requires you to specify a connection string for your custom database,
like this:

http://beta.asp.net/QUICKSTART/aspne...px#connstrings

Info for aspnet_regsql is here:

http://beta.asp.net/QUICKSTART/aspne...ls.aspx#regsql

-Brock
DevelopMentor
http://staff.develop.com/ballen
Timeout expired. The timeout period elapsed prior to completion of
the
operation or the server is not responding.
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 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. Note that 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 SQL Server Express attempts to create a duplicate
of an
already existing database.
3.. SQL Server Express must be installed on the machine.
4.. If the application services database does not already exist, the
SQL
Server Express service account must have read and write access to the
applications App_Data directory. This is necessary because the SQL
Server
Express service account will create the application services database.
5.. The web server account used to connect to SQL Server Express
must have
rights to create a new database.
1.. When using the local web server(Cassini) installed with Visual
Studio, the logged-in user needs the dbcreator privilege in the
appropriate
SQL Server Express instance.
2.. When using IIS, the process account needs the dbcreator
privilege in
the appropriate SQL Server Express instance. Only consider granting a
process account dbcreator privilege on secure development machines. Do
not
grant the dbcreator privilege on production machines without fully
investigating and understanding the security ramifications of running
a
production web server with the dbcreator privilege. The process
account
requiring dbcreator privilege varies depending on operating system
platform
and ASP.NET configuration settings:
a.. For IIS5, and IIS6 running in IIS5 isolation mode, the
default web
server account is the local ASPNET machine account.
b.. For IIS6 native mode, the default web server account is
NETWORK
SERVICE.
c.. If application impersonation is enabled, then the
application
impersonation account requires the dbcreator privilege.
d.. If an explicit account was specified for the web server
process
(either in the <processModel> element for IIS5 and IIS5 isolation
mode, or
the application pool account on IIS6), then the explicit account
requires the dbcreator privilege.


Nov 19 '05 #2
Thanks Brock! I did install SQLExpress but I don't think it was a clean
install. There were errors towards the end and for the life of me, I can't
seem to get it to install without errors. It was just confusing because I
start getting that error as soon as I add a Web Part Manager and I don't see
any connection strings or the ability to set one anywhere. I wish there were
some better tutorials out on it.

Thanks again!

"Brock Allen" <ba****@NOSPAMdevelop.com> wrote in message
news:80**********************@msnews.microsoft.com ...
This is telling you that SqlExpress can't create the database
automatically. Did you not install SqlExpress when installing VS.NET 2005?
You can also use SqlServer by running the aspnet_regsql.exe utility to
setup another database. This then requires you to specify a connection
string for your custom database, like this:

http://beta.asp.net/QUICKSTART/aspne...px#connstrings

Info for aspnet_regsql is here:

http://beta.asp.net/QUICKSTART/aspne...ls.aspx#regsql

-Brock
DevelopMentor
http://staff.develop.com/ballen
Timeout expired. The timeout period elapsed prior to completion of
the
operation or the server is not responding.
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 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. Note that 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 SQL Server Express attempts to create a duplicate
of an
already existing database.
3.. SQL Server Express must be installed on the machine.
4.. If the application services database does not already exist, the
SQL
Server Express service account must have read and write access to the
applications App_Data directory. This is necessary because the SQL
Server
Express service account will create the application services database.
5.. The web server account used to connect to SQL Server Express
must have
rights to create a new database.
1.. When using the local web server(Cassini) installed with Visual
Studio, the logged-in user needs the dbcreator privilege in the
appropriate
SQL Server Express instance.
2.. When using IIS, the process account needs the dbcreator
privilege in
the appropriate SQL Server Express instance. Only consider granting a
process account dbcreator privilege on secure development machines. Do
not
grant the dbcreator privilege on production machines without fully
investigating and understanding the security ramifications of running
a
production web server with the dbcreator privilege. The process
account
requiring dbcreator privilege varies depending on operating system
platform
and ASP.NET configuration settings:
a.. For IIS5, and IIS6 running in IIS5 isolation mode, the
default web
server account is the local ASPNET machine account.
b.. For IIS6 native mode, the default web server account is
NETWORK
SERVICE.
c.. If application impersonation is enabled, then the
application
impersonation account requires the dbcreator privilege.
d.. If an explicit account was specified for the web server
process
(either in the <processModel> element for IIS5 and IIS5 isolation
mode, or
the application pool account on IIS6), then the explicit account
requires the dbcreator privilege.


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Wayne | last post by:
This may not be the best group to ask in as the question is about the beta, if there is a better place please point me to it. I've had beta 1 installed, after a re-install of the OS this weekend...
2
by: bor_kev | last post by:
Hi, I am working under Microsoft Visual (C++)Studio 2005 Beta i am trying to port some program (implemented under .NET 2003) under this brand new software. I have two questions : First,...
10
by: _B | last post by:
I'm trying to clear space on a laptop. Currently have Visual Studio 6 + MSDN 98, AND VS2003 + recent MSDN. I had kept the older VS6 due to some legacy apps with odd code that had trouble...
3
by: Alan Wang | last post by:
Hi there, Once my application gets complicated and complicated. I found it's really hard to keep track of Session value I am using in my asp.net application. I am just wondering if anyone have...
0
by: Mark | last post by:
Hi, When trying to install WSE Beta 1, I get the following error: Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as...
0
by: ruju00 | last post by:
I am getting an error in Login() method of the following class FtpConnection public class FtpConnection { public class FtpException : Exception { public FtpException(string message) :...
10
by: David Lee Conley | last post by:
When I open the Data Sources window and create a new data source, everything works fine. But if I have a form showing in the IDE, the Data Sources window becomes disabled and doesn't display any...
7
by: Tom | last post by:
I have built a VS 2005 C++ application (ported from VC++ 2003). It's a WinForm app. It runs OK on the development system, but when I try to deploy it on any other system, all users gets an error...
2
by: Lucvdv | last post by:
VS2005 SP1, new managed C++ class library project, hardly any code entered. All it contains are the declarations of two classes plus a few properties each, and the get/set methods for those...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.