Cannot open database requested in login 'pubs'. Login fails. Login failed for user 'ITFIREDUP01ASPN

Originally posted by : Randy Chow (randy@itfiredup.com)This is so weird, because I can't access the sample from the .Net framework installation, even after installing all the components including the MSSQL Service Manager with the installation. The code is any sample from the .Net download package. Can anyone help? Thank you for reading my problem.

Originally posted by : steve (steve@aspfree.com)if you installed the msde, you have to grant this user rights to the database or use the trusted connection string.add that to your web.config. ------------Randy Chow at 1/21/2002 11:31:47 PMThis is so weird, because I can't access the sample from the .Net framework installation, even after installing all the components including the MSSQL Service Manager with the installation. The code is any sample from the .Net download package. Can anyone help? Thank you for reading my problem.

Originally posted by : Randy Chow (randychow@itfiredup.com)Tried the string, because that is the default for the installation. The pubs database though is not like an mdb, so I couldn't get to the database, becuase it theoretically exists in a different form. That's what I need to know to solve the solution, because MSSQL Server isn't suthenticating the ASPNET user properly.------------steve at 1/22/2002 5:23:00 PMif you installed the msde, you have to grant this user rights to the database or use the trusted connection string.add that to your web.config. ------------Randy Chow at 1/21/2002 11:31:47 PMThis is so weird, because I can't access the sample from the .Net framework installation, even after installing all the components including the MSSQL Service Manager with the installation. The code is any sample from the .Net download package. Can anyone help? Thank you for reading my problem.

Originally posted by : ciaran mullan (ciaran.mullen@abbeynational.co.uk)when you run the msde setup check the log file, it probably has failed on granting acces to the database for the specific user. I've found that you need to manually do this if you have set your win 2000 machine as PDC.Look in the prog~filesmicrosoft.net etframeworksdksamplessetuphtmlconfigdetails.htm file where it will tell you how to manually grant access. Make sure your machine name is domain.machine nameASPNET rather than just machine name.------------Randy Chow at 1/22/2002 11:57:37 PMTried the string, because that is the default for the installation. The pubs database though is not like an mdb, so I couldn't get to the database, becuase it theoretically exists in a different form. That's what I need to know to solve the solution, because MSSQL Server isn't suthenticating the ASPNET user properly.------------steve at 1/22/2002 5:23:00 PMif you installed the msde, you have to grant this user rights to the database or use the trusted connection string.add that to your web.config. ------------Randy Chow at 1/21/2002 11:31:47 PMThis is so weird, because I can't access the sample from the .Net framework installation, even after installing all the components including the MSSQL Service Manager with the installation. The code is any sample from the .Net download package. Can anyone help? Thank you for reading my problem.