all groups > sql server msde > january 2006 > threads for january 1 - 7, 2006
Filter by week: 1 2 3 4 5
Installation Issue
Posted by Mikey Rogers at 1/7/2006 11:14:02 AM
I try to install MSDE using the sapwd switch. During the 'Please wait while
Windows configures Microsoft SQL Server Desktop Engine' process an error pops
up stating:
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I search... more >>
Encrypt whole database in Sql 2005 Express?
Posted by MilanB at 1/6/2006 7:20:03 AM
Hello
Is it posible to encrypt whole database in Sql 2005 Express. I need it for
deployment process of my application and hiding database structure?
Or if not is good solution to use third party software for this propose?
Thank you
MilanB... more >>
MSDE HELP
Posted by Mestre at 1/5/2006 5:00:42 PM
Hi,
I have 2 PCs that aren't in any domain.
One of PCs, have installed on MSDE. I change the authentication
mode from windows to mixed mode.
Created users inside MSDE.
In the PC with MSDE I can enter with all users, but in the other PC I could
not connect to the server.
I tried to reg... more >>
License
Posted by docsql at 1/5/2006 4:35:49 PM
Do I need a license for installing SQL Server client tools? I am using EM
to manage MSDE.
... more >>
An appropriate use of MSDE
Posted by wawork NO[at]SPAM hotmail.com at 1/5/2006 4:34:39 PM
We have a project where 16 PCs will be used to run wildlife models.
Can we install MSDE on each PC and use it as a backend to the model?
Do CALs need to be puchased? I'm more than a little confused after
scanning the Microsoft web site.
Thanks... more >>
MSDE and ISA
Posted by Darrin Acreman at 1/5/2006 10:46:48 AM
I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
ISA Server 2000. From the workstations on the network I am able to create
an ODBC connection to the default instance of SQL (MSSQL) but receive an
error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). ... more >>
Help! SQLExpress2005 date formats
Posted by Michael Peters at 1/4/2006 11:52:08 AM
I installed SQLExpress2005 and restored some old MSSQL7 databases. This
seemed to work at first glance, but there is at least one problem. These
databases contained datetime values.
And we are in Germany where dates are written like this: 25.12.2005
(christmas, for example).
My ColdFusio... more >>
How do I deploy a windows app that uses SQL Express?
Posted by Ken Sturgeon at 1/4/2006 10:22:14 AM
I know this will seem to be an elementary question but since most of my
programming experience is with ASP and SQL Server 2000 I have very little
experience deploying windows applications that have a supporting database.
I currently have SQL Server 2000, 2005 and SQL Server Express installed ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Encrypt functions in sql 2005 express
Posted by MilanB at 1/4/2006 9:12:03 AM
Hello,
Does sql 2005 express have enhanced data excrypt functions. I think on
column data or just data encryption?
Any suggestion how to use Sql 2005 Express with extern cryptoApi for data
encryption?
Thanks
MilanB... more >>
Sql statement error with ntext field
Posted by MJay at 1/4/2006 12:01:02 AM
i try to execute the following sql command on a MSDE 2000
select itemlookupcode,extendeddescription from item where itemlookupcode =
'14010006'
the extendeddesription data type is ntext
i get the error when executing the command
An error occurred while executing query:
Page (1:735), s... more >>
SQLExpress 2005 backup/restore ??
Posted by Michael Peters at 1/3/2006 5:45:13 PM
I finally managed to install SQLExpress 2005 on my XPProf machine, and it
runs! Then I installed the SQL Express Manager: I could connect to the
SQLExpress2005 and even create a new database, but to my disappointment
there is no backup/restore function. Why not? The Manager seems to be a very ... more >>
MSDE2000SP3a, Installation returns: MainEngineThread is returning 1603
Posted by MLR_JDIS at 1/3/2006 1:30:03 PM
I am attempting to reinstall MSDE (default instance) on a HP laptop
with Windows XP Pro with SP2. MSDE had been installed and was removed.
Upon attempting to reinstall the installation starts, then fails, and
then rolls back. From the information I have gleaned it appears one
cause can be a i... more >>
Volume Shadow Copy Creation Timeout
Posted by dw at 1/3/2006 12:48:01 PM
I recently installed SQL Server 2005 Express on a Windows 2003 server that
had SQL Server 2000 installed on it. As it only requires a tiny database,
the intent was to copy the tables from the SQL 2000 default instance to the
SQL Express 2005 named (sqlexpress) instance.
I backed up the Win... more >>
which version for development?
Posted by Michael Peters at 1/3/2006 11:54:31 AM
I'm completely confused at the many versions of SQLServer, and I need some
advice here.
I'm a web developer and up to recently, I developed on my XP Prof machine
using MSSQL7.
Now I need to develop for MSSQL2000 as well as for MSDE2000. I have a
backup of a MSSQL2000 database and of a M... more >>
SQLExpress re-distribution clarification
Posted by VC at 1/3/2006 10:58:17 AM
Hello:
I have an application that uses SQLExpress as the backend database server. I
am planning on re-distributing sql express along with my application. One of
the re-distribution options that I am planning is to have sql express be
installed from my web site using click-once. The typical use... more >>
Database password
Posted by Penny at 1/2/2006 6:23:58 PM
Hi,
I use SQL server 2000.
I would like to know if there is any way to lock my database (set my own
password) so that someone who don't know the password won't be able to steal
the data. For example copy mdf/ldf or create a export of the database and
attach it to another sql server, or even... more >>
Access denied after changing startup account
Posted by Steve Mc at 1/1/2006 8:35:03 PM
Can anyone shed some light on this one for me?
I have a newly built Win XP SP2 development machine and I have loaded MSDE
2000 SP4 as well as SQL 2005 Express Edition. They are happily co-existing
and I'm using SQL Management Studio Express CTP to manage them. I wanted to
change the startup... more >>
|