hottroc
Forum Replies Created
-
OK finally got it working. I don’t know about Famous 5-minute install…for me it was an infamous 5-week install!
I’m not sure exactly what fixed it, I tried changing several settings on the webserver and the database, settings such as the ASP version the website used, the database Roles and various permissions on both. (Also tried 3 different webservers)
Maybe the instructions could be better in terms of what settings should be set or unset in case people haven’t got the norm (I don’t know why but I never seem to have the norm!).
Anyway thanks to everyone for trying to help and giving me some ideas what to check etc. I can at least confirm quite definitely that WordPress DOES work on Microsoft SQL Server 2008. Before I started this I read many topics where they said it didn’t, only on MySQL, but they are obviously wrong. If any Moderators are reading this, you ought to correct a few of those topics, some people might be put off using WP for that reason (I nearly was!).
I tried the suggestion but no luck. What can I try next?
My gut feeling is that this could be a problem with SQL server rather than any other elements of the equation. Apart from adding a database and login as per the WP instructions is there anything else I need to do, like Roles or anything? I’m not very SQLSrv savvy.
Or it might be some Permission problem somewhere perhaps? Doh, so many possibles.OK I’ll try out your suggestions and let you know how I get on. Bit tied up just now but soon. Thanks for your assistance.
OK, so should I use the 3.0 driver instead (I think I’ve tried both along the way). Also how am I supposed to know how my PHP was compiled? And which file in particular are you referring to?
Hi, you might be onto something here.
This is the section from phpinfo…sqlsrv
sqlsrv support enabledDirective Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On OnI have php5.dll in my folder so I guess it’s non-thread-safe. But I seem to have lots of relevant dll’s in the ext directory, both thread-safe and non-thread safe. None are quite the same as yours though as they all have _vc6 or _vc9 in the filename like…
php_sqlsrv_52_nts_vc6.dll
php_sqlsrv_52_ts_vc6.dll
php_sqlsrv_53_nts_vc6.dll
php_sqlsrv_53_nts_vc9.dll
php_sqlsrv_53_ts_vc6.dll
php_sqlsrv_53_ts_vc9.dllHow do I know which one it’s using?
Think I might try downloading them again.Thanks for your suggestions. I do wonder if this could be an incompatibility between different versions of the various components required. For example my version of SQL Server 2008 R2 native client is 10.50.1600.1 …When you said “Programs and Features menu of the server” you mean the Programs and Features from within Control Panel I presume? I couldn’t find mention of it anywhere else. And I can’t remember now whether I installed the non-thread safe version of PHP, I think it might have been the thread-safe version. Also I am using a 64-bit OS with a 64-bit browser too if that makes a difference.
Apart from that I think I’ve pretty much done the same.Hi, thanks for your reply.
I did everything you said in your first paragraph with no joy. However your second paragraph is interesting because my SQL Server version IS the 2008 one.
I can get the drivers showing in the dropbox so I think the PHP is set up. Phpinfo() can also be run and shows the drivers loaded. However it never seems to create the wp-config.php file like it should (I’ve checked the folder permissions!) so I have created it manually.
As you say a lot of settings and conditions to check. Unfortunately I’m just not finding the problem. When you say “SQL Native Client settings” what do you mean? I created the database using SQL Management Studio and created a Login as per the WordPress install instructions. At first the db was not in mixed mode but I changed that. Apart from that is there anything I should change?