Forum Replies Created

Viewing 15 posts - 16 through 30 (of 121 total)

  • RE: Resource Governor & Contained Database Users

    thomasliddledba - Tuesday, February 7, 2017 12:27 PM

    GoldenDBA
    If you are trying to use Resource Governor on a server with contained and non-contained databases,...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SQL In-Place Upgrade Issue

    Perry Whittle - Thursday, January 19, 2017 2:26 PM

    Can you post the results of the followingSelect serverproperty('edition'), @@version

    Sure

    Enterprise Edition: Core-based Licensing (64-bit)
    Microsoft SQL...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SSRS 2016 Branding Package - Colors.json Layout Template

    Actually I found a pretty good site here:
    http://www.enhansoft.com/blog/matching-ssrs-brand-colors-with-ssrs-site-items

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SQL In-Place Upgrade Issue

    Steve Jones - SSC Editor - Monday, January 16, 2017 4:37 PM

    Are you sure this is SQL 2016 RTM media? Have you used...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SQL In-Place Upgrade Issue

    Perry Whittle - Monday, January 16, 2017 10:44 AM

    not a CTP installation is it?

    No, it's an RTM version

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SSRS Report Samples

    Sorry, I realized I put this in the wrong bucket.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Opening Default Solution

    I'm trying to get SSMS to "automatically" open the solution every time I click the icon. If there is no other way then I suppose I could just create...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Allowing access to DECRYPTBYKEY function

    Found it. You have to give both the view definition and control permissions to the key and the certificate.

    GRANT VIEW DEFINITION ON SYMMETRIC KEY::SymmetricKey1 TO test;

    GO

    GRANT VIEW DEFINITION...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: License File Error on Reinstall

    It shows as upgraded successfully.

    Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

    May 14 2014 18:34:29

    Copyright (c) Microsoft Corporation

    Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Functions vs Stored Procs

    Awesome, thanks for all the replies. I'll definitely go take a look.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Max Length of AD Names for Security

    What OS and SQL Server version are you using?

    Very interesting. I've tried it on multiple environments (2005, 2008R2, 2012)...the one I'm referencing here was tested on Windows Server 2008R2...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Max Length of AD Names for Security

    Perry Whittle (11/6/2014)


    SQLJocky (11/6/2014)


    .if you enter the entire login to the "Z" on the service account, it will fail.

    Yes of course how silly of me, you make no reference to...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Max Length of AD Names for Security

    The reason I ask is because I'm currently using a VBS script that I found that interrogates the same AD data as NET USER and NET GROUP. Both of...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Max Length of AD Names for Security

    Perry Whittle (11/6/2014)


    You're referring to service accounts, so can you confirm please.

    You're creating an AD group that's longer than 20 chars and adding as a login to a SQL server...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Max Length of AD Names for Security

    Jeff Moden (11/6/2014)


    SQLJocky (11/5/2014)


    But it still causes an issue when trying to use them in their full 21+ character format when adding to SQL services and when adding to SQL...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

Viewing 15 posts - 16 through 30 (of 121 total)