Start up on SQL 2014

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
Jens
New user
New user
Posts: 3
Joined: 2014-12-26 15:08

Start up on SQL 2014

Post by Jens » 2014-12-26 15:20

Hi,

I am trying to start up on a SQL 2014 but I get these messages from the database setup window
.............
Please wait while updating database settings...
Settings updated.
Restarting server...
Database version could not be detected.
................
How do I get it to set up the database?

BR

Jens

Jens
New user
New user
Posts: 3
Joined: 2014-12-26 15:08

Re: Start up on SQL 2014

Post by Jens » 2014-12-27 14:16

I found that SQL 2014 is not supported, but 2008 should be, I got the same messages on 2008 R2 SP2!
Is this not supported?

User avatar
jimimaseye
Moderator
Moderator
Posts: 8170
Joined: 2011-09-08 17:48

Re: Start up on SQL 2014

Post by jimimaseye » 2014-12-28 16:13

Hi Jens

Im afraid I cannot help you much with the complexity of why you get this error, hopefully Martin or someone will be able to cover this for you if and when they read your post. However, I do want to tell you that I am running Windows 2008 R2 quite happily (albeit with MySQL). Im sure the problem is solvable for you - you just need someone with the answer to be reading.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
martin
Developer
Developer
Posts: 6834
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Re: Start up on SQL 2014

Post by martin » 2014-12-28 16:16

It sounds like you're not using the database setup properly. It sounds like you ran the wizard and selected "Select a new hMailServer default database" rather than "Create a new hMailServer database". Could that be the issue?
Martin Knafve
martin@hmailserver.com
https://twitter.com/knafve

alescan
Normal user
Normal user
Posts: 45
Joined: 2014-11-11 17:29
Location: Italy
Contact:

Re: Start up on SQL 2014

Post by alescan » 2016-01-18 18:47

Hi,
I have to upgrade SQL Server 2008 installation due to an application upgrade that not support it anymore.
I don't want to install a new istance, so i tried if hmail support it first.
I installed SQL 2014 Standard on a windows server 2012 virtual machine.
I selected create new db --> msssql --> IP tried 127.0.0.1 and the normal lan ip
Authentication i tried both (windows and sql).
Here the result

Code: Select all

Starting task...
Please wait while creating database...
ADO: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
From SQl Server managment studio I connect normally.
SQL server version is 12.0.4100.1

What can be?

Sorry fo my english, i'm italian

Thank you
HMS 5.6.7 B2425 on Win Server 2016 Standard with SQL Server 2014 SP2

percepts
Senior user
Senior user
Posts: 5282
Joined: 2009-10-20 16:33
Location: Sceptred Isle

Re: Start up on SQL 2014

Post by percepts » 2016-01-18 18:55

note that the hmail install creates the DB schema. You must NOT create it yourself before the install.

if you have a failed hms install but the DB schema has been created then you must uninstall hmailserver, delete the hmailserver install directory AND manually drop the db schema which the hmail install has created and then try again.

alescan
Normal user
Normal user
Posts: 45
Joined: 2014-11-11 17:29
Location: Italy
Contact:

Re: Start up on SQL 2014

Post by alescan » 2016-01-18 19:03

Sorry everyone,
my very very very bad.
It is a named instance so i had to write 127.0.0.1\Name.

It worked!

Thank you!
HMS 5.6.7 B2425 on Win Server 2016 Standard with SQL Server 2014 SP2

Post Reply