Monday, March 19, 2012

Issues getting ASP.NET and SQL to talk

Hi! This is my first time messing with SQL and ASP.NET. I'm having issues getting the SQL to work with ASP.NET. I am using win XP Pro running IIS. I have all patches and upgrades installed on the computer. All files are served off localhost.
When I try to visit the ASP.NET page I get the following error message.

Server Error in '/PortalVBSDK' Application.

SQL Server does not exist or access denied.

Description:An unhandled 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.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Source Error:
Line 28: Dim links As New ASPNET.StarterKit.Portal.LinkDB()Line 29:Line 30: myDataList.DataSource = links.GetLinks(ModuleId)Line 31: myDataList.DataBind()Line 32:

Source File:C:\Program Files\ASP.NET Starter Kits\ASP.NET Portal (VBSDK)\PortalVBSDK\DesktopModules\QuickLinks.ascx Line:30
with the stack trace of
[SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 ASPNET.StarterKit.Portal.LinkDB.GetLinks(Int32 moduleId) ASP.QuickLinks_ascx.Page_Load(Object sender, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET Portal (VBSDK)\PortalVBSDK\DesktopModules\QuickLinks.ascx:30 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Page.ProcessRequestMain() +750


Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Any help would be greatly appriciated!
Joshua
seems like your connectionstring is not correct|||Are you sure you have the right connection string in web.config?

No comments:

Post a Comment