Can't connect to local SQL Server
- by D.M.
I'm banging my head against the wall here and can't get things figured out. Yesterday I uninstalled SQL Server 2008 Express and installed a full copy of SQL Server 2008 R2. Everything installed fine but I can't connect to the database to save my life. There is a similar question here that never got answered and I'm not sure if this may be specific to 2008 R2 and how I may have installed.
Under my old configuration (SQL Express) I connected with "DM\SQLEXPRESS" just fine. So far I've tried:
DM\MSSQLSERVER -
.\MSSQLSERVER -
\MSSQLSERVER -
MSSQLSERVER -
DM\Dave\MSSQLSERVER
and I get the "cannot connect to server" error every time.
I have the service installed as well as the SQL Server Browser that I have started. If anyone had any suggestions that would be great.