Can someone point me to, if its possible, a means of allowing access to an MSDE database over the internet?? I suspect it will involve a static IP address at the host, opening a port in the firewall, and use of NAT? ...more >>

Hi! I am brand spankin' new at this and need help! We just upsized an Access 2002 database to having an MSDE backend. We used Access's wizzard. In general, the forms seem to be working fine. My problem is with the VBA underneath. The code breaks when it tries to work with recordsets. I ...more >>

Hi I have downloaded MS Web Data Administrator to conenct to my MSDE database. It hangs when i login using "SQL Login" When i open up Web Data Administrator, it defaults to Port 80 and Cassini Personal Web Server (the "IIS" button has been disabled). Once I start Web DA with this informat...more >>

Could anyone tell me what the differences are in the MSDE2000A.exe and FRN_MSDE2000A.exe or any other language for that matter? Thanks, Will...more >>

Hello, is there any How-To for implementing a replication between two msde? The Knowledgbase-Articel Q324992 dont show the whole thing. Many thanks in advance Joerg Reinhardt ...more >>

Hi I'm using the Microsoft Web Data Administrator (WDA) to access MSDE. I've created a table and inserted values into it. When I click on my table with inserted values in WDA, I can see details on the attributes of each column, but not the values. If I osql into my MSDE, I can see the value...more >>

Hi, I'm trying to install MSDE with the following command line: c:\temp\setup.exe sapwd="password" Password has 12 mixed special characters, upper and lower case letters and numbers, so I guess it is a strong SA password. Installation starts, but just before the progress bar reaches the...more >>

Are there any difference between upgrading from SQL Server 6.5 to MSDE 2000 and SQL Server 6.5 to SQL Server 2000? Is there any special instruction to upgrade from SQL Server 6.5 to MSDE 2000 comparing to from SQL Server 7? Thanks....more >>

I have found a problem when linking a SQL Server 2000 table that contains an auto incrementing integer into Access 2002 via ODBC. Access identifies this field correctly as an "autonumber" field. However, when I add a record to the table, I get an ODBC error that mentions a "Cast" error. In oth...more >>

Running MSDE 2000 Rel A install with the following information: [Setup.ini File] [Options] DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL Step 2: Reboot -- Ensure service starts. Step 3: Extract Service Pack 4 Step 4: Run Service Pack 4 for MSDE Step 5: Error on install of Service Pack 4...more >>

Hi, anyone can tell me if whith Msde 2000a (Sp3a) or with Sp4 the full text search service is supported? Thanks in advance. ...more >>

Hi, I am developing a VB application on my PC using MSDE and have been using Windows Trusted Connection and localhost sqlConn = New SqlConnection("server=localhost;trusted_connection=true;database=Pubs") Then I copied the EXE to the PC running SQL server 2000 and I get an error mess...more >>

Hi I know I probably shouldn't be doing this but... I have a table on an MSDE database that has a bigInt for the primary key. If I try to link to this table from Access (XP) using an ODBC connection the table links ok. The first time I opened the table it was ok. Since then the primary k...more >>

Hi peeps I'm running MSDE on a Win2k server, and have just installed SQL Server Web Data Administrator. Everything works, but I can't find a way to edit the actual data. I can edit columns, tables etc, but not the actual data, although I can query it. Is this right? Mucho useless if yo...more >>

I have a computed field that I want to change the formula. How do I do this in SQL ? thanks in advance ...more >>

Is there a way to install it without that little icon in the tray? Thanks ...more >>

Hi, I'm a new programmer in using ADO.Net. I have to write a simple program to create a SQL server Database on a Windows 2003 Server with MSDE 2000 installed only. Is it possible to do so by just creating a Database without installed any SQL Server 2000? After I have created the SQL...more >>

hi there, How do i have a server side code/software that will connect all the field of my exchange server to a MSDE database? i need custom fields and all address fields? i need it to be a link if pos? dorling...more >>

