INSTALL STOPS AT "SYSMESSAGE.SYS" NEED TO CANCEL INSTALL AT THIS TIME. This is MSDE related....This relates to the system tables in the master database. Posted to SBS2000 news but no answer. Best Software(ACT) does not support SBS servers...great but I still need to make it work on this serve...more >>

Hi Everyone, One of my clients started getting error messages in their "Database Maintenance Plan" that has me concerned. Databases: master & msdb (two error messages but same codes) Activity: Check Data and Index Linkage Error number: 7919 Message: Repair statement not processed. Datab...more >>

Hi NG I design my database with Visio and use the SQL-Server as DBMS. When I create a new database with my Visio model everything is fine. But when I want to update an existing database the process throws some errors. I have a table twice (original and backup). Sometimes there is data i...more >>

We have installed MSDE 2000 on XP For Tablet PC. All applications that use ODBC to connect to the database work well, however those applications that use either DBLIB or E/SQL (embedded SQL built on top of DBLIB) return a "Failed to get DBPROCESS" error. MSDE was installed with SQL-Authenticati...more >>

when a new record is inserted into one of the table? Or, we should maintain the messaging by ourselves? Thanks....more >>

I am running XP SP2. I have downloaded MSDE (SQL Sever 2000) to put on my laptop for training purposes. When I try to load the setup program I get an error message saying "The Instance Name Specified Is Invalid" and then when I acknowledge the message the install exits. I have searched for and...more >>

How can I determine the instance name of an MSDE instance in code? ...more >>

Hello. I'm creating a stand-alone windows application using the MSDE server. Performance issues in this application are big-deal to my client. I need to insert data to the database in rate of – 2MB / sec. Each insert action should insert ~ 10-40 MB to the database. My questions are: 1. Wha...more >>

I have SQL Server 2000 (installed first) and MSDE(named instance) both installed in Workstation A, and be accessed by .Net applications in Workstation B. I can open the SQL Server in the server explorer and ADO.net, but can't connect to MSDE. Also, I notice that the port listend by the MSDE...more >>

Hello, I tried to install MSDE 2K on my XP Pro box I got an error msg that I did not have enough free space. When I checked drive I had over 100GB free. Anyone seen this before? Thanks. Chris...more >>

I am installing MSDE Rel A on a XP Pro SP 2 box. I just installed XP Pro SP 2 and installed all the windows updates. I have not installed any other software. The error message reads: Setup failed to configure the server. Refer to the serer error logs and setup error logs for more informa...more >>

I am implementing an MSDE database and I would like to keep some data (like user preferences) in the Access project so that I can filter data for each user based on their selected preferences. In Access I just kept user preferences in the application database on each workstation and used quer...more >>

I am trying to create a maintenance plan to backup my SQL Desktop Engine (MSDE 2000) databases using enterprise manager. Everything goes fine in the maintenance wizard until I get to the "Specify Backup Disk Directory" screen. On this screen, the drop down box next to "Remove files older t...more >>

I am using MSDE2000 on my local machine. I have a Script generated by MS SQL Server 2000 when I try to execute it on my local machine having MSDE2000 installed on it - by using MSDE Manager by Vale - I continuously receive errors like Though I have Set 'GO' as Command Terminator in the Serve...more >>

I am new to msde for I have done all my develpment work with the Developer edition of SQL. The hosting service I am using has MSDE 2000 installed on my Windows 2000 Server. I have installed the application DBAMGR to provide a tool for working with the database. Using DBAMGR, I was able to c...more >>

I used the Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD> command to install MSDE on my windows XP professional machine. Even though the setup kicks off without a problem, towards the end it fails and says 'Setup was unable to configure the server'. It...more >>

Hej, Is there a physical limit to how many simultaneous users MSDE can have. I have read 25... and i have heard 10... what are the limits? /Richard ...more >>

Hej, I have just downloaded and installed MSDE on a computer that has XP Pro SP2. If I remove the filewall completely, (just for a test), should I be able to connect to MSDE from another machine that is running SQL Server Enterprise? /Richard ...more >>

What's the SQL or is there a stored procedure to replace the DEFAULT value of a COLUMN? Dropping and re-adding the column seems overkill to me. thanks in advance ...more >>

Hi, I don't know if this is the right newsgroup or not, but I couldn't find another even remotely appropriate. I am trying to create a new sql database using the Web Data Administrator Tool, but whenever I try to "Log in", Internet Explorer hangs. My computer does not stop reacting, I can...more >>

Please help! I have changed the name of my Win2KAS Server box and cannot find out how to get the MSDE MSSQLServer Service to start back up. MSDE was installed as part of Crystal Enterprise, so I do not have ANY source CD's to use. I cannot find a "setup.exe" file to re-run either. Any ...more >>

A PC at work was renamed recently and now our website doesn't work anymore. I think the problem is due to the Login for ASPNET. Which reads: <oldpcname>\ASPNET I'm using Web Data Administrator but I don't see anyway to rename the login or delete it. When I try to add <newpcname>\ASPNET, ...more >>

Hello, Impossible to setup MSDE release A (with sp3a) on a windows 2003 standard, with TS in application mode installed. Event ID : 11708 Setup SQL Server failed Anyone an idea ? Thanks a lot...more >>

