Forum Replies Created

Viewing 15 posts - 4,636 through 4,650 (of 6,395 total)

  • RE: Folder Settings empty following Database restore

    So your using local accounts on the SSRS server, rather than AD accounts?

    The catalog table links to polices, and the catalog is the folder structure you see in SSRS.

    Also ReportServer...

  • RE: Query help!!

    Can you post table definitions, index definitions and sample data for all tables involved? Also if you have it the execution plan.

    Please see the second and forth links in...

  • RE: SSPI Handshake Error

    Service account changed for SQL? Does it have the ability to register / deregister SPN's in AD? SPN's configured and right? Rebooted domain controllers recently?

    That error is...

  • RE: Folder Settings empty following Database restore

    Strange, as SSRS uses the SIDS of the accounts so moving from one server to another shouldnt cause any issues with users, unless something has magically changed in your AD...

  • RE: Folder Settings empty following Database restore

    Did you backup and restore the reporting services encryption keys?

  • RE: Grant everyone permission to a database

    Yes it is the whole forest as long as the nessesary trusts have been setup between the domains.

  • RE: Grant everyone permission to a database

    NT AUTHORITY\Authenticated Users

    That group contains anyone who has a AD account, so will fit your needs.

  • RE: SSRS Scale out Farm - SQL 2012

    Yes you can install SQL 2008 Enterprise on Windows 2008 Standard, there is no problem with that, it then boils down to the resources you require as Windows Standard compared...

  • RE: Trying to Find the Right Font

    Personally I change the font to Courier New and leave the colouring and sizing alone as I am used to the keyword colours so changing them would make it confusing.

  • RE: Data is not refreshing in report each time I run the report....

    Koen is right, in the folder where the solution is stored there are files with the extension rdl.data, these are the cached files, if you delete them it will recache...

  • RE: TempDB Nightmare

    You will be lucky trying to find out what caused this unless you have some sort of custom monitoring tool which polls your server seeing that is going on.

    If the...

  • RE: Policy Based Management

    You would create a condition on the database facet, for the name object and give it the names of the DB's you want it to check, then it uses that...

  • RE: WHERE Clause, IF FLAG = 0 ignore the condition

    You could use dynamic SQL

    DECLARE @UseIt varchar(20)

    DECLARE @Grade int

    DECLARE @AppleFlag int

    DECLARE @PearFlag int

    DECLARE @BananaFlag int

    DECLARE @sql NVARCHAR(MAX)

    SET @Grade = 8

    SET @AppleFlag = 0

    SET @PearFlag = 0

    SET @BananaFlag = 0

    SET @sql...

  • RE: Running LogParser in Stored Proc

    You want to go for the lowest level of access, so I would create 2 domain accounts one for the SQLServer and one for the SQLAgent, just basic bog standard...

  • RE: Today's Random Word!

    Revenant (6/12/2012)


    SQLDBA360 (6/12/2012)


    anthony.green (6/12/2012)


    Daniel Bowlin (6/12/2012)


    anthony.green (6/12/2012)


    Ray K (6/12/2012)


    Stanley (as in Cup -- congrats, LA!)

    Knife

    Blade

    Wesley Snipes

    wesley sneijder

    tulips

    Amsterdam

Viewing 15 posts - 4,636 through 4,650 (of 6,395 total)