I need some help, I am new at MSDE. I know the command to use but I am not so sure how to use it. I tried to 'EXEC sp_attach_db @dbname = kennel' at the command prompt. Can someone point me in the right direction please. -- Norm Bohana...more >>

I am trying to install MSDE desktop engine and I having the most difficult time. I installed it once and then tried uninstalling it while it was still running. Half of it uninstalled the other half still being there. I then could not reinstall or uninstall cause a the DLL kept running. I boot...more >>

I'm working in a large database of 4 Million Records of laws in 20 Country.. I have created the law info (text, year... etc) in separate table foreach country And named my Tables "law"+country id.. but when i need to search in all countries i write code to rename the tables dynamic but i have a...more >>

Hi, I can't uninstall MSDE from W2K server. Add/remove doesn't work. It's any possibility to remove the engine? Thanks Marek ...more >>

HI, I installed the SQL Data Administrator on my client machine, but I'm having problems connecting to the MSDE database on another machine. At the MSDE machine, I can us the local SQL Data Administrator to connect with the following info login name: sa password: pwd sa server: (local)\MY...more >>

Hi We have recently been looking to use MSDE for remote users, but are concerned about the limit of 2GB for a database. With the launch of SQL 2005 just days away, I was wondering if there is an SQL 2005 MSDE equivalent? and if so, what is the database size limit? Any information on this...more >>

Hi A Client has an MSDE install - checked by running @@version (clearly says developer edition in the result text). However the size of the data file is over 3GB, even allowing for empty spaces the amount of data far exceeds 2GB. Pls explain? The database was filled by regular insert stat...more >>

Hi i need to install a Msde on italian server. i set rigth the collation - caracter set and sort order but i found that language for the sqlserver is set "italian" how can i change it to english? I look on setup.ini settings without success..... i found another db that has set englis la...more >>

Hi All, I have been able to retrieve the tables within a database automatically via an sql query. Is there a way that I can retrieve the indexes (with the field names they are indexing) and relationships (Fields plus tables they are referencing). What I am trying to achieve is this. In ...more >>

I developed an application for my customer. I need the MSDE2000 to run the application. Can I install the MSDE2000 for my customer? Should I pay any runtime license fee? Or is it free redistributable?...more >>

Hi all, I've installed Visual Studio 2005 professional with SQL Express Edition. A third party app needs to use it. When installing, it's asking to login as 'sa' user. I've enabled MIXED MODE in Registry and reset the 'sa' password with 'sp_password'. However, if I enter the correct pas...more >>

I have a MFC VC7.1++ program using VS2003, and also using the MSDE2000 for some reason my import is now failing and I cannot figure out why, before today this first statement use to successfully process. The return value of retcode now is 0, it use to be retcode = 1 I have looked up the d...more >>

We have been using VB.NET and MSDE 2000 for desktop application. The db is password protected but if a client installed the actual SQL Server and got the db attached, they can find out everything about db. Attaching or connecting to db using Windows locally wont ask for password. Is there...more >>

Error message: SQL Server not found or access denied. We have installed our SW on a network with 8 clients. I runs fine on all but 1 client. This client is running Win 2000 and has 3 network cards installed to be shared by 3 networks. We use SQL auth. I have run CLICONFG on the client and enab...more >>

When we press start in SQL Service Manager it gets grey for a moment and then returns to the red square, not started. We just installed MSDE 2000 on a Win 2003 server. We have rebooted the server after inst. There is another instance of MSDE on the server used by a backup program. Ola...more >>

hi all, i downloaded the msde 2000 release A and a graphic tool . i named the instance as "MSSQLSERVER". installation was success ful. i gave the directory in the set up parameter to my local drive "C:\vinoth". Installation automatically creadted a folder named "C:\vinothMSSQL". inside...more >>

Hi I just changed my wsus server. I want to use a new server for this application. I have follwed the step described in the article Backup Windows Server Update Services. After the restoration of the data and the wsus database I have this error Event Type: Error Event Source: Windows Se...more >>

I am trying to install WSUS on a Windows 2000 server that already has MSDE installed for Backup Exec. Unfortunately the WSUS installation returns the following error: "- a database server could not be detected" I believe WSUS is looking for an instance called "WSUS". How do I install a...more >>

Hi there, This is the new installation of MSDE2000 Release A locally on the Windows XP SP1 professional (Laptop). Never got it through the installation. I have checked all the conditions in the Readme file, and they were met. This is the log file: 2005-10-27 12:01:17.09 server Microsof...more >>

if this is the right group....I just installed VS 2005 and can't connect to sql express. I have read all of the posts i can find and the cmd sqlcmd -S./sqlexpress will not connect. I installed the sql Server Express manager preview 1 and that can't connect either. The service IS running. I nee...more >>

hi all, i down loaded masde 2000 release A on windows 2000 profesioanl.i installed successfully. but i dont know how to run it. Actually one forlder is created. inside that "Binn","data",some other files are there. but there is no thing else.In, programm files no new tool is created. do i...more >>

HI all, I have a pentium 4 3.GIG dual processor 1GIG ram server, that has Exchange 5.5 and MSDE 2000. Are their any bad side effects to this setup. That is, speed issues, load etc. Will the current setup support this. Thanks Robert ...more >>

HI all, I am trying to isolate a particular propblem with our server. We are trying to see if MSDE is somehow involved in the problem in someway or other.. My question would stopping the service be sufficient to rule out MSDE or do I have to remove the service completeley Thanks Robert ...more >>

Hi All. A friend of mine mentioned that Release A actually has the max number of concurrent queries to be 25 instead of 7 as MSDE. Is this true? Thank you...more >>

I want to deploy a VB.NET app along with MSDE and a sample database. I've been trying to use the MSDE Deployment Toolkit, with help from Mario Szpuszta's 3/04 article on MSDN. However, the article does not include sample code, nor can I find it on the web - all the links I've located are dead, a...more >>

I have installed MSDE (and ODBC) at my client site on their 2003 server. I have attached my SQL database via Teratrax Database Manager to the MSDE server however when I try to setup the ODBC connection it doesn't list the database in the drop-down. I cannot attach to the database from my not...more >>

Hi, First I attemtped to upgrade MSDE to sp4, and I got the error "This product is not installed", So I removed the installation of MSDE and just installed sp4 directly. But when I do, I get the error "Setup failed to configure the server. Refer to the server error logs and setup error l...more >>

Six months ago I rework our application to use MSDE as a desktop DB. It was used to replace Paradox. I develop in Delphi with ADO. I realized tremendous performance gains and the ability to use stored procs and computed columns made many tasks far eaiser. But we seemed to have shot outsel...more >>

Thanks in advance for any help that is provided. I'd like to know the process for upgrading MSDE 7 to MSDE 2000. I need to upgrade the MSDE to allow for an upgrade of my BlackBerry servers version to ver.4 Thanks again....more >>

I have created a new MSDE instance on my SBS 2003 Standard server, using MSDE setup. The service is started, and I can access the MSDE instance locally on the server, but I am unable to access it from other PCs on the network (in the domain). Specifically, I am using SQL Server Enterpris...more >>

Hi, I tried to Install MSDE (SQL Server free ed.) on XP Home Ed. It's running but from other computer I could not connect to that database using sa account. Unlike when installed on XP Professional which MSDE can perform almost like SQLServer. Does it because XP Home Ed.? Thanks, Mart...more >>

When I try to install an instance of MSDE2000 on a machine running XP, I get the following message: "Please go to the Control Panel to install and configure system components" I have no idea what this means. I have installed the MSDE2000 100s of times on W2K without problems. Thank you ...more >>

Hello my DEd win 2003 server, uses MSDE all is ok, the server run, and can create from script Db but if i want login or create connection MSDE say wrong pass i never change the pass or other i have the server complet reinstalled from hoster image what i doing wrong ? ...more >>

I am trying to setup MSDE for the very first time. So I am absolutely a newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the file to a folder and then clicked on setup. I get an error message about using the command line to supply a strong password and the setup exits... I use ...more >>

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 >>