SQL Server 2005 Security

• Topics

  Started by

  Posts

  Last post

• How can I set the authentication mode for a SQLServer from TSQL

  hello everybody, Does somebody know how can I set the authentication mode for a SQLServer from TSQL…

  Alexandru Petre Ionescu

  9 replies

  15 years, 10 months ago

  By: shaunspad

• Trying to disable the lockout of the sa account

  It is a long sordid tale that no doubt will not meet approval, but all I can say is I have to do as…

  tony.roberts

  4 replies

  15 years, 10 months ago

  By: tony.roberts

• Grant ALL & Deny Delete

  I need to enable a User (in development) to basically do everything within a database (create table…

  rew-370421

  10 replies

  15 years, 10 months ago

  By: Lowell

• Designing security - SQL roles or Windows groups?

  Hello, I know this is a big topic, so I will try to narrow down my question as much as possible. I…

  webrunner

  5 replies

  15 years, 10 months ago

  By: webrunner

• Certificates

  What is the best practice for using certificates? 1. Is it best to have one certificate per databas…

  JWOL

  1 replies

  15 years, 10 months ago

  By: SQLRNNR

• Create table permission denied

  Good day everyone, Iam trying to create roles in the database; what permission should i give in ord…

  cute_lhen05

  9 replies

  15 years, 10 months ago

  By: Gail Shaw

• Grant Permission to database object

  Hi, I am using sql server 2005. I have created a new database. and in that database, i have created…

  mhac_0301

  1 replies

  15 years, 10 months ago

  By: GRE (Gethyn Ellis)

• Script to add or restore a user to all 50 store procedures

  Hi when i have restored database from production to UAT .as production users will be different for…

  tabrez.test

  4 replies

  15 years, 10 months ago

  By: Phil Factor

• Is there a way to prevent any user other than sa access to SQL server 2005

  I have a question and I hope you will help Is there a way to prevent any user other than sa access …

  osama.g.y.a

  5 replies

  15 years, 10 months ago

  By: sean redmond

• Encryption: column size

  Hi, I have a table to store user sensitive data. ... CMS_UserName VarChar(25) Unique Not Null…

  c00ler01

  1 replies

  15 years, 10 months ago

  By: c00ler01

• Setup ADMIN Access to ONLY One Database

  How do I configure one User with ADMIN (sa) Access over their own database? There are multliple da…

  rew-370421

  5 replies

  15 years, 10 months ago

  By: rew-370421

• The mystery of the dropped login

  Hi everyone A fellow's login was dropped between Christmas and New Year and I'm looking to be point…

  sean redmond

  3 replies

  15 years, 10 months ago

  By: Jack Corbett

• Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  I have 2 servers, a web server and my SQL db server. One my db server I'm getting the following err…

  SQL_NuB

  14 replies

  15 years, 10 months ago

  By: Gift Peddie

• Required rights for setting "db chaining" database option (using sp_dboption)

  I am working with a 3rd party application that we are setting up on a SQL 2005 instance. The insta…

  Michael Lowery

  3 replies

  15 years, 10 months ago

  By: george sibbald

• Getting mac address using xp_cmdshell

  Hi Friends I am trying to write a sql script to extract the mac address of other sql clients in the…

  logicwonder

  2 replies

  15 years, 10 months ago

  By: logicwonder