I used to be able to login with osql -S(local)\rtc but now it only works with -S(hostname)\rtc. Is there a way to switch it back? Otherwise live communication server doesn't work. Not sure why it stopped being able to log in that way. I did 2 things that might have interfered, 1. install visu...more >>

I'm baffled at the following MSDE connectivity problem: After installing MSDE 2000 SP3a (and hotfix 8.00.0818-enu) on a workstation (XP, SP2), I get the following error when trying to connect to the database using OSQL: [DBMSLPCN]SQL Server does not exist or access denied. [DBMSLPCN]Conne...more >>

Hi, I have an application which maintains around 25-30 connections to the database. The status for all those are "sleeping" most of the time. The database is MSDE. I would like to know what are the effects on performance, locking and any other issuses due to this "sleeping" connections. ...more >>

I am developing an application that will use msde or SQL sevrer depending on if they are in the office or workign on the road. If they are on the road they currently have MSDE installed by a different program. I also want to use the msde service to run my database. is it possible to run t...more >>

I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to developing SQL Dbs rather than Access mdb one, he discovered and downloaded from the MS Site a util called client tools which turned out to be Enterprise Manager. Is this no longer available for download? If so can...more >>

Hi, I have read the paperwork on MSDE, it's limits, governor, etc., and I am wondering for a real-world perspective if 25 - 30 users is fine or if it we would experience problems using this? With SQL2005 just around the corner I don't want to have my client order SQL2000 and then be told t...more >>

What is the url to sp4? I want to automatically download it from a VB6 program, but I can't find a url for the sp4 download itself. When you click on the download link there's some asp magic going on - I just want a direct url of the form: http://www.microsoft.com/<somewhere>/MSDE-KB884525...more >>

I have a need to write many scripts to alter a LOT the underlying database structure of our database in the field. We have many fields out there with a type of float, and I've been told to change those to numeric(19,5) -- easy enough. Unless there is a constraint, in which case I have to dro...more >>

Hello I have next problem(Win NT4.0 MSDE 2000) I have tryed allready all "tricks" but nothing helps Log below; use master Rows affected: -1 alter database kaste modify file (name=N'kaste_log',maxsize=UNLIMITED,FILEGROWTH = 10%) Rows affected: -1 sp_dboption 'KASTE','trunc. log on chk...more >>

Ich habe ein Problem beim Scripten von der DB-Struktu. Ich benutze folgende Befehle: nOptions = SQLDMOScript_Drops Or SQLDMOScript_Default Or SQLDMOScript_NoDRI nOptions2 = SQLDMOScript2_ExtendedProperty Or SQLDMOScript2_UnicodeFile oSQLDatabase.Script(nOptions, ScriptFile, nOptions2) W...more >>

I am having troubles with uninstalling msde so that I can reinstall it i have followed the instructions in http://support.microsoft.com/default.aspx?scid=kb;en-us;290991 and it appeared to all have gone, but when i reinstalled i get the little service icon on the taskbar but it says not con...more >>

After reading the MSDE system requirements it looks like every other flavor of Windows 2003 server is supported except Small Business Server. Is it possible to get MSDE running on Small Business Server? I've tried running the install and I'm getting an error message indicating that its not...more >>

Is there an article or clear way to upgrade from msde 7.0 to msde 2000. Any prompt response will be appreciated.... Thanks....more >>

Howdy All, How do I open Enterprise Manager for MSDE SP3? I have installed MSDE as part of ACT! installation and have found references to Enterprise Manager, but don't know how to get into it. Thanks, Brian ...more >>

Ciao a tutti, su due PC ho installato MSDE + DbaMgr2k come posso traferire l'interno DB da una macchina all'altra?? ho pensato: faccio il detach dalla macchina sorgente creo il DB nella macchina destinazione copio i 2 files nella macchina destinazione (e sovrascrivo i files esistenti) è...more >>

Hello, I'm Trying to setup a XP workstation with the msde sql server engine, but I can't find a way to create a database or import a database with it. greetings...more >>

