Can't Get Php_sqlsrv Extension To Load Correctly

Apr 11, 2008

I'm using Windows XP Home, Apache 2.2 as web server, and PHP 5.2.5.

I have php installed in c:php. I have the extensions directory set to c:phpext.

Enabling a different extension, like php_zip works.

If I leave the entry in php.ini for php_sqlsrv.dll, then I get a message that is can't be loaded.

If I try to run php at the command line using php -v, then it pops up a dialg box:
Title: php.exe - unable tolocate component
Message: The application has failed to start because php5.dll was not found.
Then another pop up dialog saying that php_sqlsrv.dll could not be loaded.

If I turn on PHP error messages to be displayed in the browser, and stop and restart Apache then I see:
PHP startup: unable to load dynamic link library ./php_sqlsrv.dll - the specified module could not be loaded.


Here's the line in my Apache config file:
LoadModule php5_module c:/php/php5apache2_2.dll

There is no plain php5.dll in the c:php directory.

Perhaps this extension ONLY works with IIS as the web server?

Happens also on XP Pro wih IIS.

View 8 Replies


ADVERTISEMENT

ODBC Extension Uninstalled Or Not Configured Correctly

Jun 14, 2007

I have just installed SQL 2005 SP2 (Workgroup Edition)



I am receiving the below error when i open a datasource in report manager. The datasource uses ODBC.



The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly.



Also, when I go to create a new datasource only "Microsoft SQL Server" is available for connection types.



How do i resolve?

View 7 Replies View Related

Cannot Load The Report Server DocumentLibrary Extension

Jan 9, 2008

I receive event ID 108 every day only once the first time I modify a subscription. We have two instances of Reporting Services on the same box in seperat SQL instances; one is native and the other is SharePoint integrated. The issue is with the native instance. The error information along with hardware and software information is below.

Does anyone know why this happens?

HARDWARE / SOFTWARE


HP ML370G5

16 Gb Memory

2 quad 2.33 GHz processors (8 proc)

Each SQL instance and OS is on a seperate RAID 5

Windows 2003 Server Enterprise x64

SQL 2005 Enterprise x64

SharePoint 2007 Server x64
ERROR LOGS

Event Log:

Source: Report Server (RPTSVR)
Time: 07:03:59 AM
Catagory: Extension
Event ID: 108
Type: Error
User: N/A

Report Server (RPTSVC) cannot load the Report Server DocumentLibrary extension.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

ReportServerWebApp__01_09_2008_07_10_30.log

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.6Reporting ServicesLogFilesReportServerWebApp__01_09_2008_07_10_30.log</Path>
<SystemName>CORPT1</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!extensionfactory!8!1/9/2008-07:10:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!8!1/9/2008-07:10:30:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.

ReportServerService__01_09_2008_00_07_07.log

ReportingServicesService!library!e!1/9/2008-06:57:09:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!e!1/9/2008-07:07:09:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!8!1/9/2008-07:14:01:: i INFO: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!15!1/9/2008-07:14:01:: i INFO: EventPolling processing item 04d50ca5-18f0-4682-93ab-b49477dbbb6b
ReportingServicesService!library!15!1/9/2008-07:14:01:: i INFO: Schedule 05e34a46-907b-458d-9c07-36da30972508 executed at 1/9/2008 7:14:01 AM.
ReportingServicesService!schedule!15!1/9/2008-07:14:01:: Creating Time based subscription notification for subscription: ac0d6836-0cc3-47ca-b3c3-b9e5b2ca81f5
ReportingServicesService!library!15!1/9/2008-07:14:01:: i INFO: Schedule 05e34a46-907b-458d-9c07-36da30972508 execution completed at 1/9/2008 7:14:01 AM.
ReportingServicesService!dbpolling!15!1/9/2008-07:14:01:: i INFO: EventPolling finished processing item 04d50ca5-18f0-4682-93ab-b49477dbbb6b
ReportingServicesService!dbpolling!8!1/9/2008-07:14:01:: i INFO: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1b!1/9/2008-07:14:01:: i INFO: EventPolling processing item 6b9e905d-5a23-4a62-a57c-bf305b87ddde
ReportingServicesService!dbpolling!1b!1/9/2008-07:14:01:: i INFO: EventPolling finished processing item 6b9e905d-5a23-4a62-a57c-bf305b87ddde
ReportingServicesService!library!15!01/09/2008-07:14:01:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties.
ReportingServicesService!dbpolling!15!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item cd3223b0-a028-4a5b-8b66-38597bc940e6
ReportingServicesService!dbpolling!18!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item 596786d9-56e0-4c4c-89b0-4a22c1b2ebde
ReportingServicesService!dbpolling!e!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item 2ff98f45-2d20-4a75-b329-6e7b15aa15f5
ReportingServicesService!dbpolling!17!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item 0ee17614-c9a9-4d8b-844b-70d14bb52787
ReportingServicesService!dbpolling!4!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item a2db68a4-7be0-4934-9036-90fe7eb4a7ec
ReportingServicesService!dbpolling!8!1/9/2008-07:14:03:: i INFO: NotificationPolling processing 7 more items. 7 Total items in internal queue.
ReportingServicesService!dbpolling!1e!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item e886fe71-9245-4c52-b74a-c6aead1b0b5c
ReportingServicesService!dbpolling!19!1/9/2008-07:14:03:: i INFO: NotificationPolling processing item 5969a46c-6e21-4b09-9f5e-fc44f20b90bf

