What installs SQL Express?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Express » What installs SQL Express?

What installs SQL Express?

Rate Topic

Display Mode

Topic Options

Author

Message

Stuart Davies

Posted Thursday, November 01, 2012 5:54 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:19 AM
Points: 2,473, Visits: 2,131

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

GSquared

Posted Thursday, November 01, 2012 6:17 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

Scott D. Jacobson

Posted Thursday, November 01, 2012 7:34 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841

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

Stuart Davies

Posted Thursday, November 01, 2012 8:45 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:19 AM
Points: 2,473, Visits: 2,131

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

Steve Jones - SSC Editor

Posted Thursday, November 01, 2012 9:49 AM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

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

paul.knibbs

Posted Friday, November 02, 2012 5:33 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:56 AM
Points: 1,256, Visits: 4,253

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

Stuart Davies

Posted Friday, November 02, 2012 9:01 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:19 AM
Points: 2,473, Visits: 2,131

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

P Jones

Posted Monday, November 05, 2012 2:48 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:58 AM
Points: 513, Visits: 1,014

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 »

Permissions