Windows 2008 R2 x64 and SQL x64 Support |
Post Reply 
|
| Author | |
jym5960 
Newbie 
Joined: 26 October 2010 Location: LILLE Status: Offline Points: 3 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Windows 2008 R2 x64 and SQL x64 SupportPosted: 26 October 2010 at 5:58pm |
|
Hi,
last year, i tried to setup SF with SQL2005 x64 without success, because paths were not correct. After having tried to change paths in SQL scripts, I gave up and setup an x86 SQL engine.
Nevertheless, my last Windows 2003 x86 servers must disappear next year. Most of them (VM) have already been replaced with Windows 2008 R2 x64.
Will you provide nearly x64 SQL scripts for correct setup with MS SQL 2008 R2 x64?
Thanks by advance.
|
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 26 October 2010 at 9:47pm |
|
jym5960,
Just yesterday we discovered (one of our users actually did) an issue with SpamFilter and SQL Server on x64 servers when using the SQL Native Client to connect to SQL Server. A patch is already available for download (SpamFilter build 4.2.4.838). As a side-note, while the patch is required with SpamFilter Enterprise, there is a simple workaround when using SpamFilter ISP "standard". With the standard version, you can go to the "Settings - Database Setup" tab, then go to the "Step 1" tab in the wizard tabs, and manually select the "MS SQL Server" radio button, without clicking on the "Check DB Connection String", and then going thru the other two steps in the setup.
|
|
|
|
|
yapadu
Senior Member 
Joined: 12 May 2005 Status: Offline Points: 297 |
Post Options
Thanks(0)
Quote Reply
Posted: 29 October 2010 at 6:35pm |
|
I am having troubles on a new x64 based system as well, using mysql. Spamfilter can not see the datasource. Have not found a solution (am running 4.2.4.838).
Have been trying to use a mysql oledb provider which I have not been able to get working either. Should spamfilter be able to work with a mysql oledb provider?
|
|
|
--------------------------------------------------------------
I am a user of SF, not an employee. Use any advice offered at your own risk. |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 30 October 2010 at 10:31pm |
|
yapadu,
Can you please post/email us your connection string (or the contents of the UDL file if you are using them - you can edit such files with notepad to see its content)?
|
|
|
|
|
yapadu
Senior Member
Joined: 12 May 2005 Status: Offline Points: 297 |
Post Options
Thanks(0)
Quote Reply
Posted: 31 October 2010 at 1:56pm |
|
I finally figured out my issue. My first x64 bit server, I installed the ODBC driver but SF could not see it.
Turns out because SF is 32 bit it can not see the 64 bit ODBC setup. You need to run the 32bit ODBC administrator and define the data source there, then SF is able to see and use it. |
|
|
--------------------------------------------------------------
I am a user of SF, not an employee. Use any advice offered at your own risk. |
|
|
|
|
merrysmith
Newbie
Joined: 17 January 2019 Location: newyork Status: Offline Points: 1 |
Post Options
Thanks(0)
Quote Reply
Posted: 17 January 2019 at 6:02am |
|
I am also facing the same issue and it was showing Windows 10 Preparing Automatic Repair Error. Can anyone give any solution?
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions 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 |
This page was generated in 0.168 seconds.