Hello All,
I have started my comp and accessed my SharePoint site. On the front page I have a web part(my custom commerce server web part) which communicates with the SQL Server 2008 and I am getting an exception
Problem :
My page opened with the following exception :
[COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +81
SharedFns.SQLGetConnStr() +220
SharedFns.ReturnOpenConnection(Connection& connCfg) +55
SharedFns.CheckAdminDatabaseVersion() +254
SharedFns.ReturnOpenConnection(Connection& connCfg) +12
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.SQLGetConnection() +13
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.Initialize(String bstrSiteName) +265
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..ctor(String siteName) +147
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplication() +205
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplication appInstance) +100
System.Web.HttpApplication.InitModulesCommon() +65
System.Web.HttpApplication.InitModules() +43
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +729
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +298
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +107
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +289
Solution :
After some research it found that SQL Server(MSSQLSERVER) service is stopped. But not sure how this service is stopped automatically. As I started this service and refreshed the page, page opened properly.