Are the [Fail] and [Warn] returns (starting at line 55, after 'installing databases') from this log file of a critical nature? Can I carry on?

My Setup.log file reads as follows:

9/10/2004 5:18:05 PM: : -------------------------------------------
9/10/2004 5:18:05 PM: : Configuration started
9/10/2004 5:18:06 PM: : Configuring IIS
9/10/2004 5:18:06 PM: [Pass] : Virtual root added at 58900_VB
9/10/2004 5:18:06 PM: [Pass] : Virtual root added at 58900_VB\02_Understanding_the_.NET_Framework\simpl econfig
9/10/2004 5:18:06 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Advanc ed
9/10/2004 5:18:06 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Compon ent
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Global asax\Async\Application
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Global asax\EventExamples\CustomData
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Global asax\EventExamples\Error
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Global asax\EventExamples\Footer
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Global asax\Inherits
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Global asax\ResolveRequestCache
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\12_Web_Applications_and_Globalasax\Proces sModel
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\Compilation\Remote
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\Globalization
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\HttpHandler
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\HttpModule
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\Impersonate
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13 - Configuration\SectionHandler
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\Session
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\13_Configuration\Tracing\TraceTool
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\14_Securing_ASP.NET_Applications\form-based
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\14_Securing_ASP.NET_Applications\custom-form-based
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\14_Securing_ASP.NET_Applications\personal ization
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\14_Securing_ASP.NET_Applications\windows
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\15_Working_with_Collections and Lists
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\17_.NET_Components
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\18_Building_ASP.NET_Server_Controls
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\19_Exposing_Web_Services
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\FormsAuthentication
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\FormsAuthentication \Consumer
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\BasicAuthentication \Consumer
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\SessionState\Consum er
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\Timeout\Consumer
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\SoapException\Consu mer
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\SoapExtensions
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\ScreenScrape
9/10/2004 5:18:07 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\SoapHeaderSimple
9/10/2004 5:18:08 PM: [Pass] : Virtual root added at 58900_VB\20_Using_Web_Services\SoapHeaderAuthentic ation
9/10/2004 5:18:08 PM: [Pass] : Virtual root added at 58900_VB\21_Mobile_Controls
9/10/2004 5:18:08 PM: [Pass] : Virtual root added at 58900_VB\22_Tracing_Error_Handling_Debugging_and_P erformance
9/10/2004 5:18:08 PM: [Pass] : Virtual root added at 58900_VB\23_Migration_and_Interoperability
9/10/2004 5:18:08 PM: [Pass] : Virtual root added at IBuyAdventure
9/10/2004 5:18:08 PM: : IIS Configuration complete
9/10/2004 5:18:08 PM: : Configuring file permissions
9/10/2004 5:18:08 PM: [Pass] : Constructing write permission for ASPNET to 08_to_11_Data_Management\data02
9/10/2004 5:18:08 PM: [Pass] : Constructing write permission for ASPNET to 08_to_11_Data_Management\data04
9/10/2004 5:18:08 PM: [Pass] : Constructing write permission for ASPNET to 08_to_11_Data_Management\data05
9/10/2004 5:18:08 PM: [Pass] : Constructing write permission for ASPNET to 16_Working_with_Other_Base_Classes\IO9/10/2004 5:18:08 PM: [Pass] : Constructing write permission for ASPNET to 20_Using_Web_Services
9/10/2004 5:18:08 PM: [Info] : Running perms.bat to change directory permissions
9/10/2004 5:18:23 PM: : File permissions configuration complete
9/10/2004 5:18:23 PM: : Installing databases
9/10/2004 5:18:49 PM: [Fail] : Error adding user 'CENTRINO\ASPNET' to CENTRINO\NetSDK : SQL Server does not exist or access denied.
9/10/2004 5:18:49 PM: [Fail] : Error adding user 'CENTRINO\IUSR_CENTRINO' to CENTRINO\NetSDK : SQL Server does not exist or access denied.
9/10/2004 5:18:49 PM: [Fail] : Failure checking for existence of database 'pubs' : SQL Server does not exist or access denied.
9/10/2004 5:18:49 PM: [Warn] : Cannot add user 'CENTRINO\IUSR_CENTRINO' to database 'pubs' as the database does not exist.
9/10/2004 5:18:49 PM: [Fail] : Failure checking for existence of database 'WroxBooks' : SQL Server does not exist or access denied.
9/10/2004 5:19:00 PM: [Fail] : Database installation of 'WroxBooks.sql' failed with code 1
9/10/2004 5:19:21 PM: [Fail] : Failure checking for existence of database 'WroxBooks' : SQL Server does not exist or access denied.
9/10/2004 5:19:21 PM: [Warn] : Cannot add user 'CENTRINO\ASPNET' to database 'WroxBooks' as the database does not exist.
9/10/2004 5:19:21 PM: [Fail] : Failure checking for existence of database 'IBuyAdventure' : SQL Server does not exist or access denied.
9/10/2004 5:19:31 PM: [Fail] : Database installation of 'IBuyAdventure.sql' failed with code 1
9/10/2004 5:19:52 PM: [Fail] : Failure checking for existence of database 'IBuyAdventure' : SQL Server does not exist or access denied.
9/10/2004 5:19:52 PM: [Warn] : Cannot add user 'CENTRINO\ASPNET' to database 'IBuyAdventure' as the database does not exist.
9/10/2004 5:19:52 PM: [Fail] : Failure checking for existence of database 'UserList' : SQL Server does not exist or access denied.
9/10/2004 5:20:03 PM: [Fail] : Database installation of 'UserList.sql' failed with code 1
9/10/2004 5:20:03 PM: [Fail] : Failure checking for existence of database 'UserList' : SQL Server does not exist or access denied.
9/10/2004 5:20:03 PM: [Warn] : Cannot add user 'CENTRINO\ASPNET' to database 'UserList' as the database does not exist.
9/10/2004 5:20:03 PM: : Database installation complete
9/10/2004 5:20:03 PM: : Modifying web.config files
9/10/2004 5:20:03 PM: [Pass] : Modify web.config file 14_Securing_ASP.NET_Applications\windows9/10/2004 5:20:03 PM: [Dbg] : Adding: server=CENTRINO\NetSDK;Trusted_Connection=yes;data base=UserList
9/10/2004 5:20:03 PM: [Pass] : Modify web.config file 14_Securing_ASP.NET_Applications\custom-forms-based9/10/2004 5:20:03 PM: [Dbg] : Adding: server=CENTRINO\NetSDK;Trusted_Connection=yes;data base=UserList
9/10/2004 5:20:03 PM: [Pass] : Modify web.config file 14_Securing_ASP.NET_Applications\personalization9/10/2004 5:20:03 PM: [Dbg] : Adding: server=CENTRINO\NetSDK;Trusted_Connection=yes;data base=Northwind
9/10/2004 5:20:03 PM: [Dbg] : Adding: server=CENTRINO\NetSDK;Trusted_Connection=yes;data base=pubs
9/10/2004 5:20:03 PM: [Dbg] : Adding: server=CENTRINO\NetSDK;Trusted_Connection=yes;data base=IBuyAdventure
9/10/2004 5:20:03 PM: [Dbg] : Adding: Provider=SQLOLEDB.1;Data Source=CENTRINO\NetSDK;Trusted_Connection=yes;Init ial Catalog=IBuyAdventure
9/10/2004 5:20:03 PM: [Dbg] : Adding: server=CENTRINO\NetSDK;Trusted_Connection=yes;data base=WroxBooks
9/10/2004 5:20:03 PM: [Dbg] : Adding: Provider=SQLOLEDB.1;Data Source=CENTRINO\NetSDK;Trusted_Connection=yes;Init ial Catalog=WroxBooks
9/10/2004 5:20:03 PM: [Dbg] : Adding: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
9/10/2004 5:20:03 PM: [Pass] : Modify web.config file
9/10/2004 5:20:03 PM: : Modification of web.config files complete
9/10/2004 5:20:03 PM: [Fail] : Failure checking for existence of database 'UserList' : SQL Server does not exist or access denied.
9/10/2004 5:20:03 PM: [Info] : UserList database does not exist - cannot update password hashes
9/10/2004 5:20:03 PM: : Configuration complete


