I have three questions?? 1. I have a Sql server instance running without any name, it just has a default name (local), when i try to go configure replication its says that replication does not support (local) name. This server is in production right now. And it will be hard to shut it down. ...more >>

I installed the MSDE 2000 Release A on XP (Home ed.) using the command: setup sapwd="fruit" DISABLENETWORKPROTOCOLS=0 Then I installed the Web Data Administrator. After invoking the SQL Web Data Administrator app, the "Desired Port" is 80 and the "Cassini Personal Web Server" is selected. ...more >>

Hi We have a UNIX server running a factory management system (CS3) which links to PCs through an ODBC program (Easysoft). We want to install an MSDE database server so that we can create our own database tables in conjunction with the UNIX server. 1. Can we use the Easysoft ODBC program ...more >>

I would like that local administrators or domain administrators dont have administrative rights on some databases running with MSDE. I've learned about to enable the user "sa" and to give a personal password to this user, but apparently administrators continue having full access to all databas...more >>

I download MSDE2000A and run setup, and then I get the following message “The instance name specified is invalid” By clicking the ok button the setup stops. My operating system is Windows XP home edition. What to do next? Gr. Frank ...more >>

Has i reviewed here after Windows XP SP2, MSDE has some problems conecctiong over a network. I installed SP3a for MSDE 2000 but the problem persists. I put a permission to sqlserver.exe but my access to it over a network (and internet) is blocked. How can i solve this problem? thanks, G...more >>

Hi - I'm building a VB.NET application using an MSDE database. I'm working on an install program for the app, and I'm running into an error with the MSDE install. I'm installing MSDE by executing the MSDE setup: setup.exe INSTANCENAME="test601" BLANKSAPWD=1 DATADIR="d:\data\test601\Data...more >>

IS IT POSSIBLE TO INSTAL SQLSERVER 7 ON WINDOWS 2003? IF POSSIBLE HOW? IF NOT POSSIBLE HOW TO SOLVE THE PROBLEM? PLS KINDLY GIVE ME REPLY BY KARTHI...more >>

Hi, I looking for the data base called "pubs" of the SQL Server MSDE version. Does anyone knows where to find it? And how to add it on the Sql Server? Many thanks for your help. Regards, Germán ...more >>

Hi! We're having troubles on a Windows 2003 Server. MSDE 1.0 does not install (even though we already have this setup at other customers). So I downloaded MSDE 2000. Unfortunately, somebody else just executed the installation procedure without setup-parameters. I wanted to have an emp...more >>

We have a problem and I'm not sure of the best way to solve it. Our situation: We have an ASP.NET application which uses a full SQL Server database. We want to add the capability for salespeople to initially install (in a separate procedure) our app locally on a tablet PC with a blank MS...more >>

Hi , i have a problem i live in Europe (Spain) and we use the " , " symbol instead of " . " as decimal symbol for money. Actually my problem is that i have a table with some varchar fields storing money values but when i try to use them in stored procedures as money using Cast(field as mon...more >>

Hello Folks, i use MSDE to collect data from a Access-Databases. I'f got the following SELECT-Statement from this newsgroup yesterday: SELECT count(*) FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\\TEMP\\FLS.mdb; User ID=Admin;Password=\'\'')...FLSA It looks l...more >>

Hi folks, Wondering if someone could help me out with an msde/windows sp2 problem. Upon installing sp2, the network protocols for my msde instance become disabled: Sm, Np, Tcp, Via. Is there a command line syntax I can use to re-enable these network protocols? Or is there a windows inter...more >>

Hi, 1. How to figure out what Port the MSDE instances are using? 2. If SQL Server is installed then whaich port does the MSDE instances use? 3. Do they all share the same port? 4. How do you change the Port for the instances(or rather can you?, If yes how?)? Thanks...more >>

I am able to query several different msde databases on my network using Query Analyzer from my pc. Using SQL Query Analyzer from my pc, I need to copy a table from a database found on my local msde installation to a database on another pc's msde installation. I was trying to find the SQL Quer...more >>

I have a table that stores differnet types of data from a VB .Net application. There is one field where I have to store decimal values. For some reason when the value gets stored into the SQL (MSDE version) table the value is rounded or truncated. For instance, I save the value of 3.33 (v...more >>

Hi, Would anyone know what the syntax is for setting a database to read only via OSQL? Thanks, Jen...more >>

Hello all, I've been running msde 2000 (the version that comes with visual studio) with a very simple database for months. I use Enterprise manager to manage it. Last week I installed xp sp2, but there wasn't enough disk space so I moved a bunch of stuff around, and deleted some things t...more >>

Hi, I am installing an MSDE instance using Setup .... call using a bat file. I know the name of the instance (its a Given). How do I uninstall automatically using a similar call? I cannot afford to ask the user to uninstall it manually by using 'Add remove programs'. Also I would like...more >>

Hi, I need to know how to install MSDE 2000 Rel A (instance) on a machine without the SQL services Manager Icon showing up in the System Tray. This is urgent. Please help. Thanks ...more >>

Can MSDE be cloned? I would like to creates an install of MSDE in an image I am working on, and create an image of the load. Does anyone know if this will cause problems for MSDE? Thanks in advance. BobS ...more >>

Hi. I've a msde database and I'm getting the following error every minute Error 1105, Severity: 17, ErrState: 2 Could not allocate space for object 'ProductSettings' in database 'epo_Srv-ms-avd' because the 'Primary' filegroup is full I've cleanup the database but the error keeps on. ...more >>

Please help me! How attach existing database in MSDE when run setup.exe in my visual basic.net project. Here are the steps that must be completed during the installation of the database (custom actions): a.. Validate whether the MSDE instance is started. b.. Attach existing database a...more >>

On microsoft support web site "http://support.microsoft.com/default.aspx?scid=kb;en-us;234626" I saw the article 234626 "SAMPLE: Setup1.exe Fully Automating MSDE Setup with the Package and Deployment Wizard (PDW)" about automation of MSDE setup from PDW of Visual Basic but only setup1.exe i...more >>

Hi, I have a strange issue. We have a DataTable in MSDE with 800 columns. The column name strings are very long.. about 200 characters or more. When we try to do BULK INSERT into this table, MSDE results in a General Network error. We use SQLDataAdapter. I am working against a very...more >>

Dear Sirs. MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP Service Pack. It is work if SP1 is instaled on Windows XP. But how i can use that merge modules if SP1 is not installed on Windows XP ? Thank you in advance. ...more >>

Hi, we have an app running in a network where the MSDE database is running on win XP Pro PC. This has been running perfect since january but after installing XP SP2 we get "SQL server does not exist or access denied" when trying to run the app from a client. The app runs fine when started on ...more >>

Please help! I've had this problem for FOREVER. It's driving me batty. I'm installing MSDE in a networked environment. I'm using SQL-DMO to find all instances of MSDE on the network. *Usually*, this works great. Unfortunately, sometimes MSDE instances refuse to advertise on the network. I ...more >>

Hi everybody, I have a simple problem: I wrote a C#.NET application that uses same tables through MSDE. I need to prepare a setup installation with the program and, obviously, the DB minimun. So, I need to export the tables and then import them during the setup execution. At the moment, I cho...more >>

Hi How do I make an MSDE remote instance to be available on the network. It was installed without the network protocols being enabled. Thanks ...more >>

I'm trying to install MSDE 2000 on an Itanium system running 64bit Windows 2003 Server. The install fails and the eventviewer shows: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more informatio...more >>

Hello, I installed software called AutoAPP on a users desktop and this software automatically installs MSDE (No idea what version). When run under the administrator account everything is fine. When the user logs on under their account (power user) SQL Icon is on the task bar, but it is bl...more >>

Well i've been given a big job of copying all the databases from an old server to a new server. In order to provide better security, availabilty, performance. My servers are in a DMZ, so i have to use remote desktop/terminal services to connect to it. 1. I have two logical partitions in the...more >>

Hi. I'm using MSDE 2000. Is there a way to get a query result in a 'readabe' XML format from command line? I found the option 'FOR XML', however this produced something that is not really XML. E.g.: ---- SELECT * FROM dbo.master FOR XML ---- Thanks and best regards, Dezo...more >>

I am trying to upsize an access 2000 application to MSDE. I get an error 14, invalid connection. I have read sever al articles in the MS KB but have not found out what to do. I have WinXP, Office Pro 2000. I am trying to put the MSDE server on the same machine as the access front end. I would ...more >>

Hi, I have2 machines connected to each other. Both the systems have MS XP operating systems with SP2 patch on them. I have installed MSDE SP3 on both the systems. I would like to run a query from one machine on a database on the other using osql.I was unable to. It gives an error saying "A...more >>

Hi i was wodering how can i transfer a developed dts package from sqlserver to an installed MSDE2000. ...more >>

I want to use MSDE 2000 Release A on an NT Server currently running MS SQL Server 6.5 Will the installation of MSDE cause issues for SQL Server 6.5? or vice versa? (We are not ready to throw 6.5 out just yet ...) -- Hoppy ...more >>

How do I completely remove MSDE so I can do a new clean install? ...more >>

What are steps that i need to take in order for me to configure SQL Mail (If my company creates all the email accounts). What are the neccecary options do i need to consider. Does my company have to create a new account Just for SqlMail? ...more >>

What is the best and safest way to copy about 55 Databases from a server running win2k to a new server running Win Server 2003 Ent. Ed. What are the different options do i have? Can I copy all the current Db plans, jobs, and Logins? What is a good practice for doing this? The win2k server is...more >>

I am new to MSDE, does anyone know if it comes with Search Server or is that a full SQL Server app? If it is available, how do I install it, or do I need to by it? Thanks Chris...more >>

Hi all... MSDE installs with pure Windows Security. Can it be reconfigured to use mixed security? Does somebody know how this can be done? I have tried it using Enterprise Manager in a scenario where that tool was availeable due to presence of SQL 2K Standard, however, MSDE did not accept a con...more >>

I made a new login for my database. In the database access tab i only checked my database as permit and gave the login no server roles. But when I log on to the SQL Server with that login, I can see all Databases and their tables on the server. Why is that? Thanks, Rainer....more >>

Can anyone give me instructions on how to SCHEDULE backups for MSDE2000? Enterprise manager will do backups manually but the scheduled ones don't keep the file location of the backup. If you enter a maintenance plan and then go back to it in properties, the path for the backup is gone and you ...more >>

HI all, What is supposed to be in te master database, and how can I fix it. Seems to me that I messed up and have some tables, lviews, etc,looks like from northwind database. I think it happened when I tried the upsize wisard in access and made a big booboo Robert ...more >>

Is it a better practice to use the shrinkfile first then use the Backup with truncate only command, and then again the Shrinkfile command when shrinking a large t-log file??? ...more >>

Hi, I am trying to install msde as part of the installation with Live Communications server. The installation rolls back with the following shorten version of the log file. Any suggestions you could give me will be helpful. ..... Starting custom action InstallSQLAgentSecurity InstallSQLA...more >>

I have a VB6 Windows app that uses Access 2K as a local database. The app uses ADOX to create new files (databases) and tables. I want to rewrite the app in VB.NET (VS 2003) and I am thinking I should change the local DB to MSDE? I have some experience with SQL Server 2000 but from what I've read...more >>