• SQL 2000 migration to SQL 2005 – need to preserve user security

    Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an "orphaned" database.  Our app stops working if a database is simply detached/attached to...

    Vitomizer5 pointsBadges:
  • Free Chapter – Hardening a SQL Server implementation

    Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration. Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based...

    BrentSheets6,925 pointsBadges:
  • SQL Server Security Login does not work after restoring database on another computer

    I backup the production database on server named SQL1 then restored the database on server named SQL2. SQL server security login name "user1" has been created on both SQL1 and SQL2 servers. When I restore the database on SQL2 I have to re-map and give db_datareader access to the "user1" user name...

    Rick Martinez585 pointsBadges:
  • Don’t run the SQL Server Account as Local Administrator or member of the Administrator Group?

    Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group" Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...

    Aswad10 pointsBadges:
  • Access rights in SQL Server 2005 users

    Hello, I'm using Ms SQL Server 2005. I'm connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all righst on TBL_1 and...

    DetayMan5 pointsBadges:
  • Deny domain administrators to select from sql server tables ( SQL server 2005)

    I have added the "domain admin" group to the Sql Server, and set permission as "Deny" to connect to the database engine. All employees of this group can still select from any table. The sql server "public" role does not have any permissions on any database table. The "domain admin " group has local...

    IgorS5 pointsBadges:
  • Row-level security in SQL Server 2012

    I've noticed something different about the row-level security in SQL Server 2012. In earlier versions, the only was views. Now in 2012, they announced something like this:Row Level Security in Tabular ModelsCan someone explain to me what this is?

    ITKE342,785 pointsBadges:
  • Security for SQL Server 2012 SSAS

    So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

    ITKE342,785 pointsBadges:
  • Encypting a customer table in SQL Server 2012

    I have a customer table with contains several columns (names, address and contact info). Now, there are over 15000 records so I'm trying to figure out if I should encrypt the entire table of just several specific columns. How can I do this on a production database? Thanks!

    ITKE342,785 pointsBadges:
  • Setting up access rights in a SQL Server 2005 database

    Hello, I'm using MS SQL Server 2005. I'm connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let's say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will have all rights on...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Encrypt a Column in SQL Server 2005

    I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is...

    Jfw10075 pointsBadges:
  • What are the security risks of using hosted SQL

    B"H Where ever I look I see that no one recommends having your SQL Server available on the Internet (public ip). Everyone says that you should only have local machines access your sql. If you need to access your sql then you should VPN into your secure network and then have access. or you should...

    Mplotkin5 pointsBadges:
  • VPN Hollander Powerlink Server issues

    I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having trouble making the...

    greatjubee165 pointsBadges:
  • Name Pipe work arounds in SQL 2005 database

    I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue I...

    greatjubee165 pointsBadges:
  • SQL Injection in my network

    How can I protect against SQL injections and remove the injection point?  Also, how can I remove an injection that my antivir has detected?  My computer is running extremely slow and I'd like to know what information has been compromised.

    ML35 pointsBadges:
  • Is there a way to find out when a patch was last applied to an instance?

    Is there a way to find out the date a SQL Server instance was last patched?  I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack.  I looked in the ServerProperty function but did not see anything that would return this...

    Mrhr246120 pointsBadges:
  • Free IT Book: Securing SQL Server by Mrdenny!

    This week's free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He's always providing quality and thoughtful answers, and we're excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from...

    MelanieYarbrough6,345 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • SQL Server and AntiVirus

    We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?

    Rick Martinez585 pointsBadges:
  • DBCCShrinkDatabase as Security Cleanup Measure?

    Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming...

    KansasCoder40 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following