Forum Replies Created

Viewing 15 posts - 796 through 810 (of 6,105 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...

  • 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...

  • 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...

  • 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,...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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. ...

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