Thanks for your help :D



Gene Kelley
BizFlowDesigns.com
Arlington, Texas, USA

I also have the same proplem!!

Hi,

If you notice the log carefully specially the following line

9/10/2004 5:18:49 PM: [Fail] : Error adding user 'CENTRINO\ASPNET' to CENTRINO\NetSDK : SQL Server does not exist or access denied.

It means the setup is not able to detect the MSDE Instance named "CENTRINO\NetSDK", following are possible problmes.

MSDE is not installed on your machine, or it might be installed using a different instance name

its becoz of security related issues, it is possible that MSDE is installed and running in windows only authentication mode and thats the reason setup is not able to log on to the MSDE.

Identify your case and post so we can move forward on this issue to resolve this.

Charul Shukla

Any progress

Charul Shukla

I too am having the exact same error. I have the full version of SQL server and the log is saying the same.

How do i find the correct instance name? Is this problem not connected to the username and passwords?

To put it simply the databses are not being created.

"Error adding user 'DEVSERVER\ASPNET' to DEVSERVER\NetSDK : SQL Server does not exist or access denied."


Thanks in advance for any help.

Regards,

TheFIsh

I too have the error, but here's some more information:

Error adding user 'MACHINE\ASPNET' to MACHINE\NetSDK : SQL Server does not exist or access denied.

