nickbro

On that one I have no idea, are you accessing HAP+ internally via a proxy server?

Nope, HAP+ should be run on a Member server in 2008 onwards. Extremely odd that the role system isn't working correctly. Are you using Windows or the default authentication system?

Ok, very odd. Does adding back the deny users="*" causes the issue to happen again now? You can try re-entering your ad stuff and re saving.

Do have windows firewall on the servers turn on? What's the connection string you are using?

Make sure the app pool is set to use ASP.net 4, it's trying to load 3.5 there

Have a look at the hapConfig.xml file in the app_data folder, looks like the AD settings are wrong

You should be able to work out, from the 1st script, the table structures

This scripts, creates the database as well (you need to change the paths at the top, as I've generated these from SQL 2012 USE [master] GO /****** Object: Database [hap] Script Date: 12/06/2013 12:09:53 ******/ CREATE DATABASE [hap] CONTAINMENT = NONE ON PRIMARY ( NAME = N'hap', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\hap.mdf' , SIZE = 129024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'hap_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\hap_log.ldf' , SIZE = 10240KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [hap] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [hap].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [hap] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [hap] SET ANSI_NULLS OFF GO ALTER DATABASE [hap] SET ANSI_PADDING OFF GO ALTER DATABASE [hap] SET ANSI_WARNINGS OFF GO ALTER DATABASE [hap] SET ARITHABORT OFF GO ALTER DATABASE [hap] SET AUTO_CLOSE OFF GO ALTER DATABASE [hap] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [hap] SET AUTO_SHRINK ON GO ALTER DATABASE [hap] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [hap] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [hap] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [hap] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [hap] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [hap] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [hap] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [hap] SET DISABLE_BROKER GO ALTER DATABASE [hap] SET AUTO_UPDATE_STATISTICS_ASYNC ON GO ALTER DATABASE [hap] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [hap] SET TRUSTWORTHY OFF GO ALTER DATABASE [hap] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [hap] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [hap] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [hap] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [hap] SET RECOVERY SIMPLE GO ALTER DATABASE [hap] SET MULTI_USER GO ALTER DATABASE [hap] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [hap] SET DB_CHAINING OFF GO ALTER DATABASE [hap] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [hap] SET TARGET_RECOVERY_TIME = 0 SECONDS GO USE [hap] GO /****** Object: User [iis apppool\hap] Script Date: 12/06/2013 12:09:53 ******/ CREATE USER [iis apppool\hap] FOR LOGIN [iIS APPPOOL\HAP] GO ALTER ROLE [db_owner] ADD MEMBER [iis apppool\hap] GO /****** Object: Table [dbo].[TrackerEvents] Script Date: 12/06/2013 12:09:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TrackerEvents]( [id] [int] IDENTITY(1,1) NOT NULL, [LogonDateTime] [datetime] NOT NULL, [username] [nvarchar](50) NOT NULL, [ComputerName] [nvarchar](50) NOT NULL, [LogoffDateTime] [datetime] NULL, [domainname] [nvarchar](50) NOT NULL, [ip] [nvarchar](50) NOT NULL, [logonserver] [nvarchar](50) NOT NULL, [os] [nvarchar](50) NOT NULL, CONSTRAINT [PK_TrackerEvents_1] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[WebTrackerEvents] Script Date: 12/06/2013 12:09:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WebTrackerEvents]( [id] [int] IDENTITY(1,1) NOT NULL, [DateTime] [datetime] NOT NULL, [username] [nvarchar](50) NOT NULL, [ComputerName] [nvarchar](50) NOT NULL, [EventType] [nvarchar](50) NOT NULL, [iP] [nvarchar](50) NOT NULL, [browser] [nvarchar](50) NOT NULL, [OS] [nvarchar](50) NOT NULL, [Details] [nvarchar](max) NOT NULL, CONSTRAINT [PK_WebTrackerEvents_1] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO USE [master] GO ALTER DATABASE [hap] SET READ_WRITE GO

Try this USE [hap] GO /****** Object: Table [dbo].[TrackerEvents] Script Date: 12/06/2013 12:07:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TrackerEvents]( [id] [int] IDENTITY(1,1) NOT NULL, [LogonDateTime] [datetime] NOT NULL, [username] [nvarchar](50) NOT NULL, [ComputerName] [nvarchar](50) NOT NULL, [LogoffDateTime] [datetime] NULL, [domainname] [nvarchar](50) NOT NULL, [ip] [nvarchar](50) NOT NULL, [logonserver] [nvarchar](50) NOT NULL, [os] [nvarchar](50) NOT NULL, CONSTRAINT [PK_TrackerEvents_1] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[WebTrackerEvents] Script Date: 12/06/2013 12:07:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WebTrackerEvents]( [id] [int] IDENTITY(1,1) NOT NULL, [DateTime] [datetime] NOT NULL, [username] [nvarchar](50) NOT NULL, [ComputerName] [nvarchar](50) NOT NULL, [EventType] [nvarchar](50) NOT NULL, [iP] [nvarchar](50) NOT NULL, [browser] [nvarchar](50) NOT NULL, [OS] [nvarchar](50) NOT NULL, [Details] [nvarchar](max) NOT NULL, CONSTRAINT [PK_WebTrackerEvents_1] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

Ok, which version of HAP+ are you using?

Ok, can you try this

When are you getting the error? After you log in, or when you browse a folder?

Hmm, odd it should work with that. I don't know what to say, the MS SQL doesn't seem to like the SQL script that generates the database

Seems you have a folder with a < sign in it

Major releases, it's everything except for the app_data folder Minor releases, it's the upgrade zip which has the upgraded files needed.

Which version of SQL are you using?

That's a very strange issue, I know I had an issue with my alpha release, but that was an internal only alpha, never shared.

You shouldn't need to, you should be able to open the .sql file in notepad and run the query on the db

You should of been able to upgrade from the old version, if you'd backed up the App_Data folder. It's a known issue with some AD setups which HAP+ can't communicate with it

OPen ~/web.config with notepad, look for the svg line and remove it

How very odd, I don't quite know what to say here, something isn't working properly and I don't quite know what

Try this connection string Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; Where User Id and Password are a user account on that SQL server mapped to that SQL database

Hi Paul-K, it's coming in the next release. Odd that it's stuck in an infinite redirect

Ok, can you look at the ~/app_data/tickets.xml and see if there is a ticket with 5 as the id

That error is telling you that the current user cannot be found the drop down list, make sure that the user you are using is in an OU which is parsed.