Re: MSDE and SQL 2000 on same box..which is being used?
From: James (jamesATnorton-associates.co.ukREMOVE)
Date: 05/13/04
- Next message: dev: "Re: How can I secure a MSDE database for users who have SQL Server?"
- Previous message: Godfrey r: "MSDE and SQL 2000 on same box..which is being used?"
- In reply to: Godfrey r: "MSDE and SQL 2000 on same box..which is being used?"
- Next in thread: Godfrey R: "Re: MSDE and SQL 2000 on same box..which is being used?"
- Reply: Godfrey R: "Re: MSDE and SQL 2000 on same box..which is being used?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 15:53:17 +0100
An MSDE instance should be visible as its own SQL Server registration under
enterprise manager. If, your application databases are stored within your
SQL Server instance, then it is logical (but not necessarily safe!) to
assume the MSDE instance is not being used for this purpose. However, it
might be worth adding the MSDE instance to EM to check.
MSDE does not come with the graphical tools, such as Enterprise Manager etc.
-- Cheers, James Goodman "Godfrey r" <anonymous@discussions.microsoft.com> wrote in message news:9E445B81-0902-436B-8BA3-E4A739FA6257@microsoft.com... > I read somewhere in here that SQL server and MSDE can exist on the same box. If that is true, how does the application know what instance to call up? We bought an app from a vendor that apprantly uses MSDE, but I noticed that SQL Server 2000 is on the same box. I can view the supposed MSDE databases using the sql server Enterprise manager. When I go to the control panel to the add/remove programs. It says that the MSDe is rarely used, while the SQL server is used frequently.The app is used frequently. Can I assume that we are not using the MSDE like I thought we were? Is it true that the MSDE engine does not come with the grahpical tools? > > Godfrey r
- Next message: dev: "Re: How can I secure a MSDE database for users who have SQL Server?"
- Previous message: Godfrey r: "MSDE and SQL 2000 on same box..which is being used?"
- In reply to: Godfrey r: "MSDE and SQL 2000 on same box..which is being used?"
- Next in thread: Godfrey R: "Re: MSDE and SQL 2000 on same box..which is being used?"
- Reply: Godfrey R: "Re: MSDE and SQL 2000 on same box..which is being used?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
