Hey, Happy New Year! I tried to install MSDA release A. When install, it pops up a window "A Strong SA password is requried for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exist." I need help. I don't know much about p...more >>

I have a database that was created in SQL Server 2000. Would there be any issues if I used this database in MSDE? Does anyone know of any document regarding this? All the articles I have read talk about MSDE databases being compatible with SQL Server 2000. None of them discussed the reverse case...more >>

We have an application running on SQL-Server and now we want to have another verison for MSDE. But I could not install it successfully. According to some articles I know that there would have problem to install MSDE on Chinese Version (Hongkong) Windows XP. Could someone help to tell me any ...more >>

Please help me. How export data with SQLDMO.BulkCopy (MSDE2000 + vb.net) in text file (export format - fixed width!!!). ...more >>

Hi, When I am trying to open Access 2003 report after SQL server is stopped I am getting following error: ------------------------------------------------------ Microsoft SQL Server Login ------------------------------------------------------ Connection failed: SQL Server Error: 53 SQL S...more >>

Dear all, During install MSDE 2000 on WINXP HOME edition, not complete and then rollback, could anyone can help? Thanks. Below attached error.log content. 2004-12-23 16:47:36.38 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 198...more >>

hi, According the list of redistributable components in http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp MSDE2000 should includes ANALYSIS SERVCIE Decision Support Objects . Is it true? ...more >>

I've installed the latest MSDE version Re1A and MSDE Manager (from Vale Software) and SQL works fine on the workstation on which msde is installed. But when i try to create a connection with another workstation, the connection fails. I've installed msde on WinXP Pro SP2 with the following comm...more >>

We have developed an application for Small Business Server (SQL) on a system that is running MSDE. All programming and testing was conducted on a remote, standalone system, and when completed, we were able to move appropriate copies to the LAN via an external 80GB Western Digital USB attac...more >>

I am traveling on a borrowed laptop and am stuck with XP Home. I installed SQL Server 2000 MSDE and tried to connect and failed. Using "netstat -an" I failed to find port 1443 open (or the corresponding UDP). I am trying to connect using a JDBC connector and it seems to be failing due to thi...more >>

I am trying to install MSDE 2000 on my WIN XP Professional machine. I have installed it previously and uninstalled it. Now I am trying to reinstall. Here is the error message I am receiving. SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A} TempFolder ...more >>

Tried to do a search on EXEC and got a lot of hits, but none that I saw addressed my problem. I'm trying to move a DB, but when I type, EXEC sp_detach_db 'database' I get the unrecognized command error. I did a search for EXEC, but couldn't find it. Any suggestions/assistance? Thanks....more >>

Because of a configuration error by field engineer who didn't check the error logs before leaving, an error logging table in an MSDE database has made it grow to 2GB in a couple of days. The result is that the database status became "suspect" (I had to connect through enterprise manager to see...more >>

I've installed MSDE SP3a on a Windows 2000 Server, and the VB6 client application on multiple workstations. These workstations are either Win2000 Pro or WinXP Pro (both SP1 and SP2). All workstations can access and ping the server under 1MS. When the client application opens and reads data f...more >>

Is it possible to set DATADIR=\\<company_network_somedirectory>\? When I try it, set-up seems to fail. Also, if I were to create a new database on a default instance of MSDE, I am not able to pick mapped network directories. Appreciate any insight. Thanks, Sha. ...more >>

We have a software program that uses MSDE and the log file is currently at 7 gigabytes in size which is abnormal. When I do a backup using the softwares utility the backup is only about 12 meg but when i restore to a fresh install of windows the log file is right back at 7 gigabytes. Wha...more >>

Hi All, I am using Crystal Report 8.0 to create report on MSDE 2000 sp3a , but when I try to make connection Natively : More Data Source->MiCrosoft SQL Server-> [Dialog opens] then I type the ServerName, UserID and Password. System hangs for a while, then I get this error : "Unable To Co...more >>

How do we deliver MSDE database ? Like with access, we have a frontend mdb and a backend mdb, which has all the data. There it is only copy the backend and link the front end tables to it and its done. What is the process with MSDE ? When you make a setup of your program, how can you...more >>

It is very important to me. thank you....more >>

Hi everybody, can someone help me about replication ? I want to install msde2000 on two machines (identical) and keep database updated like mirroring, so my users can connect to mirrored data if primary server crashed down. The two machines are in my LAN with their own IP number Is it Po...more >>

I'm having trouble making a new ms access project. MSDE is running. I run the wizard and it asks for a user name and password for the new database. I put in sa and leave the password blank. Then I get an error message. What should I do? Thanks. Also, do the tables actually reside...more >>

We can't seem to get TCP/IP working......more >>

Am I correct in observing that neither MSDE or SQL Svr 2000 Personal edition can be used as a distributor in a merge replication system?...more >>

Where is Windows Authentication, is somewhere in Windows? Where is it ? I have to change SAPWD but I can't I have lost a lot of time just to install MSDE2000A. ...more >>

Is it possible to install MSDE from more than 1 application. 2 different companies on one server, or is this a restriction....more >>

Hi, I have Installed MSDE 2000 on Windows 98 SE box After REBOOT MSDE service is running. I am not able to connect to the MSDE in WIndows Authentication mode while using Login ( sa ) / password the connectivity is done. My GUI uses the MSDE connection in "Windows Authentication Mode" which is ...more >>

