I installed the app and it seemed to go fine.

When I started it, the login screen came up and when I tried to login admin/admin I got the following

---------------------------------------------------------------------------------------------------------------------------------------------------------

Server user 'LOHENGRIN02\ASPNET' is not a valid user in database 'IssueTrackerStarterKit'. Cannot open database requested in login 'IssueTrackerStarterKit'. Login fails. Login failed for user 'LOHENGRIN02\ASPNET'.

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.

Exception Details: System.Data.SqlClient.SqlException: Server user 'LOHENGRIN02\ASPNET' is not a valid user in database 'IssueTrackerStarterKit'. Cannot open database requested in login 'IssueTrackerStarterKit'. Login fails. Login failed for user 'LOHENGRIN02\ASPNET'.

Source Error:

[SqlException: Server user 'LOHENGRIN02\ASPNET' is not a valid user in database 'IssueTrackerStarterKit'.
Cannot open database requested in login 'IssueTrackerStarterKit'. Login fails.
Login failed for user 'LOHENGRIN02\ASPNET'.]
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +384
   ASPNET.StarterKit.IssueTracker.DataAccessLayer.SQLDataAccessLayer.ExecuteScalarCmd(SqlCommand sqlCmd) +132
   ASPNET.StarterKit.IssueTracker.DataAccessLayer.SQLDataAccessLayer.Authenticate(String username, String password) +192
   ASPNET.StarterKit.IssueTracker.BusinessLogicLayer.ITUser.Authenticate(String username, String password) +44
   ASPNET.StarterKit.IssueTracker.DesktopDefault.Login(Object s, EventArgs e) +94
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292

I had that account (which only shows up as ASPNET beacause LOHENGRIN02 is the name of the computer).

To be sure, I dropped that user and added it again. It was configured with dbowner authority on all of the databases.

The result was the same.

David

Were you able to solve this problem? Because I am also having the same problem. And trying to resolve.

Thanks

H

Cannot open database "IssueTrackerStarterKit" requested by the login. The login failed.
Login failed for user 'DTS-D456L81\ASPNET'.

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.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "IssueTrackerStarterKit" requested by the login. The login failed.
Login failed for user 'DTS-D456L81\ASPNET'.

Source Error:

[SqlException (0x80131904): Cannot open database "IssueTrackerStarterKit" requested by the login. The login failed.
Login failed for user 'DTS-D456L81\ASPNET'.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   ASPNET.StarterKit.IssueTracker.DataAccessLayer.SQLDataAccessLayer.ExecuteScalarCmd(SqlCommand sqlCmd) +123
   ASPNET.StarterKit.IssueTracker.DataAccessLayer.SQLDataAccessLayer.Authenticate(String username, String password) +177
   ASPNET.StarterKit.IssueTracker.BusinessLogicLayer.ITUser.Authenticate(String username, String password) +44
   ASPNET.StarterKit.IssueTracker.DesktopDefault.Login(Object s, EventArgs e) +74
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Are you using XP or Server?  If you are using Server you have to use the NT Authority\Network Service instead of HostName\ASPNET

Hi All,

I am facing the same database connection problem.

Can anyone please tell me from where do i download /install

"Use Enterprose Manager, Query Ananlyser or the OSQL Commandline tool for this."

To solve this problem as discussed in the forum.

Thanks

If you are using the MSDE version of SQL 2000 then if you did like I did when I acquired it and paid for it, then you should have Enterprise Manager tools on the CD that MSDE SQL 2000 came on.  If you downloaded MSDE, the free edition, there isn't an Enterprise Manager tool that came with it.

If you are using SQL 2005 Express editions, then you can go to http://msdn.microsoft.com/vstudio/express/sql/download/ and you can download the Management Studio Express which will allow you to manage SQL User accounts and establish their permissions within databases.

Hope this helps.

Add "machinename\ASPNET user to  login (Tip - Go to MsQL server Management studio, security , Login, right click, new login)

Then give permission to that login for write, and database access

Regards

Hi,

I have this problem connecting to SQL server 2005.

I am using a hosting that has sql server. i am getting this error message:

Server Error in '/tejiendofuturo.com.ar' Application.

---

Cannot open database "wi720289_TejiendoFuturo" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Line 825:            this.Adapter.SelectCommand = this.CommandCollection[2];
Line 826:            DSProducto.ProductoDataTable dataTable = new DSProducto.ProductoDataTable();
Line 827:            this.Adapter.Fill(dataTable);
Line 828:            return dataTable;
Line 829:        }

The connection string i am using is:

connectionString="data source=localhost;integrated security=SSPI;initial catalog=wi720289_TejiendoFuturo;User ID=wi720289_tejiendofuturo;Password=whatever" 

wi720289_ was set by the hosting web admin when i created the db and user.

Thx.

Bye. 

As a starting point to troubleshoot your connection problem, the "data source = localhost" might be your problem.  The only time this is valid is when the SQL Server is on the same machine as the web server where your web site files are loaded at.  It has been my experience that hosting providers usually have the web server on one machine and the database server on another machine.  Check with your hosting provider and find out if the SQL Server is on the same machine as the web server, if that is the case then the localhost setting is correct.  If that is not the case, then you would need to find out from your hosting provider what address you should use in the connection string to connect to the machine that has SQL Server and your database.

Hope this helps.

Thanks. The problem was that the hosting needed for asp.net 2.0 to use another account than the asp one.

To do this you have to put this line in the web.config file: <identity impersonate="true"/> 

Bye and thx for the replay. 

 Hello. i have faced the same problem during the development of a web application for my thesis.

The following works for me:

On SQL Server Management Studio==>new query and jot down the following code:

(with Win XP pro, IIS 5 and MS SQL 2005)

exec sp_grantlogin 'MachineName\ASPNET'
use database_name
exec sp_grantdbaccess 'MachineName\ASPNET'
exec sp_addrolemember 'db_owner', 'MachineName\ASPNET'

(with win server 2008, iis 7 and sql server 2008)

exec sp_grantlogin 'NT Authority\Network Service'
use database_name
exec sp_grantdbaccess 'NT Authority\Network Service'
exec sp_addrolemember 'db_owner', 'NT Authority\Network Service'

 Thank you so much. I used the solution and it works.