Is there a free "dts designer" like program for MSDE? exlcuding the command line program. ...more >>

Hello, I have searched through the archive and can't seem to find an answer, so forgive this post if it has been answered previously. I have an application that uses MSDE for it's database. I have three workstations that connection to this instance of the MSDE database, which is installed o...more >>

Hello Did anyone ever get the SQL2000 server or MSDE to work on an XP Pro computer, with a static IP address? If so how is this done? I’ve done the following: 1) setup router to forward to a port 5000 2) I setup MS SQL server to listen to this port, I check error logs, and it is listenin...more >>

Hello, Does anyone have an idea how you can store japanese characters (eg. 取り消し) in an msde database and afterwards display them in a vb.net winforms application? thanx, t...more >>

Hi, I've enabled the TCP/IP protocol on my MSDE(ver.2000), but I cannot connect the MSDE instance from other machines. Do you know how to solve this problem? Thanks ...more >>

Dear Freinds, I purchased a piece of software yesterday for over 600 dollars. That Application depends on installing SQL Server Desktop Engine. It goes to "6 seconds left" and then just hangs. I tried a hundred times - same results. After some 5 hours of research i did find that if you have ra...more >>

Hi, I have SQL2005 WKG edtn on my WS2k3 standard box. I noticed that backups from sql2k5 cannot be restored on MDSE 2.0... so, since I need to create bkps that have to be restored on clients pc's with MSDE, I decided to install an instance of MSDE on the server. but... no way installation hangs...more >>

My apologies for beating a dead horse, but from looking at several similar posts I still cannot make sense of getting MSDE to work on my home PC to give me what I ultimately want - connection of Northwind to my Visual Studio. I'm, running at home a stand-alone PC, XP Pro. I have Visual Basic ...more >>

Hi, Trying to install SQL Server Express 2005 DB for doing shapes development, however when I try the install, I get the following error message: "This machine does not currently have SQL Server 2000 or compatible technologies (MSDE) installed." I notice there are a few posts with the s...more >>

I've seen conflicting advice: Some say it's the *.MDF file AND the *LDF file combined that equal the 2GB limit, so I have to monitor both and sum them to calculate my database size. Still others say that those files can individually reach 2GB. Which is it? My goal in the long run is automate ...more >>

My project developped in Visual Studio 2005 uses MS SQL Express 2005. The project also contains a Setup & Deployment project. As part of the installation I would like to be able to create the db with all the tables, constraints, etc. How do I go after doing this. Note that the db is designed in ...more >>

I have MSDE loaded on my computer and have a database that I want to query but don't know what tables are in the database (an ASP.net learning program created the database). How do I get information about the tables in the database? Do I use 'osql' from a command line? Thanks, RABMissouri ...more >>

Using MSDE 2000, I ran out of db space (2gb limit). I downloaded and installed the sql server 2005 trial software and can query the data but I still cannot save data. It looks like I still have the 2gb limit. Any help would be greatly appreciated....more >>

We have 3 or 4 computers with ADP payroll application on them that uses MSDE. If I install the package under an account such as administrator, then another user attempts to use that computer, each time they logon, it goes through the Windows Installer portion "Please wait while windows config...more >>

I'm trying to upgrade my installation of MSDE 2000 to SP4. The progress bar gets about 95% done, and then rolls back without comleting the upgrade. Any ideas on what's going on? ...more >>

Hello. I have the question. Now i am writing the tool that clear my instance registry values if install of msde failed. How to determine is any msde instance installed ? Is it enough to know that in HKLM\software\microsoft\microsoft sql server\component set is exist {productcode} and in ...more >>

I unistalled an MSDE instance no problem, then ran my usual install, but it stopped and froze my laptop. I had to end-task the install and re-boot. When I went to reinstall it keeps in failing. I tried to reinstall as a different instance and still fails. I checked the log and it says 'Sus...more >>

Hello. In some strange way services are not installed during MSDE install with named instance. So, after install (i disabled rollback by parameters to setup.exe), i didnt find my services in Administrative tools -> Services. I mean services: 1) MSSQL$<MyInstanceName> 2) SQLAgent$<MyInstanceNa...more >>

