I have a single instance of MSDE 2000 SP4 installed on my computer, set to mixed mode authentication. It happens - sometimes a few times a day, sometimes once in a few days - that MSDE resets itself to NT only authentication. I installed MSDE on a few computers in a LAN and it still happens, tot...more >>

(This was originally in the sqlserver.programming group but I moved it to a more appropriate place) I'm using the bcp utility to create a text file from a view. The text file is used by a 3rd party program for other processing. bcp installs on the server machine with sql 2k (or in my case MS...more >>

When I install my instance of NETSDK MSDE I am trying to get it to appear as the instance shown in the MSDE Explorer in the task bar. No other instance is installed. How can I do this? All I get right now is it saying it "not connected". It needs to show this reference in the task bar explorer...more >>

First, does this newsgroup cover SQL Server Express? Couldn't find any other one. Can anyone point to any links related to compatibility of SQL Server Express and Vista? As far as I can tell, they should be fully compatible. I'm looking for any general "gotchas". thx ...more >>

PRB SQL Express Installation not installing Manager. Please help, We are trying to work with SQL Server Express 2005, but we are having several installation problems. #1) Despite all efforts, the Database Manager program (ssmsee.exe) is NOT being installed on some XP-Pro machines even t...more >>

Hi I have an issue with Windows Firewall and SQL Server on our server. I have tried to allow remote access to SQL server. The default setup of SQL server Express is to use dynamic ports. However, beacause we use a firewall, I need to set one port which all client connections use. I have...more >>

Hi I am wanting to install the replication features in SQL Server Express 2005. I currently have the default installation on the server with a few databases, and data which is being used in live websites. I now have a need to install the replication features, however I do not wish to di...more >>

Ho il problema con Msde di modificare il tipo disicurezza e passare da quella integrata a quella sql, non ho la console e il dbmanager non me lo fa fare, esistono comandi , store procedure o altro che mi consente di fare questo passaggio? -- Cordiali Saluti Luigi Galdi Serin S.r.l. Sale...more >>

Hello, I'm working with SQL Express User Instances. This is an interresting functionnality. Our product is divided into 2 main components : - A windows Service that insert data into a database. - An ASP.NET 2.0 Web Site that needs mainly read but also write access to the same database. Pa...more >>

Hellow First i appoligize for my english but I'm from Belgium Second, this is my problem: I installed a Server on my Server PC (Windows XP Professional) setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0 SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELO...more >>

I hope this is the correct group for this question, if not I hope someone can direct me to the correct one.. I have a co-working that is running Sql Server on a desktop and she has 3 tables that are extremely large. The files are so large she has no disk space let to work, At the current ti...more >>

Plese, I don't know where to put this post and if this is the rigt group... I wont to know if software like SQL Server Express and Sql Server will work on all editions of windows vista? ...more >>

We wrote our .Net 2.0 application using MSDE. However, the demo programs we have sent out many times have trouble installing MSDE on the customer's computer. We are thinking about converting our database from MSDE to access because of this practical problem. The question is this: Will the s...more >>

Hi Folks Trying to install SQLExpress but would like to leave my MSDE installation intact... is this possible. If, yes can you provide instructions, since I always get that you have to upgrade... Thanks Danny ...more >>

I was working on a install for MSDE SQL SERVER 2000 when I noticed that there was a more recent version available. I have not yet installed and wanted to kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine (MSDE 2000) included the Microsoft SQL Server 2000 - Database Engi...more >>

I have a couple of databases developed and being used in MSDE. The db's are used and maintained from a couple of programs written in Visual Basic 6 (using an ADO connection) (these programs run on a separate computer). I've just set up a new computer and installed SQL Server Express 2005 on i...more >>

1. is there a must/best sequence for installing sqlserver express 2005 and the full fledged sql server 2005? 2. how can I specify custom install path away from system drive for the express version? ...more >>

Hi, I am currently coding the backup/restore methods for our software and would like the give a "zip" option to the user. This I think would be most easily achieved using an existing compression program and to feed it with a pipe from SQL Server (SQL Server 2005 Express Edition). Can anyo...more >>

Hi Trying to access my MSDE data via a Visual Basic 2005 .Net Express edition - do I need to download a data provider, since it only comes with the ".Net framework Data Provider for SQL server" and I can't connect to my MSDE database. MSDE 8.0.2039, default instance, SQL authentication... ...more >>

Hi, I have a small access database develop using msde as back end. I want to put this backend database on shared drive so that other user can access to it. My question is 1 - Does I need to setup MSDE on every workstation? 2 - Can other user connect to this database using ODBC? SF ...more >>

I have a small application that I've developed using MSDE (2K). I'm going to put this in to production by setting up a new computer and it seems that Server 2005 Express edition will be adequate for our needs. I want to check that the size of the databases I'm using are less than 4GB. How do I...more >>

Estimados colisteros: ¿Alguien sabe cómo incluir el MSDE 2000 Release A junto con el instalador de nuestra aplicación? Un saludo, -- Jorge L. Cotarelo Grupo ESI ...more >>

Thanks in advance. I am trying to register my local machine with MSDE 2000. SQL server authetication keep rejecting my login id and password. Please, advised me why it is not accepting. Is it because I don't have installed server portion of SQL 2000 Server? ...more >>

Hello, I'm trying to install MSDE SP4 on my computer (Windows XP), but the = installation hangs. At the end of the log file I have the following = informations = CustomActionSchedule(Action=3DInstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB= 2C064397B,ActionType=3D3073,Source=3DBinaryData,Tar...more >>

hi newsgroup! we have already some msde databases installed and we didn't had any troubles until now! the OS is a Windows XP prof. SP2 with MSDE Version; msde desktop engine 8.00.7630SP3 now our trouble is that the sqlserver.exe process is using more and more ram and the pagefile grows ...more >>

Want to Install WSUS with MSDE on a MOM server with SQL2000 SP4. Is this practical/best practice? Any issues that may arise from this? Anything that I should look out for? Thanks in advance. ...more >>

I am having trouble connecting remotely to a SQL2000 engine. It is located on the "gateway" PC where I have set up ISA Server. I am logging my proxy and firewall stuff to the local SQL2000 server with no problem. I have two instances of SQL: 'gateway' and 'gateway\msfw'. I have pipes and TCP set ...more >>

Hello, I'd like to configure a MSDE SQL server we're using to be available on the internet. I allowed 1434 (udp) through the firewall, as well as 1433 (tcp). I set the MSDE server to port 1433 and verified it was accessible inside the LAN. I also verified you could telnet to port 1433 from...more >>

I am writing an application that relies on Sql Express 2005 with advanced services. I have just moved on to creating the setup and realized this is a 230+MB install. Is there a smaller install available that I can redistribute or a way to trim it down to just the feature(s) I need (Fulltex...more >>

Hello i plan to use sql-server express 2005 in one project and have some basic questions on this product, as i do not seem to find any detailed information on the microsoft page. 1) Is it completly free? May i redistribute it? 2) Is it possible to destribute the product via a normal setup? ...more >>

Hi, I'm using msde as the database server for my asp.net intranet application. The application is running live and atleast 50 - 100 records get inserted everyday. However I have been checking the .mdf file everyday for the last week and surprisingly the file size is constant at 5,504 KB. an...more >>

Hi Are there any place where it is possible to get hold of the pubs database for SQL Server 2005? /A. ...more >>