Hi, We use msde to our clients, and I' m wordering how can I have a standard Instance Name. For example, in setup.ini I have the following parameters: TARGETDIR=C:\MSDE\Binn DATADIR=C:\MSDE\Data INSTANCENAME=BNFT SAPWD=sa SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 The problem is that ...more >>

I have some applications which require the Microsoft SQL Server Desktop Engine. Can some body tell me from where I can install MDSE. I have .NET framework v 1.1. ...more >>

I am trying to install the MSDE on a Win 2003 server. The install keeps rolling back and then tells me to check the error log. I have tried everything I can think of, can anyone help tell me what is wrong? =3D=3D=3D Verbose logging started: 1/30/2006 10:20:09 Build type: SHIP UNICODE 3.01....more >>

Has anyone upgraded from SQL Server 7 to MSDE 2000? Is this even possible? Thanks, John...more >>

Does MSDE support the full, complete set of backup options that SQL Server does? If not, what options does MSDE support and are they available via the Enterprise Manager interface? Thanks in advance....more >>

I just installed MSDE (got successful install msg in Log) but now cannot logon. I get 'Connection failed SQL State 08001 Error 17 I'm using the SA userid and password I entered upon installing I'm attempting this via Visual Studio 2003 What could the problem be? -David...more >>

HI all, I need help on some SQL logic. I have a two tables related. The parent has cascading deletes set. Which obviously means when deleting a parent all children are deleted as well. Which is what I want. Also the user has opertuninty to delete indivisual child records, With one exceptions...more >>

I found a KB article that says SQL Mail is not supported in MSDE but i couldn't find anything about SQL Agent Mail. Is SQL Agent Mail supported in MSDE?...more >>

I am building a web app using VS 2K5 with SQL Server Express as the backend. The project and database are stored in the default location: My Documents\Visual Studio 2005\WebSites\MyWebSiteName. I also downloaded and installed the SQL Server Management Studio Express to be able to manage the ...more >>

Hi, I need help on changing the subscription expiration using MSDE, i would like to know how can i do this, im not familiar with OSQL commands. Thanks ...more >>

Have an MSDE named instance which works just fine. Just installed another instance of the same and can only connect to it using OSQL locally, nothing across the network. I made sure to use all the gotcha flags during install to enable network access, etc: setup.exe DISABLENETWORKPROTOCOLS=0 ...more >>

Hi, I have installed SQL Server 2000 on a Windows Server 2003 machine with an instance name of "TestDB". But I cannot connect to this instance from another machines. It doen't even show up in the Enterprise Manager's "Register SQL Server" window. But if I use the default instance, it wor...more >>

Hi Everyone, I've got Windows SharePoint Services installed and it uses a database called STS_svr-apps-1_1414639615 I'm trying to back up this database from the QSQL command line tool. However when I try to run the backup, I get the following error: 1> BACKUP DATABASE STS_svr-apps-1_14...more >>

Hello all, I am going to run a script to install my tables onto my SQL server. I would like to populate some of the tables with values when the script is run (dropdown tables, default values table etc). How should I do this? ...more >>

Hi we would like to install MSDE using Wise installation script. The Wise documentation is telling us to look for a file named MSDEx86. We've looked on our Visual Studio disks and can't locate the file. Two questions: 1. is MSDEx86 the correct file to deploy? 2. if 1 = true then where c...more >>

HI all, I have, as per normal, relations setup with delete contraints on the parent child relation. Now I have a table that has many such child relations and constraint. As a result when a user tries to delete the parent, a correct message is triggered. My problem is, trying to determine whi...more >>

I have added MSDE merge modules in VS Installer as well as MDF and LDF file, now what should I do, so that setup can automatically Attach the database after installing MSDE client's Machine. Best Regards, Luqman ...more >>

HI, I've downloaded the sqlexpress edition from the MS site How can I install SQLXpress on to the same machine as sql2000. I cant uninstal my previous 2000 instalation as I have current development going on there. I tried to install, but at the moment cant even see the SQLX server. Thanks ...more >>

I have a database in MSDE2000 sitting on one machine and I want to transfer it to another machine which has SQL Server 2000. Can I simply backup the database and restore it on the second machine? Or do I need to create the database/Users etc on the second machine first? What would the best ...more >>

Hi I have a dreamweaver/coldfusion application which uses MSDE as it's back end. I have been using the User Name DBO, Login Name SA as the owner of my objects so that whenever I use a query I preface the field with [dbo].[tablename].fieldname. I remember reading somewhere that I should not...more >>

I have tried to install SQL 2005 Express but It seems that MDAC is not present in my system Windows 2000 server SP4 spanish. - What is MDAC ? - How can I get it to install it ? Thanks in advance. The report is the following: ------------ - Minimum MDAC Version Requirement (Error) Messa...more >>

Hello, there, Some time ago, there was a database with a name sts_servername_1. God knows what I did, but it's now gone. I most probably have deleted it, or maybe detached and never reatached. The fact is, I don't care about it and its data anymore. I want it gone. There are no files of it...more >>

How does the MSDE and SQL Server 2005 Express calculate the database size for the 2GB and 4GB limit respectively? Are they based on database size or just the allocated part of the database size? Does it include log file size? I want to write a script to check whether a database is reaching ...more >>

Being new to setting up MSDE, we are currently testing crystal reports and Microsoft Sharepoint services. We want to install these on a seperate server and see that they use MSDE. We also have a server currently installed with MSDE for Altiris deployment images and HP insite manager. Is it a goo...more >>

I've started a tech forum for everything from tech questions to general computer talk (ie geek speak) if anyone would like to come over and join. I have a few of these that I am a regular in for some of my hobbies and just thought a tech forum would be great. I would love to hear some of your ...more >>

There is a problem with my SQL server desktop installation. The message says corrupt or did not install properly & that I shoud uninstall & try again. The problem is that there is no place to uninstall that i can find. What should I do? I am using win xp pro sp2 and was trying to install it wi...more >>

Hello all, My app uses MSDE to sotre data, but raw data in database are not supposed to exposed to end users per my view. I found that users can attach the data file installed to another database and then see everything in the database. That's what I don't wanna see. Per my thoughts, users ar...more >>

Hello, I have MSDE Installed on a different computer (WIndows 2003) within my network. I also have MSDE Installed on my production computer for development. I have successfully created databases on both computers using OSQL. What I would really like to accomplish is a connection from t...more >>

I have a client that is using MSDE as a back-end for a site built in ASP. The database features a product database with over 300,000 records. One of the search options on the site is to search a description field, so we are using the LIKE clause - the problem is that the search takes ages to ...more >>

I'm using VS .NET 2005 which I understand has SQLExpress built in. I've modified the Personal Web Starter Kit and would like to know what the process is to upload the db to my Hosting Service. The Hosting Service claims they support VS .NET 2.0 and SQL 2005. I notice the mdf files are stored ...more >>

Is MS planning to add support for installation of Windows Installer V3 on Win98? SQL Native Client requires this to be able to install it on Win98. Or does SQL Server driver (older driver for sql server) works with SQL Server 2005 Express? Thank you -- Dejan Rodiger - PGP ID 0xAC8722DC D...more >>

I have a client who is being told by their Database Vendor that they need to purchase three licences of SQL-Server 2000. One for the server and one each for a laptop that will be used out of the office. Firstly our client already has the server copy as part of SBS 2003 Premium. My question is;...more >>

Hello, I have an access database that I am trying to upsize to MSDE. Everything works great except when the upsize takes place it does not transfer the data that is in the tables (only the structure). I do NOT have the wizard set to do only the structure, so it seems odd. I have update...more >>

I have a client that is using MSDE as a back-end for a site built in ASP. The database features a product database with over 300,000 records. One of the search options on the site is to search a description field, so we are using the LIKE clause - the problem is that the search takes ages to...more >>

Has anyone found equivalent for the SQLAgent service for MS SQL Server 2005 Express Edition? ...more >>

I previously had a web server that was running a application that used a MSDE database. This server had a motherboard failure and I was not able to repair it. I did get all the data off the drives so the MSDE SQL databases did get copied. The problem is the admin password for those database i...more >>

Hello, According to documentation I'm supposed to be able to deploy SQL project = directly from VS2005. I don't have Either Build<project name> under = Build menu, neither I have Deploy <project name> for my SQL project. What am I doing wrong? To deploy items in a SQL Server project to ...more >>

I have an MSDE installation that I need to connect to within a C# .NET project as a Limited User (from the same machine, not via the network) The MSDE instance is not in sql authentication mode, only windows authentication. Is this possible? I've used the 'Trusted_Connection=True;' in the ...more >>

hi Andrea Here am using "Use Database" keyword, as the connection string will contain a different Initial Catalog Pls let me know is there any Technical issues to execute this query (Its working fine-) Public Function GenerateCreateIndexQuery(ByVal TableName As String, _ ...more >>

This is a general question " xpsqlbot.dll" what is it doing running a SP? My environment is SQL 2000 sp 3a One problem I am having is a database is transaction log is being truncated during the nightly SQL backup. All other SQL functions appeared to be running normally TIA Jim ...more >>

Hi I cant install MSDE 2000 on one XP machine Cant figure out whats wrong Because log file too large Download it here www.deltmar.ee/logfile.zip Regards; Mex ...more >>

Will my 'smart device application' designed with VS.Net 2005 allow my ce device to pull data from a SQL Server EXPRESS 2005 database residing on the server computer? Or must I be using the full version of SQL Server 2005 to accomplish this movement of data between my ce device and my server ...more >>

I just installed MSDE 2000 Release A. I expected to see an icon in the system try which lets you start and stop msde. I've seen this before, but it didn't appear on my machine. Can I get this icon to appear somehow ? Thanks... ...more >>

it seems that the SQLExpress2005 Management Studio Express has no DTS functionality ... is there a way to automatically export an SQLExpress2005 database (or parts of it) to Access and/or Excel ?? thanks -Michael ...more >>

I've seen a number of reputable NG posts (including one from an MVP) reffering to the 5 concurrent connection limit of MSDE. However I found this MS site reffering to an 8 operations limit for MSDE? "The Microsoft=AE SQL Server=99 2000 workload governor is designed to limit the performance ...more >>

Hi All I have a bunch of test/demo servers running on VMware Workstation Some of those is running Axapta 3.0 sp3 demo version with MSDE 2 as the data engine (named instance) I have moved the VMware files around from one host to another OS starts nicely, I get an IP and get access to the ...more >>

I try to install MSDE using the sapwd switch. During the 'Please wait while Windows configures Microsoft SQL Server Desktop Engine' process an error pops up stating: Setup failed to configure the server. Refer to the server error logs and setup error logs for more information. I search...more >>

Hello Is it posible to encrypt whole database in Sql 2005 Express. I need it for deployment process of my application and hiding database structure? Or if not is good solution to use third party software for this propose? Thank you MilanB...more >>

Hi, I have 2 PCs that aren't in any domain. One of PCs, have installed on MSDE. I change the authentication mode from windows to mixed mode. Created users inside MSDE. In the PC with MSDE I can enter with all users, but in the other PC I could not connect to the server. I tried to reg...more >>

Do I need a license for installing SQL Server client tools? I am using EM to manage MSDE. ...more >>