Security (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Limit access using domain groups

  I have the following scenario in a SQL Server 2008 R2 instace: - Domain group DOM\Group01:. User DO…

  sqlvitoco

  3 replies

  4 days, 1 hour ago

  By: RobertSSmith

• Lost the database master key password

  Dear Everyone We are upgrading our SP application and database from SP2010 to SP2013 and our databa…

  hurricaneDBA

  6 replies

  2 weeks, 1 day ago

  By: hurricaneDBA

• Alerting when a login is created

  Hi, I wonder if anyone can point me in the right direction. I would like a way to be alerted (prefe…

  Maddave

  11 replies

  3 months ago

  By: Admingod

• Query data from another database

  Hi, I have several databases but I only want to give a user the rights to do something on one datab…

  c.myny

  5 replies

  4 months, 4 weeks ago

  By: Erland Sommarskog

• Managing SSRS Reports with domain groups

  Hi,Im not sure if this is an SSRS issue or SQL server security issue but Ive created domain level g…

  Shabbaranks

  1 replies

  6 months ago

  By: Sue_H

• Restoring Server Certificate to new instance

  I have two instances, InstanceA running under accountA, and InstanceB running under accountB. Both …

  winston Smith

  8 replies

  9 months, 3 weeks ago

  By: freeman99z

• Allowing *ALL* users to access a database

  I didn't think opening a database up to all users would be this hard, but I'm getting nowhere fast …

  captbob007

  5 replies

  11 months, 1 week ago

  By: Orlando Colamatteo

• A call to ‘LogonUserW’ failed with error code : ‘1385’

  I'm pulling data from a NAS share and have recently run into the following error. An error occurre…

  Brandie Tarvin

  22 replies

  1 year ago

  By: Brandie Tarvin

• Grant Execute on an SP

  Hi All,I've two databases on a server , DB1 and DB2. There is User1 who has Read\Write on DB1 and n…

  Arsh

  7 replies

  1 year, 1 month ago

  By: Arsh

• Security context of a trigger

  Hi All,Would be great if any body can advise what security context a trigger runs using , once its …

  Arsh

  1 replies

  1 year, 1 month ago

  By: Erland Sommarskog

• Limit Concurrent Logins by database and/or user ID

  In my environment I have a sql server 2008 database on 64bit architecture. The production database …

  kwoznica

  23 replies

  1 year, 4 months ago

  By: Gail Shaw

• Logon failure: the user has not been granted the requested logon type at this computer.error for SQL Services even though account has Log on as a Service priveledges

  I have a 2008 R2 instance running on a Windows 2008 Virtual Machine.  After a server reboot I …

  craig.d.brown

  6 replies

  1 year, 5 months ago

  By: craig.d.brown

• First time CoBIT audit experience....

  We had our first CoBIT audit. From the sql side I can only say the auditors want us …

  Barkingdog

  3 replies

  1 year, 10 months ago

  By: Sue_H

• SSRS And Inconsistent Kerberos Authentication

  Hi, I'm having problems with Double Hop Scenario With Kerberos Authentication. IE On Windows Client…

  Guðjón Kr. Sigurðsson

  1 replies

  2 years ago

  By: wayne.yan

• Database Roles dbo_owner and db_datareader

  Hello all.. its been awhile and I have been way from SQL for a couple years.. Getting back into it …

  Steve Vassallo

  4 replies

  2 years, 2 months ago

  By: Erland Sommarskog