Forum Replies Created

Viewing 15 posts - 796 through 810 (of 6,104 total)

  • RE: set up SPN in sql 2005

    You also probably want to create an SPN without the port for a default instance on SQL Server 2000/2005. In SQL Server 2008, this is most certainly the case if...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server - Domain controller

    When you look at the DNS server on the DC, what are the name servers (NS records) listed for the domain? If one is your Exchange Server, it's a secondary...

    K. Brian Kelley
    @kbriankelley

  • RE: what is the use of Raid ?

    Nicholas Cain (12/15/2008)


    RAID 10 has 4 cans and double the spray rate, however due to it being more cans it cost more (however the performance is better and more bugs...

    K. Brian Kelley
    @kbriankelley

  • RE: Security and schemas: an example please?

    This sounds an awful lot like a classroom assignment. Even if it's not, can you post what your thoughts are so we know kind of where your starting point is,...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server - Domain controller

    Perry Whittle (12/15/2008)


    ensure the virtual DC's clock is constantly in sync otherwise it could become orphaned from the domain

    This should be taken care of automatically thanks to the Windows Time...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server - Domain controller

    sean.mcneill (12/15/2008)


    You also want to ensure that the second DC has DNS installed and ensure all of your member machines have the IP for the second DC set as the...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server - Domain controller

    The second one also needs to be a global catalog server. By running dcpromo, you made the second system a domain controller, but making it a global catalog server is...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    Rob Symonds (12/15/2008)


    I should've checked before I posted: I can see using the query from the article that all the logins are using NTLM.

    I'm still not sure why I...

    K. Brian Kelley
    @kbriankelley

  • RE: Dec 12 - SQL Security Issue

    Luke L (12/12/2008)


    Actually I've been seeing reports of a new SQL Server vulnerability, this is a different one from the IE exploit.

    Here's the post from secunia...

    http://www.sec-consult.com/files/20081209_mssql-2000-sp_replwritetovarbin_memwrite.txt

    This was originally reported as...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    schwizzla (12/12/2008)


    This is a great article. I never clearly understood why I was getting the informational message in my SQL Error logs

    "The SQL Network Interface library could not register the...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    Neither the local System nor the Network Service account is recommended for the SQL Server service account. Your best bet would be to get a domain or account administrator in...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    Mark Scro (12/11/2008)


    Great article. Do you have a version of query that will work with SQL 2000?

    Thanks

    Unfortunately, no. SQL Server 2000 does not provide that sort of information in...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    jabbott (12/11/2008)


    Great article, I really needed this!

    Do I have to go to each server and create the SPN's or can I install SETSPN.EXE on my local...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    Kevin Rathgeber (12/11/2008)


    Mr. Kelley, did I maybe get this wrong in what I was explaining above. Setting the NTAuthenticationProviders to NTLM, is it possible that I am getting mixed...

    K. Brian Kelley
    @kbriankelley

  • RE: Configuring Kerberos Authentication

    Kevin Rathgeber (12/11/2008)


    Yes I agree it does. I understand where you are coming from....the funny part....the Microsoft guys told us not to look at what they had published. ...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 796 through 810 (of 6,104 total)