I'm seeing some conflicting information and wanted to try to get it clarified. The original release of MSDE 2000 couldn't be installed from a Terminal Services session on a TS in Application Mode. The release notes for MSDE 2000 Release A (which contains SP3A) still mention that there could ...more >>

Hi, I have installed 2 Instances of SQL Server 2000 and a MSDE Instance on a Server (only for testing). I have connect the Query Analyzer and the Enterpise Manager with the 3 Instances (always on the server). Then i wanted to connect a client ( the Query Analyzer and the Enterpise Manager of th...more >>

Can I use MSDE 2000 (Release A) for websites public on Internet ? In EULA I found: "for your internal use" .. then NO ? [EULA (license.txt)] 1.1 General License Grant. Microsoft grants to you for your internal use a nonexclusive, limited, royalty free license to install and use the Sof...more >>

hi, In the overview article on SQL 2005 (http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sseoverview.asp) the following is written about Xcopy deployment: 'There are some assumptions implicit in Application XCopy. We assume that SQL Server Express with instance ...more >>

We are experiencing trouble with MSDE on a Win2K3 server with Exchange. Veritas, doesn't complete the install due to MSDE no completing. We have reinstalled the instance with DISABLEROLLBACK as this was the only way to get it in. After hours of trouble shooting, I appears to be a login prob...more >>

I am trying to install msde and everything went fine until the end i got the error message "The instance name specified is invalid" that came up while it was configuring Microsoft SQL Server Desktop Engine...more >>

i need get update record log in my database. Then i can find what data is wrong updated. ...more >>

Installed MSDE. Icon on system tray shows "not connected". Start, Stop & Pause are greyed out. I am trying to connect to a database. Please help. Regards, Shah....more >>

hi all im instaling msde 2000 in XP PRO SP2, but when is end install, rolled back and not install without any message error... anybody now anything about this... tanks Edson ...more >>

Which one would you choose for a small application that needs to go in production NOW? SQL 2005 Express is supposed to be the successor of MSDE 2000, but is it stable enough for production? ...more >>

Could I use MSDE for a web site that has 1 million hits per day; 300,000 of it would be database requests? Or do I have to go with MSSQL? Thanks Stephan...more >>

I currently have an Access database connecting to an MSDE back-end running on the server. The server is running Windows Server 2000. The rest of the workstations are running Windows XP Home Edition. MSDE is installed in Mixed mode, and is configured to accept network connections. When I ...more >>

Hi i am having problems creating a new MSDE database when using the ASP.NET Web Matrix to create it. It says to click on New Connection, select SQL Sever Authentication, add in the username and password and then click create new database. I get an error though saying Unable to connect to ...more >>

I used the MSDE 8.00.760. I try to run EXEC from the command line, but it is not recognized as a command ... I can run the osql in the command line. Does someone knows what is the problem? Thanks in advance....more >>

I have a problem getting connected to an instance of MSDE remotely. I can register the instance in Enterprise Manager, and work with it locally on the machine it is installed on but cannot get connected remotely. I get the famous SQL Server does not exist or access is denied. It is a named ...more >>

After I install MSDE on a windows 2000 machine I enable the network protocols stop and start the server and everything works fine. When I try to disable the network protocols I stop and start the server and it doesn't work. I have to run SVRNETCN to see that the TCP/IP and Named Pipes are disa...more >>

While I discovered there is no way to create FK relation betwwen 2 table in diffrent Database & I need to check integrity between them.. So i'm trying to use For Delete Trigger but I'm unable to make my trigger refrence to second database. How could i implement trigger work with 2 database.. ...more >>

Hello I tried the fix from joe without any result, I have the same problem i can connect from an other PC to my msde2000, netsat -a is telling me that my port 1433 is not listening Any ideas Bernhard ...more >>

Situation: 1st time using Oracle for a training class. 1st install Problem: I just went through the instructions for " Installing the Oracle9i Database[1]". My problem is that I don't remember the passwords I created and I'm following the instructions for loggin in... I am failing m...more >>

Hi, I habe a MSDE 2000 on a server machine. I don't habe "Enterprise Manager" or "SQL Analyzer". How can I restore a backup database? This machine had MS Access XP, I can write program with VB6. Is there anyway to execute a SQL script "RESTORE DATABASE ..."? Thanks for help Martin ...more >>

Hi, I habe a MSDE 2000 on a server machine. I don't habe "Enterprise Manager" or "SQL Analyzer". How can I restore a backup database? This machine had MS Access XP, I can write program with VB6. Is there anyway to execute a SQL script "RESTORE DATABASE ..."? Thanks for help Martin ...more >>

Hi, SQL 2000 had an example for using DMO programing with VB to restore and backup a database, which named BackRestEvents. I want to extend this project to build a tool, which can restore from a backup file to a new database (new name). But I don't know, how I can set the database filenames...more >>

I installed MSDE SP2 from the MSDN. I can connect to it using sa on the local machine but can't connect remotely. If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it from the local machine as telnet localhost 1433. The server is Win Web 2003. Any ideas? -Joe ...more >>

Hi Trying to install Microsoft SQL Server 2000 Service Pack 4 on Win XP machine. MSDE 2000 Sp3 already installed on D: drive, instance name= db1 In enterprise manager the db appears as ABC-111\DB1 ABC-111 is the name of the machine I am using mixed authentication mode. After reading the help I...more >>

I am trying to install some new software which evidently requires SQL. When the install script call for Windows to install the SQL Server Desktop Engine, the install program hangs and never completes the task. The status window reads 'Please wait while windows configures Microsoft SQL Serv...more >>