Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
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 >>



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 >>


DevelopmentNow Blog