Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
sstrauss  
#1 Posted : Wednesday, January 9, 2013 4:02:49 AM(UTC)
sstrauss

Rank: Newbie

Groups: Registered
Joined: 2/2/2012(UTC)
Posts: 4
Location: DE

Hi,

we connectet the emailarchitect so an MS SQL 2000 Server via ODBC (http://www.emailarchitect.net/emailserver/doc/default.aspx?ct=archive.htm) the Database and Tabels "eas_archive" and "eas_archive_owner" are successfully createt; but the archive-funktion dont work. the archive is empty and no email stored in the sql-database.
please help us.

ivan  
#2 Posted : Sunday, January 13, 2013 11:25:56 PM(UTC)
ivan

Rank: Administration

Groups: Administrators
Joined: 11/11/2010(UTC)
Posts: 1,033

Thanks: 9 times
Was thanked: 42 time(s) in 42 post(s)
sstrauss wrote:
Hi,

we connectet the emailarchitect so an MS SQL 2000 Server via ODBC (http://www.emailarchitect.net/emailserver/doc/default.aspx?ct=archive.htm) the Database and Tabels "eas_archive" and "eas_archive_owner" are successfully createt; but the archive-funktion dont work. the archive is empty and no email stored in the sql-database.
please help us.



Thanks for using Emailarchitect server.

First of all, please make sure "Mail Archive is active" is checked.
Secondly, please check Journal->System Events and see if there is any error in it.
sstrauss  
#3 Posted : Monday, January 14, 2013 2:15:37 AM(UTC)
sstrauss

Rank: Newbie

Groups: Registered
Joined: 2/2/2012(UTC)
Posts: 4
Location: DE

0x80004005 [ARCHIVE][Microsoft][ODBC SQL Server Driver][DBNET LIB]SQL Server existiert nicht oder Zugriff verweigert.;conn=Driver={SQL Server};Server=server;Database=mailarchiv;Uid=sqladmin;Pwd=xxx; Mon, 14 Jan 2013 11:10:01
ivan  
#4 Posted : Monday, January 14, 2013 3:34:28 AM(UTC)
ivan

Rank: Administration

Groups: Administrators
Joined: 11/11/2010(UTC)
Posts: 1,033

Thanks: 9 times
Was thanked: 42 time(s) in 42 post(s)
sstrauss wrote:
0x80004005 [ARCHIVE][Microsoft][ODBC SQL Server Driver][DBNET LIB]SQL Server existiert nicht oder Zugriff verweigert.;conn=Driver={SQL Server};Server=server;Database=mailarchiv;Uid=sqladmin;Pwd=xxx; Mon, 14 Jan 2013 11:10:01



First Server and database name

Did you enter the server name or IP correct? For named instances, enter " server name \ instance name "field.

Second Required Services

Start the program on the server "SQL Server Configuration Manager" and open the left node "SQL Server Services":

"SQL Server ( name ) "must be started.
"SQL Server Browser" must be started for named instances.
Start the services please, if it is not executed. Also, change the startup mode to "Automatic".

Third Allow remote access

Please start "Microsoft SQL Server Management Studio" and mark left in the Object Explorer, select the top node or the root node of the required server. Click on it with the right mouse button and choose the command Properties .

In the dialog box "server properties - Name "left click on the page links . Make sure that the option Allow remote connections to this server is enabled. Maximum number of simultaneous connections must be set to 0 or to a sufficient number. Restart the SQL Server service check again if you have made ​​changes.

4th Firewall

Microsoft SQL Server is configured to use port 1433. Check if it is blocked by a firewall or antivirus program. To test you can "telnet servername 1433 "use the command prompt. If you receive an error message, then the port is open. To enable you to define a detailed rule exception in the server's firewall.

Named instances of the SQL server to use other ports. Especially if the used instance is not the first, then you should firewall exceptions (inbound rules) for the services necessary to define. The port forwarding for 1433 is not required.


5th User privileges

Make sure that the user with which you want to connect to the database has sufficient access privileges.



6th Network Protocol

Please start "SQL Server Configuration Manager", open the left node "SQL Server Network Configuration" and select "Protocols for Name ". Enable the TCP / IP protocol and possibly also "named pipes". Please re-start the service, if the Protocol had not been activated.

7th Error log check

The error log can contain information when a connection was rejected. The log file can be in the Management Studio through node " server view \ Management \ SQL Server Logs "or the text file ERRORLOG directly in" C: \ Program Files \ Microsoft SQL Server \ MSSQL version MSSQLSERVER \ MSSQL \ Log \. " . open
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2020, Yet Another Forum.NET
This page was generated in 0.075 seconds.

EXPLORE TUTORIALS

© All Rights Reserved, AdminSystem Software Limited.