ReportServer__01_09_2008_00_05_18.log

w3wp!library!8!01/09/2008-07:03:54:: Call to GetPermissionsAction(/Canned IHIP/Overridden Billing).
w3wp!library!1!01/09/2008-07:03:54:: Call to GetSystemPropertiesAction().
w3wp!library!1!01/09/2008-07:03:54:: Call to GetPropertiesAction(/Canned IHIP/Overridden Billing, PathBased).
w3wp!library!c!01/09/2008-07:03:54:: Call to GetSystemPermissionsAction().
w3wp!library!a!01/09/2008-07:03:54:: Call to ListSubscriptionsAction(/Canned IHIP/Overridden Billing, null).
w3wp!library!c!01/09/2008-07:03:55:: Call to GetPropertiesAction(/Canned IHIP/Overridden Billing, PathBased).
w3wp!library!c!01/09/2008-07:03:55:: Call to ListEventsAction().
w3wp!library!8!01/09/2008-07:03:55:: Call to GetSystemPropertiesAction().
w3wp!library!a!01/09/2008-07:03:58:: Call to GetSystemPermissionsAction().
w3wp!library!b!01/09/2008-07:03:58:: Call to GetReportParametersAction(/Canned IHIP/Overridden Billing).
w3wp!library!8!01/09/2008-07:03:59:: Call to GetSubscriptionPropertiessAction(703bc2bc-fce7-4929-bb67-25641931a3b1).
w3wp!library!8!01/09/2008-07:03:59:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
w3wp!extensionfactory!8!01/09/2008-07:03:59:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).
w3wp!library!8!01/09/2008-07:03:59:: Call to ListChildrenAction(/, False).

View 10 Replies View Related

Problems With The Query, ResultSet Property Not Set Correctly, Parameters Not Set Correctly, Or Connection Not Established Cor

Oct 22, 2007



I have the following query in an ExecuteSQL Task:

Insert Into Table2
Select * From Table1 Where Column1Val = '4'


As you can see, I don't need any parameters so I havent configured any. Also, there should not be any result set so I shouldnt need to configure a resultset parameter.

Why is the above query failing with

Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly

View 4 Replies View Related

Not Able To Load The Application In Case Web Farm Garden When We Load Data Through Background Thread.

Dec 14, 2007

Hi,

Here I will describe my problem.
1. We are loading large amount of data from database on background thread which is starting on Application_start event in global.aspx.cs file.The data is later cached for subsquent request to improve the performance.
2. Now when we put the application on web farm garden, it is not able to load the application.
3. We are sending the request the servers through Router kind of application.
4 This application is working fine on single server enviornment.

Please help us.

Ajay Kumar Dwivedi

View 1 Replies View Related

Load All Data Without Knowing Old One Was Load In The Previous Time???

Apr 27, 2007

I just have done the SSIS example in the tutorial document included when install SQL 2005 ENT. I have a problem that whenever I test to run, the service load all data from source with out noticing about the data (I mean it load all the data to the destination), I do it several time and it continue to load all without checking. That mean the data is dublicated when the schedule run???



I think there should be a paramete or something like that to help the engine just load the new data to the destination. Could you help please?



Thank

View 3 Replies View Related

