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 [...]
Answer Question
| March 31, 2012 2:20 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
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 [...]
Answer Question
| March 31, 2012 2:20 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
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.
Answer Question
| March 31, 2012 6:40 PM
SQL injection, SQL Injection Validation, SQL Security, SQL Server security
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.
Answer Question
| March 31, 2012 6:40 PM
SQL injection, SQL Injection Validation, SQL Security, SQL Server security
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 [...]
Answer Question
| March 31, 2012 12:41 AM
SQL 2005, SQL Express, SQL Server, SQL Server administration, SQL Server security
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 [...]
Answer Question
| March 31, 2012 12:41 AM
SQL 2005, SQL Express, SQL Server, SQL Server administration, SQL Server security
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 [...]
Answer Question
| March 31, 2012 3:34 AM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3
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 [...]
Answer Question
| March 31, 2012 3:34 AM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3
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
Answer Question
| April 9, 2011 7:15 AM
SQL Backup, SQL Data Types, SQL Server backup, SQL Server database, SQL Server security
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
Answer Question
| April 9, 2011 7:15 AM
SQL Backup, SQL Data Types, SQL Server backup, SQL Server database, SQL Server security
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 Attackers. Denny is a Microsoft SQL Server [...]
Answer Question
| February 21, 2012 8:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, SQL Server security, Storage, Virtualization, VoIP, Windows Server
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 Attackers. Denny is a Microsoft SQL Server [...]
Answer Question
| February 21, 2012 8:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, SQL Server security, Storage, Virtualization, VoIP, Windows Server
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?
Answer Question
| March 2, 2011 4:46 PM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003
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?
Answer Question
| March 2, 2011 4:46 PM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003
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 that this will [...]
Answer Question
| January 24, 2011 9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database
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 that this will [...]
Answer Question
| January 24, 2011 9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database
Adding another level of security to SQL 2005 database
We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security – requiring a SQL username and password along with a valid user name and password on the domain?
Answer Question
| January 12, 2011 4:17 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication
We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security – requiring a SQL username and password along with a valid user name and password on the domain?
Answer Question
| January 12, 2011 4:17 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication
How to create data security in SQL server 2005 so that the code will not be opened
how to create data security in sql server 2005 so that the code will not be opened
Answer Question
| December 13, 2010 9:52 AM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server security
how to create data security in sql server 2005 so that the code will not be opened
Answer Question
| December 13, 2010 9:52 AM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server security
Database Security: SQL Server 2005 security login
Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me……….
Answer Question
| August 23, 2010 12:51 PM
Database security, SQL Server 2005, SQL Server 2005 security, SQL Server security, SQL Server Security Login, Windows XP
Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me……….
Answer Question
| August 23, 2010 12:51 PM
Database security, SQL Server 2005, SQL Server 2005 security, SQL Server security, SQL Server Security Login, Windows XP
Kerberos unconstrained delegation for MS SQL svc account
Can an MS SQL service account run non-SQL services if “trust this user for delegation to any service (Kerberos only) has been enabled?
Answer Question
| August 26, 2010 2:11 AM
Kerberos, MSSQL, SQL Server permissions, SQL Server security
Can an MS SQL service account run non-SQL services if “trust this user for delegation to any service (Kerberos only) has been enabled?
Answer Question
| August 26, 2010 2:11 AM
Kerberos, MSSQL, SQL Server permissions, SQL Server security
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 another server because it loses that [...]
Answer Question
| June 17, 2010 2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade
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 another server because it loses that [...]
Answer Question
| June 17, 2010 2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade
Please explain SQL Ingestion with a example?
Please explain SQL Ingestion with a example?
Answer Question
| April 12, 2010 7:21 AM
SQL Server integration/interoperability, SQL Server security
Please explain SQL Ingestion with a example?
Answer Question
| April 12, 2010 7:21 AM
SQL Server integration/interoperability, SQL Server security
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 [...]
Answer Question
| September 11, 2012 10:17 PM
Hosted servers, Hosted services, SQL Server, SQL Server Hosted Servers, SQL Server security
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 [...]
Answer Question
| September 11, 2012 10:17 PM
Hosted servers, Hosted services, SQL Server, SQL Server Hosted Servers, SQL Server security
SQL Database User
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql login (user1). Can I create the sql login on server3 and copy the [...]
Answer Question
| September 15, 2009 9:22 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql login (user1). Can I create the sql login on server3 and copy the [...]
Answer Question
| September 15, 2009 9:22 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security
Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application. Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user. Is there a way to ”capture the SQL Server logged in user name” in the Access code? Probably in [...]
Answer Question
| August 27, 2009 11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application. Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user. Is there a way to ”capture the SQL Server logged in user name” in the Access code? Probably in [...]
Answer Question
| August 27, 2009 11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security
Changing the sql server service and agent windows account password
Hello, we are considering changing the sql server service and agent’s password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!
Answer Question
| August 5, 2009 4:09 PM
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services
Hello, we are considering changing the sql server service and agent’s password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!
Answer Question
| August 5, 2009 4:09 PM
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services
Encrypt the password in SQL 2000
How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to pass the encrpted [...]
Answer Question
| August 4, 2009 11:53 AM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB
How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to pass the encrpted [...]
Answer Question
| August 4, 2009 11:53 AM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB
Being notified when a delete operation is performed on SQL Server
How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?
Answer Question
| July 24, 2009 5:31 PM
SQL Server security
How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?
Answer Question
| July 24, 2009 5:31 PM
SQL Server security
