Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite 7
 AfterLogic Forum : AfterLogic WebMail Lite 7
Subject Topic: help, wont install on ms sql Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
rookster1984
Newbie
Newbie


Joined: 16 August 2011
Online Status: Offline
Posts: 2
Posted: 16 August 2011 at 7:59am | IP Logged Quote rookster1984
hello, i have downloaded the new sql server express and installed it.
i can connect to it with the tool that comes with it.
on doing the webmail install all i keep getting is:
Connect unsuccessful!: Internal Server Error. Please, contact your system administrator in order to report the problem.
tried everything i can think of, including x86 and x64 versions of mssql,
typing the same details in as the tool that works, just the ip address of the server. but nothing.
please help
Back to Top View rookster1984's Profile Search for other posts by rookster1984
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 16 August 2011 at 9:57am | IP Logged Quote Igor
I understand this is about ASP.NET version of WebMail Lite, right? Try enabling special debug log as shown here, it would provide you with more or less verbose error information. Also, you might need to use ODBC connection string, this resource offers a vast range of examples for various database engines.

Currently, it is recommended to use MySQL if possible. To use it with ASP.NET edition of AfterLogic WebMail, you'll need ODBC Connector installed.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
Orlog
Newbie
Newbie


Joined: 25 January 2012
Online Status: Offline
Posts: 6
Posted: 25 January 2012 at 4:48am | IP Logged Quote Orlog
Hi,
I got the same problem. The answer doesn't help because I get the error while installing WebMail Lite. I even can't find any instructions how to handle with the database. I tried to use the windows-user, created a sql-user and even created the (empty) database by myself but nothing works. ODBC can't be the solution. Wherefore are the special MS SQL inputs then?

Here is a screenshot from where i stuck:



btw: I'm using SQL-Server 2008R2 Standard on W2k8R2 Standard.

thx for help...
Back to Top View Orlog's Profile Search for other posts by Orlog
 
Orlog
Newbie
Newbie


Joined: 25 January 2012
Online Status: Offline
Posts: 6
Posted: 25 January 2012 at 8:47am | IP Logged Quote Orlog
I'm a step further, I think.
After switching the logging on in the web.config I get a more detailed error:
Quote:

[25.01.2012 17:30:34][PrepareCommand] - CREATE DATABASE AfterLogic_WebMail_Lite
------------------------------------------------------------
[25.01.2012 17:30:34] ERROR!!!
[Message]
Internal Server Error. Please, contact your system administrator in order to report the problem.
[TargetSite]
Void OnError(System.Data.SqlClient.SqlException, Boolean)
[Stack Trace]
   at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at WebMail.DbManager.CreateDatabase(String databaseName)
[Method]: CreateDatabase
[Line, Column]: [0, 0]
------------------------------------------------------------



When I create the db manually the "test database" button approves everything ok, but the create-button still raises the error. The Code in the App_Code/DBManager.cs looks good.
Back to Top View Orlog's Profile Search for other posts by Orlog
 
Orlog
Newbie
Newbie


Joined: 25 January 2012
Online Status: Offline
Posts: 6
Posted: 26 January 2012 at 12:22am | IP Logged Quote Orlog
Ok, I got it. The missing "db_creator" role for the user caused the error and - maybe - the windows-only authentication mode. This must be set to mixed-mode to use a DB-Login.

This part should be better documented. It's hard to figure out what to do when the requirements are particulary unknown.

And as feature-request: I would like to use the UserCredentials for the DB-Login.

Back to Top View Orlog's Profile Search for other posts by Orlog
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 26 January 2012 at 12:40am | IP Logged Quote Igor
In case if standard database access configuration approach isn't suitable for some reason, using ODBC connection string instead might work.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide