Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What installs SQL Express? Expand / Collapse
Author
Message
Posted Thursday, November 1, 2012 5:54 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:20 AM
Points: 3,060, Visits: 3,283
We're in the middle of a security audit at my place of work and we have unearthed a lot of SQL express installations (different versions). I know that a Visual Studio installation can also install SQL Express - but not all of the PCs have Visual studio installed.
Some of the users have had the PCs from new and claim that they haven't installed it.

Does anyone know how to determine what has installed it - or am I asking for the impossible and have to compare installed software on all the PCs to try to find a common element?
Thanks in advance


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1379760
Posted Thursday, November 1, 2012 6:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
A fair number of applications will install SQL Express as their data backend. Mainly if you have third party .NET apps installed. I've seen that a fair number of times.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1379773
Posted Thursday, November 1, 2012 7:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, September 13, 2014 10:46 AM
Points: 356, Visits: 912
Gus is right, quite a few applications use SQL Express as their backend these days. One I can think of is Symantec's BackupExec software.
Post #1379803
Posted Thursday, November 1, 2012 8:45 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:20 AM
Points: 3,060, Visits: 3,283
Thanks for the replies - one of the net admin chaps here put me onto the Microsoft Assessment and Planning Toolkit which might give me more information to go on.

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1379861
Posted Thursday, November 1, 2012 9:49 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:02 PM
Points: 31,018, Visits: 15,452
When I worked at JD Edwards, OneWorld stuck an MSDE (Express) instance on client machines to cache some data.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1379900
Posted Friday, November 2, 2012 5:33 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:52 AM
Points: 1,589, Visits: 5,628
The instance name of the installed software may give a clue as to what installed it--the aforementioned Backup Exec instance is called BKUPEXEC, for example.
Post #1380289
Posted Friday, November 2, 2012 9:01 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:20 AM
Points: 3,060, Visits: 3,283
Thanks for additional info Steve and Paul - will try to check for these as well

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1380425
Posted Monday, November 5, 2012 2:48 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 554, Visits: 1,178
Visio Professional also installs express I believe (I know older versions of Visio did) and so does installing the sql tools such as BIDS or Management Studio.
At least most users don't even know it is there so don't put data into it!
Post #1380940
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse