I installed MSDE on a Server 2000 machine as sql authentication. I can login locally using osql -U sa fine but when I try and access using sql manager or visual studio I get cannot connect to server or access denied? I use this on some nt 4.0 machine and 2000 workstation no problem. Any ideas?...more >>

Hi I am looking for MSDE for Win CE. Any clue of how to get that version Thank you, Shmuel Shulman SBS Technologies LTD ...more >>

I get this error when trying to install msde2000a at the end of the installation. After the installation, i install msde with no problem, and Client components of SQL Server 2000, later uninstall the msde instance and client components, but when i try to install again msde, i get this.... ...more >>

We had to rename our domain and thus, had to re-join the new domain after MSDE was installed. I am now unable to connect to MSDE. MSDE is installed on XP 2 on a workstation computer. I'm guessing it has something to do with the accounts the MSDE is running under. Does anyone know how to ge...more >>

MSDE archive downloaded & extracted. to G:\Windows Server Update Services\MSDERelA. setupsapwd="password"instancename="WSUS" run at command prompt for above folder. Program appears to install successfully but MSSQL$WSUS does not appear in the list of services. Install retried, same result. ...more >>

Hello, I work for a company that wants to deploy MSDE with an application and put a lot of data in the database when it is installed. The data is in XML and I tried to insert it line by line, but the performance was not good enough. So I have been experimenting with SQLXMLBULKLOADLib. I ...more >>

Hi, I've installed the MSDE 2000 before and use programming to create database. However, I would like to change the machine name now. Do I need to reinstall the MSDE again before I can connect to the old database? How to change the server name in data connection? -- Regards, SCM Pro...more >>

Hi, I continue to have problems within an application that I wrote in VB.Net with an error "SQL Server does not exist or access denied". I thought it had something to do with the install script installing MSDE 2000 and attaching the databases. So I uninstalled MSDE and manually ran the i...more >>

I know this is going to make me look like a complete 'numpty' but... I just installed this server and the server Manager tools. Installed great and only went that route because I had so many problems trying to get MSDE to install and work. So, anyway, installed fine. The Server Manager starts...more >>

I keep getting setup errors in MSDE. None of the KB articles I've found have helped. Here is the MSDE setup log: === Verbose logging started: 06/25/2005 13:42:38 Build type: SHIP UNICODE 3.01.4000.1823 Calling process: C:\WINDOWS\system32\msiexec.exe === MSI (c) (2C:C8) [13:42:38:263]: Rese...more >>

Hi I am new to MSDE. I see that you can use Access Data Projects to setup MSDE but don't see some of the tools I have seen in SQL Server enterprise manager. (Forgive me if I ask some really elementary questions for a while). I want to set up tables with unique PK's that auto-generate values. ...more >>

A few questions here. 1. I have noticed a problem when MSDE SP3a is installed on a server with SQL Server SP4. The Registry key value SQLPath at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup loses the last character and that makes the path to osql, inval...more >>

I USE VB.NET AND MSDE I WANT TO DO A QUERY LIKE IN MSACCESS SELECT * FROM TABLENAME WHERE FIELD1 LIKE 'TEXT*' THE QUERY DO NOT RETURN RECORDS THANKS IN ADVANCE FLAVIO ...more >>

Hi, all! I encountered that error message while testing my application using MSDE. It appears when I issue this type of statement: INSERT INT atable (Col1, Col2, ...) VALUES (Val1, Val2,...) The string columns are of type 'char'. The strange is that the message does not appear always....more >>

After pulling my hair out for quite some time trying to log in to MSDE with osql, I discovered that I have to reboot Windows after installing MSDE to get it to start up. Is that normal? I'm using MSDE SP4 on WinXP Pro SP2. ...more >>

Hi, If I install MSDE on a live deployed server and manage it using SQL Server 2000 DEVELOPER Edition, which is installed on another machine, would I be breaking the licencing rules? By manage, I mean use Enterprise Manager to perform maintenance tasks etc. Our situation is that we curr...more >>

Hi We distribute an application that includes MSDE. The customer installed our application on their W2K Server.They had Hebrew set as their language in their regional settings (from control panel). However, something didn't work and the msde installation was not successful (unfortunately I do...more >>

The MSDE redistribution agreement is unclear (to me). It talks about redistributing specific parts of MSDE. I just want to put the whole MSDE2000A.exe setup program on a CD with my app's setup program. Is that allowed? Thanks! J....more >>

ok yesterday i crunched my head against the wall, after trying MSDE installation (MSDE rel.A and MSDE SP4) on a brand new WXPPSP2 laptop. Today it worked, in this way: #Prerequisites 1.removed any MSDE installation (control panel > Remove Applications) 2.removed any MSDE directory (eg. "C:\p...more >>