Database Extension In MS SQL?

Jun 24, 2006

hello ... I am trying to copy 1 field from a table in database called DB1 to a same table in DB2 .. I am not sure if this is possible. I found out form www3.schools.com it's doable using Select Into ... but it uses MS Access for example (Northwind.mdb) ... I wonder what's the extension database in MS SQL? Does anyone know where can we check the query syntax on the web? Can anyone tell me it's correct? I dun have MS SQL from home .. so :(
======copy prodID from DB1 to DB2 table called production1 (both DB1 and DB2)=======
// this is done in SQL QUERY ANALYZER under DB1?
SELECT production1.prodID INTO production1 IN DB2 FROM DB1
=====create VIEW in DB2=======
// this has to be done in DB1 ... if I have multiple databases, is there anyway to do it using something like SELECT INTO to create view in differences databases? 
CREATE VIEW production_id AS SELECT prodID from DB1
 
 

View 1 Replies View Related

Back Up With No BAK Extension

Feb 18, 2014

I have made the sql server 2008 database backup through proper procedure.I am doing this backup in remote server. The task is completed successfully. But When I check the folder that I made the backup,is showing extension as file,not .bak. Why the backup extension is not proper? And due to that,when I sent this backupfile through mail to someone,that person is not being able to retrieve or restore it..

View 1 Replies View Related

Date Extension

Jun 7, 2007

I've been using Michaels excellent date function http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519 quite honestly it has saved me loads of time (the e-beers are on me)

For my purposes I need to work sometimes with Financial Years and I also need the Dates available to SQL Server 7. So I used Michaels function to create a table and added two fields (possibly more to follow). Please note that this has only been done on SQL Server 2000

ALTER TABLE DATEINFO
ADD -- Needs these to allow NULL so that the Alter Table will work.
FINANCIAL_YEAR_START_DATE[datetime]null , -- the start date for the financial year
FINANCIAL_YEAR_START_YEAR[smallint]null , -- the year that the financial years starts in depending on the Financial Year Start Date

Given that the table is then populated by Michaels function, to set the FINANCIAL_YEAR_START_DATE I used



/* @ARBITRARY_FINANICAL_YEAR_START_DATE is SET to any date that would be the start date of a financial year
only the day and month parts are important, so in this case the start of the financial year is 1 April
*/
DECLARE @ARBITRARY_FINANCIAL_YEAR_START_DATE DATETIME
SET @ARBITRARY_FINANCIAL_YEAR_START_DATE = '20060401'
UPDATE DATEINFO
SET FINANCIAL_YEAR_START_DATE =
CASE
WHEN DATEDIFF(dd,DATEADD(yy, year([DATE]) - YEAR(@ARBITRARY_FINANCIAL_YEAR_START_DATE), @ARBITRARY_FINANCIAL_YEAR_START_DATE),[DATE]) < 0
Then DATEADD(YY,YEAR([DATE])- YEAR(@ARBITRARY_FINANCIAL_YEAR_START_DATE) -1, @ARBITRARY_FINANCIAL_YEAR_START_DATE)
Else DATEADD(YY,YEAR([DATE])- YEAR(@ARBITRARY_FINANCIAL_YEAR_START_DATE) , @ARBITRARY_FINANCIAL_YEAR_START_DATE)
END

With that it is trivial to set FINANCIAL_YEAR_START_YEAR to YEAR(FINANCIAL_YEAR_START_DATE)

steve


-----------

Don't worry head. The computer will do all the thinking from now on.

View 4 Replies View Related

File Extension

Sep 27, 2006

I was told by my website provider that they do not support the .mdf extension and only support the mdb extension. What am I not getting here? I am using SQL Server Express 2005. Is .mdf a subset of .mdb?

View 1 Replies View Related

READ A FILE WITH EXTENSION Dat

Aug 16, 1999

Hi,

I need to read a binary file with extention *.dat like this:
tat.dat and import it in ms sql server 7.0.

Thanks for any help

Dr Bangaly Diané

View 2 Replies View Related

File Extension For Sqlserver2000

Oct 25, 2006

Hi,

If access database has an extension of .mdb then what is sqlserver2000 file extension?

View 1 Replies View Related

Extension For Trial Period

May 27, 2007

Guys,

