Installed MSSQL Express 2008 R2 64-bit on my Toshiba Satellite netbook running Windows 7 (Home).
During the installation I named the local instance 'SQLEXPRESS_XXX' the XXX is a placeholder for my initials, which I don't want to say on the forum.
I checked the config manager and it sees the services for the named instance and corresponding SQL Server Agent service, both are stopped. I noticed both TCP/IP and named pipes were disabled, I enabled named pipes.
But when I start SSMS there is no database engine shown, when I type the instance name it can't connect. I tried registering it, started it from the config mgr, and it could not connect using window auth.
Not sure how to fix this issue, when I have installed earlier version couple years ago (MSDE) as soon as I brought up SSMS the first time the local instance appeared in the list.
View Complete Post