SQL Server 2005 Security

• Topics

  Started by

  Posts

  Last post

• Error :15274 Access to the remote server is denied because the current security context is not trusted.

  I have a service broker which calls a stores procedure sp_dequeue queue --> ACTIVATION ( ST…

  ranjeeth.pt

  6 replies

  1 year, 8 months ago

  By: MMartin1

• Which is better, certificates OR asymmetric keys for encrypting symmetric keys used for data encryption?

  In http://msdn.microsoft.com/en-us/library/cc837966.aspx it is stated that, in terms of encrypting …

  Marios Philippopoulos

  8 replies

  1 year, 11 months ago

  By: SecurityDBA

• Explicit Permission not visible after save

  After going into the Securables | Explicit Permissions for my db Role I see that all of the explici…

  tripower

  1 replies

  3 years, 3 months ago

  By: tan110

• The EXECUTE permission was denied on the object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'.

  Problem Statement: I have some users that are not a part of any server role (except the default pub…

  91rghf

  18 replies

  3 years, 7 months ago

  By: stefan.quinn

• SQL Server Active Directory helper?

  Hi I am not able to start SQL Server Active Directory helper in my server 2003. What is the use of …

  mayurambokar

  4 replies

  5 years, 9 months ago

  By: Jonathan AC Roberts

• Encrypt the whole database

  Hi Techies, I have requirement to encrypt the whole database ( all data in all tables ) so that …

  SQL Dev-938873

  12 replies

  6 years, 11 months ago

  By: dan.henwood

• GRANT EXECUTE ... TO [blah] AS [dbo] - What does the "AS DBO" do exactly?

  GRANT EXECUTE ON [dbo].[SomeSproc] TO [Some_User] AS [dbo] What EXACTLY does the "AS DBO" part do? …

  Maxer

  15 replies

  6 years, 11 months ago

  By: SoHelpMeCodd

• Could not locate entry in sysdatabases for database.

  Hi All, Please help me as I'm getting this error : "Could not locate entry in sysdatabases for data…

  Nitin Gupta - SQL DBA

  7 replies

  7 years ago

  By: varunchopra.apj

• XP_CMDSHELL access denied when accessing shared location

  Hi , When try to access or create a file in shared UNC path with full rights, I m getting access de…

  Ranga_CDS

  7 replies

  7 years, 2 months ago

  By: Michael_O

• Create and Alter Table Permission only for specific schema

  Hello experts, I need advice on how to grant create table, alter table and create procedure permiss…

  shadow_2

  6 replies

  7 years, 2 months ago

  By: Jeff Moden

• XP_CMDSHELL fails execution

  Hi All, Got a SQL Server 2005 problem whereby we get the following error: ExecuteDTS (X import):[Mi…

  John Parker-202766

  9 replies

  7 years, 2 months ago

  By: Jeff Moden

• List all logins, databases, role mapping

  Hi there, I'm looking for a query or script that can generate a list of all SQL Server login's on a…

  EVCCDBA

  9 replies

  7 years, 3 months ago

  By: Fandango68

• Run As Account does not exist on the target system or does not have enough permissions

  Hi, I got the below error couple of the times and Reboot is fixing the issue.. I want to fix it per…

  dm_tapas

  2 replies

  7 years, 10 months ago

  By: Lowell

• Signatures & Database Triggers

  Is it possible to add a signature to a database trigger? If so, then how? Someting like: ADD SIGNA…

  solomon.yakobson

  10 replies

  7 years, 11 months ago

  By: Solomon Rutzky

• DROP LOGIN

  Dear All, Could you please advise on the below error. Msg 15174, Level 16, State 1, Line 1 Login 'a…

  ravisamigo

  4 replies

  7 years, 12 months ago

  By: Miguel Angel Zavala Vizcaya-410089