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 :
![Machine generated alternative text: Server Error ¡n ‘I' Application.
fDBNETLIBJ[ConnectionOpen (ConnectQ).JSQL Server does not exist or access denied.
Description: An unharidled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code
Exception Details: System.Runtime.lnteropServices.CoMException: [DDNETLIOJ[ConnectionOpen (Connecto).]SQL Server does not exist or access denied.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin anc
the exception stack trace below.
Stack Trace:
[COMException (0x80004005): [DSNETLIB][Connectionopen (ConnectO).]SQL Server does not exist or access denied.]
ADODB.Connectionclass.Open(String ConnectionString, String UserID, String Passrd, 1nt32 Options) -i-0
SharedFns. ReadSQLDbLocale(Stri ng& strAdmi nConn) +148
SharedFns. SQLcetConnStr() +132
SharedFns. ReturnOpenConnection(Connection& connCf g) +76
Mi crosoft.CormierceServer. Interop.Confi guration. SiteConfi gReadOnlyFreeThreaded. SQLGetConnection() +20
Microsoft.CormierceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.Initialize(String bstrSiteName) +396
Microsoft.CormierceServer.Runtime.Configuration.ConnierceResourceCollection. .ctor(String siteName) +246
Microsoft.ConnierceServer.Runtime.CormierceApplicationModule.InitializeApplication() +283
Microsoft.CormierceServer.Runtime.ComerceApplicationModule.Init(HttpApplication applnstance) +127
System.Web.HttpApplication.InitModulesConnvn() +124
System.Web. HttpAppl i cation. Initlnternal (HttpContext context, l-ittpAppl i cationState state, Methodlnto [] handi ers) +1162
System.Web.HttpApplicationFactory.GetNormalApplicationlnstance(HttpContext context) +312
System.Web.HttpApplicationFactory.GetApplicationlnstance(HttpContext context) +133
System. Web.HttpRuntime.ProcessRequestlnternal (HttpbrkerRequest wr) +196]()
[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.