Home » Support » Telligent Evolution Platform » Telligent Community » Discussions » Installation issue on Windows 2008 R2

Installation issue on Windows 2008 R2

Open Support Ticket

Call Support:
Direct: (214) 420-1337
Toll Free: (877) 522-6334

Monday through Friday
8 a.m. to 6 p.m. Central (GMT-6)

Join our Community
Details
  • 8 Replies
  • 1 Subscriber
  • Posted3 months ago
Options

Installation issue on Windows 2008 R2

This question is answered
chirdeeptomar
Posted by
on Thu, Feb 21 2013 2:47 PM

I am trying to install Telligent Community on Windows Server R2 with a database on a separate machine. I have followed the documentation below:

http://telligent.com/support/telligent_evolution_platform/community/w/community7/24664.install-telligent-community.aspx

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.

aspnet_Membership_FullAccess

aspnet_Profile_FullAccess

db_datareader

db_datawriter

Any suggestions would be much appreciate, thanks in advance.
Verified Answer
  • chirdeeptomar
    Posted by
    on Thu, Feb 21 2013 4:42 PM
    Verified Answer
    Verified by

    Fixed, for some reason, roles were not applied. I applied them again it worked.

All Replies
  • Michael Monteleone
    Posted by
    on Thu, Feb 21 2013 3:05 PM

    Hi. This is a pretty standard installation path. How are you authenticating against SQL?

    If you're using "trusted", have you ensured the same user assigned for the App Pool's identity is the same user granted role memberships on the database and that these aren't separate local accounts?

    If you're storing credentials in connectionStrings.config, have you tried logging into the SQL server directly through Management Studio using those credentials and attempting to execute the same stored procedure?
  • chirdeeptomar
    Posted by
    on Thu, Feb 21 2013 3:09 PM

    I am using Sql Server authentication and yes I have logged in using the same credentials through management studio. I also tried executing the stored procedure through management studio and i get  the same error.

  • Michael Monteleone
    Posted by
    on Thu, Feb 21 2013 3:20 PM

    I would double-check the roles again. Have you also assigned the user to the "db_ddladmin" role? I just noticed it wasn't listed alongside the others in original post.
  • chirdeeptomar
    Posted by
    on Thu, Feb 21 2013 3:47 PM

    Oh sorry I had just missed it while copying that here...but yes I have that role selected.
  • Michael Monteleone
    Posted by
    on Thu, Feb 21 2013 3:58 PM

    Ok, thanks. I would still suggest double checking role assignments. To help, here's a SQL script which can list all mappings of SQL users/roles for a database.

    SELECT

    mp.name AS db_user,

    rp.name AS db_role

    FROM YOUR_DATABASE_NAME.sys.database_role_members drm

    JOIN YOUR_DATABASE_NAME.sys.database_principals rp ON (drm.role_principal_id = rp.principal_id)

    JOIN YOUR_DATABASE_NAME.sys.database_principals mp ON (drm.member_principal_id = mp.principal_id)

    ORDER BY mp.name DESC
  • Alex Crome
    Posted by
    on Thu, Feb 21 2013 4:03 PM

    SQL 2005 is not a supported version of SQL Server for Telligent Community 7.
  • chirdeeptomar
    Posted by
    on Thu, Feb 21 2013 4:42 PM
    Verified Answer
    Verified by

    Fixed, for some reason, roles were not applied. I applied them again it worked.

  • Michael Monteleone
    Posted by
    on Thu, Feb 21 2013 5:02 PM

    Great. Alex does make a good point though... as of 7.0, SQL 2005 is no longer supported. There may be broken functionality.