Forum Replies Created

Viewing 15 posts - 751 through 765 (of 6,105 total)

  • RE: KERBEROS

    Tracey, have your AD administrator PM me and I can discuss it with him/her off-line. Sounds like there's just a simple misunderstanding or misconfiguration going on.

  • RE: Remove from users view all the sys.objects

    Outstanding. I didn't know Dreamweaver had that capability.

  • RE: MBSA and SQL Server 2005 groups

    To be honest, I'm not a big fan of MBSA. I use it to check patch levels and do password checks, but when it comes to SQL Server, I don't...

  • RE: Remove from users view all the sys.objects

    You could if you can specify a WHERE clause. Unfortunately, I'm not familiar with Dreamweaver, so I don't know if that's possible. What's going on with sys.objects is in SQL...

  • RE: Insert permissions

    Do you mean the user is a member of the db_datawriter role? Being a member of db_datareader and db_ddladmin in this instance is irrelevant. Neither give access to INSERT into...

  • RE: Configuring Kerberos Authentication

    The SPN does not need to be recreated when SQL Server is stopped and restarted. The only reason this would be necessary is the SQL Server is using dynamic ports...

  • RE: Login Permissions

    GUI: Adding a SQL Login to SQL Server

    It's how to add, but it shows the basic mechanism. You would just right-click on the login and choose Properties to get to...

  • RE: Attach/detach permissions

    I'd go with the SQL Server 2000 BOL, then. I'm looking at the 2005 BOL which lists db_owner.

  • RE: Attach/detach permissions

    hawkeyeboy (1/13/2009)


    I need to grant a user permissions to detach/attach and export data.

    I also need to grant a user export only permissions.

    Best advice?

    Attach = I think as a member of...

  • RE: KERBEROS

    Have you done troubleshooting with KerbTray running on the client computer?

  • RE: Actual Sql Server Name

    dpkngm (1/13/2009)


    Actually i am trying to replicate database from one server to another server. When i click on the replication->Configuration Distribution m receiving an error saying SQL Server replication requires...

  • RE: KERBEROS

    And use Kerbtray in your troubleshooting. That will show you if the tickets are being created correctly.

  • RE: Secuirty in stored procs with passphrase

    The best way to do this is not to store the password/passphrase at all. Rather, store a hash of the password/passphrase. You can get that by using a cryptographic hash...

  • RE: KERBEROS

    But there's a significant difference between configuring for Kerberos authentication and Kerberos delegation. Kerberos delegation requires configuration beyond the SPNs.

  • RE: KERBEROS

    Are both SQL Servers set up for Kerberos authentication (including SPNs in Active Directory) and the first SQL Server set up further for Kerberos delegation to the second?

Viewing 15 posts - 751 through 765 (of 6,105 total)