Post reply

System.Data.SqlClient.SqlException: SQL Server does not exist or access denied

  • March 26, 2009 at 10:13 am

    #155473

    I had an error on all web pages which comes for two minutes and goes away periodically, any one knows what is it?

    Error:

    System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId, DateTime dt) at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId) at CustomDirect.Util.Shop.GetContentArea(Int32 pageId, String brandCode, Int32 locationId, String strDate) at CustomDirect.styles.module.left_nav_default.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Commerce.Orders.CDIPricingCalculator.SetSourceCodePrices(String sourceCode, String brandCode) at CustomDirect.Commerce.Orders.CDICommerceManager.SetSourceCodePricing(String sourceCode, String brandCode) at CustomDirect.styles.shop.wysiwygPreview.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at CustomDirect.Util.CDIPageBase.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId, DateTime dt) at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId) at CustomDirect.Util.Shop.GetContentArea(Int32 pageId, String brandCode, Int32 locationId, String strDate) at CustomDirect.styles.module.left_nav_product_browse.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Commerce.Orders.CDICommerceManager.ProcessIfValuePack(String catalogName, String baseCatalog, String brandCode) at CustomDirect.styles.module.cart_content.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId, DateTime dt) at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId) at CustomDirect.Util.Shop.GetContentArea(Int32 pageId, String brandCode, Int32 locationId, String strDate) at CustomDirect.styles.module.left_nav_product_browse.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId, DateTime dt) at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId) at CustomDirect.Util.Shop.GetContentArea(Int32 pageId, String brandCode, Int32 locationId, String strDate) at CustomDirect.styles.module.left_nav_product_browse.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId, DateTime dt) at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId) at CustomDirect.Util.Shop.GetContentArea(Int32 pageId, String brandCode, Int32 locationId, String strDate) at CustomDirect.styles.module.left_nav_product_browse.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Data.SqlClient.SqlConnection.Open() at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId, DateTime dt) at CustomDirect.Cms.ContentManager.GetLiveContentForPage(Int32 pageId, String brandCode, Int32 locationId) at CustomDirect.Util.Shop.GetContentArea(Int32 pageId, String brandCode, Int32 locationId, String strDate) at CustomDirect.styles.module.left_nav_default.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Server.GetLastError().StackTrace.ToString():

    at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Server.GetLastError().TargetSite.ToString():

    Boolean HandleError(System.Exception)

    Server.GetLastError().Message.ToString():

    Exception of type System.Web.HttpUnhandledException was thrown.

    Server IP#:

    165.193.92.4

  • March 26, 2009 at 10:48 am

    #966852

    it sounds like a network issue...maybe DNS/WINS?

    at the end, it says the IP is 165.193.92.4. is that an IP Address on your network?

    does your connection string use the name of a server, or it's IP address?is it by server name, like SERVER4, or by DNS, like server4.yourdomain.com, or raw ip address?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 26, 2009 at 11:49 am

    #966908

    Yes, it is a server on the network

  • March 26, 2009 at 12:35 pm

    #966955

    Here are two possible reasons for the error and fixes per Microsoft, if these are not relevant to you post again but this time I need to know Asp.net version and IIS version.

    http://support.microsoft.com/kb/315159

    http://support.microsoft.com/default.aspx?kbid=328306

    Kind regards,
    Gift Peddie

  • March 26, 2009 at 12:41 pm

    #966961

    Asp.net

  • March 26, 2009 at 1:10 pm

    #966986

    System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown.

    The first line of your stack trace tells me it is Asp.net and I have posted two Asp.net solutions so do all that is recommended before posting with you new error. And you are not using Asp.net direct you are running third party CMS so you may need to contact product support for your CMS vendor.

    Kind regards,
    Gift Peddie

  • March 26, 2009 at 1:22 pm

    #966999

    Thank you

  • March 30, 2009 at 1:24 pm

    #968611

    CMS is not a vendor it is a folder

  • March 30, 2009 at 1:43 pm

    #968625

    The first things to try is disable anonymous access and enable impersonation both in IIS. And I see connection pooling related error that may be related to your connections not disposed because anything you use with ADO.NET must be disposed.

    Kind regards,
    Gift Peddie

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply