[DBNETLIB][ConnectionOpen (Connect).]SQL Server Does not exist or access denied exception

 

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.

Ebook Download
View all
Learn
View all