Well, I'm kind of frustrated. Yes, I know this is a Community thingy. And I am really grateful for the time and effort put in to developing YAF. I've been running it for quite some time, and built my own phpBB to YAF 1.9.1 converter that solved the bbcodes junk. But I'm a database guy and down in the data I'd like to solve the issue. What I really love with YAF is the Clean database schema. Well, for large sites there are needs. The database could really use a higher grade of normalisation. But anyway...
From day one there been issues with installing YAF. There are bad T-SQL, for example you should never use aliases that might generate error when different collations are in Place. The v, w thing in VIEWS.SQL for example. Ok, if you know your SQL you can easily fix that.
The upgrade between 1.9.4 to 1.9.5 worked close to smoothly. The VIEWS.SQL issue needed to be solved. Logon was possible.
The upgrade from 1.9.4 straight to 1.9.6 failed with a number of issues.
The upgrade from 1.9.5 to 1.9.6 had some problems. The DLLs in BIN, the WEB.CONFIG cleanout and merge....
When I was done with the INSTALL part it all looked great, the password failed during logon.
I created a new user, email activation and all. Even that user fails to logon.
I'm not the only one with these issues.
Yes, this is my second post. Trust me I've read every topic that is close to my problem. After I read Colleens questions and felt with hers frustration I felt I needed to post a question as well. Even is it's asked Before as this issue not have been solved.
But ok...
I'm running YAF on a Windows Server 2008R2, IIS7.5, Another Windows Server 2008R2 running SQL Server 2012, A third Windows Server 2008R2 as a domain controller for my DMZ.
I'm doing Windows Authentication, SSPI, forced Kerberos, as well as Domain Isolation using IPSEC.
During install I allow "Everyone" "Full Control" in the installdirectory. yes, of course do I stop access through my firewall Before I change the permissions, and after the install I remove the added permissions. There are only read permissions during normal usage besides for the upload directory. I also gives the YAF SQL login sysadmin role-membership during install just to make sure Everything may be created.
Yes, the SQL Server is a dedicated server.
Yes, I know alot abot Active Directory. I'm one of the lucky few that workes with Active Directory since 1998. And most of you ppl know it Went public with Windows Server 2000. I'm also a SQL Server MVP. And a WIndows Server Technologies trainer. My focus is Active Directory, and SQL Server. I'm not a .Net Developer, even if I proably can read through all the sourcecode and figure this out. I do have alot of other work to do besides running this free Community I'm running. If you google me you'll probably find me... *smiles
/Matt