/Reports Site Returning 404.3 Error After Install
Oct 17, 2007
Hi All,
I have just installed SSRS 2005 SP2 on a x86 box (one of several boxes we use to run SSRS). However, on this particular machine, I get an http 404.3 error (file not found) when attempting to access any aspx file in the reports virtual directory. aspx files in the /reportserver site all return just fine.
All the check marks for the configuration site show green
I've uninstalled / re-installed / re-booted / etc...
No luck
This is a VM server....
Ideas?
View 1 Replies
ADVERTISEMENT
May 9, 2008
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings)
- Used the defaults for the Repor tServer and Report Manager Virtual Directories
- Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database
- Web Service Identity set to NT AuthorityNetworkService
When I open http://localhost/reports/, I get the following error:
I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!!
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0 068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86 042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648 068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 5 Replies
View Related
Aug 24, 2006
Hello, I am running out of ideas on how to get SSRS to work. I am trying get this setup with the intention to replace our Crystal Reports server. Currently I have set up the RS Virtual Directory on a Win XP box. The ReportServer database sits on another SQL2000 box.
I can connect to the http://localhost/ReportServer/ on the XP box to display the page the depicts "Microsoft SQL Server Reporting Services Version 9.00.2047.00"
When I connect to the http://localhost/Reports/, I get this error "A name was started with an invalid character. Error processing resource 'http://leej/Reports/'. Line 1, Position 2" I checked my IIS Virtual Directory properties for Reports and ASP.NET is set to v2.0.50727. I also executed "aspnet_regiis.exe -i" in the "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727" directory.
Any thought on how to fix this? I hate to let this blocker deters us from deploying SSRS.
Thanks,
John
View 15 Replies
View Related
Oct 11, 2007
Hello,
We have a small .NET intranet site and I have some experience with Reporting Services. What I am looking to do is develop some reports on our website. However, I would like to make it so the user can do some customization of their reports.
For example, there would be sections of reports (Headcounts, Turnover, etc.) and in each section there would be measurements they could click to include. So I could select the Headcounts section and select the measurements such as Terminations, Hires, and Period End Headcount. I may not select the Turnover sections at all. I am almost thinking like a Google page where you can move around the sections and have your own customized report. Maybe these sections could work as Web Parts, or something like that.
Does any of this make sense? Is it possible? Are there are websites or examples that are out there that I could get an idea to see if this has been done and how to do it?
Thank you.
-Gumbatman
View 8 Replies
View Related
Dec 10, 2007
hello when i try to view reports in reports manage i get the following error
The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
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: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:
[InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found]
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded() +212
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance() +17
Microsoft.Reporting.WebForms.LocalizationHelper.Microsoft.Reporting.WebForms.IReportViewerMessages.get_ProgressText() +42
Microsoft.Reporting.WebForms.WaitControl.CreateChildControls() +210
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7248
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +213
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.pages_report_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 3 Replies
View Related
Jul 20, 2005
Greetings,I am in the process of installing a SQL database at a customerlocation. I have determined that there are 3 ways to do this, and Iwanted to know which is the best of the 3.1 Install From Script.In this method I create the database and its objects in scripts thatare run via osql utility on the SQL server machine. For loading anyinitial data that I need in the database I also run bcp commands.2 Install from a backupIn this method I created an empty database on the SQL server, and thenrestore over it the database from a backup of the database that I needto deploy. Then I add or re-attach the users for the database. Iperform all of these operations using osql as well.3 Install by attaching the data files.In this method I created an empty database on the SQL server, and thenI attach the data files to the database using the sp_attach procedure.Then I add or re-attach the users for the database. I perform all ofthese operations using osql as well.Although it is no problem for me to use any of these methods, I wantedto know from you veterans out there what the best practices are. Andalso if there are any unseen hazards for each method above. Or if Iam totally off-the-target, and there is another method that is thepreferred way.Thanks in Advance,roger
View 5 Replies
View Related
Oct 31, 2007
Hi,
I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':
http://dyzimw.bay.livefilestore.com/y1pwxE9mLpX4JV7e438WA4DeGwu6YHQOkRoC20r_EhQ5uoXkt15dqs99LmiDSTauSvUCno9HnOwYKR34rPpFYA_lQ/ssrs.jpg
When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.
Thank you.
Regards,
Antonio
View 1 Replies
View Related
Sep 14, 2007
I've tried changing the default zoom setting by editing the RSReportServer.config file to include
<Configuration>
<DeviceInfo>
<Zoom>Page Width</Zoom>
</DeviceInfo>
</Configuration>
under the
<Render>
<Extension Name = "HTML4.0" etc.
However, all reports still show up with the zoom setting at 100% on the toolbar.
I stop and restart the Report Server Service and it comes up OK so I know my XML syntax is cool. What am I doing wrong?
This is on a 2005 Report Server. Reports are built in VS2005 Report Designer and deployed to the Report Server directly. Reports are accessed via IE7 browser.
View 2 Replies
View Related
Mar 22, 2007
Is there anyway to install a Reporting Services Project that doesn't involve either using the Deploy function from Visual Studio or manually via the upload function in Report Manager?
In other words is it possible to build an msi or a set up file that can be used to install Reporting Service projects?
Thanks in advance.
Niall
View 3 Replies
View Related
Jan 29, 2008
Hi,
I have uninstalled and reinstalled several times and I can't get Reporting Services to create the virtual directories in Default Web Site, instead it creates a new web site called Report Server with the virtual directories under that, this Report Server website points to C:Program FilesMicrosoft SQL ServerInetPubwwwroot. Any ideas as to why this happens? My Default Web Site is called Default Website from the initial IIS install , I am on XP Pro SP 2 with IIS 5.1.
This is an issue for me since I don't want to have on another site that doesn't have the aspnet mapings.
I am dumbfounded and can't figure out what to do to make it not do that with the default configuration option checked during install. Should I uninstall and reinstall again and not use the default configuration?
Regards,
Chris
View 3 Replies
View Related
Oct 8, 2007
i have restored site using stsadm, site get successfully restored.
all user of the site able to access the site but the unable to access from same machine on which it is restored.
i got the error
The file exists. (Exception from HRESULT: 0x80070050)
View 1 Replies
View Related
Aug 9, 2007
Hi
I am developing a Report Project ,that contains some reports
using VS.Net ,My task is to install these reports on client Machine.
Is there any option to add a "Set Up Project" to the Report Project solution, so that client may run this setup project(.exe) to install the reports in his server.
My Main requirement is , client can install these reports into his machine by executing a set up file.
Is this possible?, Please suggest me a good solution
View 1 Replies
View Related
Apr 19, 2008
Hi.
Im getting a error when trying to install the QoE reports
it says this in the install log.
Script Output: Parent folder QMSReport created successfully
Data source QMSDB created successfully
Report: Call Detail Report published successfully with no warnings
Report: Call List Report published successfully with no warnings
Report: QMS Home Page published successfully with no warnings
Report: QoE Summary Report published successfully with no warnings
Report: QoE Trend Report published successfully with no warnings
Report: QoE Device Report published successfully with no warnings
Report: Server Health Report published successfully with no warnings
Report: Worst Performing Endpoints Report published successfully with no warnings
Report: QoE Overall Summary Report published successfully with no warnings
Report: AudioStream SubReport published successfully with no warnings
QMS Browser has been removed successfully.
QMS Content Manager has been removed successfully.
QMS Browser has been created successfully
QMS Content Manager has been created successfully
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The user or group name 'MYDOMAINRTCUniversalServerAdmins' is not recognized. ---> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MYDOMAINRTCUniversalServerAdmins' is not recognized.
at Microsoft.ReportingServices.Library.Security.XmlPolicyToAclStruct(String& xmlPolicy, SecurityScope scope, Hashtable relatedRoles, Hashtable& principalsAndRoles)
at Microsoft.ReportingServices.Library.Security.CompileXmlPolicy(SecurityPolicy policy, Byte[]& realSecDesc, String& stringSecDesc)
at Microsoft.ReportingServices.Library.Security.InnerSetPolicies(SecurityPolicy policy)
at Microsoft.ReportingServices.Library.Security.SetCatalogItemPolicies(String catalogItemPath, ItemType catItemType, String xmlPolicy)
at Microsoft.ReportingServices.Library.SetPoliciesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetPolicies(String Item, Policy[] Policies)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.SetPolicies(String Item, Policy[] Policies)
at ____ScriptClass.CreateRoleAssignment(String roleName, String userGroup)
at ____ScriptClass.Main()
Unhandled exception:
The user or group name 'MYDOMAINRTCUniversalServerAdmins' is not recognized.
View 1 Replies
View Related
Mar 9, 2007
Hello,
I don't know if this is the correct place, please redirect if it is wrong.
Before i installed sp2 i had this result to a mdx query
Storetype parametervalue parametercaption plevel
null [Store].[Store types].[All stores] All stores 0
Frs [Store].[Store types].[Store type].&[Frs] frs 1
After i installed SP2 the result turned out to be
Frs [Store].[Store types].[Store type].&[Frs] frs 2
Frs [Store].[Store types].[Store type].&[Frs] frs 2
The query is
WITH MEMBER [Measures].[ParameterCaption] AS '[Store].[Store types].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Store].[Store types].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Store].[Store types].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , DESCENDANTS([Store].[Store types].[All stores],[Store].[Store types].[Store type],self_and_before) ON ROWS FROM [Store]
WHERE (STRTOMEMBER(@PPContact,CONSTRAINED),STRTOMEMBER(@Store,CONSTRAINED))
Why? How can i make it to behave like before?
Thank you
View 2 Replies
View Related
Mar 20, 2007
Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwrootweb.config' because access is denied.
Source Error:
[No relevant source lines]
Source File: c:inetpubwwwrootweb.config Line: 0
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
If you see, it says that the source file is "c:inetpubwwwrootweb.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.
View 8 Replies
View Related
Mar 7, 2007
I am getting the following error using the Web Site Administration
Tool. I have created the database I want to use. Please
help.Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to
create and configure the database, and then return to this tool to set
the provider.
The utility either is not working or I do not know how to use it.
I have SQL 2005 Express and SQL 2000. SQL 2000 is working
properly, not sure about SQL 2005. I have been told to use SQL
2000 because that is what our server is using. I am developing on
my server and when application works will port to our server.
Dee
View 24 Replies
View Related
Sep 18, 2006
Correct me if I'm wrong...
There is a potentially costly error in at least 2 Reporting Services
2005 licensing docs on Microsoft€™s web site. They fixed the docs a few months
ago after I called and told them about it but, now they are bad again! Here are
links to the bogus docs:
http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
Both of these docs say that you need 2 SQL licenses to run
Reporting Services 2005 on a separate server from the SQL engine. This is not
true. You only need 1 license! You do of course need the correct number of CAL's or a CPU license.
The license.txt file that ships on the SQL Server 2005 standard edition install
disk is very clear about this. As you know this is the only doc that is
legally binding. It€™s the only doc that matters. Also, I called and talked to both the
licensing department and the SQL Server product manager about this. Both
confirmed that this was done on purpose in response to customer feedback!
Please help me pressure the marketing document at Microsoft
to fix these confusing documents once and for all! This will be my last post
about this issue. I felt that I had to make one final attempt to get this fixed
before I give up. I€™m having a lot of trouble getting people to actually read
the license.txt and understand the issue. I bet you $5 that the first reply to
this thread will be someone who says I€™m wrong but didn€™t actually read the
license.txt file.
Thanks,
Greg
View 30 Replies
View Related
Jan 16, 2006
I created a website project and added login control etc. etc.Login works fine when running in Debug, however when i try to browse to site via iis , it fails with following error when "Log In" button. I am receive following error:
Server Error in '/LoginTest' Application.
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'.
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: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'aspnetdb', schema 'dbo'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857162
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734774
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +367
System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection connection) +85
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
I can view other pages fine, but login page.
can someone help me?
thanks,
-kushpaw
View 1 Replies
View Related
Jan 9, 2007
I'm currently learning my way around with SQL Server 2005 and asp.net 2.0, and for this I wrote a little site that uses SQL Server for it's backend.
I developed it on my laptop, and it works great, until I deployed the website to my test server, so it's visible to the outside world.
The instance I try to access any page that invokes the database, I get the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).
The server doesn't differ much from my laptop setup, except that it accepts connections through named pipes and TCP/IP and has the Network Service as a user(I also tried running the website under Administrator privileges, just to test it out).
Both IIS and the SQL Server running on the same machine(Windows 2003 Server SP1), and the SQL server accepts connections from a locally running SQL Management Studio Express instance. However: It does not accept connections from my laptop, which resides outside the domain. The server is set to use Windows Authentication for log ins.
What am I doing wrong here?
EDIT: Filled out this found questionare:
[1] Client side:
What is the connection string in you app or DSN? (please specify) connectionString="Data Source=.SQLEXPRESS;Initial Catalog=EroSite;Integrated Security=True" providerName="System.Data.SqlClient"
If client fails to connect, what is the client error messages? Error Locating Server/Instance Specified
Is the client remote or local to the SQL server machine? LocalCan you ping your server? YesCan you telnet to your SQL Server? YesWhat
is your client database provider? ADO.NET2.0
Or/And, what is your client
application? Website using DataSets (Works fine with Server Management Studio)
Is your client computer in the same domain as the Server computer? Local machine
What protocol the client enabled? Shared Memory, TCPIP, Named Pipes.Do
you have aliases configured that match the server name portion of your
connection string? NoDo you select force encryption on server and/or client? No
[2] Server side:
What is the MS SQL version? SQL Server 2005What is the SKU of MS SQL? ExpressWhat
is the SQL Server Protocol enabled? Shared Memory | TCPIP | Named
Pipes
Does the server start successfully? YesIf SQL Server is a named instance, is the SQL browser enabled? YesWhat is the account that the SQL Server is running under? Local SystemDo
you make firewall exception for your SQL server TCP port if you want
connect remotely through TCP provider? not applicableDo
you make firewall exception for SQL Browser UDP port 1434? In SQL2000,
you still need to make firewall exception for UDP port 1434 in order to
support named instance. Not applicable
[3] Platform:
What is the OS version? Windows 2003 SP 1Do you have third party antivirus, anti-spareware software installed? No
View 7 Replies
View Related
Nov 14, 2007
I moved all my databases to sql server 2005 & when appliction is trying to connect to 2005 databases i get the following error
In the connection string i am using
Password=test;Persist Security Info=True;User ID=test;Initial Catalog=test;Data Source=externalip/instancename
this is the only change on the web server
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
please let me know the problem
View 7 Replies
View Related
Aug 1, 2006
I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code.
Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information.
Error Code -1071607685 Error Column 0 Error Desc No status is available.
The only thing I can find for the above error code is
DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE
To add to the confusion, I can not see any errors in the data written to the error table. It appears that after a certain point is reached in the processing, everything, or most records, error out.
Any help is appreciated.
Thanks
Derrick
View 21 Replies
View Related
Nov 14, 2007
Hi,
I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.
Error Code: -2147024894
MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155
I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1651162&SiteID=17
http://support.microsoft.com/kb/940971
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlcasqlassembly.cpp@Do_sqlAssemblyRegSvcs@Do_sqlAssemblyRegSvcs@x80131501
The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.
I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.
Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.
Thank you in advance.
Tim
View 7 Replies
View Related
Nov 13, 2007
My site crashed, so I had to rebuild the Project Site.
I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server).
I then reran SharePoint products and technologies configuration wizard to setup the site.
Configured the Project Service and attached to the existing dB's.
Previously, I used the url http://servername.domain.forest/PWA/default.aspx .
Now when I attempt the use the same URL, I get the following error:
"An unexpected error has occurred"
I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?
View 1 Replies
View Related
Jun 12, 2007
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
View 3 Replies
View Related
Feb 9, 2007
I have set up a locahost site in IIS using the "Configure Web Synchronization Wizard". One of the first test I was asked to do was to open a broweser and browse to http://localhost/MobileTest/sqlcesa30.dll
If all is well I should get a web page with the following line:
SQL Server Mobile Server Agent 3.0
But unfortunately I get an error stating :
"The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance."
I checekd the Event log and found this error related the IIS launch process on my machine.
DCOM got error "Logon failure: unknown user name or bad password. " and was unable to logon .IWAM_Rataq in order to run the server:
where Rataq is the name of my machine. Could my IWAM_Rataq account be corrupted, my other sites on the machine work.
Infact if i put in a Test.htm page in the virtual directory MobileTest I am able to browse to the page.
Can the Account be re-set? is there another problem that I am not aware of. I have Norton Internet 2006 running could that be the reason? Could Norton be blocking the dll from loading? But the event log states it is a Account error.
Any ideas why this might occur? any help is always appreciated
View 1 Replies
View Related
Mar 13, 2008
First off I understand that it is a horrible idea to run extremely large/long running reports, but sometimes it ends up being the best possible solution due to external forces.
I've got a 25,000 page report that we recently converted from crystal reports to SSRS. The SSRS server is a 64bit 2003 server with 32 gigs of ram running SSRS 2005. When running the report through the report manager web application, it renders in the browser/viewer after about 12 minutes. Exporting to pdf through the browser/viewer in the report manager takes an additional 55 minutes. It does work and it produces a whopping 1.03gb pdf.
Unfortunately, I've run into a problem when trying to do this from a console application using the SSRS client API. After about 30-35 minutes I get an exception on the client with the following error:
Exception Message: The underlying connection was closed: An unexpected error occurred on a receive.
InnerException = Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Here is the api call:
Code Snippet
byte[] m_data = reportingService.Render(this.ReportPath, this.ExportFormat, null,
deviceInfo, selectedParameters, null, null, out encoding, out m_mimeType,
out usedParameters, out warnings, out streamIds);
Here are some things I've tried so far:
set the HttpRuntime ExecutionTimeout value to 3 hours on the report server
disabled http keep alives on the report server
increased the script timeout on the report server
set the report to never time out on the server
set the report timeout to several hours on the client call
Disabled antivirus on the client side, and verified there was no antivirus running on the reporting server.
Tried using default credentials in the ReportingService object as opposed to supplying credentailsAny ideas would be appreciated. I understand the best solution is to split the report up into smaller reports, which is the backup option, but being able to keep it as one report is the goal.
View 1 Replies
View Related
Jan 31, 2007
Hi..
I use an Execute SQL Task to return XML via a stored procedure but the task fails for some reason..
My Settings in Execute SQL Task Editor is:
General
ResultSet: XML
SqlStatement EXEC dbo.myProc
ResultSet
Result Name = 0
Variable Name = sXml (Variable Type = String)
When i run the proc (which uses FOR XML PATH) from Management Studio the following is returned (no outputparemeters are used):
<Data>
<Sty>
<Sys>PXX</Sys>
<Ftg>01</Ftg>
<Anv>xxx</Anv>
<Losen>yyyy</Losen>
<Fok>zzz</Fok>
<Funk>02</Funk>
</Sty>
<InkOrd B="N" Id="000945">
<InkOrdNr>000945</InkOrdNr>
<DelLevnsNr>0</DelLevnsNr>
<LagId>001</LagId>
<LevNr>000MAS</LevNr>
<LevDat>2006-10-26T00:00:00</LevDat>
<OrdTyp>01</OrdTyp>
<LevnsVillk>004</LevnsVillk>
<TranspSa>1</TranspSa>
<Sped>001004</Sped>
<BetVillk>017</BetVillk>
<ValuKod>EUR</ValuKod>
<ValuKurs>9.35</ValuKurs>
<InKop>Sara</InKop>
<LevRef>MR RUPINDER</LevRef>
<UpplDat>2006-09-07</UpplDat>
<BestDat>2006-09-18</BestDat>
<Rad B="N">
<InkOrdRad>1</InkOrdRad>
<LagArtNr>70903</LagArtNr>
<LagAttr1>001</LagAttr1>
<StlGrp />
<RabProc />
<KomplLevns />
<LevDat />
<Stl B="N">
<LagAttr2>001</LagAttr2>
<AntBest>3000</AntBest>
<AntVaruHus>0</AntVaruHus>
<InkPr>1.48</InkPr>
</Stl>
</Rad>
</InkOrd>
</Data>
When i run the Execute SQL Task i get the following error:
[Execute SQL Task] Error: Executing the query "exec dbo.myProc " failed with the following error: "End tag 'ROOT' does not match the start tag 'LagArtNr'. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Sicne the XML is valid I have no idea why the task fails...
I have read this link...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=619288&SiteID=1
... where using FOR XML RAW should do it, but it doesn´t help me
Any ideas?
Have a nice day /erik
View 1 Replies
View Related
Feb 24, 2007
Hello, can anyone see a problem with this T-SQL? 1 set ANSI_NULLS ON
2 set QUOTED_IDENTIFIER ON
3 GO
4 ALTER PROCEDURE [dbo].[Logon_P]
5 @User_ID VARCHAR(50),
6 @User_Password VARCHAR(50)
7 AS
8
9 IF EXISTS(SELECT 1
10 FROM [User]
11 WHERE [User_Name] = @User_ID)
12 BEGIN
13 RETURN 1
14 IF ((SELECT User_Password FROM dbo.[User] WHERE [User_Name]) = @User_ID) = @User_Password
15 BEGIN
16 RETURN 2
17 END
18 END
19 ELSE
20 RETURN 0
21 Its returning the following error:Msg 4145, Level 15, State 1, Procedure Logon_P, Line 11An expression of non-boolean type specified in a context where a condition is expected, near ')'.
View 3 Replies
View Related
Apr 13, 2000
Help! I am importing a large comma delimited text file into an existing table useing the BULK INSERT command. The table is 4 colums (char16, char16, varchar50, char1). The first 100 or so lines go in without an error. then, I recieve an error stateing that an entry is too long for the field in the database, and kicks me out. The entry is 50 characters, which is allowed. Any ideas why this would happen?
View 1 Replies
View Related
Feb 12, 2004
Hi ,
I am creating a function which is going to return a table. The Code ofr the function is as follows...
===============================
Create function udf_qcard (@cg1 varchar(25)) returns @rec_card table (t_cusip varchar(10),t_data varchar(70))
AS
begin
declare @t1_sys char(10),@t1_all varchar(11)
declare @temp_qcard table (tdata varchar(11) collate SQL_Latin1_General_CP1_CS_AS)
if (substring(@cg1,1,2)='Q$')
set @cg1 = (select substring(@cg1,3,len(@cg1)) where substring(@cg1,1,2)='Q$')
DECLARE c1 SCROLL CURSOR FOR select groups_system, substring(groups_alldata,3,10) from tbl_groups
where groups_system = @cg1 and groups_alldata like 'Q$%' and groups_seq>=1 FOR READ ONLY
insert into @temp_qcard values(@cg1)
OPEN C1
FETCH NEXT FROM c1 INTO @t1_sys,@t1_all
WHILE @@FETCH_STATUS = 0
BEGIN
insert into @temp_qcard values(@t1_all)
declare @t2_sys char(10),@t2_all varchar(10)
DECLARE c2 SCROLL CURSOR FOR select groups_system, substring(groups_alldata,3,10) from tbl_groups
where groups_system = @t1_all and groups_alldata like 'Q$%' and groups_seq>=1 FOR READ ONLY
begin
OPEN C2
FETCH NEXT FROM c2 INTO @t2_sys,@t2_all
WHILE @@FETCH_STATUS = 0
BEGIN
insert into @temp_qcard values(@t2_all)
declare @t3_sys char(10),@t3_all varchar(10)
DECLARE c3 SCROLL CURSOR FOR select groups_system, substring(groups_alldata,3,10) from tbl_groups
where groups_system = @t2_all and groups_alldata like 'Q$%' and groups_seq>=1 FOR READ ONLY
begin
OPEN C3
FETCH NEXT FROM c3 INTO @t3_sys,@t3_all
WHILE @@FETCH_STATUS = 0
BEGIN
insert into @temp_qcard values(@t3_all)
FETCH NEXT FROM c3 INTO @t3_sys,@t3_all
end
end
close c3
deallocate c3
FETCH NEXT FROM c2 INTO @t2_sys,@t2_all
end
end
close c2
DEALLOCATE c2
FETCH NEXT FROM c1 INTO @t1_sys,@t1_all
END
CLOSE c1
DEALLOCATE c1
Insert @rec_card select groups_q+groups_cusip,groups_data from tbl_groups
where groups_system in (select tdata from @temp_qcard) and groups_seq>=1 and groups_alldata not like 'Q$%' order by groups_alldata
RETURN
END
==========================
While compiling this I am getting the Below error ....
==================
Server: Msg 1049, Level 15, State 1, Procedure udf_qcard, Line 10
Mixing old and new syntax to specify cursor options is not allowed.
Server: Msg 1049, Level 15, State 1, Procedure udf_qcard, Line 23
Mixing old and new syntax to specify cursor options is not allowed.
Server: Msg 1049, Level 15, State 1, Procedure udf_qcard, Line 35
Mixing old and new syntax to specify cursor options is not allowed.
=================
Can Anyone please help me how to resolve this issue...
Thanks with Regards.
-Mohit.
View 1 Replies
View Related
Jan 15, 2001
Lately I noticed that I cannot return any rows using enterprise manager. The version I am using is MS-SQL 7.0 with SP 1 on NT. This will return an error:-
An unexpected error happened during this operatation.
[Query]-Query Designer encountered a query error.
Unspecified error.
I can return rows using another computer with enterprise manager installed.
Any help appreciated.
Tony
View 2 Replies
View Related
Aug 27, 2014
This query was run against a database on 2008 SP3 and 2012 SP2
Here is an example of what I ran
Declare @A_number varchar(5)
Select Top 1 Column_Is_an_int = @A_number
From Our_Main_Table
Where A_Database_Name = 'A database with many records in this table and multiple records in the Column_is_an_int some are more than 5 characters'
Select @A_number
Exec My_Stored_Proc @A_Nmuber
The top result for that database had an integer that was 8 characters including the - sign.
When the query ran I would normally expect it to throw the binary data cannot be truncated error. However in this case it returned a * in the variable which then tried to pass it in to the SP which of course threw a fit.
Once I changed the varchar(5) to varchar(50) it worked perfectly.
View 5 Replies
View Related
Jul 23, 2005
HI,I am getting an error on my sqlserver database server. My clients aregetting kicked out of transaction, giving an error"New transaction cannot enlist in the specified transaction coordinator"When i saw the event log on the DB server i found the following message************************************Event Type: InformationEvent Source: MSDTCEvent Category: CMEvent ID: 4156Date: 6/13/2005Time: 9:30:48 AMUser: N/AComputer: XXXXXXXDescription:String message: ProcID= 0x780 QMGR::Receive Returning Out Of ResourcesError.************************************************** ***************I am using SQLServer 2000 Advanced server, on Windows 2000 Advanced server.Thanks for help.Indushekar.
View 4 Replies
View Related