dasetup.log:
Ini Section: General
    : ProductName = Microsoft Data Access Components 2.7
    : ProductBuild = 2.71.9040.2
    : ProductUrl = http://www.microsoft.com/data
    : ProductVersionKey = SOFTWARE\Microsoft\DataAccess
    : ProductVersionValue = FullInstallVer
    : InstanceName = MDAC

Then on the Samples Setup Dialog I've tried setting up with Instance set as both NetSDK and MDAC. I am also running sql-desk-sp3.

I have "SA" and the SAPWD used from the MSDE install for both authentication areas.

Any help appreciated.
Chris Wallingford

Is there no assistance to be had here? A moderator or anyone?

I don't have time to dip into all the forums I'd like so wasn't aware this topic was around. As the author of the setup tool I feel I should be able to help. I'll get some background out of the way first.

When you install .NET you might only get the MSDE instance of SQL Server if you install the Framework SDK samples. I therefore couldn't automatically default to this, so included the option to specify the server and the instance (Note to self: check what happens if the user doesn't enter an instance - it's been a while since I looked at the code). Anyway I tried to give the most flexible method.

For the two user accounts, the first is the account used to create the samples; this might need to be an admin account within SQL as it creates databases and tables. If you select Windows Authentication then your current windows user needs to have been created in SQL Server as a login and must have appropriate permissions.

The second is the account under which the samples will connect once installed. By default a trusted connection is used, which is the ASPNET account - a local machine account that ASP.NET runs under. This user is machineName\ASPNET, and it is added as a login to the SQL Server and a user to the databases.

If anyone is still having setup problems then I recommend mailing me and I'll do my best to help you with them - put "Wrox Setup Problems" in the title of the message and attach the log file. Go to http://ipona.com/consultancy.aspx - my email address is displayed there.

Thanks

Dave

The easiest way I have found to successfully install this is to open it up with Winzip, copy those files to a differenct dir, close winzip and let it erase the temp files, then run the setup from the new location.
If you use winzip and do the install from that app, when winzip deletes the temp files you will LOSE all of the data in the subfolders in inetpub\wwwroot. I did this twice before realizing it and doing what I did above.


For those having problems with MSDE as in the cases above, I left the instance field blank (or fill in with your named instance) and then instead of letting the authen be windows, I used my sql authen and it worked like a charm.