Get Authentication Error in upgrade SQL 2005 named instance to SP1 TCP

I got the following error using either NT or SQL Login ('sa') that are sysadmin in my SQL 2005 instance:

Your Account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To process further deselect the instances to which connectivity cannot be established.

However, I would login to SQL 2005 named instance, either NT or SQL login 'sa' without any problems to do anything I want because both are sysadmin.

<PS> Note that my default SQL instance in my local server is SQL 2000 and SQL 2005 named instance.

Richard

Hi Richard, I just tried this on my machine and didn't hit any issues. Can you send a little more info about the state of your machine? Are you running SQL 2000 SP4? What SKU is SQL 2000 and what SKU is 2005? Are they both ENT? And how are you connecting to the 2005 named instance? I was able to install SP1 using Windows Authentication. Can you submit your install logs so I can try to help debug?

Here's what I did:
1) Install SQL 2000 ENT SKU as local system, setting SA password - default instance
2) Apply SQL 2000 SP4
3) Install SQL 2005 ENT SKU setting SQL to run under domain account - named instance
4) Install SQL 2005 SP1

Does that look similar to your repro steps?

Thanks,
Samuel Lester (MSFT)

|||

What I hae done is 1), 3), and get the error for 4). Attached is the log file for your information:

4 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:40.464 splevel = 0,1
04/03/2006 15:54:40.504 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:40.574 upgradecode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B}
04/03/2006 15:54:40.644 version = 9
04/03/2006 15:54:40.694
04/03/2006 15:54:40.714 File Group Details: MSI
04/03/2006 15:54:40.734 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:40.764 File Details: msxml6.msi
04/03/2006 15:54:40.784
04/03/2006 15:54:40.824 Instance Details: MSXML 6.0 Parser
04/03/2006 15:54:40.854 productcode = {AEB9948B-4FF2-47C9-990E-47014492A0FE}
04/03/2006 15:54:40.884
04/03/2006 15:54:40.904 Product Details:
04/03/2006 15:54:40.924 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixMsxml6_x64.inf
04/03/2006 15:54:40.944 baselinebuild = 1399
04/03/2006 15:54:40.994 build = 2040
04/03/2006 15:54:41.015 description = MSXML 6.0 Parser (64-bit)
04/03/2006 15:54:41.045 details = Service Pack for Microsoft XML 6.0 Parser.
04/03/2006 15:54:41.075 kbarticle = KB913090
04/03/2006 15:54:41.115 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:41.155 lcid = 1033
04/03/2006 15:54:41.195 legalproductname = MSXML 6.0 Parser (64-bit)
04/03/2006 15:54:41.215 machinetype = x64
04/03/2006 15:54:41.305 package = HotFixMsxml6_x64
04/03/2006 15:54:41.325 packagetype = Hotfix
04/03/2006 15:54:41.355 productname = Redist9
04/03/2006 15:54:41.405 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:41.435 splevel = 0,1
04/03/2006 15:54:41.455 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:41.475 upgradecode = {5BBED1F8-E6F3-4A02-BC97-26D35BE200CA}
04/03/2006 15:54:41.595 version = 9
04/03/2006 15:54:41.695
04/03/2006 15:54:41.776 File Group Details: MSI
04/03/2006 15:54:41.856 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:41.946 File Details: msxml6_x64.msi
04/03/2006 15:54:42.196
04/03/2006 15:54:42.296 Product Details:
04/03/2006 15:54:42.396 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixSqlxml4.inf
04/03/2006 15:54:42.507 baselinebuild = 1399
04/03/2006 15:54:42.617 build = 2040
04/03/2006 15:54:42.687 description = SQLXML4
04/03/2006 15:54:42.757 details = Service Pack for Microsoft SQLXML 4.0.
04/03/2006 15:54:42.837 kbarticle = KB913090
04/03/2006 15:54:42.937 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:43.037 lcid = 1033
04/03/2006 15:54:43.138 legalproductname = SQLXML4
04/03/2006 15:54:43.238 machinetype = x86
04/03/2006 15:54:43.368 package = HotFixSqlxml4
04/03/2006 15:54:43.398 packagetype = Hotfix
04/03/2006 15:54:43.438 productcode = {8C62A94B-4AB6-485F-A111-93056684D340}
04/03/2006 15:54:43.458 productname = Redist9
04/03/2006 15:54:43.488 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:43.578 splevel = 0,1
04/03/2006 15:54:43.638 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:43.678 upgradecode = {D9CA3D82-6F1B-41A7-8141-B90ACA8F865B}
04/03/2006 15:54:43.708 version = 9
04/03/2006 15:54:43.748
04/03/2006 15:54:43.768 File Group Details: MSI
04/03/2006 15:54:43.809 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:43.829 File Details: sqlxml4.msi
04/03/2006 15:54:43.869
04/03/2006 15:54:43.899 Instance Details: SQLXML4
04/03/2006 15:54:43.919 productcode = {8C62A94B-4AB6-485F-A111-93056684D340}
04/03/2006 15:54:43.969
04/03/2006 15:54:43.999 Product Details:
04/03/2006 15:54:44.019 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixSqlxml4_x64.inf
04/03/2006 15:54:44.069 baselinebuild = 1399
04/03/2006 15:54:44.099 build = 2040
04/03/2006 15:54:44.129 description = SQLXML4 (64-bit)
04/03/2006 15:54:44.169 details = Service Pack for Microsoft SQLXML 4.0.
04/03/2006 15:54:44.199 kbarticle = KB913090
04/03/2006 15:54:44.229 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:44.269 lcid = 1033
04/03/2006 15:54:44.299 legalproductname = SQLXML4 (64-bit)
04/03/2006 15:54:44.329 machinetype = x64
04/03/2006 15:54:44.359 package = HotFixSqlxml4_x64
04/03/2006 15:54:44.399 packagetype = Hotfix
04/03/2006 15:54:44.429 productname = Redist9
04/03/2006 15:54:44.459 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:44.510 splevel = 0,1
04/03/2006 15:54:44.600 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:44.650 upgradecode = {F457D8E6-7686-437D-9B17-E21D45CCABD8}
04/03/2006 15:54:44.680 version = 9
04/03/2006 15:54:44.720
04/03/2006 15:54:44.750 File Group Details: MSI
04/03/2006 15:54:44.780 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:44.820 File Details: sqlxml4_x64.msi
04/03/2006 15:54:44.850
04/03/2006 15:54:44.880 Product Details:
04/03/2006 15:54:44.920 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixSQLServer2005_BC.inf
04/03/2006 15:54:44.950 baselinebuild = 1399
04/03/2006 15:54:44.980 build = 2040
04/03/2006 15:54:45.020 description = Backward Compatibility
04/03/2006 15:54:45.050 details = Service Pack for the Backward Compatibility components, including Data Transformation Services Runtime and SQL-DMO.
04/03/2006 15:54:45.080 kbarticle = KB913090
04/03/2006 15:54:45.120 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:45.160 lcid = 1033
04/03/2006 15:54:45.191 legalproductname = Microsoft SQL Server 2005 Backward Compatibility
04/03/2006 15:54:45.231 machinetype = x86
04/03/2006 15:54:45.261 package = HotFixSQLServer2005_BC
04/03/2006 15:54:45.291 packagetype = Hotfix
04/03/2006 15:54:45.321 productcode = {96327C3C-96BE-4C7A-A6F7-A71635E5949A}
04/03/2006 15:54:45.361 productname = Redist9
04/03/2006 15:54:45.391 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:45.421 splevel = 0,1
04/03/2006 15:54:45.461 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:45.491 upgradecode = {1E70C6C9-E1B7-4A74-BC8C-8EB5D010CEC9}
04/03/2006 15:54:45.521 version = 9
04/03/2006 15:54:45.561
04/03/2006 15:54:45.591 File Group Details: MSI
04/03/2006 15:54:45.621 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:45.661 File Details: SQLServer2005_BC.msi
04/03/2006 15:54:45.691
04/03/2006 15:54:45.721 Instance Details: Backward Compatibility
04/03/2006 15:54:45.761 productcode = {96327C3C-96BE-4C7A-A6F7-A71635E5949A}
04/03/2006 15:54:45.791
04/03/2006 15:54:45.821 Product Details:
04/03/2006 15:54:45.851 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixSQLServer2005_BC_x64.inf
04/03/2006 15:54:45.892 baselinebuild = 1399
04/03/2006 15:54:45.922 build = 2040
04/03/2006 15:54:45.952 description = Backward Compatibility (64-bit)
04/03/2006 15:54:45.992 details = Service Pack for the Backward Compatibility components, including Data Transformation Services Runtime and SQL-DMO.
04/03/2006 15:54:46.022 kbarticle = KB913090
04/03/2006 15:54:46.052 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:46.092 lcid = 1033
04/03/2006 15:54:46.122 legalproductname = Microsoft SQL Server 2005 Backward Compatibility (64-bit)
04/03/2006 15:54:46.152 machinetype = x64
04/03/2006 15:54:46.192 package = HotFixSQLServer2005_BC_x64
04/03/2006 15:54:46.222 packagetype = Hotfix
04/03/2006 15:54:46.322 productname = Redist9
04/03/2006 15:54:46.362 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:46.402 splevel = 0,1
04/03/2006 15:54:46.432 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:46.462 upgradecode = {7B6BF434-3C72-4DB3-8049-FEF31AEAFF9A}
04/03/2006 15:54:46.492 version = 9
04/03/2006 15:54:46.532
04/03/2006 15:54:46.562 File Group Details: MSI
04/03/2006 15:54:46.593 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:46.633 File Details: SQLServer2005_BC_x64.msi
04/03/2006 15:54:46.663
04/03/2006 15:54:46.693 Product Details:
04/03/2006 15:54:46.733 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixSqlWriter.inf
04/03/2006 15:54:46.763 baselinebuild = 1399
04/03/2006 15:54:46.793 build = 2040
04/03/2006 15:54:46.833 description = Microsoft SQL Server VSS Writer
04/03/2006 15:54:46.863 details = Service Pack for Microsoft SQL Server VSS Writer.
04/03/2006 15:54:46.893 kbarticle = KB913090
04/03/2006 15:54:46.933 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:46.973 lcid = 1033
04/03/2006 15:54:47.003 legalproductname = Microsoft SQL Server VSS Writer
04/03/2006 15:54:47.053 machinetype = x86
04/03/2006 15:54:47.083 package = HotFixSqlWriter
04/03/2006 15:54:47.113 packagetype = Hotfix
04/03/2006 15:54:47.153 productcode = {1CBE3804-20DF-48DA-B048-895C206E80A5}
04/03/2006 15:54:47.183 productname = Redist9
04/03/2006 15:54:47.213 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:47.253 splevel = 0,1
04/03/2006 15:54:47.284 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:47.314 upgradecode = {65D8E1DF-6201-4B53-A0F9-E654F8E80F97}
04/03/2006 15:54:47.344 version = 9
04/03/2006 15:54:47.384
04/03/2006 15:54:47.414 File Group Details: MSI
04/03/2006 15:54:47.444 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:47.484 File Details: SqlWriter.msi
04/03/2006 15:54:47.514
04/03/2006 15:54:47.544 Instance Details: Microsoft SQL Server VSS Writer
04/03/2006 15:54:47.584 productcode = {1CBE3804-20DF-48DA-B048-895C206E80A5}
04/03/2006 15:54:47.614
04/03/2006 15:54:47.644 Product Details:
04/03/2006 15:54:47.684 INF File Name: \\2003SERVER\d$\9a954d1afa2c57beebe098\HotFixSqlWriter_x64.inf
04/03/2006 15:54:47.714 baselinebuild = 1399
04/03/2006 15:54:47.744 build = 2040
04/03/2006 15:54:47.774 description = Microsoft SQL Server VSS Writer (64-bit)
04/03/2006 15:54:47.814 details = Service Pack for Microsoft SQL Server VSS Writer.
04/03/2006 15:54:47.844 kbarticle = KB913090
04/03/2006 15:54:47.874 kbarticlehyperlink = http://support.microsoft.com/?kbid=913090
04/03/2006 15:54:47.944 lcid = 1033
04/03/2006 15:54:47.995 legalproductname = Microsoft SQL Server VSS Writer (64-bit)
04/03/2006 15:54:48.045 machinetype = x64
04/03/2006 15:54:48.085 package = HotFixSqlWriter_x64
04/03/2006 15:54:48.155 packagetype = Hotfix
04/03/2006 15:54:48.225 productname = Redist9
04/03/2006 15:54:48.275 servicepackname = Microsoft SQL Server 2005 Service Pack 1 Setup
04/03/2006 15:54:48.345 splevel = 0,1
04/03/2006 15:54:48.405 supportdir = \\2003SERVER\d$\9a954d1afa2c57beebe098
04/03/2006 15:54:48.475 upgradecode = {E9031696-DD39-4C25-BAEB-425FF28279EA}
04/03/2006 15:54:48.625 version = 9
04/03/2006 15:54:48.716
04/03/2006 15:54:48.756 File Group Details: MSI
04/03/2006 15:54:48.786 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/03/2006 15:54:48.816 File Details: SqlWriter_x64.msi
04/03/2006 15:54:48.856
04/03/2006 15:55:14.993 Authenticating user using Windows Authentication
04/03/2006 15:55:15.073 SQL Service MSSQL$YUKON was previously running, ready for authentication
04/03/2006 15:55:15.114 SQL Agent Service SQLAgent$YUKON was not previously running
04/03/2006 15:55:24.247 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
04/03/2006 15:55:33.009 Failed to receive sysadmin status for RS instance: YUKON
04/03/2006 15:55:58.786 Authenticating user using SAPWD
04/03/2006 15:55:58.836 SQL Service MSSQL$YUKON was previously running, ready for authentication
04/03/2006 15:55:58.866 SQL Agent Service SQLAgent$YUKON was not previously running
04/03/2006 15:56:07.509 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
04/03/2006 15:56:16.151 Failed to receive sysadmin status for RS instance: YUKON
04/03/2006 15:57:24.440 Hotfix package closed