I am running SQL Server 2005 Enterp Trial version, which is about to expire in 14 days..
Is this possible to Extend this?
Or
Un-installing and re-installing may give me back 180 days again? I haven't tried this, but need to know before I do an attempt?

Don't have other machine, don't want to re-built my system..

Any help?

Thanks in advance


SKR

View 6 Replies View Related

Spool File Without An Extension Name

Feb 2, 2008

Hello there!

I am in need of urgent help. i do believe that when you used the command SPOOL filename without specifying an extension name, it automatically puts an .lst extension name. Can you help me identify if there is any way i can generate a file without an extension name? I am in need of help right now. I hope someone will answer my post as soon as possible. I really really appreciate it!

Thanks,
Jen

View 1 Replies View Related

File Name Or Extension Is Too Long

Jul 20, 2005

Hi All,I am receiving the following message when I run Dts package which iscreating a cube.Error Source : Microsoft Data transmission Services (DTS)PackageError Description: File name or extension is too longAny help will be appreciated!Thanks in advance,Mohammed SarwarOcp dba oracle 9i,8i,8.0*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

MS Word Rendering Extension

Mar 30, 2006

When rendering extension for RTF or Doc or WordML will be available?
Will it be released in service pack for SQL2K5 or it will be released in next version of SQL Server?

View 3 Replies View Related

Which Kind Of File With Extension .pem ?please Help Me

Jan 4, 2006

In document for  encryption in SQLServer with application XP_Crypt, i see file with extension .pem when using private key or public key. How to create file .pem. Please explain me private key or public key.

View 1 Replies View Related

What Is Reporting Service Extension...??

Feb 28, 2008



What is Reporting Service Extension and how can I check that whether it is installed in my PC or not.

And if not then what is requirement for get it installed...?

View 6 Replies View Related

MS SQL SNMP Extension Agent Reconnecting.

Apr 17, 2007

We just upgraded to 2005 from a previous installation of 2000. Due to performance issues, I stopped the 2000 instance, and now the following message keeps popping up in the event log:

MS SQL SNMP Extension Agent reconnecting.

Following that, there are the following messages:

ODBC error encountered, State = 08001, native error = 17, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied..
-------------
ODBC error encountered, State = 01000, native error = 2, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())..
-------------
ODBC error encountered, State = 08001, native error = 17, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied..
-------------
ODBC error encountered, State = 01000, native error = 2, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())..

Any suggestions?a

View 3 Replies View Related

Extension- Urgent Help Required - Recovery

Jul 20, 2005

I have actually extended my requestI have a scenario like this.......update esan set tes_address_city = 'TEST1' --at some timeupdate esan set tes_address_city = 'TEST12' --at some timeupdate esan set tes_address_city = 'TEST123' --at some timebackup database TESTWMS to disk = 'D: empRecoveryTestTESTWMS.db'backup log TESTWMS to disk = 'D: empRecoveryTestTESTWMS01.log'I take these backups at the end of day....Now i want to recover till the second update ie 'TEST12'...Assumptions to be made:-I dont know the timing of the updates.I am allowed to take back only once.We can also assume to have a backup of the previous day also.Is this possible and how can i do it.......Please help me ...and urgent also.......Thanks in advanceRVGExtension is hereSuppose that ou database is crashing at 2.30 and i run the restoreRESTORE DATABASE TESTWMS FROM DISK='D: empRecoveryTestTESTWMS.DB'with norecovery --Prev day logRESTORE LOG TESTWMS FROM DISK='D: empRecoveryTestTESTWMS01.log'with norecoveryRESTORE LOG TESTWMS FROM DISK='D: empRecoveryTestTESTWMS02.log'with recovery, STOPAT = '2003-08-26 16:37:45.870'i get message like thisThis log file contains records logged before the designatedpoint-in-time. The database is being left in load state so you canapply another log file.RESTORE LOG successfully processed 0 pages in 0.389 seconds (0.000MB/sec).Now when i try to run aSelect * i get message lkeServer: Msg 927, Level 14, State 2, Line 1Database 'TESTWMS' cannot be opened. It is in the middle of a restore.How do i solve this problem. One way is to use a NO_TRUNCATE with abackup in between (ie incase of database corruption).But i dont want to use a log backup once again. I should be able tosolve it without using a log backup once again. In shot backup onlyonce a day. Aslo i need to refer to a database to that particularpoint of time from my backup.Thanks in advanceRVG

View 6 Replies View Related

