Hi all,

I'm new to all this and I thought I would try setting up my Dotnetpanel on an internal network before putting it all live on my new server (that way I can break it and it wont matter).

After getting both Windows Server 2003 Web Edition and all the updates installed I then installed MS SQL Express 2005 (for the testing of Dotnetpanel as I dont have a full copy of SQL yet).

Next came the install of Dotnetpanel, where I started off with installing the Enterprise Server on 127.0.0.1:9002 which is showing as running, then I installed the Server on 127.0.0.1:9003 which is also shown as running. Finaly I insalled the Portal which opens up with the login page but when I enter the login and password as "serveradmin" it comes up with the scrip code below.

 I was just wondering if someone could please point me in the right direction as I'm now lost. 

Server Error in '/' Application.

---

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'AUTHENTICATE' task on 'serveradmin' USER ---> System.Data.SqlClient.SqlException: Login failed for user 'DNPEnterpriseServer1'. The user is not associated with a trusted SQL Server connection.
  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
  at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
  at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
  at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
  at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
  at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
  at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
  at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  at System.Data.SqlClient.SqlConnection.Open()
  at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
  at DotNetPark.DotNetPanel.EnterpriseServer.DataProvider.GetUserByUsernameInternally(String username)
  at DotNetPark.DotNetPanel.EnterpriseServer.UserController.AuthenticateUser(String username, String password, String ip)
  --- End of inner exception stack trace ---
  at DotNetPark.DotNetPanel.EnterpriseServer.UserController.AuthenticateUser(String username, String password, String ip)
  at DotNetPark.DotNetPanel.EnterpriseServer.esAuthentication.AuthenticateUser(String username, String password, String ip)
  --- End of inner exception stack trace ---

[SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'AUTHENTICATE' task on 'serveradmin' USER ---> System.Data.SqlClient.SqlException: Login failed for user 'DNPEnterpriseServer1'. The user is not associated with a trusted SQL Server connection.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at DotNetPark.DotNetPanel.EnterpriseServer.DataProvider.GetUserByUsernameInternally(String username)
   at DotNetPark.DotNetPanel.EnterpriseServer.UserController.AuthenticateUser(String username, String password, String ip)
   --- End of inner exception stack trace ---
   at DotNetPark.DotNetPanel.EnterpriseServer.UserController.AuthenticateUser(String username, String password, String ip)
   at DotNetPark.DotNetPanel.EnterpriseServer.esAuthentication.AuthenticateUser(String username, String password, String ip)
   --- End of inner exception stack trace ---]
   DotNetPark.DotNetPanel.Portal.PortalUtils.AuthenticateUser(String username, String password, String ipAddress, Boolean rememberLogin, String preferredLocale, String theme) +148
   DotNetPark.DotNetPanel.Portal.Login.LoginUser(String username, String password, Boolean rememberLogin, String preferredLocale, String theme) +32
   DotNetPark.DotNetPanel.Portal.Login.btnLogin_Click(Object sender, EventArgs e) +128
   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

Thanks for your time and help

Scott

Please check this topic: http://forum.dotnetpanel.com/forums/p/760/4155.aspx#4155

 Hi Paul,

 Thanks for the posting but I managed to find this link

http://msdn2.microsoft.com/en-us/library/ms143705(SQL.90).aspx

which pointed me into the right direction, also for anyone else that has this problem and is using the Express Edition of MSSQL 2005 you will need to have the Management Studio Installed to change this.

Scott