I installed an instance of SQL Server 2008; no errors during the install. The computer has SQL Server 2005 Express installed.
When I run SSMS I can see the SQLEXPRESS (2005) which I can connect to it, no problem.
But when I change the name of the server from SQLEXPRESS to MSSQLSERVER (name of the new SQL Server 2008 instance) connection failed. In the SQL Server Configuration I see that MSSQLSERVER and the agent are running. The only thing not running is the SQL Server Browser. And I can't Start this since the Start is disabled.
Must I find the way to start SQL Server Browser in order to connect from SSMS to new instance of SQL Server 2008? Or what else could be missing in my SSMS or MSSQLSERVER?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham