473,657 Members | 2,832 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Configuration issue: WAT fails to create aspnetdb.mdf database!

Problem summary:
Web Site Admin Tool is not generating the application services database
(aspnetdb.mdf) in a SS 2005 only environment; i.e. The DB is not found under
the app_data directory.

The Question:
What configuration am I missing to allow WAT to create the application
services database?

Scenarios I tried:
On a dedicated developer workstation running WXP w/ SP2, I installed
- SQL Server '05 (without SQLEXPRESS)
- vStudio '05

-- SS 2005 is running and has no problems
-- IIS is running and has no problems

Logged in as a member of the Administrators group, within vStudio 2005,
I try to run the Web Site Admin Tool (WAT), the site opens. Next when I
click on the SECURITY tab, I get the following error:
"Unable to connect to SQL Server database"

Clicking the [Choose Data Source] button takes me to the PROVIDER tab, and
when I click on either of the two choices, I get the same error message:
"Could not establish a connection to the database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to create and
configure the database, and then return to this tool to set the provider."

1) Running the aspnet_regsql tool as a wizard and specifying:
- YLW4WSDVLPR2 -- the localserver name
- aspnetdb for the database name
the utility completes successfully.

Trying again to use the Web Site Admin Tool, the database is not to be found
under the app_data diretory and the same error senario unforlds.

2) Running the aspnet_regsql tool from the command line as:
aspnet_regsql.e xe -E -S localhost -A all
comletes successfully, but the DB is not to be found.

Additional config info:
The machine.config connection string was changed to refer to the correct SS
'05
e.g.
".\SQLEXPRE SS" was changed to "YLW4WSDVLP R2"
"User Instance=True" is removed

The vStudio application's web.config connection string is empty.

Any suggestions???? will be appreciated
(found nothing relevant in this or other newgroup)
Feb 8 '06 #1
0 1878

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

Similar topics

6
1437
by: Carlos | last post by:
Hi all, I am trying to configure a sample website under asp .net 2.0, and play with the security provider. I already have the aspnetdb db, but when I go to the security tab for the asp configuration tool, a connection can not be established with the provider. I noticed I did not have the NT AUTHORITY\NETWORK SERVICE user for the db, so I went and added it with db_owner role. However, it is still not able to connect.to that provider. Am...
5
3055
by: VB Programmer | last post by:
My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db for my 2.0 site to work. Is this accurate? If so, how can I rename it without breaking anything on my site? FYI: This is the error I'm getting after I publish my site to their servers... An attempt to attach an auto-named database for file c:\hosting\myhost\member\myaccount\customerdomains\mysite\App_Data\ASPNETDB.MDF failed. A database with the same name exists,...
2
2513
by: te goody | last post by:
Problem summary: Web Site Admin Tool is not generating the application services database (aspnetdb.mdf); i.e. The DB is not found under the app_data directory. The Question: What configuration am I missing to allow WAT to create the application services database? Scenarios I tried: On a dedicated developer workstation running WXP w/ SP2, I installed
0
1177
by: RAM | last post by:
Hello, I have written simple ASP.NET application with logging in. I need to open ASPNETDB database to read some information which is not available using class library (custom table). I have written: using (SqlConnection aspnetdb = new SqlConnection(ConfigurationManager.ConnectionStrings.ConnectionString)) { aspnetdb.Open(); // here problem
10
2720
by: Pete | last post by:
I have used Visual Studio 2005 to create a website. I set up standard login page using standard procedures. Nothing fancy or out of the ordinary, just standard procedures described in any "Login stuff for halfwits" book. Everything works perfectly fine! ! Nothing whatsoever goes wrong at all! However, when I deploy the website to another computer, the login fails ! I have searched the internet from top to bottom trying to find an answer....
4
1478
by: SAL | last post by:
I'm trying to use the website configuration tool and it keeps telling me that it is unable to connect the SQL Server Database. I do not have SQL Server Express installed. I have the real deal installed on my development box. Is this the problem or is there someway to tell this tool that I'm using and named instance of SQL Server. I ran the aspnet_regsql.exe tool and it installed the aspnetdb database in the server. In the...
0
1208
by: R.A.M. | last post by:
Hello, Please help in the following problem. (I translate texts and messages from Polish to English, so there may be some differences). I have created ASP.NET application with aspnetdb database and I have created one user: demo. The problem is that when I enter ASP.NET Configuration (from Visual Studio Express Edition) and I choose 'Security' tab, then 'Manage users' I receive an .aspx page with error: Generating user instances in SQL...
0
1056
by: Dhananjay | last post by:
Hi all, I have developed a Asp.net website application.It was working properly, but due to crash of system, I have downloaded Vs.net 2005 professional edition and sql server express. But now it's not working. I have IIS and configured virtual directory also. The problem lies at this place :- I have used inbuilt Asp.net login control.Through which i am redirecting my login page to home page, but it doesn't work.I have
6
8808
by: Mr. X. | last post by:
Hello. How can I create aspnetdb from scratch ? (I want a script that create all table, views, etc... on that database). Thanks :)
0
8303
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8821
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8723
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8502
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7316
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6162
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
1941
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.