Security

• Topics

  Started by

  Posts

  Last post

• Interesting behaviour when programmatically manage avail groups with SMO+PS

  It can make failover even if the user who runs the PS has only Connect SQL permission. What's more …

  basaj

  1 replies

  2 years, 10 months ago

  By: Site Owners

• DOMAIN\HOSTNAME$ Logins

  Hello, I take over a new production SQL Server from different department. When I check sql server l…

  myalliku

  3 replies

  5 years, 9 months ago

  By: myalliku

• Security violation for Database Mail XPs Option

  Hello folks, I m a newbie for SQL Server. I have a question about Database Mail XP violation for SQ…

  myalliku

  8 replies

  8 years, 6 months ago

  By: myalliku

• Anonymous access in SQL RS 2008

  Hi In SSRS 2008 their is no IIS required. So anonymous access is not possible by configuring IIS. I…

  vasamsetti_prasad

  38 replies

  8 years, 8 months ago

  By: renz.vidal

• Permissions writing files across servers

  I am having an issue with a dts package. I have a dts package scheduled to run at 12:25am and it g…

  tschuler-738392

  6 replies

  8 years, 10 months ago

  By: gobidettullo-5709

• xp_cmdshell security risk: Any other option

  Hi, I our SQL server project we are using xp_cmdshell to generate .txt or .csv file. As per SQL sev…

  nikhil.desai1

  5 replies

  9 years, 2 months ago

  By: Sergiy

• Minimum privileges

  SQL2000 What are the minimum privileges / permissions / database roles needed to grant a user (besi…

  asdsfssd

  3 replies

  9 years, 3 months ago

  By: Steve Jones - SSC Editor

• Risks/drawbacks of using ALTER TABLE NOCHECK CONSTRAINT FK_XXX on production system ???

  I have a selfreferenced foreignkey table . Deleting records from this table is complicated. I am us…

  jayrocks20

  1 replies

  9 years, 3 months ago

  By: Steve Jones - SSC Editor

• How to determine SQL Security Login group for windows login when user is member of active directory security group.

  My users login to SQLServer through Active Directory security group memberships.  These groups…

  Jamie Johnson-406551

  10 replies

  9 years, 5 months ago

  By: Lowell

• SSAS drillthrough with security returns empty rowset 2008R2

  Hello, We have a role that hides a detail attribute from a dimension by adding in "Dimension data"-…

  jon_curriculum

  1 replies

  9 years, 6 months ago

  By: kanagokul23

• Failure Reason: The specified user account has expired. Status: 0xc0000193 Sub Status: 0xc0000193 Process Information: Caller Process ID: 0x3bdc Caller Process Name: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe

  Hi all , we are getting this Below error can any one give solutions or guidance on it for troubles…

  naga.rohitkumar

  2 replies

  10 years, 2 months ago

  By: naga.rohitkumar

• What permissions are necessary to issue "ALTER TABLE ? NOCHECK CONSTRAINT ALL"

  When logged on as a particular user and attempting to run "ALTER TABLE <tblName> NOCHECK CONS…

  Jon Ryan

  4 replies

  10 years, 2 months ago

  By: HanShi

• Login Failed for user 'sa'

  This is on a SQL Server 2000 Machine. The SQL server does not have access to the internet and is be…

  GF

  7 replies

  10 years, 5 months ago

  By: GF

• Error while Assigning database level role (db_datareader) to SQL login (Domain Account)

  Team, I got an error while creating a User for Domain Account. Below is the screen shot of the erro…

  chetanr.jain

  2 replies

  10 years, 5 months ago

  By: chetanr.jain

• Design HELP FOR TO N FRO MOVEMENT OF DATA.

  What protocols or list of steps can be followed while pushing and pulling data from intranet to int…

  harsimranjeetsinghwasson

  6 replies

  10 years, 6 months ago

  By: harsimranjeetsinghwasson