Showing posts with label win. Show all posts
Showing posts with label win. Show all posts

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?

Friday, February 24, 2012

Issue publishing reports under Win2k3

I'm trying to publish some reports using the RS tool under Windows
Server 2003 SBS.
It works fine under Win XP but using SBS I get the messages
"The operation you are attempting requires a secure connection
(HTTPS)."
Any ideas?
Cheers
Chris.The rs script uses rs.CreateReport
and this is where the exception occurs.|||On 18 Jun, 18:54, theinvisibleGhost <theinvisibleGh...@.yahoo.com>
wrote:
> The rs script uses rs.CreateReport
> and this is where the exception occurs.
I found a similar message here:
http://groups.google.co.uk/group/microsoft.public.crm/browse_thread/thread/4b3872a882e9bcd7/bdba3dfc3d002231?lnk=st&q=Microsoft.ReportingServices.Diagnostics.Utilities.SecureConnectionRequiredException&rnum=1&hl=en#bdba3dfc3d002231
It didn't resolve my issue but I found that my virtual directorys were
corrupted in someway.
I deleted them and then recreated them and my issue was resolved.