Forms Security Extension Sample

Mar 9, 2006

Hi,

I have installed the SSRS 2005 Forms based login security extension as per the sample and instructions that come with the product install. I have double checked my work and debugged up to the point explained here.

My user is in the database and I can get to the login page. I have traced the code and can see the user being authenticated properly by server.LogonUser, the authentication cookie being created and placed in the response object, and then the redirect url being set to the reports/pages/folder.aspx. I have employed tcptrace and can see the sqlAuthCookie set in subsequent posts.

Unfortunately the redirect to folder.aspx never happens. I keep returning to UILogon.aspx. I think their is something either wrong with the auth cookie or the web.config in the ReportServer IIS virtual directory. The relevant xml from the web.config is attached below.

I would appreciate any thoughts. I am running on W2K3 SP1. Thanks.

Mitch

<identity impersonate="false" />

<!--<authentication mode="Windows" />-->

<authentication mode="Forms">

<forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/"></forms>

</authentication>

<authorization>

<deny users="?" />

</authorization>

View 3 Replies View Related

Rendering Extension For PPT (Power Point)

Jul 24, 2006

Does someone of you know a rendering extension for ppt. Any integrated or third party componens ?
The management wants to have the reports as powerpoint presentation

Best regards
HANNES

View 3 Replies View Related

Alter Database File Extension

May 14, 2008



Hi,

I'm trying to change the file extension of one of the database files of a big database that contains 10 years of EPOS data.
When this file was created, at the beginning of 2008, with the following script:

USE [Live]


ALTER DATABASE [Live] ADD FILE (NAME = 'Live_2008',

FILENAME = €˜E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLive_2008') TO FILEGROUP [2008]
the .ndf file extension was not added to the filename. So the file now has a file type of "File", instead of "SQL Server Secondary Data File"
I tried, in a test environment, to bring the database offline, change the filename to "Live_2008.ndf" and bring the database back online, but it gives me an error message saying that "cannot open the Live_2008 file", i'm guessing because it's looking for "Live_2008" and it finds "Live_2008.ndf" instead.
This file is quite big (5Gb) and I cannot afford to risk to lose any data.
The situation is complicated even further by the fact that it seems that a partition for 2008 does not exist.
How can I find out what data this file contains?
Is it going to be an issue if I leave the file like that?
Thanks

View 3 Replies View Related

Teradata Data Extension Question

Jun 16, 2006

I recently installed the Teradata .NET data provider and I am trying to use named parameters and multi-value parameters in my SQL.  I am finding information on this topic hard to come by.
 
In order to get parameters to work do I need to write my own Teradata data extension from scratch, expand an existing data extension to work with Teradata, or can I simple edit my .config files to point to a generic extension wrapper already existing?
 
Thanks!

View 3 Replies View Related

Custom Data Extension (CDE) For SQL Express

Oct 25, 2007

Hi all,

My query should be pretty simple to answer by the gurus. I have SQL Server Express Advance series installed at my system along with VS 2005. I tried the reporting services (remote mode) to display a report in the report viewer on my aspx page. The report simply uses an SQL query to get the result. Everything works fine and dandy!

However if i want to get data from my own data set, i used a webservice and ussed the XML data source option in the report to traverse through the XML. In the preview mode of the RDL everything works fine however when i deploy or rather run it using report viewer on my webpage, it gives an error that 'XML' has not been registered as an extension etc.

I looked in the rsserver config file, it IS configured. The only answer i have is that the EXPRESS version of SQL only supports the regular SQL data sources. I do not understand if that was the case, why does the preview mode work fine??

If i am correct then for the next release the ms developers should disable that or rather give a more meaning full error. I spent an entire day fideling around just to find out that it isnt supported with debates all over the place as to why in the world does it work in the preview mode?

Anyhoo, to get around that issue, i am wondering if the Custom Data Extension would work on the SQL Express or not? I am assuming it wouldnt. Please clearify this. Ideally all i want is to access my own data set in the report, no SQL queries or whatever, CDE seems the way forward but does SQL Express allow it?

Many thanks guyz.

Regards

Zeeshan
(btw, its only been two days since i started working with reporting services, so be gentle :-D )

View 1 Replies View Related

ForEach File Enumerator Extension Bug?

Jul 5, 2006

I set up a basic ForEach enumerator loop and specified files of type *.sql.

In the directory, I had some files I needed to keep but didn't want the package to touch, so I changed the extension to *.sqlo. Much to my dismay, the ForEach loop picked up those files. (Though it did skip the *.xml and *.bat and a few other types...)

Sounds like a bug to me.

View 3 Replies View Related

Data Processing Extension Not Visible

May 3, 2007

hello,



I have written a Custom Data Processing Extension for SSRS 2005.

The Report Server is in SharePoint integrated mode, this works perfect except for the extension.

When I want to set a DataSource in SharePoint (WSS 3.0), the extension is not in the ComboBox.

This works well on another server with the same extension.

The DLL file of that extension is copied in the reportserver bin folder.

I have added the references in the rsreportserver.config and rssrvpolicy.config (see below).


Code Snippetrsreportserver.config


<Data>

<Extension Name="SPSLISTS" Type="ICom.ReportingServices.SharepointListsExtension.Connection,

ICom.ReportingServices.SharepointListsExtension" />

<Data>




Code Snippet
rssrvpolicy.config
This code is located inside the CodeGroup with Name="SharePoint_Server_Strong_Name".


<CodeGroup class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="SPSLISTS_CodeGroup"

Description="Code group for my SPS LISTS data processing extension">

<IMembershipCondition class="UrlMembershipCondition"

version="1"

Url="D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinICom.ReportingServices.SharepointListsExtension.dll"

/>

</CodeGroup>



I already tried re-installing Reporting Services and the add-in for SharePoint but the problem remains.



Does anyone has an idea of what's wrong here?



Thanks in advance,

Tom

View 3 Replies View Related

Issue In Custom Security Extension

Aug 22, 2006

Hi,

The custom security extension generates the following error, when try to access Report Manager. The specifications are as follows.
1. Its 64-bit SQL Server (Reporting Services) and installed as default instance.
2. The Report Server is accessible programmatically. I can publish, view reports without problems, but Report Manager gives an error.
3. Another instance (named instance) of Reporting Services with the same custom security extension on same server is working fine. Report Manager opens up without problems.
4. Both the instances working fine since 3 installation and configuration (3 months back). Now, only the Report Manager of the default instance is not openeing up.

ReportServerWebApp__08_22_2006_08_52_20.log
-------------------------------------------------------------------------
w3wp!ui!1!8/22/2006-08:52:56:: i INFO: Overwriting existing cookie
w3wp!ui!1!8/22/2006-08:52:57:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!1!8/22/2006-08:52:57:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.Global.SecureAllAPI()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!8/22/2006-08:52:57:: i INFO: Overwriting existing cookie
w3wp!ui!1!8/22/2006-08:52:58:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)


