I am trying to install Telligent Community on Windows Server R2 with a database on a separate machine. I have followed the documentation below:
I have all the roles selected but I am still getting
"The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'Chambers Connect', schema 'dbo'."
This tutorial worked on my local machine but now I am deploying to a web server Windows 2008 R2 and Sql Server 2005 which on a separate machine. I am using SQL server authentication.
Any suggestions would be much appreciate, thanks in advance.