I have installed msde 2000 but my application cannot recognize it. Does msde require that iis be installed and running on the hosting machine? Does the hosting machine have to be setup as a server or can msde just be used as a local database for a single computer application without iis. ...more >>

I am trying to backup WMSDE from Sequel Server tools and keep receiving the following error. "sequel server does not exist or access denied". I also noticed that when i log onto the server and the system tray application does not even recognize the services on the server, but sharepoint works...more >>

As part of a data center migration, I am going to be changing the name of several servers that are running MSDE. Does MSDE have the same issues with changing the name of the system it runs on as SQL Server does? thanks, Jason ...more >>

I have establlished a MSDE server. I know how to check the TCP port at the server. But, I also want to know if it is possible to check the TCP port from other workstation? Please advise. Thanks....more >>

Hi , Can anyone please give me some thoughts on how to achieve the following:- I have a SCADA system updating an SQL database using MSDE on a PC. I have an analysis tool from which I want to access the same database with also using MSDE via ADO from a second machine (here the updates won...more >>

I have a licensed copy of SQL Server 2000 and am trying to load the database from the MS Desktop Engine edition. Is this possible. I have tried simply attaching the MDF file and get the following message. Error 5105: Device activation error. The physical file name '[' may be incorrect....more >>

I have downloaded msde 2000. I have edited and saved the setup.ini file for a sa password. [Options] SAPWD="cfm56z" Setup appears to run and install msde. However when I try to access it with DbatMGR, I get SQL Server does not exist or access is denied Any suggestions would be hel...more >>

Hi Group, I've installed msde already about 20times and they all went ok, except one but that had to do with file and printer sharing. Now I'm trying to install it on win 2000 sp4 like all the others, but I can't get it to install, the pc has got file and printer sharing enabled, it has got in...more >>

I am new to msde but have worked with management tools that comes with sql server. Can someone recommend a good third party tool for manageing a msde database? Thanks, Fred Herring...more >>

hi i am trying to install a software package called arrayinformatics. this comes along with msde as part of it. when i run the setup for arrayinformatics, as admin, after sometime, the status of the installshield wizard shows that... generating script operations for action:....... and thats ...more >>

Hi, I'm a newcomer to MSDE and I need to copy data to my PC from another installation. What is the correct way of doing this ? Can I simply copy the .mdf file or do you need to detach/attach it ? Or is there some other way I havn't come across yet ? Assistance would be greatly appreciated...more >>

What are the prerequisites for Win2K and WinXP Clients to connect to a MSDE server? I have installed MDAC2.8, is there anything else they need?...more >>

All, I was looking for a database centric developer conference. Any suggestions please ? Thanks in advance. Bill ...more >>

I choosed, as a unique key autoincrement, a int field, but the lenght is automatically set to 4. Will I have problems when I'll reach more than 9999 records? ...more >>

Hello, What is the best way to import data to a client's MSDE database from our website? We want our client to log onto our website so we can update a table on the client's PC. I need a little direction on this, not sure which is the best way to go. Thank you, Randers...more >>

hi, how can I download msdex86.exe...more >>

I have a Windows XP application that uses MSDE as its DB engine. If I create an identical database in MySQL and include the correct ODBC "driver", is it be possible to replace MSDE with MySQL? What does it take for them to be compatible? After all both engines process SQL commands. Tha...more >>

trying to connect to remote MSDE database to manage it --msde instance with DISABLENETWORKPROTOCOLS=0 is installed and working. --local connection works to confirm username and password --firewall ports are configured correctly and listening --remote telnet connection works to confirm ip and...more >>

I have MSDE 7 and MSDE2000 on the same computer. They both work fine and independently as long as I access them from a local applicacation. However, I cannot access the MSDE2000 dataserver from a remote location. My computer name is DESK. I can easily access the MSDE 7 server with the...more >>

Which is the best, and easiest way to backup the msde data? ...more >>

When I install msde on a W2K professional and go into My Computer/manage and click on Services and Applications, it shows a MS Sql Server entry from which I can manage msde. When I install on W2003 server, it's not there. Is this by design ?...more >>

Hi How can i stop msde with a command in prompt? I need to stop this to let my backup software to work. -- Message posted via http://www.sqlmonster.com...more >>

Installing MSDE2000A. When i click the setup.exe file it says 'a strong SA password is needed for security reasons. Please use SAPWD switch to supply the same' and refers me to the read me file, which refers me to Microsoft Knowledge Base article 322336. That didn't help because when I went ...more >>

I have laptops that require the loopback adapter when they are not connected. However when they connect back to the network the networked servers display just the computer name not the / instancename. Any ideas? It only happens on network instances. The local instances are correct. This happens...more >>

How forgiving is SQl Server MSDE in a power loss? Can it become corrupted or possibly just loss of the last record being committed? We would like to use it in our embedded systems that run Windows XP Embedded that allows immediate power loss without a graceful shutdown. Thanks for any help ...more >>

Please help I have two databases, old database ‘db1’ with data and the new database ‘db2’ empty How can I update the structure of database ‘db1’ to be equal the structure of database ‘db2’ Tanks ...more >>

I installed MSDE 2000 SP3 Release A using the Windows Authentication security mode. When I attempt to logon to MSDE I get the following error: "Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection." (obviously) the Administrator account be...more >>