The service is running fine. Any suggestions/pointers would be greatly appreciated.

THanks in advance

View 4 Replies View Related

Security Extension Sample RS 2005

May 15, 2008

Hello,

I have followed all the steps indicated in the Security Extensions Sample for RS 2005, and I have not changed any webpage code. However, I get the following errors:
- when accessing http://<computername>/ReportServer Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerlogon.aspx' is denied
- when accessing http://<computername>/Reports Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied


Can someone help please?

Thank you!

View 1 Replies View Related

Automating Data Extension Deployment

Jan 6, 2006

Hi,

I have written a Data Processing extension for my application and can deploy it on my development machine no problems. My question is: what is the "correct" way of deploying an extension to an end user's machine? Do I have to write a special program to find and modify the Reporting Server config files and copy the extension over. Surely many developers have the same need so there must be a generic solution to this problem, however, I haven't managed to find one.

I first came across this issue in SQL2000 and I thought/hoped it would be rectified with SQL2005 but it appears not to be (unless I'm missing something).

Any ideas would be greatly appreciated.

Thanks in advance,

Tim

View 2 Replies View Related

The Designer Extension SQL Could Not Be Loaded... Help... I'm A Beginner.

Dec 19, 2007

I'm trying to start the generic query designer and i get this error.
I have no idea what is wrong, but I know I'm using
Visual Studio 2005 V 8.050727.42
.net Framework 2.050727
SSRS Designers v 9:00.3042.00

Here is the content of my RSReportDesigner.config file if that helps at all.
<Configuration>
<Add Key="SecureConnectionLevel" Value="0" />
<Add Key="InstanceName" Value="Microsoft.ReportingServices.PreviewServer" />
<Add Key="SessionCookies" Value="true" />
<Add Key="SessionTimeoutMinutes" Value="3" />
<Add Key="PolicyLevel" Value="rspreviewpolicy.config" />
<Add Key="CacheDataForPreview" Value="true" />
<Extensions>
<Render>
<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" />
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" />
<Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering" />
<Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RemoteGdiReport,Microsoft.ReportingServices.ImageRendering" Visible="false" />
<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering" />
<Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" />
<Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" />
<Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering" />
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" />
</Render>
<Data>
<Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
<Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="RS" Type="Microsoft.ReportingServices.DataExtensions.RSDPConnection,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>
<Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>
<!-- <Extension Name="SSIS" Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> -->
<!-- <Extension Name="SAP" Type="Microsoft.Adapter.SAP.SAPConnection,Microsoft.Adapter.SAP.SAPProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> -->
</Data>
<Designer>
<Extension Name="SQL" Type="Microsoft.ReportingServices.QueryDesigners.VDTQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="OLEDB" Type="Microsoft.ReportingServices.QueryDesigners.VDTQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.QueryDesigners.ASQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.QueryDesigners.VDTQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="ODBC" Type="Microsoft.ReportingServices.QueryDesigners.VDTQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="XML" Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="RS" Type="Microsoft.ReportingServices.QueryDesigners.SMQLQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.QueryDesigners.SapBw.SapBwQueryDesigner,Microsoft.ReportingServices.QueryDesigners.SapBw"/>
<Extension Name="ESSBASE" Type="Microsoft.ReportingServices.QueryDesigners.Essbase.EssbaseQueryDesigner,Microsoft.ReportingServices.QueryDesigners.Essbase"/>
<!-- <Extension Name="SSIS" Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/> -->
<!-- <Extension Name="SAP" Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/> -->
</Designer>
</Extensions>
</Configuration>

View 3 Replies View Related

Can You Set Up Forms Authentication Without A Security Extension?

Mar 13, 2007

On my current project we have a requirement to re-authenticate the user when accessing sensitive information.

We want re-authenticate using standard NT logins against Active Directory (not a custom database or SSO.

This is trivial to configure using Basic Authentication, however I would like to use an ASP.NET login form. I would like to avoid writing a security extension as I do not want to perform custom authentication. I would like the web service to use it's built in authentication and authorisation mechanisms.

Is the above possible???

The following gives some more details about wht I've tried.

I have tried configuring the report server/manager with Forms authentication as in the sample but cannot get it to work with out implementing the security extensions.

I changed the web.config files and the policy files for permissioning my dll with FullTrust. I did not configure an extension as I want reporting services to use it's built in windows security mechanisms.

In the login page code behind I call the ReportingService2005.LogonUser() method which always throws the following exception:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: --




Reporting Services Error




The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help



SQL Server Reporting Services --.



I check the log file and it has the following:


at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.logon_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!18!03/13/2007-11:38:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.FormatException: Input string was not in a correct format.
at System.Text.StringBuilder.FormatError()
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at Microsoft.Samples.ReportingServices.CustomSecurity.Logon.ServerBtnLogon_Click(Object sender, EventArgs e) in C:Program FilesMicrosoft SQL Server90SamplesReporting ServicesExtension SamplesFormsAuthentication SamplecsFormsAuthenticationLogon.aspx.cs:line 130
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.logon_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---
aspnet_wp!library!18!03/13/2007-11:38:24:: i INFO: Exception dumped to: c:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!1!03/13/2007-11:39:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., Could not load Authentication extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.



Am I missing something? Is this even possible? If not, then why isn't it possible?

It feels like I've been going round in circles on something that shouold be pretty trivial to configure.

Thanks in advance.

Adam.

View 9 Replies View Related

WSS 3.0 Lists Data Processing Extension

Mar 12, 2007

Hello,



I'm writing a Data Processing Extension for SSRS 2005 that allows you to use a WSS 3.0 List as a dataset.
This works for one list per dataset. Now I am trying to extend the extension to allow multiple lists in a dataset because I want to join lists on a common field (INNER JOIN). The problem is that I can only return one DataTable to the Report Server with the DataReader. Does anyone know if it is possible to return multiple DataTables (without the join)?

I'm a student, working on this project. I know Visual Basic.net but only started last month with Data.

Thanks in advance

Tom

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved