FIPS Compliance
Dec 8, 2006Is SQL Server CE's encryption capability FIPS 140-2 compliant?
ADVERTISEMENT
FIPS 140-2 In SQL Server 05 CE?
May 29, 2008Hello,
On the desktop, it is possible, through an OS setting, to automatically encrypt SQL Server 2005 databases with FIPS 140-2 compliant encryption algorithms.
My question is; is it also possible to do this with SQL Server 2005 Compact Edition database files on mobile devices?
Thanks!
SqlDependency And FIPS
Aug 30, 2007Hello!
I am developing with .NET 2.0 and SQL Sever 2005 on WinXP for a production system of Windows 2003 Server with FIPS enabled (http://www.itl.nist.gov/fipspubs/).
When our team tries to use SqlDependency, we get FIPS exceptions. I assume that this is because the inner workings use encryption algorithms that are not FIPS-compliant. Is there a way to configure my application (or even the entire machine) such that SqlDependency will use FIPS-approved encryption?
I guess my real question is how can I use SqlDependency on a FIPS-enabled machine?
We have been using SqlNotificationRequest, but I'm now developing a client, of which, we require multiple instances. So we've run into the problem where when multiple clients run, only one will receive and process a notification.
Thanks!
John
How To Enable FIPS And Keep SRS (for MOM Reporting) Working?
Mar 15, 2007Long Time Lurker, First Time Poster
Need to know how to enable FIPS and yet still keep SRS (for MOM Reporting) working? Is this even possible? SQL 2005 box sits in an OU where FIPS is enabled, serves MOM Reporting up.
Tried SSL-ing IIS and using TLS.
Tried enabling FIPS also in the local policy to ensure it was on when SQL started.
Even have SQL 2005 SP2 on there.
Everything works great if I disable FIPS and bounce it. Enable FIPS and bounce it and can't get to the SRS or MOM Reporting web pages, not locally or from a workstation.
Has anyone got this to work?
Does anyone see a reference stating that this is not supposed to work, by design, or whatever?
TIA,
KAZE33
MSSQL And Y2K Compliance
Feb 2, 1999Hi,
MS had come up with SQL 6.5 SP5 which fixes Y2K problems and hopefully
SQL 7.0 is already Compliant.
Now, I know that MS has beta tested before releasing these fixes. But as we all know, sometimes they do not behave the way they are supposed to. Therefore, I would like to make sure by running some tests against
SQL 6.5 SP5 just to make sure these claims are correct.
Does anydoby have a set of tests designed for this purpose which he would
be willing to share with the readers of this forum ?
Thanks you.
Ranjit
FDA Compliance And SQL 2000
Apr 20, 2007We have an application using SQL 2000 database that must be FDA compliant. Anyone with FDA compliance experience? Know any products that will audit database changes? How about validation of backups and restores.
Thanks!
Anyone Know Anything About Sql Server HIPAA Compliance??
May 2, 2007Does anyone know of a good tutorial for setting up a website for HIPAA compliance? In particular, what's involved in setting up Sql Server to be compliant?
I'm developing a simple c# website for a friend who owns a small company based in the medical field. Now that his company is growing, he wants to allow his doctors to log into his website to view their patients' test results rather than having to snail mail out the test results every day.
This brings us to a rather delicate issue because even though it's just a few simple pages on the website to view this test result data, I think we're now into HIPAA compliance territory. Meaning we'll have to look at more secure (and expensive) measures than what is currently being performed. For example, I was looking at a web hosting service that provides .net hosting & shared sql server for $15/month. Will I now need to look into a $199/month dedicated server (which probably would cancel the project since, as I said, it's just a simple website with a few small simple features).
Thanks for any help on this.
-Goalie35
XML Newbie: Sql 2005 Compliance To XML Standards
Nov 24, 2006I was told that XML names must not start with the letters xml (or XML, or Xml, etc) But I was able to store such data in sql 2005. Any thoughts on this one?
TIA,
Barkingdog
IntelliSense And Standards Compliance Tools For SQL Coding
May 13, 2008Visual Studio provides IntelliSense and targeted standards compliance code checkers that are extremely useful when writing code. A good example is for web pages targeted to XHTML 1.0 transitional versus strict versus XHTML 1.1.
Is there anything comparable for SQL coding in any of the Microsoft products whether Visual Studio or SQL Server Management Studio or any other development environment?
I'm looking for IntelliSense that can be targeted to one of three alternative configurations: (1) ANSI SQL-92 only, or (2) ANSI SQL-99 only, or alternatively, (3) T-SQL with proprietary Microsoft features/functions (ie, not ANSI compliant in the sense that it is no longer portable per ANSI criteria - it will break when ported due to presence of Microsoft proprietary features/functions).
If standards targeted IntelliSense is not available in any of the Microsoft products for SQL development, is there any third-party product that provides this capability?