We had a working MSDE sp3 (500+ installs) install utilizing the M$ merge modules and Installshield DevStudio. We need to allow a seamless!!! upgrade path to SQL Express which requires sp4 as a minimum. We aquired the new version, created the directories, and switched the merge module location in...more >>

Hi all, I have an app which uses an SQL Express database. The problem I'm encountering is that when I deploy the app (including installing SQL Express) my app cannot connect to the database. What is it I have to do to get this working? Is it the format of my connection string within my ap...more >>

Hi, Is it possible to install MSDE without password in windows 2003 server. Thanx Sarath S ...more >>

Is MSDE being phased out in lieu of SQL Server Express and is it just a marketing name change, or is there a performance benefit? ACT! 2006 runs on MSDE (or MS SQL Server for larger installs), and is a machine hog. Its also not .NET 2.0. Hoping they will update what's under the hood. -- ...more >>

We have 2 instances of MSDE 2000 SP3 on a W2K Advanced server with 1 Gig of memory. One for an online storefront and the other for live chat software from SightMax.com. The live chat instance which is really not being used since the users never log into the software starts to use over a gig ...more >>

We have two Windows 2003 servers. One is a dedicated server for a TeleVantage phone system. The other is our main server and domain controller. The Televantage workstation application uses MSDE to talk to the SQL server 2000 Application on the server. We recently installed additional ...more >>

Hey everyone, We are running MSDE on a Windows 200 server and it has data in it. What I would like to know is can we also install MSSQL 2005 on that server and have assess to both databases. Is there anything we have to do to install it and make sure it doesn't overwrite or delete the MSD...more >>

I'm setting up a Win2003 server on AD as a domain controller. I have two 68GB SCSI disks mirrored (RAID 1), which only give me one virtual disk for the OS and any data. Should I partition the virtual disk and put MSDE on one partition and the OS on another or does it make any difference since ...more >>

Sage Software's ACT! 2006 Contact Manager is a machine hog. The install sets it to pre-load something on bootup including MSDE which is what it runs on if you don't have the SQL Server Version. On a notebook, even a fast processor, slow spinning hard drive etc. I don't want MSDE running when...more >>

Hi I'm writing an installer application in VC++. I need to install an instance of MSDE on the system from my application. I've tried using CreateProcess to run setup.exe with installation options given in setup.ini. Though it starts the installation of MSDE but the control returns immediately ...more >>

Hi All, i have migrated from access to sql server 2005. It went smooth without any real troubles. There are only 2 minor things, which has to be solved. Let me explain how the application structure looks like, i think this is a very common structure: i still use access as a front-end appli...more >>

I have created a database called books and created a table called services. After creating an new login id and granting permission to the databse if i try to query select * from health. I get an error SELECT permission denied on object 'health',database 'books',owner 'dbo'. Can any one help m...more >>

Hello Can anyone tell me how to configure SQL Server to handle static ip requests from the internet. The sql server is installed on a windows XP Pro machine. Is the above even doable? OR does the sql server need to be installed on the Windows 2000/2003 server OS before the static IP can wor...more >>

I have a basic stand-alone PC at home (P3 - 800Mhz) running Windows 2000 Pro. I HAD SQL Server MSDERelA installed (and working), BUT I downloaded SQL Server 2005 Express and tried to install it. This eventually failed (cannot remember exactly why, but I think my machine was not capable of ...more >>

Hey peoples... Just wanted to share a methodology that lets you uncap the 2 GB limit legally with MSDE. Use of distributed query IS permitted with MSDE, IF on the same machine, including up to 16 instances also allowed on the same machine, this means 32,767 2 GB DB's = 64 TB x 16 = 1 PB of...more >>

Hi all, A previous developer installed MSDE to an inappropriate path, and I'd like to move it to a new install path. Is this possible, or should I just uninstall and re-install MSDE? Thanks! Wade ...more >>