Hi, I trying to install MSDE 2000 in my PC a lot of times, but unsucessfully; show me a pop-up screen:Setup failed to configure the server. Refer to the server error logs and setup error logs for more information. My log file: 2005-05-07 10:01:25.98 server Microsoft SQL Server 2000 - 8.00....more >>

Hi, Would like to get help on this matters ? If let say i've the software (Primavera Project Management), and required MSDE to serve as a database. How do i install & configure MSDE as part of my Project Management database (PMDB). Thank you...more >>

We have certain SQL tasks which we've been carrying out by running scripts in Query analyzer (sample below). In some contexts, the users won't be sophisticated enough to execute these scripts in this manner. We'd therefore like to develop a small VB SQL script execution utility program which w...more >>

Hello, What would cause the inability to see a SQL instance from one machine. I may not be asking correctly, so I will try to explian. On 3 out of 4 network workstations (XP SP2), I can see the instance ( servername\instancename ) of the SQL db on the Win2003 server. On the fourth iden...more >>

Hello. I have an application I am developing with MSDE. I know that I am properly licensed to use MSDE and distribute that with my application. However, I cannot seem to find any information about Enterprise Manager licensing. We have a valid license of Sql Server 2000 and I have been using...more >>

Hi all! I have a problem with a database with more than 100 tables. I have theese tables in MSDE and linked to an Access database. If I open this database, it tells me that I have no SELECT permission for every table, so I would like to have a way to grant all permissions (SELECT, DELETE, I...more >>

Hi, I have installed the latest MSDE and am entering the following text in the query analyzer: EXEC sp_attach_db @dbname = 'SRPA', @filename1 = '{c:\SRPA\SRPA.MDF}', @filename2 = '{c:\SPRA\SRPA.LDF}'; but i'm getting the following error: Error: Device activation error. The physical f...more >>

After 8 hours of failure, i am feeling like the world's stupidest person In the last two weeks, i've bought a new PC, installed VS.NET 2003, installed MSDE, installed pubs & northwind, installed MS Web Data Administrator, installed code from ASP.NET Unleashed and tried to write hello world ...more >>

I have forgotten the SA password for my MSDE install. Can some one please tell me how to reset it? Thanks....more >>

Dear all, I use a windows xp with sp1 installed Then, i install SQL server client tools, this ok! Then, i install msde2000 , but it auto rollback during installing process and it does show any error or message... Even , i try to use sql2ksp3 to install, it also like this, what is the proble...more >>

We have a Front End/Back End database. The Back End is stored in a shared folder on a per-to-peer network. 1. Can we use MSDE to back-end the database and have up to five users access it from each of their workstations if we change the front-end to an Access project using ADO? 2. If this ca...more >>

Hi, I'm on Win2000 Pro Version 5.00.2195 I've installed succesfully Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A... As I forgot to use the DISABLENETWORKPROTOCOLS=0 and SECURITYMODE=SQL flags the first time I decided to uninstall MSDE. Now, it won't install anymore. I use ...more >>

Hi: I have a Win2000 server that has been running MSDE for about five months. Suddenly today it just stopped running. There were no entries in the event viewer or anything. I stopped and restarted the service and it still did not respond. Finally I rebooted the computer and it's working ...more >>

I am creating an application that need store data locally (the new data are downloaded from my webserver daily). Here is what I want: 1. Secure - Only my application can read the database. I don't want the user be able to look at the data using other tools, or be able to export the data for ot...more >>

We should install MSDE from a small CD and we only got less than 20Mo free for the install. Does it exist a way to have a smaller msde install files. only minimal install and no test db..... ...more >>

Hi There I have just installed ISA 2004 to a Win 2003 server. This had also installed an instance of SQL MSDE which is eating up the memory. Is there an easy command prompt statement or registry hack I can run to restrict the maximum memory usage possible as we are regularly getting "Low Vi...more >>

Hi, I've downloaded MSDE 2000 R1 from Internet. Tried to install on my PC with running on Windows XP Pro with SP2. When everytime i runned the Setup.exe, it will prompt for "A Strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme...more >>

Hello! I want to build an application (in visual basic) using the MSDE, and sell it to thirds. What should i do for make it legally? I have licenses for visual basic, but as far i know, I can redistribute the MSDE for free. Or I should sign some agreement, like the Microsoft Agent? Thank...more >>

Dear All, We have been facing problems in installing MSDE 2000 in machines having Windows XP. The installation starts and then after sometime it retraces back. The error seems to be because of something related to SQLAgentSecurity. I am attaching the error log details ( the portion which ...more >>

I have read that I can use Enterprise Manager to manage MSDE databases. I currently have SQL Server on my computer and have many databases which I use. What I don't understand is how to create/import new databases in MSDE with Enterprise Manager? It seems to only want to work with my SQL Se...more >>

Is there a way to run a compress using the command line? If so what is the command?...more >>

Please help, MSDE won't install here's the relevant strings from error log /// PerfmonLoad routine returned error code 6 Action ended 20:57:46: InstallFinalize. Return value 3. \\\\ I've read and complied with the kb articles but taking those steps doesn't solve problem. Help is ...more >>