|||I get the same problem. I have installed SQL 2000 SP4 and it did not fix it.

get an error on a sample code

This is a sample code from an MSDN help site. I copied it and pasted into an open new query. I tried to execute it and got two errors:

USE AdventureWorks;
GO
DECLARE @.tablename sysname
SET @.tablename = N'Person.AddressType'
table_loop:
IF (@.@.FETCH_STATUS <> -2)
BEGIN
SELECT @.tablename = RTRIM(UPPER(@.tablename))
EXEC ('SELECT ''' + @.tablename + ''' = COUNT(*) FROM '
+ @.tablename )
PRINT ' '
END
FETCH NEXT FROM tnames_cursor INTO @.tablename
IF (@.@.FETCH_STATUS <> -1) GOTO table_loop
GO

The errors are:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'PERSON.ADDRESSTYPE'.

Msg 16916, Level 16, State 1, Line 9
A cursor with the name 'tnames_cursor' does not exist

The database is connected. Table Person.AddressType is a part of it.

What is wrong?

Thanks.

Did you get this from the GOTO help topic? This note is in the topic right above the example:

Note:

The tnames_cursor cursor is not defined. This example is for illustration only.

so effectively this example is expected not to work. If you need some specific help on using the GOTO syntax, I would suggest asking in the T-SQL forum, that's where the syntax gurus hang out.

Mike

Get a timeout error when trying to export to excel

Hi I generate a report successfully in SQL reporting services . Once
the report is generated I then select the export option to export it
to excel
I then get this error message( see below) after waiting about 20 mins
for the excel file to be generated.
There is a lot of data in this report . There is 1240 pages and there
is about 50 rows for each page. That makes it 62000 rows in the
report.
I'm using excel 2007 on my pc. I've updated sql server 2005 to sp2.
Is there some limitation to the amount of data you can export to
excel.'
thanks in advance
Aidan Geraghty
Server Error in '/Reports' Application.
________________________________________
For more information about this error navigate to the report server on
the local server machine, or enable remote errors
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.Exception: For more information about this
error navigate to the report server on the local server machine, or
enable remote errors
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:
[Exception: For more information about this error navigate to the
report server on the local server machine, or enable remote errors]
[Exception: An error occurred during rendering of the report.]
[Exception: The operation has timed out. The report server has
canceled the operation.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
isAbortable, String url, Stream outputStream, String& mimeType,
String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean
isAbortable, String format, String deviceInfo, NameValueCollection
urlAccessParameters, Stream reportStream, String& mimeType, String&
fileNameExtension) +958
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
format, String deviceInfo, NameValueCollection additionalParams,
String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection
urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
Boolean& completedSynchronously) +64
________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.42;
ASP.NET Version:2.0.50727.210
When I look at the log files on the server I find this error message:
2007-03-30 14:12:44 65.53.207.181 50411 10.251.129.151 80 HTTP/1.1
GET /Reports/ - 478678319 Connection_Dropped DefaultAppPool
2007-03-30 14:17:43 65.53.206.137 21323 10.251.129.151 80 HTTP/1.1
GET /Reports/Reserved.ReportViewerWebControl.axd?
ReportSession=refs1e553cirzg45tdvejtuw&ControlID=ec48b970-2dd3-438c-9b98-
df1db9c941ab&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=RebateCoopFundsUploadSixMonthsReport&ContentDisposition=OnlyHtmlInline&Format=EXCEL
- 478678319 Connection_Dropped DefaultAppPool
2007-03-30 14:19:13 65.53.206.137 21501 10.251.129.151 80 HTTP/1.1
GET /reports/ - 478678319 Connection_Dropped DefaultAppPool
2007-03-30 14:23:42 65.53.207.181 50419 10.251.129.151 80 HTTP/1.1
GET /Reports/ - 478678319 Connection_Dropped DefaultAppPool
2007-03-30 14:24:54 10.253.212.85 3385 10.253.212.85 80 HTTP/1.1 GET /
ReportServer?%2fReports
%2fRebateCoopFundsUploadSixMonthsReport&rs:SessionID=refs1e553cirzg45tdvejtuw&rs:command=Render&rs:Format=EXCEL&rc:Toolbar=false&rs:ErrorResponseAsXml=true&rs:AllowNewSessions=false
- 478678319 Connection_Abandoned_By_AppPool DefaultAppPool
2007-03-30 14:24:54 65.53.206.137 21338 10.251.129.151 80 HTTP/1.1
GET /Reports/Reserved.ReportViewerWebControl.axd?
ReportSession=refs1e553cirzg45tdvejtuw&ControlID=ec48b970-2dd3-438c-9b98-
df1db9c941ab&Culture=1033&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl160TouchSession0&CacheSeed=Fri
%20Mar%2030%2014%3A49%3A52%202007 - 478678319
Connection_Abandoned_By_AppPool DefaultAppPool
2007-03-30 14:24:54 10.251.129.151 3419 10.251.129.151 80 HTTP/1.1
POST /reports/ReportService2005.asmx - 478678319
Connection_Abandoned_By_AppPool DefaultAppPool
2007-03-30 14:24:54 65.53.207.181 50461 10.251.129.151 80 HTTP/1.1
GET /Reports/ - 478678319 Connection_Abandoned_By_AppPool
DefaultAppPool
2007-03-30 14:27:09 65.53.206.137 21553 10.251.129.151 80 - - - - -
Timer_ConnectionIdle -
2007-03-30 15:07:17 10.253.212.85 3710 10.253.212.85 80 - - - - -
Timer_ConnectionIdle -
2007-03-30 15:07:17 10.253.212.85 3714 10.253.212.85 80 - - - - -
Timer_ConnectionIdle -On Apr 2, 9:04 am, aidan.gerag...@.gmail.com wrote:
> Hi I generate a report successfully in SQL reporting services . Once
> the report is generated I then select the export option to export it
> to excel
> I then get this error message( see below) after waiting about 20 mins
> for the excel file to be generated.
> There is a lot of data in this report . There is 1240 pages and there
> is about 50 rows for each page. That makes it 62000 rows in the
> report.
> I'm using excel 2007 on my pc. I've updated sql server 2005 to sp2.
> Is there some limitation to the amount of data you can export to
> excel.'
> thanks in advance
> Aidan Geraghty
> Server Error in '/Reports' Application.
> ________________________________________
> For more information about this error navigate to the report server on
> the local server machine, or enable remote errors
> 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.Exception: For more information about this
> error navigate to the report server on the local server machine, or
> enable remote errors
> 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:
> [Exception: For more information about this error navigate to the
> report server on the local server machine, or enable remote errors]
> [Exception: An error occurred during rendering of the report.]
> [Exception: The operation has timed out. The report server has
> canceled the operation.]
> Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
> isAbortable, String url, Stream outputStream, String& mimeType,
> String& fileNameExtension) +489
> Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean
> isAbortable, String format, String deviceInfo, NameValueCollection
> urlAccessParameters, Stream reportStream, String& mimeType, String&
> fileNameExtension) +958
> Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
> format, String deviceInfo, NameValueCollection additionalParams,
> String& mimeType, String& fileExtension) +84
> Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection
> urlQuery, HttpResponse response) +143
> Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> context) +75
> System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> +154
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
> Boolean& completedSynchronously) +64
> ________________________________________
> Version Information: Microsoft .NET Framework Version:2.0.50727.42;
> ASP.NET Version:2.0.50727.210
> When I look at the log files on the server I find this error message:
> 2007-03-30 14:12:44 65.53.207.181 50411 10.251.129.151 80 HTTP/1.1
> GET /Reports/ - 478678319 Connection_Dropped DefaultAppPool
> 2007-03-30 14:17:43 65.53.206.137 21323 10.251.129.151 80 HTTP/1.1
> GET /Reports/Reserved.ReportViewerWebControl.axd?
> ReportSession=refs1e553cirzg45tdvejtuw&ControlID=ec48b970-2dd3-438c-9b98-
> df1db9c941ab&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=RebateCoopFundsUploadSixMonthsReport&ContentDisposition=OnlyHtmlInline&Format=EXCEL
> - 478678319 Connection_Dropped DefaultAppPool
> 2007-03-30 14:19:13 65.53.206.137 21501 10.251.129.151 80 HTTP/1.1
> GET /reports/ - 478678319 Connection_Dropped DefaultAppPool
> 2007-03-30 14:23:42 65.53.207.181 50419 10.251.129.151 80 HTTP/1.1
> GET /Reports/ - 478678319 Connection_Dropped DefaultAppPool
> 2007-03-30 14:24:54 10.253.212.85 3385 10.253.212.85 80 HTTP/1.1 GET /
> ReportServer?%2fReports
> %2fRebateCoopFundsUploadSixMonthsReport&rs:SessionID=refs1e553cirzg45tdvejtuw&rs:command=Render&rs:Format=EXCEL&rc:Toolbar=false&rs:ErrorResponseAsXml=true&rs:AllowNewSessions=false
> - 478678319 Connection_Abandoned_By_AppPool DefaultAppPool
> 2007-03-30 14:24:54 65.53.206.137 21338 10.251.129.151 80 HTTP/1.1
> GET /Reports/Reserved.ReportViewerWebControl.axd?
> ReportSession=refs1e553cirzg45tdvejtuw&ControlID=ec48b970-2dd3-438c-9b98-
> df1db9c941ab&Culture=1033&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl160TouchSession0&CacheSeed=Fri
> %20Mar%2030%2014%3A49%3A52%202007 - 478678319
> Connection_Abandoned_By_AppPool DefaultAppPool
> 2007-03-30 14:24:54 10.251.129.151 3419 10.251.129.151 80 HTTP/1.1
> POST /reports/ReportService2005.asmx - 478678319
> Connection_Abandoned_By_AppPool DefaultAppPool
> 2007-03-30 14:24:54 65.53.207.181 50461 10.251.129.151 80 HTTP/1.1
> GET /Reports/ - 478678319 Connection_Abandoned_By_AppPool
> DefaultAppPool
> 2007-03-30 14:27:09 65.53.206.137 21553 10.251.129.151 80 - - - - -
> Timer_ConnectionIdle -
> 2007-03-30 15:07:17 10.253.212.85 3710 10.253.212.85 80 - - - - -
> Timer_ConnectionIdle -
> 2007-03-30 15:07:17 10.253.212.85 3714 10.253.212.85 80 - - - - -
> Timer_ConnectionIdle -
I'm not sure about a limitation in MS Excel 2007; but, in MS Excel
2003, the limit was somewhere around 65000 rows. In my opinion, it
sounds like it might be too much data to stream into Excel. Sorry I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Get "Invalid cursor state" when modifying a table in SQL 2000

When I try to modify a table that I just created I get the following error message: - Unable to modify table ODBC error:[Mircrosoft][ODBC SQL Server Driver] Invalid cursor state.

SP3 has been applied to SQL Server 2000.

Can anyone help explain what is causing this error? There is sufficient space for the database and transaction log.

If you reuse an hstmt after doing a query that opens a cursor, you need to call SQLCloseCursor(hstmt) before you make your next call.

Hope that helps,

John

|||I guess that you message is from any GUI to manage SQL Server, right ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
sql

Get 'DB Error 10083' with SQL Server 2000

Setup: SQL Server 2000 sp3 on a Windows 2000 machine, transactions running through an ODBC connection running SQLSRV32.dll version 2000.86.1830.00

Transactions: Being generated via a Citrix server (MetaFrame Presentation Server, Enterprise Edition 4.0(Build 2198), Service Pack 2005.04.... This sits on top of an install of Windows 2003 terminal server installaion.

Error: Appears to only be happening on a ADD(Insert) ....

Any thoughts on this would be a big help.

Dave

Is there any more to the error message? I can't find reference to error 10083|||

Here is the exact message I received...

Db Error: 10083

"Cursor statement generated no results.

No changes made to database.

Insert Into Test (testid, testdesc,sequence,createdt,creatorid,lastmodifieddt,modifierid,testinstances,allowinstances,activityid,worklisttable,qutoqc) Values ('999','Test Test',0,'10-31-2006 9:22:30.253','SysAdmin','10-31-2006 9:22:30.253','SysAdmin',1,'N',0,'N','N')

The above highlighted text was the exact message...

Thanks-David

|||

This is not a SQL Server error message. You need to check your data access layer. Here are few guesses on what the problem is:

1. You are issueing insert statement but expecting a result set to be returned. SQL Server will return some result if SET NOCOUNT OFF (in which it will be number of rows affected) or if the insert trigger returns results. In other cases, if SET NOCOUNT ON is set you will not get any results for the insert statement

2. You are doing the wrong thing from the data access layer and should use some direct execute mechanism that doesn't look for results from the command.

|||

Thanks for giving me some direction on this issue! I will do some testing to how I can resolve this issue in a good way.

David

|||

I have same this error message in some computer

I use MSDE with 2 clients. found this problem 1 client.

The error message show with this query

Db Error: 10083

"Cursor statement generated no results.

No changes made to database.

INSERT INTO EMSide ( SideID, SideCode, SideName, SideNameEng ) VALUES ( 1000, '001', 'test', '' )

This is query from another computer:

Begin Transaction

go

declare @.P1 int

set @.P1=180150003

declare @.P2 int

set @.P2=2

declare @.P3 int

set @.P3=-1

exec sp_cursoropen @.cursor = @.P1 output, @.stmt = 'SELECT sidecode ', @.scrollopt = @.P2 output, @.ccopt = 4, @.rows = @.P3 output

select @.P1, @.P2, @.P3

go

exec sp_cursorfetch @.cursor = 180150003, @.fetchtype = 1, @.rownumber = 0, @.nrows = 2

go

exec sp_cursorclose @.cursor = 180150003

go

Select prefix From SMId where name ='aum/AUM/emside'

go

Select max ( prefix ) From SMID Where Type =1 And charindex ( 'emside' , name ) > 0

go

Begin Transaction

go

INSERT INTO SMID ( Name , Prefix , Type ) VALUES ( 'aum/AUM/emside' , 1000 , 1 )

go

Commit Transaction

go

declare @.P1 int

set @.P1=180150004

declare @.P2 int

set @.P2=8

declare @.P3 int

set @.P3=1

exec sp_cursoropen @.cursor = @.P1 output, @.stmt = 'SELECT max(sidei', @.scrollopt = @.P2 output, @.ccopt = 4, @.rows = @.P3 output

select @.P1, @.P2, @.P3

go

exec sp_cursorfetch @.cursor = 180150004, @.fetchtype = 1, @.rownumber = 0, @.nrows = 1

go

exec sp_cursorclose @.cursor = 180150004

go

declare @.P1 int

set @.P1=180150005

declare @.P2 int

set @.P2=2

declare @.P3 int

set @.P3=-1

exec sp_cursoropen @.cursor = @.P1 output, @.stmt = 'SELECT sideid FR', @.scrollopt = @.P2 output, @.ccopt = 4, @.rows = @.P3 output

select @.P1, @.P2, @.P3

go

exec sp_cursorfetch @.cursor = 180150005, @.fetchtype = 1, @.rownumber = 0, @.nrows = 2

go

exec sp_cursorclose @.cursor = 180150005

go

INSERT INTO EMSide ( SideID, SideCode, SideName, SideNameEng ) VALUES ( 1000, '001', 'test', '' )

go

Select InsertFlag From SMaudit_option Where brchid =1

go

SELECT GETDATE( ) As cf_server_time

go

Select prefix From SMId where name ='aum/AUM/smAudit'

go

declare @.P1 int

set @.P1=180150006

declare @.P2 int

set @.P2=8

declare @.P3 int

set @.P3=1

exec sp_cursoropen @.cursor = @.P1 output, @.stmt = 'SELECT max(audit', @.scrollopt = @.P2 output, @.ccopt = 4, @.rows = @.P3 output

select @.P1, @.P2, @.P3

go

exec sp_cursorfetch @.cursor = 180150006, @.fetchtype = 1, @.rownumber = 0, @.nrows = 1

go

exec sp_cursorclose @.cursor = 180150006

go

declare @.P1 int

set @.P1=180150007

declare @.P2 int

set @.P2=2

declare @.P3 int

set @.P3=-1

exec sp_cursoropen @.cursor = @.P1 output, @.stmt = 'SELECT audit_id ', @.scrollopt = @.P2 output, @.ccopt = 4, @.rows = @.P3 output

select @.P1, @.P2, @.P3

go

exec sp_cursorfetch @.cursor = 180150007, @.fetchtype = 1, @.rownumber = 0, @.nrows = 2

go

exec sp_cursorclose @.cursor = 180150007

go

INSERT INTO SMAudit ( audit_id, audit_system, audit_screen, audit_datetime, audit_username, audit_action, audit_docuno, audit_columnid, brchid, audit_computername, audit_refid ) VALUES ( 139002, 1, 6, '5-3-2007 18:36:24.453', 'prosoft', 'I', '001', 1000, 1, 'AUM', 139002 )

go

Commit Transaction

go

|||

This's profiler from another computer with same form.

Begin Transaction
go
sp_tables @.table_name = 'emside'
go
sp_special_columns @.table_name = 'emside'
go
select emside.SideID FROM emside where 0 = 1
go
select timestamp from emside where 0 = 1
go
select * from emside where 0 = 1
go
SELECT sidecode FROM emside where 0 = 1
go
set rowcount 2
go
SELECT sidecode , emside.SideID , emside.SideID, emside.SideCode, emside.SideName, emside.SideNameEng, emside.Remark FROM emside WHERE (sidecode like '%AAA%' AND (LTRIM(sidecode) = 'AAA' OR RTRIM(sidecode) = 'AAA')) order by emside.SideID
go
set rowcount 0
go
Select prefix From SMId where name ='accdomain\sql2000/MORAGOTD/emside'
go
Select max ( prefix ) From SMID Where Type =1 And charindex ( 'emside' , name ) > 0
go
Begin Transaction
go
INSERT INTO SMID ( Name , Prefix , Type ) VALUES ( 'accdomain\sql2000/MORAGOTD/emside' , 2000 , 1 )
go
Commit Transaction
go
sp_tables @.table_name = 'emside'
go
sp_special_columns @.table_name = 'emside'
go
select emside.SideID FROM emside where 0 = 1
go
select timestamp from emside where 0 = 1
go
select * from emside where 0 = 1
go
SELECT sideid FROM emside where 0 = 1
go
set rowcount 2
go
SELECT sideid , emside.SideID , emside.SideID, emside.SideCode, emside.SideName, emside.SideNameEng, emside.Remark FROM emside WHERE sideid = 2000 order by emside.SideID
go
set rowcount 0
go
INSERT INTO EMSide ( SideID, SideCode, SideName, SideNameEng ) VALUES ( 2000, 'AAA', 'AAA', '' )
go
Rollback Transaction
go

|||

Did you ever find a resolution to this? We are getting this error in an application we are upgrading. The upgraded version uses SQL Server 2000 and the old version uses SQL Server 7. We are only seeing the error on some of our machines but not all. On two different machines where we have SQL Server 2000 client utilities installed we do not get the error. On another machine where I have SQL Server 7 client utilities or no client utilities exist we do get the error. I think there is a driver found in the 2000 client utilities that resolves the issue, but can't quite put my finger on which one it is. The application vendor seems to think it is our machine configuration.

Thanks,

I found a solution: Check your version of the ntwdblib.dll driver. Version 2000.80.194.0 fixed the issue.

genral network error on .net framework 1.1 using system.data.sqlclient in asp .net

hi i am using asp .net 1.1

i have deployed my application on server where sql server 2005 exists but if i try to connect to sql server from my development machine then it is not connecting and gives me error when

conn.open()

in my sql server it is windows authentication.

the error is general network error check network docs.

i have tried timeout=0 and pooling=false

but neither works please answer.

what should my connection string.

you're in the wrong forum for this question. this forum is for SQL Server 2005 Mobile Edition. I'd recommend one of the ASP.NET MSDN Forums for this question.

Darren

Generic GDI+ error

Hello,
There were a couple of posts about this but no answers. I wanted to see if
anyone has been able to resolve the "Generic error occurred in GDI+" message
when they attempt to preview the report? I'm just trying to create a simple
stacked column report.
Are help would be greatly appreciated.
thanks,
Jenisehello,
I found a microsoft patch that will correct the error...In the case anyone
else has the same issue.
http://www.microsoft.com/technet/security/bulletin/ms04-028.mspx
Jenise
"Jenise" wrote:
> Hello,
> There were a couple of posts about this but no answers. I wanted to see if
> anyone has been able to resolve the "Generic error occurred in GDI+" message
> when they attempt to preview the report? I'm just trying to create a simple
> stacked column report.
> Are help would be greatly appreciated.
> thanks,
> Jenise

generating user instances in sql server is disabled. use sp_configure user instances enabl

When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances."

I am currently using SQL server 2005 Express.

What do I need to do, to create an SQL database? Thanks in advance.

Execute this statement:

sp_configure'user instances enabled', 1;RECONFIGURE

You can execute it either from Management Studio for SQL Express (http://msdn.microsoft.com/vstudio/express/sql/download/) or from Visual Stuido (create new connection to SQL Express instance then New Query, then execute it!).

Good luck.

|||

Thanks for the advice. Being so new to this, a lot of that went over my head. So I have two questions...

1. How do I create a new connection the SQL Express instance?

2. How do I execute a query after creating it? (With F5?)

Thanks for your help CS4Ever

|||

Select theData | Add New Data Source menu command. This launches theData Source Configuration Wizard.

In theData Source Configuration Wizard, in theChoose a Data Source type step, selectDatabase and then clickNext,then complete the wizard.

Checkout this link:http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm

Good luck.

|||Ok I got it to work. Thanks!

Generating scripts, tables, views, procedures, roles...

Hi...

I'm trying to generate scripts in SQL Server Management Studio 2005.

When I choose 'Script all objects' I get an error when I try to execute it. When I generate the scripts in single files, only tables in one file, only views in one file etc. etc., the execution is succeded.

1) Why do I get an error when I try to execute the script containing tables, views, procedures in one file....?

2) I get an error in the view-file where one column is 'invalid' but I can see it in the view. A generated script should execute succesfully when it is generated one second ago on the same database and so on... Right?

Thanks....

Which exact error do you get ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

sorry, I cant reproduce the errors because my workbuddy has the day off...

But I remember it was one of the views with 2 columns in it, which caused the error: 'Invalid item on view...'

And the sequense in the script is wrong. For example I can see that the script are trying to create a view before the table is created?

|||

You may find that the Database Publishing Wizard offers you more functionality.

Database Publishing Wizard
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

|||Thomas, did you find a solution to your problem?

I have the same problem and Database Publishing Wizard does not work any better.

The CREATE VIEW is placed before the dependant tables in the script.

This ONLY happens when I'm trying to script a SQL Server 2005 Express db.

I run the script wizard in SQL Server Management Studio 2005.

SQL Server 2005 Express: 9.0.3042
SQL Server 2005: 9.0.1399

Thanks
Jonas
|||

Did you use the switch "create dependent objects" ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Yes I did.

I've now updated to sp2 (9.0.3042) on the SQL Server 2005 too - no difference. Except that the default value of "create dependant objects" in the script wizard is now false.

I can not include any image of the properties selected, but all are default exept the dependant switch which is true.

The final report start with:

Generate Script Progress

- Determining objects in database '....MDF' that will be scripted. (Success)

- dbo.AllDataView (Success)

- dbo.FindNewRawData (Success)

Which also shows that a View is created first of all objects.

Thanks

Jonas

Generating scripts, tables, views, procedures, roles...

Hi...

I'm trying to generate scripts in SQL Server Management Studio 2005.

When I choose 'Script all objects' I get an error when I try to execute it. When I generate the scripts in single files, only tables in one file, only views in one file etc. etc., the execution is succeded.

1) Why do I get an error when I try to execute the script containing tables, views, procedures in one file....?

2) I get an error in the view-file where one column is 'invalid' but I can see it in the view. A generated script should execute succesfully when it is generated one second ago on the same database and so on... Right?

Thanks....

Which exact error do you get ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

sorry, I cant reproduce the errors because my workbuddy has the day off...

But I remember it was one of the views with 2 columns in it, which caused the error: 'Invalid item on view...'

And the sequense in the script is wrong. For example I can see that the script are trying to create a view before the table is created?

|||

You may find that the Database Publishing Wizard offers you more functionality.

Database Publishing Wizard
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

|||Thomas, did you find a solution to your problem?

I have the same problem and Database Publishing Wizard does not work any better.

The CREATE VIEW is placed before the dependant tables in the script.

This ONLY happens when I'm trying to script a SQL Server 2005 Express db.

I run the script wizard in SQL Server Management Studio 2005.

SQL Server 2005 Express: 9.0.3042
SQL Server 2005: 9.0.1399

Thanks
Jonas
|||

Did you use the switch "create dependent objects" ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Yes I did.

I've now updated to sp2 (9.0.3042) on the SQL Server 2005 too - no difference. Except that the default value of "create dependant objects" in the script wizard is now false.

I can not include any image of the properties selected, but all are default exept the dependant switch which is true.

The final report start with:

Generate Script Progress

- Determining objects in database '....MDF' that will be scripted. (Success)

- dbo.AllDataView (Success)

- dbo.FindNewRawData (Success)

Which also shows that a View is created first of all objects.

Thanks

Jonas

Generating scripts, tables, views, procedures, roles...

Hi...

I'm trying to generate scripts in SQL Server Management Studio 2005.

When I choose 'Script all objects' I get an error when I try to execute it. When I generate the scripts in single files, only tables in one file, only views in one file etc. etc., the execution is succeded.

1) Why do I get an error when I try to execute the script containing tables, views, procedures in one file....?

2) I get an error in the view-file where one column is 'invalid' but I can see it in the view. A generated script should execute succesfully when it is generated one second ago on the same database and so on... Right?

Thanks....

Which exact error do you get ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

sorry, I cant reproduce the errors because my workbuddy has the day off...

But I remember it was one of the views with 2 columns in it, which caused the error: 'Invalid item on view...'

And the sequense in the script is wrong. For example I can see that the script are trying to create a view before the table is created?

|||

You may find that the Database Publishing Wizard offers you more functionality.

Database Publishing Wizard
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

|||Thomas, did you find a solution to your problem?

I have the same problem and Database Publishing Wizard does not work any better.

The CREATE VIEW is placed before the dependant tables in the script.

This ONLY happens when I'm trying to script a SQL Server 2005 Express db.

I run the script wizard in SQL Server Management Studio 2005.

SQL Server 2005 Express: 9.0.3042
SQL Server 2005: 9.0.1399

Thanks
Jonas
|||

Did you use the switch "create dependent objects" ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Yes I did.

I've now updated to sp2 (9.0.3042) on the SQL Server 2005 too - no difference. Except that the default value of "create dependant objects" in the script wizard is now false.

I can not include any image of the properties selected, but all are default exept the dependant switch which is true.

The final report start with:

Generate Script Progress

- Determining objects in database '....MDF' that will be scripted. (Success)

- dbo.AllDataView (Success)

- dbo.FindNewRawData (Success)

Which also shows that a View is created first of all objects.

Thanks

Jonas

Generating Reports Error, dependent on local groups?

Hi,
I finished creating my reports and have had an issue with generating the
reports on http://localhost/reports. When I login to
http://localhost/reports with a user that is part of the Local Administrators
Group the reports run perfectly correct. But when I login with a user that
is not part of the Local Administrators Group I get the Reporting Services
Error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'OVSDPROD'.
(rsErrorOpeningConnection) Get Online Help
ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
The user that I am logged in with has the same exact item-level and
system-level roles as the BUILTIN\Administrators and can navigate throughout
the site to get to the reports but when its time to actually generate the
reports I get the error above.
MikeThis is a problem of the user connecting to Oracle, not to Report Server. The
error is coming form ODBC.
Test this by reconfiguring the data source and storing credentials on the
report server so that the credentials you use are the same as those being
used by the other person.
HTH
Charles Kangai, MCT, MCDBA
"mtam79" wrote:
> Hi,
> I finished creating my reports and have had an issue with generating the
> reports on http://localhost/reports. When I login to
> http://localhost/reports with a user that is part of the Local Administrators
> Group the reports run perfectly correct. But when I login with a user that
> is not part of the Local Administrators Group I get the Reporting Services
> Error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'OVSDPROD'.
> (rsErrorOpeningConnection) Get Online Help
> ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> SQLSetConnectAttr failed
> The user that I am logged in with has the same exact item-level and
> system-level roles as the BUILTIN\Administrators and can navigate throughout
> the site to get to the reports but when its time to actually generate the
> reports I get the error above.
> Mike|||The data source is configured with "Credentials stored securely in the report
server"...
Even though the error states that this is an ODBC issue, it confuses me
since I am able to generate reports with users that are part of the Local
Administrator Group, but anyone outside of that group can not Generate
Reports. If everyone was having problems generating reports then I would
definitely see how it is an ODBC issue.
Any other suggestions?
Thanks,
Mike
"Charles Kangai" wrote:
> This is a problem of the user connecting to Oracle, not to Report Server. The
> error is coming form ODBC.
> Test this by reconfiguring the data source and storing credentials on the
> report server so that the credentials you use are the same as those being
> used by the other person.
> HTH
> Charles Kangai, MCT, MCDBA
> "mtam79" wrote:
> > Hi,
> >
> > I finished creating my reports and have had an issue with generating the
> > reports on http://localhost/reports. When I login to
> > http://localhost/reports with a user that is part of the Local Administrators
> > Group the reports run perfectly correct. But when I login with a user that
> > is not part of the Local Administrators Group I get the Reporting Services
> > Error:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'OVSDPROD'.
> > (rsErrorOpeningConnection) Get Online Help
> > ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> > error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> > SQLSetConnectAttr failed
> >
> > The user that I am logged in with has the same exact item-level and
> > system-level roles as the BUILTIN\Administrators and can navigate throughout
> > the site to get to the reports but when its time to actually generate the
> > reports I get the error above.
> >
> > Mike|||I figured out my problem had to do with the security permissions that were
assigned to the folder where my tnsnames.ora file was located. I needed to
set permissions for Everyone to be able to read that folder so they can
access the file and therefore run the reports.
"mtam79" wrote:
> The data source is configured with "Credentials stored securely in the report
> server"...
> Even though the error states that this is an ODBC issue, it confuses me
> since I am able to generate reports with users that are part of the Local
> Administrator Group, but anyone outside of that group can not Generate
> Reports. If everyone was having problems generating reports then I would
> definitely see how it is an ODBC issue.
> Any other suggestions?
> Thanks,
> Mike
> "Charles Kangai" wrote:
> > This is a problem of the user connecting to Oracle, not to Report Server. The
> > error is coming form ODBC.
> >
> > Test this by reconfiguring the data source and storing credentials on the
> > report server so that the credentials you use are the same as those being
> > used by the other person.
> >
> > HTH
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "mtam79" wrote:
> >
> > > Hi,
> > >
> > > I finished creating my reports and have had an issue with generating the
> > > reports on http://localhost/reports. When I login to
> > > http://localhost/reports with a user that is part of the Local Administrators
> > > Group the reports run perfectly correct. But when I login with a user that
> > > is not part of the Local Administrators Group I get the Reporting Services
> > > Error:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'OVSDPROD'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> > > error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> > > SQLSetConnectAttr failed
> > >
> > > The user that I am logged in with has the same exact item-level and
> > > system-level roles as the BUILTIN\Administrators and can navigate throughout
> > > the site to get to the reports but when its time to actually generate the
> > > reports I get the error above.
> > >
> > > Mike|||Please also check this KB article, because you may run into the same
security permission issues when trying to setup subscriptions on these
reports: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mtam79" <mtam79@.discussions.microsoft.com> wrote in message
news:E1E6AF79-39B8-4E1B-AFAA-69A00E5C4B19@.microsoft.com...
> I figured out my problem had to do with the security permissions that were
> assigned to the folder where my tnsnames.ora file was located. I needed
to
> set permissions for Everyone to be able to read that folder so they can
> access the file and therefore run the reports.
>
> "mtam79" wrote:
> > The data source is configured with "Credentials stored securely in the
report
> > server"...
> >
> > Even though the error states that this is an ODBC issue, it confuses me
> > since I am able to generate reports with users that are part of the
Local
> > Administrator Group, but anyone outside of that group can not Generate
> > Reports. If everyone was having problems generating reports then I
would
> > definitely see how it is an ODBC issue.
> >
> > Any other suggestions?
> >
> > Thanks,
> > Mike
> >
> > "Charles Kangai" wrote:
> >
> > > This is a problem of the user connecting to Oracle, not to Report
Server. The
> > > error is coming form ODBC.
> > >
> > > Test this by reconfiguring the data source and storing credentials on
the
> > > report server so that the credentials you use are the same as those
being
> > > used by the other person.
> > >
> > > HTH
> > >
> > > Charles Kangai, MCT, MCDBA
> > >
> > > "mtam79" wrote:
> > >
> > > > Hi,
> > > >
> > > > I finished creating my reports and have had an issue with generating
the
> > > > reports on http://localhost/reports. When I login to
> > > > http://localhost/reports with a user that is part of the Local
Administrators
> > > > Group the reports run perfectly correct. But when I login with a
user that
> > > > is not part of the Local Administrators Group I get the Reporting
Services
> > > > Error:
> > > >
> > > > An error has occurred during report processing.
(rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot create a connection to data source 'OVSDPROD'.
> > > > (rsErrorOpeningConnection) Get Online Help
> > > > ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text
for
> > > > error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's
> > > > SQLSetConnectAttr failed
> > > >
> > > > The user that I am logged in with has the same exact item-level and
> > > > system-level roles as the BUILTIN\Administrators and can navigate
throughout
> > > > the site to get to the reports but when its time to actually
generate the
> > > > reports I get the error above.
> > > >
> > > > Mike

Generating Report Error, Local Administrator Group

Hi,
I finished creating my reports and have had an issue with generating the
reports on http://localhost/reports. When I login to
http://localhost/reports with a user that is part of the Local Administrators
Group the reports run perfectly correct. But when I login with a user that
is not part of the Local Administrators Group I get the Reporting Services
Error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'OVSDPROD'.
(rsErrorOpeningConnection) Get Online Help
ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
The user that I am logged in with has the same exact item-level and
system-level roles as the BUILTIN\Administrators and can navigate throughout
the site to get to the reports but when its time to actually generate the
reports I get the error above.
The data source is configured with "Credentials stored securely in the report
server"...
Even though the error states that this is an ODBC issue, it confuses me
since I am able to generate reports with users that are part of the Local
Administrator Group, but anyone outside of that group can not Generate
Reports. If everyone was having problems generating reports then I would
definitely see how it is an ODBC issue.
I am using ODBC Drivers from Oracle.....
Thanks,
MikeI figured out my problem had to do with the security permissions that were
assigned to the folder where my tnsnames.ora file was located. I needed to
set permissions for Everyone to be able to read that folder so they can
access the file and therefore run the reports.
"mtam79" wrote:
> Hi,
> I finished creating my reports and have had an issue with generating the
> reports on http://localhost/reports. When I login to
> http://localhost/reports with a user that is part of the Local Administrators
> Group the reports run perfectly correct. But when I login with a user that
> is not part of the Local Administrators Group I get the Reporting Services
> Error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'OVSDPROD'.
> (rsErrorOpeningConnection) Get Online Help
> ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> SQLSetConnectAttr failed
> The user that I am logged in with has the same exact item-level and
> system-level roles as the BUILTIN\Administrators and can navigate throughout
> the site to get to the reports but when its time to actually generate the
> reports I get the error above.
> The data source is configured with "Credentials stored securely in the report
> server"...
> Even though the error states that this is an ODBC issue, it confuses me
> since I am able to generate reports with users that are part of the Local
> Administrator Group, but anyone outside of that group can not Generate
> Reports. If everyone was having problems generating reports then I would
> definitely see how it is an ODBC issue.
> I am using ODBC Drivers from Oracle.....
> Thanks,
> Mike|||I
"mtam79" wrote:
> Hi,
> I finished creating my reports and have had an issue with generating the
> reports on http://localhost/reports. When I login to
> http://localhost/reports with a user that is part of the Local Administrators
> Group the reports run perfectly correct. But when I login with a user that
> is not part of the Local Administrators Group I get the Reporting Services
> Error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'OVSDPROD'.
> (rsErrorOpeningConnection) Get Online Help
> ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> SQLSetConnectAttr failed
> The user that I am logged in with has the same exact item-level and
> system-level roles as the BUILTIN\Administrators and can navigate throughout
> the site to get to the reports but when its time to actually generate the
> reports I get the error above.
> The data source is configured with "Credentials stored securely in the report
> server"...
> Even though the error states that this is an ODBC issue, it confuses me
> since I am able to generate reports with users that are part of the Local
> Administrator Group, but anyone outside of that group can not Generate
> Reports. If everyone was having problems generating reports then I would
> definitely see how it is an ODBC issue.
> I am using ODBC Drivers from Oracle.....
> Thanks,
> Mikesql

Generate SQL Script Error

Hi,
I'm getting an error when I attempt to generate a SQL script from Enterprise
Manager:
[SQL-DMO]CreateFile error on 'servername.dbname.DP1'.
I googled it and found one receommendation to uninstall McAfee. I did so
and it made no difference.
I found another suggestion to save it to a fully-qualified UNC path (not
just clicking on "My Docments"), but that made no difference.
Does anyone know what could be causing this error?
It doesn't matter if I script all objects or just one type of object. It
doesn't matter if I save it to a file or just try to "Preview" it -- either
way I get the same error message.
Thanks for any help that can be provided.
ChuckForgot to include the essentials:
SQL Server 2000 sp3a running on Windows 2000 Advanced Server (fully
patched).
"CR" <chuck.rich__ardson@.sfcc.edu> wrote in message
news:u%238$rOswFHA.2880@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm getting an error when I attempt to generate a SQL script from
Enterprise
> Manager:
> [SQL-DMO]CreateFile error on 'servername.dbname.DP1'.
> I googled it and found one receommendation to uninstall McAfee. I did so
> and it made no difference.
> I found another suggestion to save it to a fully-qualified UNC path (not
> just clicking on "My Docments"), but that made no difference.
> Does anyone know what could be causing this error?
> It doesn't matter if I script all objects or just one type of object. It
> doesn't matter if I save it to a file or just try to "Preview" it --
either
> way I get the same error message.
> Thanks for any help that can be provided.
> Chuck
>

Generate SQL Script Error

Hi,
I'm getting an error when I attempt to generate a SQL script from Enterprise
Manager:
[SQL-DMO]CreateFile error on 'servername.dbname.DP1'.
I googled it and found one receommendation to uninstall McAfee. I did so
and it made no difference.
I found another suggestion to save it to a fully-qualified UNC path (not
just clicking on "My Docments"), but that made no difference.
Does anyone know what could be causing this error?
It doesn't matter if I script all objects or just one type of object. It
doesn't matter if I save it to a file or just try to "Preview" it -- either
way I get the same error message.
Thanks for any help that can be provided.
ChuckForgot to include the essentials:
SQL Server 2000 sp3a running on Windows 2000 Advanced Server (fully
patched).
"CR" <chuck.rich__ardson@.sfcc.edu> wrote in message
news:u%238$rOswFHA.2880@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm getting an error when I attempt to generate a SQL script from
Enterprise
> Manager:
> [SQL-DMO]CreateFile error on 'servername.dbname.DP1'.
> I googled it and found one receommendation to uninstall McAfee. I did so
> and it made no difference.
> I found another suggestion to save it to a fully-qualified UNC path (not
> just clicking on "My Docments"), but that made no difference.
> Does anyone know what could be causing this error?
> It doesn't matter if I script all objects or just one type of object. It
> doesn't matter if I save it to a file or just try to "Preview" it --
either
> way I get the same error message.
> Thanks for any help that can be provided.
> Chuck
>

Generate SQL Script Error

Hi,
I'm getting an error when I attempt to generate a SQL script from Enterprise
Manager:
[SQL-DMO]CreateFile error on 'servername.dbname.DP1'.
I googled it and found one receommendation to uninstall McAfee. I did so
and it made no difference.
I found another suggestion to save it to a fully-qualified UNC path (not
just clicking on "My Docments"), but that made no difference.
Does anyone know what could be causing this error?
It doesn't matter if I script all objects or just one type of object. It
doesn't matter if I save it to a file or just try to "Preview" it -- either
way I get the same error message.
Thanks for any help that can be provided.
Chuck
Forgot to include the essentials:
SQL Server 2000 sp3a running on Windows 2000 Advanced Server (fully
patched).
"CR" <chuck.rich__ardson@.sfcc.edu> wrote in message
news:u%238$rOswFHA.2880@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm getting an error when I attempt to generate a SQL script from
Enterprise
> Manager:
> [SQL-DMO]CreateFile error on 'servername.dbname.DP1'.
> I googled it and found one receommendation to uninstall McAfee. I did so
> and it made no difference.
> I found another suggestion to save it to a fully-qualified UNC path (not
> just clicking on "My Docments"), but that made no difference.
> Does anyone know what could be causing this error?
> It doesn't matter if I script all objects or just one type of object. It
> doesn't matter if I save it to a file or just try to "Preview" it --
either
> way I get the same error message.
> Thanks for any help that can be provided.
> Chuck
>

Generate Script - Specified cast is not valid

When trying to generate a script, from SQL Server Management Studio, for the
following Store Procedure ( SP ) I receive the following error. I have
dropped and recreated the Store Procedure but I continue to get the error.
CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
@.RecordCount INT OUTPUT
AS
SET NOCOUNT ON
SELECT @.RecordCount = COUNT(*)
FROM CreditCardSaveTargetQueue
WITH(NOLOCK) WHERE validation = 'X'
GO
-- **************************************************************
Error:
TITLE: Microsoft.SqlServer.SqlEnum
--
Failed to retrieve dependency information (object_id(System.Int32)
1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
731149650.relative_type(System.DBNull) .object_name(System.String)
usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
--
ADDITIONAL INFORMATION:
Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)I'm having the same problem and have tried the same resolution
(dropping/recreating stored procedure). If I try to script the database and
include this stored procedure, it fails. If I try to view dependencies to
this stored procedure it fails. Specified cast is not valid.
(Microsoft.SqlServer.SqlEnum).
"BarDev" wrote:
> When trying to generate a script, from SQL Server Management Studio, for the
> following Store Procedure ( SP ) I receive the following error. I have
> dropped and recreated the Store Procedure but I continue to get the error.
>
> CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
> @.RecordCount INT OUTPUT
> AS
> SET NOCOUNT ON
> SELECT @.RecordCount = COUNT(*)
> FROM CreditCardSaveTargetQueue
> WITH(NOLOCK) WHERE validation = 'X'
> GO
> -- **************************************************************
> Error:
> TITLE: Microsoft.SqlServer.SqlEnum
> --
> Failed to retrieve dependency information (object_id(System.Int32)
> 1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
> 731149650.relative_type(System.DBNull) .object_name(System.String)
> usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
> dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
> --
> ADDITIONAL INFORMATION:
> Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)
>

Generate Script - Specified cast is not valid

When trying to generate a script, from SQL Server Management Studio, for the
following Store Procedure ( SP ) I receive the following error. I have
dropped and recreated the Store Procedure but I continue to get the error.
CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
@.RecordCount INT OUTPUT
AS
SET NOCOUNT ON
SELECT @.RecordCount = COUNT(*)
FROM CreditCardSaveTargetQueue
WITH(NOLOCK) WHERE validation = 'X'
GO
-- ****************************************
**********************
Error:
TITLE: Microsoft.SqlServer.SqlEnum
--
Failed to retrieve dependency information (object_id(System.Int32)
1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
731149650.relative_type(System.DBNull) .object_name(System.String)
usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
ADDITIONAL INFORMATION:
Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)I'm having the same problem and have tried the same resolution
(dropping/recreating stored procedure). If I try to script the database and
include this stored procedure, it fails. If I try to view dependencies to
this stored procedure it fails. Specified cast is not valid.
(Microsoft.SqlServer.SqlEnum).
"BarDev" wrote:

> When trying to generate a script, from SQL Server Management Studio, for t
he
> following Store Procedure ( SP ) I receive the following error. I have
> dropped and recreated the Store Procedure but I continue to get the error.
>
> CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
> @.RecordCount INT OUTPUT
> AS
> SET NOCOUNT ON
> SELECT @.RecordCount = COUNT(*)
> FROM CreditCardSaveTargetQueue
> WITH(NOLOCK) WHERE validation = 'X'
> GO
> -- ****************************************
**********************
> Error:
> TITLE: Microsoft.SqlServer.SqlEnum
> --
> Failed to retrieve dependency information (object_id(System.Int32)
> 1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
> 731149650.relative_type(System.DBNull) .object_name(System.String)
> usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
> dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
> --
> ADDITIONAL INFORMATION:
> Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)
>|||I'm having the same problem and have tried the same resolution
(dropping/recreating stored procedure). If I try to script the database and
include this stored procedure, it fails. If I try to view dependencies to
this stored procedure it fails. Specified cast is not valid.
(Microsoft.SqlServer.SqlEnum).
"BarDev" wrote:

> When trying to generate a script, from SQL Server Management Studio, for t
he
> following Store Procedure ( SP ) I receive the following error. I have
> dropped and recreated the Store Procedure but I continue to get the error.
>
> CREATE PROCEDURE dbo.usp_CreditCardSaveTargetQueue_S_Count
> @.RecordCount INT OUTPUT
> AS
> SET NOCOUNT ON
> SELECT @.RecordCount = COUNT(*)
> FROM CreditCardSaveTargetQueue
> WITH(NOLOCK) WHERE validation = 'X'
> GO
> -- ****************************************
**********************
> Error:
> TITLE: Microsoft.SqlServer.SqlEnum
> --
> Failed to retrieve dependency information (object_id(System.Int32)
> 1952726009.object_type(System.Int16) 4.relative_id(System.Int32)
> 731149650.relative_type(System.DBNull) .object_name(System.String)
> usp_CreditCardSaveTargetQueue_S_Count.object_schema(System.String)
> dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).
> --
> ADDITIONAL INFORMATION:
> Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)
>