BugNET

Open source issue tracking & project management
Welcome to BugNET Register | Login |
  Search

BugNET Forums

 
  Forum  Support  Installation pr...  SQL/server error
Previous Previous
 
Next Next
New Post 4/3/2007 4:50 AM
User is offline ichiokada
12 posts
No Ranking


SQL/server error 

  Hi Im very new to setting up these type of applications, can anyone please kindly advise me what I did wrong or missing?  i set a db in sql 2005 express, some how i just cannot connect to it. Any ideas what i did wrong?

Thanks.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: Login failed for user 'BugNet'. The user is not associated with a trusted SQL Server connection.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[SqlException (0x80131904): Login failed for user 'BugNet'. The user is not associated with a trusted SQL Server connection.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   BugNET.ApplicationBlocks.Data.DataHelper.PrepareCommand(IDbCommand command, IDbConnection connection, IDbTransaction transaction, CommandType commandType, String commandText, IDbDataParameter[] commandParameters) +29
   BugNET.ApplicationBlocks.Data.DataHelper.ExecuteReader(IDbConnection connection, IDbTransaction transaction, CommandType commandType, String commandText, IDbDataParameter[] commandParameters, ConnectionOwnership connectionOwnership) +37
   BugNET.DataAccessLayer.GenericDataAccessLayer.GetHostSettings() +76

[ApplicationException: An error has occured in accessing the database]
   BugNET.DataAccessLayer.GenericDataAccessLayer.GetHostSettings() +329
   BugNET.BusinessLogicLayer.HostSettings.GetHostSettings() +133
   BugNET.BusinessLogicLayer.HostSettings.GetHostSetting(String key) +7
   BugNET.UserInterfaceLayer.BasePage.OnInit(EventArgs e) +22
   BugNET._Default.OnInit(EventArgs e) +61
   System.Web.UI.Control.InitRecursive(Control namingContainer) +321
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +692

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

Server Error in '/' Application.

Login failed for user 'BugNet'. The user is not associated with a trusted SQL Server connection.

 
New Post 4/3/2007 4:59 AM
User is offline ichiokada
12 posts
No Ranking


Re: SQL/server error 

My newest error:

 

  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: Login failed for user 'Administrator'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[SqlException (0x80131904): Login failed for user 'Administrator'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   BugNET.ApplicationBlocks.Data.DataHelper.PrepareCommand(IDbCommand command, IDbConnection connection, IDbTransaction transaction, CommandType commandType, String commandText, IDbDataParameter[] commandParameters) +29
   BugNET.ApplicationBlocks.Data.DataHelper.ExecuteReader(IDbConnection connection, IDbTransaction transaction, CommandType commandType, String commandText, IDbDataParameter[] commandParameters, ConnectionOwnership connectionOwnership) +37
   BugNET.DataAccessLayer.GenericDataAccessLayer.GetHostSettings() +76

[ApplicationException: An error has occured in accessing the database]
   BugNET.DataAccessLayer.GenericDataAccessLayer.GetHostSettings() +329
   BugNET.BusinessLogicLayer.HostSettings.GetHostSettings() +133
   BugNET.Global.Application_Start(Object sender, EventArgs e) +58

Server Error in '/' Application.

Login failed for user 'Administrator'.

 

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

 
New Post 4/3/2007 5:30 AM
User is offline cgraefe
54 posts
No Ranking


Re: SQL/server error 
Hi,

1.) What type of authentication are you using? (integrated or sql authentication)
2.) Post your connection string without password
3.) Is your database service up and running?
4.) What Windows-OS are using?

regards
Christian
 
New Post 4/3/2007 7:19 PM
User is offline ichiokada
12 posts
No Ranking


Re: SQL/server error 

Hi,

1.) What type of authentication are you using? (integrated or sql authentication)
I set server authentication to "SQL server and windows authen. mode", is that correct?


2.) Post your connection string without password
<add name="LocalSqlServer"connectionString="server=SYNERGYSERVER\SQLEXPRESS;database=BugNet;uid=Administrator;pwd=MYPASSWORD"
   providerName="" />
 </connectionStrings>


3.) Is your database service up and running?
How do i make sure it is up and running? sorry im new to this, please advise


4.) What Windows-OS are using?
bugnet is setup on Ms windows server 2003 R2 , standard edition SP2


Thanks in advance!

 

Regards,

Crystal
 
New Post 4/4/2007 4:27 AM
User is offline ichiokada
12 posts
No Ranking


Re: SQL/server error 

Installation Status Report


Installing Version: 0.7.820.0
Installing Membership Provider... - 00:00:00.0625000
Error!

Error in file:C:\BugNET\Install\dbscripts\InstallCommon.sql
Message:Login failed for user 'Administrator'.


Error!

Error in file:C:\BugNET\Install\dbscripts\InstallMembership.sql
Message:Login failed for user 'Administrator'.


Error!

Error in file:C:\BugNET\Install\dbscripts\InstallProfile.sql
Message:Login failed for user 'Administrator'.


Error!

Error in file:C:\BugNET\Install\dbscripts\InstallRoles.sql
Message:Login failed for user 'Administrator'.


Installing BugNET Database... - 00:00:00.4218750
Error!

Error in file:C:\BugNET\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Login failed for user 'Administrator'.


Installing BugNET Default Data... - 00:00:00.5312500
Error!

Error in file:C:\BugNET\Install\dbscripts\BugNET.Data.SqlDataProvider.sql
Message:Login failed for user 'Administrator'.


Creating Administrator Account... - 00:00:00.5937500
 
 Page 1 of 212Next 
Previous Previous
 
Next Next
  Forum  Support  Installation pr...  SQL/server error

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.

 

Copyright 2008 BugNET   Terms Of Use  Privacy Statement  Page generated in 0.609375 seconds.