locked
App-V 5.1 Permissions.sql issues RRS feed

  • Question

  • This has been very difficult install APP-V 5.1, I am having to run the script files manual to install the database  

    I am on the last part setting the permissions on the database

    Here is the SQL Query

    RAISERROR('Granting access on SchemaChanges table to Public role', 0, 1) WITH NOWAIT
    GO
    /* Grants access on SchemaChanges table to Public role */
    GRANT SELECT ON dbo.SchemaChanges TO PUBLIC
    GO
    RAISERROR('Setting up server login and db login for read-access to SchemaChanges table', 0, 1) WITH NOWAIT
    GO
    /* Setting up server login and db login for read-access to SchemaChanges table */
    EXEC dbo.spSetupLogin '0x[S-1-5-21-608344308-3719020910-3434760552-500]', N'[summit\administrator]', 0
    GO
    RAISERROR('Setting up server login, db login and db roles for write-access to AppVReporting database', 0, 1) WITH NOWAIT
    GO
    /* Setting up server login, db login and db roles for write-access to AppVReporting database */
    EXEC dbo.spSetupLogin '0x[S-1-5-21-608344308-3719020910-3434760552-500]', N'[summit\administrator]', 1
    GO

    This is the error I am getting

    anting access on SchemaChanges table to Public role
    Setting up server login and db login for read-access to SchemaChanges table
    Msg 257, Level 16, State 3, Procedure spSetupLogin, Line 0 [Batch Start Line 28]
    Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.
    Setting up server login, db login and db roles for write-access to AppVReporting database
    Msg 257, Level 16, State 3, Procedure spSetupLogin, Line 0 [Batch Start Line 35]
    Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.

    Wednesday, February 22, 2017 5:30 PM

Answers

All replies

  • Just an update, I found this link

    https://blogs.technet.microsoft.com/appv/2013/05/06/how-to-install-the-app-v-5-0-database-and-management-server-using-sql-scripts-on-the-db/

    Followed the steps but it will not adjust the SID when pasted in.

    Please help

    Wednesday, February 22, 2017 6:47 PM
  • please have a look at this blogpost.

    Roy Essers

    Wednesday, February 22, 2017 10:39 PM