| ArGoStuff User to User Support Forums |
Connection string for remote SQL server? Last Post 17 Sep 2009 08:18 AM by Steve Topilnycky. 3 Replies. | Sort: |
|  Prev Next | You are not authorized to post a reply. | |
Shadow D. Wolf
New Member
Posts:8
 | | 15 Sep 2009 03:43 AM |
| I'm going to be moving to another host soon; one that offers hosted SQL 2005, so I no longer have to install and mantain MS SQL Express on my own machine. That said, I'm utterly stumped as to how to create a connection string that will allow Mail Server.NET to communicate with the seperate SQL server, as my experience in dealing with MS SQL is roughly nil.
The host has given me the following information to work with:
- DB Name
- User Name
- Password
- DB Host (internal & external IP addresses)
- SQL Server Authentication is enabled
Google's been amazingly unhelpful with this so far. I've played a bit with it on my own, but I suspect that even if I do stumble upon a way to do it, it probably wouldn't be secure.
So, what should my connection string look like? | | |
|
|
Steve Topilnycky
Forum Administrator
Veteran Member
Posts:1278
| | 15 Sep 2009 04:15 PM |
| Options -> Connection String
This will let you see the current connection string. Will the new host also be hosting your install of ArGo Mail Server .NET? While you can connect to a remote database within your own network, I do not believe you can do this over the internet, if that is what your intent is. | | - - - - - - -
Regards,
Steve Topilnycky
Top Cat Computing
http://www.topcatcomputing.com/ | |
| Shadow D. Wolf
New Member
Posts:8
| | 16 Sep 2009 01:21 AM |
| I found the Connection String window easily enough. The problem is, I'm at a loss as to what to type into it.  ArGo Mail .NET is installed on my VPS, as is the web interface (and most everything else). My VPS provider (Kick*ssVPS) is providing the SQL hosting (on a dedicated server, since databases as a general rule tend to perform poorly in a VM), and it's all on the same network in their colo, so it won't be traversing the Internet. | | | |
| Steve Topilnycky
Forum Administrator
Veteran Member
Posts:1278
| | 17 Sep 2009 08:18 AM |
| You would have to contact your VPS provider and ask them what you need. You can show them what the current connection string looks like. | | - - - - - - -
Regards,
Steve Topilnycky
Top Cat Computing
http://www.topcatcomputing.com/ | |
|
| You are not authorized to post a reply. |
|
|
|  | | Mail Server v1.0.8.3 |
- Added support of STARTTLS (STLS) command for SMTP, POP3, IMAP, and SMTP relay and delivery, which will
allow secure, fully encrypted connections, when possible;
| | 11/6/2011 1:10:34 PM |
| Mail Server v1.0.8.2 |
- Optimized delivery speed. In earlier versions each "tick" which was checking whether messages were
in the outbox queue, was picking up only one message at a time. Now it will attempt to pick MaximumAllowedThreads-ActiveDelivery threads
messages, which should considerably increase deliver speed;
- Optimized SEARCH and STATUS IMAP commands. They appear to be used very extensively by Android, and (not that extensively, but still) by
iPhone. Now users who use mobile phones to access their IMAP accounts will see considerable improvement;
- Optimized STORE IMAP command. Before storing of IMAP flags was occuring one message at a time, which seemed to be fine
with SQL server, but proved to be slow for SQLite... Now it happens with single SQL call.
| | 10/8/2011 7:59:35 PM |
| ArGoSoft Mail Server v1.0.8.1 | -
Fixed a bug: when using IMAP via Firefox with "When I delete a message, move it
to Trash folder" option, marking messages in the trash folder was causing high CPU usage,
and was taking some time, making the server pretty much non-responsive. The problem was
happening only when using SQLite.
| | 6/6/2011 9:33:36 PM |
| ArGoSoft Mail Server v1.0.8.0 |
- Fixed a problem with web interface - was showing only first page of messages, and would not
switch to other pages; In order to fix the web interface, mail server itself has to be updated;
- When installint initially, was still using SQLite, even when SQL was requested;
- There was a problem with switching from SQLite database engine to SQL server database engine:
the SQL database was not being created;
| | 5/23/2011 5:53:55 PM |
| ArGoSoft Mail Server .NET v1.0.7.9 |
- The server no longer requires Microsoft SQL Server. If SQL server is not found, it will use
SQLite engine, which does not require separate installation. If SQL server is found, then user will be
prompted whether he wants to use it;
- Made other improvements, such as, now mailbox rebuild indexes orphaned records, rather then deleting them,
also added an opotion to increment UIDL validity of folder (both on the Mailbox viewer box);
- Made minor improvements on web interface;
| | 4/26/2011 9:47:25 PM |
| |
|  |  | |  |
|