Security (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  1 month 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

  2 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

  5 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 n…

  captbob007

  5 replies

  7 months, 1 week ago

  By: Orlando Colamatteo

• Limit access using domain groups

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

  sqlvitoco

  2 replies

  8 months ago

  By: sqlvitoco

• 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 o…

  Brandie Tarvin

  22 replies

  9 months 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…

  Arsh

  7 replies

  9 months, 4 weeks 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

  10 months 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 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, 1 month 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, 6 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 …

  Guðjón Kr. Sigurðsson

  1 replies

  1 year, 8 months 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

  1 year, 10 months ago

  By: Erland Sommarskog

• ssis security

  Hi, we are saving passwords for all our packages in an xml file which is not very secure, is there …

  Tara-1044200

  1 replies

  1 year, 11 months ago

  By: Chris Harshman

• Permissions to access all sysusers records

  I have this problem I can not figure out.The users login to the database using their own SQL Server…

  JacekO

  12 replies

  2 years, 1 month ago

  By: Erland Sommarskog