Can’t Install Microsoft SQL Server 2008 R2 Management Studio Express
The key is to go installing a ‘new’ instance, not to add features to existing installation. then there is an option to select SSMSE.
SQL2008R2
Cannot Access SQL Server 2008 remotely – enable Named Pipes and TCPIP
By default Named Pipes and TCPIP are diabled. You need to enable them in the SQL Server Configuration Manager.
How can I determine installed SQL Server instances and their versions?
All of the instances installed should show up in the Services Snap-In in the Microsoft Management Console. To get the instance names, go to Start | Run | type Services.msc and look for all entries with “Sql Server (Instance Name)”. This will list all the sql servers installed on your network. At a DOS prompt … Read more