After installation, in SSMS, I cannot connect to database
because I don't know what the server name is. I tired . .(local) (local) SQLEXPRESS
but none of four options work.
During installation of SQLManagementStudio_x86_ENU.exe
I was not prompted to specify instance name (or maybe I have not paid attention when it was prompted). This may be related to an existing but abandoned version of SQL Server Express there. Meaning, a version existed and during the installation I haven't asked for a new instance.
Prior to the installation of SQLManagementStudio_x86_ENU.exe
, I attempted to install another version of SQL Server (also express). After I knew it was wrong version, I restored the system to a previous restore point
which must have cleared the registries for bad version of SLQ Server Express but must have kept the bad installation intact. This is why I am having this problem I guess.
Is it possible now to associate the new installation with SQLEXPRESS
as its instance name?
Also I need the missing SP3 to facilitate Visual Studio 2010 Premium to work with SQL Server just installed.
Question2: , Also need SP3 (I am not sure that will be SP3 for SQL Server or SP3 for Visual Studio if they are different to begin with).
FYI, I have Windows 7 home edition.