Connect to SSIS Service failed: Error loading type library/DLL

by Davy Knuysen 18 September 2009 09:44

After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio. The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following error [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, integration services, sql server, uncategorized, data

Davy Knuysen

Administrator has no access to the Report Manager (SQL2008 R2 and Windows7/Vista)

by Davy Knuysen 11 September 2009 19:19

Today I wanted to start playing around with the new Report Manager of SQL 2008 R2. After installing and configuring R2, I opened Internet Explorer and entered the URL of the Report Manager. In my case: http://localhost/reports_r2 I got a very empty Report Manager : Okay, something is wrong. I tried to connect to http://localhost/reportserver_r2 : No [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, reporting services, sql 2008 r2, sql server, data

Davy Knuysen

Excel Services: Data Refresh Failed

by Davy Knuysen 12 August 2009 22:41

After deploying an Excel file to Excel Services on a new MOSS Server I got the following error: Data Refresh Failed: Unable to retrieve external data for the following connections: <<connection>> The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, excel, excel services, moss, data, sharepoint

Davy Knuysen

OLAP Reporting with Excel 2007: Use Member Properties!!

by Davy Knuysen 3 August 2009 20:55

Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties. When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind of [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, excel, data, olap, pivot table, reporting, sql server

Davy Knuysen

Recordings of last event available on Chopsticks

by Davy Knuysen 17 July 2009 21:41

Visual StudioTeam System 2008 Database Edition by Bart Wullems The Azure Services Platform and SQL Services by Kurt Claeys Enjoy the movies!!
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: event, sqlug.be, azure, chopsticks, data, tfs

Davy Knuysen

Configuring Reporting Service to use Host Headers for the Report Manager Website

by Davy Knuysen 5 February 2009 22:37

Ever tried to change the URL of the Report Manager in IIS using host headers? I did, but got the following error message when I tried to open the Report Manager: “The request failed with HTTP status 400: Bad Request” There is some extra configuration needed to make this work: Edit the RSWebApplication.config file to update the report [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, sql server, data

Davy Knuysen

SQL Server 2008 Management Studio: Saving changes is not permitted.

by Davy Knuysen 25 December 2008 22:35

In SQL Server 2008 Management Studio, saving changes to the design of a table that requires the table to be dropped and recreated is not possible, but will show the following message instead: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql server, data

Davy Knuysen

Error publishing an InfoPath Form: The following URL is not valid.

by Davy Knuysen 4 November 2008 22:34

Today, I tried to publish an Infopath Form to MOSS, but I received the following error message: The following URL is not valid: http://servername/sites/sitename Different solutions are available for this problem, but in my case the cause seemed to be that there was no root site (http://servername). So the solution was to edit the site collection and [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: infopath, moss, data

Davy Knuysen

Import Excel files with SQL Server Integration Services on a 64-bit server

by Davy Knuysen 26 August 2008 21:22

Today I deployed some SSIS packages to a test environment. These packages needed to import some excel files to a certain database. Testing the packages resulted in the following error: Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0×80004005. An OLE DB record is available. Source: “Microsoft JET Database Engine” Hresult: [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, sql server, data, excel

Davy Knuysen

Blog N-Technologies

Connect to SSIS Service failed: Error loading type library/DLL

Administrator has no access to the Report Manager (SQL2008 R2 and Windows7/Vista)

Excel Services: Data Refresh Failed

OLAP Reporting with Excel 2007: Use Member Properties!!

Recordings of last event available on Chopsticks

Configuring Reporting Service to use Host Headers for the Report Manager Website

SQL Server 2008 Management Studio: Saving changes is not permitted.

Error publishing an InfoPath Form: The following URL is not valid.

Import Excel files with SQL Server Integration Services on a 64-bit server

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts