Can an individual computer be configured contain both a SQL Server
instance & an MSDE instance?
Our software we charge separate costs depending if they are running on
a MSDE or SQL Server edition, and if they already have SQL Server
running (which they may have installed for some other application), can
we install our MSDE instance on the same machine?
And on the flip side, if they already have a machine that has an MSDE
instance, can the SQL Server install be done over top of that without
affecting the MSDE?
Thanks for any help,
Greg gc****@nauticom .net 1  1897  gc****@nauticom .net (gc****@nautico m.net) writes: Can an individual computer be configured contain both a SQL Server
instance & an MSDE instance?
You can install several instances of SQL Server of the same machine,
and that can be a mix of different editions, including MSDE.
What you cannot do, though, is to use the graphical tools from
standard/enterprise edition to access MSDE. Technically, it works
all right, but it violates the license agreement.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: stefanPL |
last post by:
Hello,
well, I am still trying to connect to SQL Server 2000 (MSDE) form PHP
I did the following:
1. enabled php_mssql.dll extension in php.ini (phpinfo() shows it)
2. every dll is in proper place (System32 or php folder and few more
folders just to be sure) including
ntwdblib.dll
|
by: Brad H McCollum |
last post by:
I'm writing an application using VB 6.0 as the front-end GUI, and the
MSDE version of SQL Server as the back-end (it's a program for a
really small # of users --- less then 3-4).
I'm trying to determine, through the Visual Basic interface, the
permissions of each user that's using the application on his/her
machine.
For example, let's say I'm user "Michael" that's sitting down at my
machine using the app. I've written. The security...
|
by: Edward Mitchell |
last post by:
I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the bound
datagrid), I receive an error stating:
login failed for user...
|
by: geodev |
last post by:
I have developed a small application using ASP.NET and VB.NET on my
development machine it works great. When I copy across the files manually to
my test machine and create a Virtual Directory all of the functionality works
well except for a page with a datagrid that retrieves data from an MSDE
database (error message is detailed below). I have checked the connection
string and that looks good and MSDE is properly installed and configured on...
|
by: Piedro |
last post by:
Hi Group,
I haven written a program on a win 2000 pc and sql server 2000, in the
sql server there're about 40 tables with data and now I'm deploying my
project on a test pc with windows xp professional SP2 and an msde
database but the strange thing is, on my win 2000 sql server 2000 pc
I've got a table which keeps the heighth of something (decimal(8,2)).
An example of a stored value is 4512 and in the msde it's also stored
as 4512 but...
| | |
by: Microsoft |
last post by:
Hi,
I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The...
|
by: rob |
last post by:
I want to create an application that can be used both for a
server-client model as well as a standalong application. The idea is to
write a general server-client application. The standalong then just has
both components on the same system. Now the question is if this is a
good approach or if this is even doable. For instance do web services
have requirements that would prevent them from running on a non-server
OS? Any input?
Rob
|
by: Developer |
last post by:
Hello All,
i have recently installed VS2005 and was trying to install SQL sever
2000.
I have Win XP' SP2. But when I tried installing, it only installed
client tools and not the database.
Can anyone please help me with this as I want to install SQL server and
also wouold be grateful, if you can suggest me any workaround to
dealwith this problem.(Like should I install any new OS etc).
Any help would be appreciated.
|
by: HC |
last post by:
Hello, all, I started out thinking my problems were elsewhere but as I
have worked through this I have isolated my problem, currently, as a
difference between MSDE and SQL Express 2005 (I'll just call it
Express for simplicity).
I have, to try to simplify things, put the exact same DB on two
systems, one running MSDE and one running Express. Both have 2 Ghz
processors (one Intel, one AMD), both have a decent amount of RAM
(Intel system...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