Using VB6 and SQLDMO, I'm attempting to get a columns description, as shown in the 'Description' field in the Design view of a table. Problem is that I can't find a 'Description' property in the SQLDMO server.databases(x).Tables(X).Columns(x).Properties(X) Can anybody help? TIA Jim K. ...more >>

I've got MSDE (w/SP3) running on an XP Home Media Edition laptop, and it will not for the life of me let me enable TCP/IP connections. I can select it in the Network Config Util., and it saves those changes, but when I (re)start SQL Server, in the log, it only says it's listening on Shared ...more >>

I'm trying to decide what path to take in implementing Backup & Restore processes in my VB6/MSDE application. Either (a) create and execute Maintenance Plans or (b) use the BACKUP / RESTORE / DBSHRINK commands in the program. Can anybody explain to me the pros/cons of using one of the other? ...more >>

Hallo, after successful installation of MSDE, and starting with command : sqlservr.exe -sMSSQLSERVER i got following issue: the SQL server is started in single user mode. Is there a way how to switch off single user mode? This lines are in ERRORLOG file: ..... 2004-12-20 21:36:33.31 se...more >>

A collegue (really not me ;) has accidentally emptied a table in one of his databases by making a simple typing error in a query, only to notice after it happened that he had forgotten to create a backup schedule for that database. He has full recovery enabled the log has never been shrunk, so...more >>

I have an MSDE application and I'm wondering, if SQL Desktop already exists on the machine its being installed on, what will happen if I try to install a named instance of MSDE? Will it still install and then show an additional service in the Services MMC? Thanks. STom ...more >>

This is a newbie question but how can I change the sa password in MSDE?...more >>

I recently obtained Visual C++ .NET 2003, and am under the impression that I have to install MSDE to provide SQL support for applications I write. Do I need to install SQLServer as well? (None of the documentation I have read so far says so, but some comments I have read make me want confirma...more >>

I removed (as far as I can tell) all versions of MSDE from my computer. This was confirmed when I examined the installed programs on the 'Add or remove programs' screen If I then use the files from my SP3a disk (installed on my D drive) to apparently successfully install a new default instanc...more >>

I need to move an SQL database from the C: partition to another partition. Is there a way to do it that will not cause errors? Is there a way to increase the partition size without a full re-intall of Windows Server 2000? Brice...more >>

Dear all I did this. I installed client version of SQL 2000 to connect to my server (I can connect to my server and access the database there). I installed MSDE2000RelA on my Win ME PC. Installation all went smooth,(no errors). How do I use MSDE now. In the enterprise manager I dont see any r...more >>

I want to use msde as an embedded database with my application dev on VB.net. It is a small application who demo version i want to post on net. What is minimum footprint of msde i can use? Or what are the options to reduce the footprint of msde? Also mention how different options affect it...more >>

Hi there guys, I'm trying to install MSDE 2000 Release A on a Win98 RTM (not Win98 SE) and I'm getting an installation error such as the one below. And I can't seem to find any resources on the net that mentions my problem. Here's the segment of the log that I think contains the problem area. ...more >>

I have installed a named instance of MSDE on 4 machines with no problems. Some had preexisting versions of local which were uninstalled no problems. On this machine the local instance has been uninstalled. The names instance installs fine however when you try to connect the named instances are...more >>

Does anyone know of a utility that will check the integrity of windows to determine if MSDE will install correctly or not? If so, will it show what needs to be "fixed" (what is broken) f it reports that the installation will fail? If not, can anyone tell me what exactly MSDE depends on to...more >>

Does the MSDE 2000 allows you to create your own local database like SQL 2000 developer edition would....more >>

Why SQL Server Agent (MSDE2000) not started on Win98? ...more >>

I have written an SQL Server 2000 Application using the indexing service for full-text indexing a table. Try to use MSDE instead of Sql Server (SQLDMO) oSQLServer.FullTextService.isFullTextInstalled returns always false Has anyone an idea what to do? Thanks Alex ...more >>

I use Web Data Administrator. When I ask export of SQL tables, Web Data Administrator formats decimal numbers in format '6,5' and not '6.5'. Résult : for import, comma is taken like field separator, and import fail. My first reaction, beeing french, was to change regional settings, but no eff...more >>

when I try to schedule a backup, or just do a backup, of a remote database I get this error message: "database 'msdb' cannot be opened. It has been marked SUSPECT by recovery." I can connect to the database and view it. I checked the error logs and there is no information about this error...more >>

Hallo! My goal i s to write an application which will run on MSDE database, with that application i need to read data from this database and convert it to XML documents according to the XSD's i have. I don't know if this is possible with MSDE 2000 version. Please, is any one familiar to ...more >>

Hi I'm having a problem during installation: it stops when it is 5 seconds to complete, and then rolls back. However: If I delete the lines with datadir and targetdir from my ini-file, it works fine. Anyone knows...? I am using this ini file: [Options] Disablenetworkprotocols=0 Sequritymod...more >>

Hi I'm having a problem during installation: it stops when it is 5 seconds to complete, and then rolls back. However: If I delete the lines with datadir and targetdir from my ini-file, it works fine. Anyone knows...? I am using this ini file: [Options] Disablenetworkprotocols=0 Sequritymod...more >>

Hi, I checked the links, you suggested me to research on this error “Unknown token received from SQL Server”. I am trying to insert 8-10 million rows in the table. I am using a while loop to insert the row into a single table and not using cursor (Website suggested to use LOCAL FAST...more >>