Good moorning, I am testing with a MSDE and ASP.NET, comment on you a bit: - from the Server 1 connects with MSDE server without any problem, and it is possible to operate on without problem. - from the Server 2 and 3 it does not connect, does not open the connection, and gives me the followin...more >>

I have msde 2000 installed by one of my applications and every time i access my pc via Remote Desktop, the msde initializes? When I'm at my pc locally, it is not an issue. What is Remote Desktop doing that is causing this behaviour and how can i get it to stop? thanks in advance jo ...more >>

I downloaded something that installed an SQL instance of <Machine Name>NETSDK. It contains Northwind, Pubs, and other sample databases. Does anyone know how I got this? For the life of me I can't remember. Marty...more >>

I have database in sql 'crmsource.mdf" I like to automate a backup for it. OSQL -Usa -PmyPasword -n -Q "BACKUP DATABASE crmsource TO DISK = 'c:\backup\crmsource.dat_bak'" I get an error: [shared memory] SQL Server does not exist or access denied. [shared memory]connectionOpen <connect>>. A...more >>

Hello, I've tried to get an answer in several other forums without success. I am trying to install Visual Studio 6.0 on Win XP Tablet PC witn SP2 installed. The installation fails saying that it cannot register MSDE.Dll, which is version 6.0.0.3005, in the C:\Program Files\Common Files\...more >>

Hello, Our Production Database Server, a Win2K Advanced Server box, contains SQL Server 2000 SP3a (Standard Edition). On that box, I noticed in the "Add/Remove Programs" that there was an item called "Microsoft SQL server Desktop Engine". 1. Is this required or used by the Standard Editio...more >>

Hello, A customer of mine has a problem with my database : When he makes a backup of my database with Veritas Backup Execute, my database is marked as suspect, (and my application can not start anymore). I know that I can use "sp_resetstatus 'DBName'" to restore the normal status, then stop a...more >>

Hi, can I use MSDE on remote server? Magnus. ...more >>

My installation of MSDE Rel A is stopping at the following point in the log file: Starting custom action InstallSqlRedis Executing "C:\Program Files\Microsoft SQL Server\80 \Tools\Binn\sqlredis.exe /q:a" MSI (c) (B0:E4) [16:21:46:280]: Font created. Charset: Req=0, Ret=0, Font: Req=MS She...more >>

I have installed VB.Net on my PC, I am a single user with XP Home Ed.. I am trying to follow the instructions to load and install MSDE but the installation phase keeps failing. I would appreciate any suggestions or help. The scenario is as follows: Applying the instructions on the MSDN pag...more >>

Hi all, MS just released SP4 for SQL Server 2000 as well as MSDE 2000. MS released a version of MSDE 2000 Release A, which is for free redistribution independently. This version of MSDE is kind like being released on different EULA than other MSDE versions in other MS products. May I kn...more >>

My administrator doesn't like seeing the list of instances of MSDE when he opens his Enterprise Manager. Since the instances I install all have network protocols disabled, there is really no need to see them there. Does anyone know if there is a method available to hide the instance from th...more >>

I am having a problem installing MSDE on a NT 4 SP6 workstation. The first time I tried this it installed fine. As I was testing an installation CD wanted to retest. I uninstalled it from Remove Programs and tried to re- install it. At this point it complained that it could not register 3 dll...more >>

Hi I am compiling some SQL run books for various servers in our Enterprise. Does anyone have a Word document, which can be used as the basis of the Run Book?? I'm sure someone must have a document which can be used as a template for this already?? I can create one myself, but don't rea...more >>

Hi, Would like to seek for the help on following matter. I've a MSDE2000 (SP3) to be installed on my PC with WinXPpro(SP2). When the installation almost complete that time, the MSDE will roll back by itself. I did tried to install the software on another PC. It's working fine. Note : ...more >>

I have UDDI services running on WS03 w/SP1. I updated the SQL Server Desktop Engine SP4 successfully, but I'm a little confused on where it updated the files... UDDI has its 'key' files in C:\Program Files\Microsoft SQL Server\MSSQL$UDDI\Install SQL Server Desktop Engine SP4 updated its ke...more >>