I have been given my first database project that requires data encryption.
[We'll be storing SSN's, CCN's, etc.] I have SQL Server 2000 and MSDE 2
005
as my choice of databases. The project is small enough that MSDE would work
.
My question is does MSDE 2005 have the encryption capabilities of SQL Server
2005 and are those capabilities sufficient to meet Federal regulations for
data security?
Since the project is a small one, is MSDE 2005 a better choice than SQL
Server 2000 with a third party encryption tool, since the SQL Server 2000
that I'd use is hosted by my Hosting company on a shared SQL Server?
Thank you
--
Johnhi,
jhcope wrote:
> I have been given my first database project that requires data
> encryption. [We'll be storing SSN's, CCN's, etc.] I have SQL Server
> 2000 and MSDE 2005 as my choice of databases. The project is small
> enough that MSDE would work. My question is does MSDE 2005 have the
> encryption capabilities of SQL Server 2005 and are those capabilities
> sufficient to meet Federal regulations for data security?
SQLExpress supports the full set of encryption as the full SQL Server 2005
editions..
> Since the project is a small one, is MSDE 2005 a better choice than
> SQL Server 2000 with a third party encryption tool, since the SQL
> Server 2000 that I'd use is hosted by my Hosting company on a shared
> SQL Server?
...
unfortunately I'm not able to solve this dilemma...
your policies and/or standards should be evaluated... SQLExpress can be an
optimal solution, but lacks some features that could be required, such as
SQL Server Agent, Database Mail, DTS/SISS features and the like... or the
new Service Broker related features as well... you have to balance all your
requirements and the supported features...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||SQL Server Express does include Service Broker, but there are some licensing
limitations to its use.
Dan
> hi,
> jhcope wrote:
> SQLExpress supports the full set of encryption as the full SQL Server
> 2005 editions..
>
> ...
> unfortunately I'm not able to solve this dilemma...
> your policies and/or standards should be evaluated... SQLExpress can
> be an
> optimal solution, but lacks some features that could be required, such
> as
> SQL Server Agent, Database Mail, DTS/SISS features and the like... or
> the
> new Service Broker related features as well... you have to balance all
> your
> requirements and the supported features...|||hi Dan,
Dan Sullivan wrote:
> SQL Server Express does include Service Broker, but there are some
> licensing limitations to its use.
yes, the limitations make the Service Broker quite "useless" for inter-SQLX
scenarios as a full SQL Server licensed edition is normally required...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply
Showing posts with label requires. Show all posts
Showing posts with label requires. Show all posts
Wednesday, March 28, 2012
Wednesday, March 21, 2012
MSDE 2000 and SQL 2005 Express on one machine
Is it possible to have these two services on one machine? I notice that my
server requires MSDE 2000 SP3a and don't know it there will be a conflict if
I will install it (or is it possible to have these on the same machine) or I
will just install the 2005 version since it was the replacement of MSDE.
Hoping for your response.
Me
I don't believe you can install both at the same time, at least using
the default installs. 2005 Express attempts to upgrade MSDE
|||I'm running MSDE as the default instance and a SQLEXPRESS
instance on the same machine.
Karl Tarbet
MCSD .net
sql
server requires MSDE 2000 SP3a and don't know it there will be a conflict if
I will install it (or is it possible to have these on the same machine) or I
will just install the 2005 version since it was the replacement of MSDE.
Hoping for your response.
Me
I don't believe you can install both at the same time, at least using
the default installs. 2005 Express attempts to upgrade MSDE
|||I'm running MSDE as the default instance and a SQLEXPRESS
instance on the same machine.
Karl Tarbet
MCSD .net
sql
MSDE 2000 and SQL 2005 Express on one machine
Is it possible to have these two services on one machine? I notice that my
server requires MSDE 2000 SP3a and don't know it there will be a conflict if
I will install it (or is it possible to have these on the same machine) or I
will just install the 2005 version since it was the replacement of MSDE.
Hoping for your response.
MeI don't believe you can install both at the same time, at least using
the default installs. 2005 Express attempts to upgrade MSDE|||I'm running MSDE as the default instance and a SQLEXPRESS
instance on the same machine.
--
Karl Tarbet
MCSD .net
server requires MSDE 2000 SP3a and don't know it there will be a conflict if
I will install it (or is it possible to have these on the same machine) or I
will just install the 2005 version since it was the replacement of MSDE.
Hoping for your response.
MeI don't believe you can install both at the same time, at least using
the default installs. 2005 Express attempts to upgrade MSDE|||I'm running MSDE as the default instance and a SQLEXPRESS
instance on the same machine.
--
Karl Tarbet
MCSD .net
MSDE 2000 and SQL 2005 Express on one machine
Is it possible to have these two services on one machine? I notice that my
server requires MSDE 2000 SP3a and don't know it there will be a conflict if
I will install it (or is it possible to have these on the same machine) or I
will just install the 2005 version since it was the replacement of MSDE.
Hoping for your response.
MeI don't believe you can install both at the same time, at least using
the default installs. 2005 Express attempts to upgrade MSDE|||I'm running MSDE as the default instance and a SQLEXPRESS
instance on the same machine.
Karl Tarbet
MCSD .net
server requires MSDE 2000 SP3a and don't know it there will be a conflict if
I will install it (or is it possible to have these on the same machine) or I
will just install the 2005 version since it was the replacement of MSDE.
Hoping for your response.
MeI don't believe you can install both at the same time, at least using
the default installs. 2005 Express attempts to upgrade MSDE|||I'm running MSDE as the default instance and a SQLEXPRESS
instance on the same machine.
Karl Tarbet
MCSD .net
MSDE 2000
Hi, I have been working with SQL 2000. I recently have a small project to d
o
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so
I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I us
e
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish dat
e?
Thanks,
Alpha"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> MSDE 2000 relase A
> David
>
>
o
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so
I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I us
e
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish dat
e?
Thanks,
Alpha"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> MSDE 2000 relase A
> David
>
>
MSDE 2000
Hi, I have been working with SQL 2000. I recently have a small project to do
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I use
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish date?
Thanks,
Alpha
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David
|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> MSDE 2000 relase A
> David
>
>
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I use
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish date?
Thanks,
Alpha
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David
|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> MSDE 2000 relase A
> David
>
>
MSDE 2000
Hi, I have been working with SQL 2000. I recently have a small project to do
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I use
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish date?
Thanks,
Alpha"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> > Hi, I have been working with SQL 2000. I recently have a small project to
> > do
> > and it requires getting data from the Access database. I tried using the
> > Access as my database but found it very difficult to use, maybe it's
> > becuase
> > I'm more used to SQL server. The customers mostly won't have SQL server
> > so I
> > thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> > download center. One's title says MSDE for Visual Studio.net devloper (I
> > use
> > C# for the application development), Publish date of 8/21/2003. The other
> > one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> >
> > Can someone tell me which one I should down load? Should I down load the
> > first one to my PC for development purpose and then the 2nd to the
> > customer
> > pC ? Or should I just download the 2nd one which has the latest publish
> > date?
> >
> MSDE 2000 relase A
> David
>
>sql
and it requires getting data from the Access database. I tried using the
Access as my database but found it very difficult to use, maybe it's becuase
I'm more used to SQL server. The customers mostly won't have SQL server so I
thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
download center. One's title says MSDE for Visual Studio.net devloper (I use
C# for the application development), Publish date of 8/21/2003. The other
one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
Can someone tell me which one I should down load? Should I down load the
first one to my PC for development purpose and then the 2nd to the customer
pC ? Or should I just download the 2nd one which has the latest publish date?
Thanks,
Alpha"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> Hi, I have been working with SQL 2000. I recently have a small project to
> do
> and it requires getting data from the Access database. I tried using the
> Access as my database but found it very difficult to use, maybe it's
> becuase
> I'm more used to SQL server. The customers mostly won't have SQL server
> so I
> thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> download center. One's title says MSDE for Visual Studio.net devloper (I
> use
> C# for the application development), Publish date of 8/21/2003. The other
> one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> Can someone tell me which one I should down load? Should I down load the
> first one to my PC for development purpose and then the 2nd to the
> customer
> pC ? Or should I just download the 2nd one which has the latest publish
> date?
>
MSDE 2000 relase A
David|||Thank you.
"David Browne" wrote:
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:0034163A-0ABE-44DA-BE3F-197C4371127C@.microsoft.com...
> > Hi, I have been working with SQL 2000. I recently have a small project to
> > do
> > and it requires getting data from the Access database. I tried using the
> > Access as my database but found it very difficult to use, maybe it's
> > becuase
> > I'm more used to SQL server. The customers mostly won't have SQL server
> > so I
> > thought maybe I'll try the MSDE 2000. I saw 2 versio of this at the MS
> > download center. One's title says MSDE for Visual Studio.net devloper (I
> > use
> > C# for the application development), Publish date of 8/21/2003. The other
> > one's title is MSDE 2000 relase A, Publish date of 10/29/2003.
> >
> > Can someone tell me which one I should down load? Should I down load the
> > first one to my PC for development purpose and then the 2nd to the
> > customer
> > pC ? Or should I just download the 2nd one which has the latest publish
> > date?
> >
> MSDE 2000 relase A
> David
>
>sql
Subscribe to:
Posts (Atom)