I have enabled "SQL Server Browser" service but that doenst resolve the starting issue.
The config file in my documents has following contents
[Database]
Server=XYZXYZ
Instance=
Database=Vienna
UserID=
Password=
And config file in my information is like this
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="ViennaUAT.Properties.Settings.dataConnectionString"
connectionString="Data Source=SENTOSA\SQLEXPRESS;Initial Catalog=Vienna;Connection Timeout=180;Integrated Security=True;"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
Initially when I installed, database got created without issues, but opening the Vienna, I am getting error at the splash screen iteslf and never got to open Vienna desktop.
MSSQL$ service not installed on my machine, as i have checked my services.msc, but I have SQL Server 2005 Developer edition installed already. I didnt get what MSSQL$ service mean.
I have enabled a service called "SQL Server Browser" just to verify if it works. But no luck.