Can't find Reporting Services on SQLEXPR_ADV.EXE?

Can anyone tell me why I can't find Reporting Services when I try to install SQL Server Express with Advanced Services?

Thanks...

Hi,

as a prerequisite, you will need to have IIS installed first, is it ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I figured it out, but thanks anyway :).|||Could you please post your solution then, that any other reader can participate on your work ?sql

Can't find Report Viewer/Explorer WebPart (SP v3+SQL 2005)

Hello all,
I'm new with SP v3 and the Reporting Services of SQL Server 2005.
I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.
Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.
Cheers
MarcHave you uploaded the web parts to the SharePoint site? I don't think they
come preinstalled with SharePoint.
On the server with SQL Server 2005 installed, you should find the web parts
in a cab at
C:\Program Files\Microsoft SQL Server\90\Tools\Reporting
Services\SharePoint\RSWebParts.cab
Copy the Cab file to your SharePoint server and install it using Stsadm or
any other program you use to deploy web part packages (cabs).
Kaisa M. Lindahl
"Marc" <M.Thierer@.web.de> wrote in message
news:1139324142.873377.225310@.g43g2000cwa.googlegroups.com...
> Hello all,
>
> I'm new with SP v3 and the Reporting Services of SQL Server 2005.
> I did a prototyp report and show it with "SQL Reporting Services
> Report"-WebPart, but I can't find the WebParts Report Viewer and
> Explorer in the WebPart Gallery.
> Please, could somebody give me a clue where the problem could be, or
> how I could isolate the problem area.
>
> Cheers
> Marc
>

Can't find Report Builder

I've installed SQL Server 2005 Developer Edition along with Visual Studio 2005. The SQL management consol indicates that Reporting Services is running, but I can't seem to find the Report Builder for the life of me. Is it integrated into Visual Studio somewhere?Report Builder is a ClickOnce app that is installed and run from the web. If you go to the web interface for SSRS you should see a button towards the top of the web page that will launch Report Builder.sql

Can't find Microsoft.ReportingServices.ReportRendering assembly

Hi,
I have installed Microsoft SQL Server 2000 Reporting services
Evaluation Edition. I am trying to wrtie a custom rendering service.
But to implement the
IRenderingExtension interface i need to reference
Microsoft.ReportingServices.ReportRendering assembly. I am unable to
find it any of the installed directories. Can you please tell me how
to go about this?
Any help will be appreciated.
Regards
VijaykumarHi,
I don't think such a file exists.
You have specific dlls for rendering extensiosn for example :
Microsoft.reportingservices.excelrendering,
Microsoft.reportingservices.csvrendering.
You don't have a dll for a report rendering. Reports are rendered through
rendering extensions (excel, pdf, csv, etc...
Cédric
"Vijaykumar" <vijaykumarkarekar@.hotmail.com> wrote in message
news:63da8fe5.0408152338.88b9e0b@.posting.google.com...
> Hi,
> I have installed Microsoft SQL Server 2000 Reporting services
> Evaluation Edition. I am trying to wrtie a custom rendering service.
> But to implement the
> IRenderingExtension interface i need to reference
> Microsoft.ReportingServices.ReportRendering assembly. I am unable to
> find it any of the installed directories. Can you please tell me how
> to go about this?
> Any help will be appreciated.
> Regards
> Vijaykumar|||Hi Vijaykumar:
The type IRenderingExtension exists in the
Microsoft.ReportingServices.ReportRendering *namespace*.
The assembly for the type is actually
Microsoft.ReportingServices.Processing.dll.
HTH,
--
Scott
http://www.OdeToCode.com
On 16 Aug 2004 00:38:26 -0700, vijaykumarkarekar@.hotmail.com
(Vijaykumar) wrote:
>Hi,
>I have installed Microsoft SQL Server 2000 Reporting services
>Evaluation Edition. I am trying to wrtie a custom rendering service.
>But to implement the
>IRenderingExtension interface i need to reference
>Microsoft.ReportingServices.ReportRendering assembly. I am unable to
>find it any of the installed directories. Can you please tell me how
>to go about this?
>Any help will be appreciated.
>Regards
>Vijaykumar|||You need to reference the ReportRendering namespace, which is contained in
the same assembly as the ReportProcessing namespace:
Microsoft.ReportingServices.Processing.dll
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vijaykumar" <vijaykumarkarekar@.hotmail.com> wrote in message
news:63da8fe5.0408152338.88b9e0b@.posting.google.com...
> Hi,
> I have installed Microsoft SQL Server 2000 Reporting services
> Evaluation Edition. I am trying to wrtie a custom rendering service.
> But to implement the
> IRenderingExtension interface i need to reference
> Microsoft.ReportingServices.ReportRendering assembly. I am unable to
> find it any of the installed directories. Can you please tell me how
> to go about this?
> Any help will be appreciated.
> Regards
> Vijaykumar|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<#uOoZ$5gEHA.1656@.TK2MSFTNGP09.phx.gbl>...
> You need to reference the ReportRendering namespace, which is contained in
> the same assembly as the ReportProcessing namespace:
> Microsoft.ReportingServices.Processing.dll
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Vijaykumar" <vijaykumarkarekar@.hotmail.com> wrote in message
> news:63da8fe5.0408152338.88b9e0b@.posting.google.com...
> > Hi,
> > I have installed Microsoft SQL Server 2000 Reporting services
> > Evaluation Edition. I am trying to wrtie a custom rendering service.
> > But to implement the
> > IRenderingExtension interface i need to reference
> > Microsoft.ReportingServices.ReportRendering assembly. I am unable to
> > find it any of the installed directories. Can you please tell me how
> > to go about this?
> >
> > Any help will be appreciated.
> >
> > Regards
> > Vijaykumar
Thnaks Robert I got it. Let me try to implement the custom rendering.

Cant find error

I am developing a new report in VS 2005 with Reporting Services 2005
installed. I go to preview the report, and I get this:
"The definition of report blah is invalid. An internal error occurred on
the report server. See the error log for more details."
I have been looking everywhere for these error logs, and cant seem to find
one. I have checked my local event viewer and program files\mssql.3\logs, as
well as the remote Sql Server's event logs, rs logs, etc.
All the docs on Google point me to where the web server keeps their logs at
, but I am just tryign to preview a dev version locally.
Any help would be greatly appreciated.
thanks!On Aug 20, 4:50 pm, Carl Henthorn
<CarlHenth...@.discussions.microsoft.com> wrote:
> I am developing a new report in VS 2005 with Reporting Services 2005
> installed. I go to preview the report, and I get this:
> "The definition of report blah is invalid. An internal error occurred on
> the report server. See the error log for more details."
> I have been looking everywhere for these error logs, and cant seem to find
> one. I have checked my local event viewer and program files\mssql.3\logs, as
> well as the remote Sql Server's event logs, rs logs, etc.
> All the docs on Google point me to where the web server keeps their logs at
> , but I am just tryign to preview a dev version locally.
> Any help would be greatly appreciated.
> thanks!
In general, this is a very vague error. If you can remember the last
thing you changed before you got the error, that's the first place to
start. Also, depending on the number of SQL Services you have
installed (i.e., SSRS, SSIS, SSAS), it could be located in a different
MSSQL. directory. On my local machine, the SSRS logs are located in
the following location:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services
\LogFiles
Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant

Can't Find ConfigEdit

I installed the ConfigEdit XML editor mentioned in Kirk Haselden's great Integration Services book. But I can't use it unless I can find it! It's nowhere to be found in the Start menu or BIDS or right-click menus or inside projects. The book assumes you know where to go to open the editor. I'll be the first to eat crow if it's somehwere obvious. ConfigEdit installs to %ProgramFiles%\SSIS\Package Configurations Editor. I wouldn't call that obvious.|||

jaegd wrote:

ConfigEdit installs to %ProgramFiles%\SSIS\Package Configurations Editor. I wouldn't call that obvious.

The setup executable prompted me for the location to save it to... So, yes, it is obvious.

Did you guys run (do you have) SetupConfigEdit.msi dated 12/27/2005?|||

Thanks jaegd, got it!

Phil, the date of my SetupConfigEdit.msi is 12/27/2005, but I don't recall getting a prompt. It's possible I was surrounded by distractions at the time or I may have installed it and didn't have time to try it right away. In any case, it would have been helpful to mention the default location in the book. Oops, I'm supposed to be eating crow...

|||

Sorry folks... :(

What can I say. It wasn't like, my day job or something...

Hopefully, you get some facility from the utility!

K

|||

Kirk, if you wrote merely the best SSIS book out there (IMHO) in your spare time then I'm even more amazed. I'll be one of the first in line (or online) if you ever do a 2nd Edition. That's because I use this book a lot and would always want the latest version--something I can't say for most of the tech manuals on my shelf.

ConfigEdit is just what the doctor ordered when using XML package configurations. Without it I'd be stuck using a text editor right now. Yuk. It would be nice to have such a utility built in to SSIS...

Cant enter user&password for Integration Services

I'm about to start using Integration Services in Mgmt Studio 2005.

But, when I try to register a server for Integration Services,
the option for choosing between Windows authentication and SQL Server
authentication is greyed out, and it's set to Windows.
My domain user is automatically filled in, but greyed out. I can't enter
my password since this field is also greyed out.
Is this some installation problem? (Connection to a Database Engine works fine.)SSIS doesn't support sql auth (at least not from SSMS). there is only windows auth.

SSAS is the same way.|||My next problem is that I can't make my domain account connect
without making it a member of the server's local Administrators group.

I read this article:

http://msdn2.microsoft.com/en-us/library/aa337083.aspx

which describes how to fix this. I gave my users all kind of rights
for the MsDtsServer component and restarted the Integration Services service on the server, but it doesn't help. What can be missing?|||I had to add my user to the Distributed DCOM Users group, and
the Users group had to get full access to the MsDtsServer component.
Now it works.

can't drop login

can't drop login

icrosoft SQL Server, Error: 15141

The server principal owns an event notification and cannot be dropped.

notification services do not show anything, where else could it be ?

Did you opened up the Service Broker node in the database node ? There might be a Queue open for that principal that you want to delete.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Have you checked sys.server_event_notifications? Is there any notification there owned by the login?

Queues are owned by database principals, so this error is not caused by the presence of a queue.

Thanks
Laurentiu

|||

thanks a lot

sys.server_event_notifications showed a row related to user.

I droped notification and and was able to drop login

can't drop login

can't drop login

icrosoft SQL Server, Error: 15141

The server principal owns an event notification and cannot be dropped.

notification services do not show anything, where else could it be ?

Did you opened up the Service Broker node in the database node ? There might be a Queue open for that principal that you want to delete.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Have you checked sys.server_event_notifications? Is there any notification there owned by the login?

Queues are owned by database principals, so this error is not caused by the presence of a queue.

Thanks
Laurentiu

|||

thanks a lot

sys.server_event_notifications showed a row related to user.

I droped notification and and was able to drop login

Can't deploy from local machine

Can anyone help me. I work in a workgroup environment as opposed to domain
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't deploy a cube project to the Analysis Server using BIDS

I am working through the Microsoft SQL Server 2005 Analysis Services Step by Step book and I can't deploy the first cube project to my Analysis Server from my workstation.

I have a server running Windows 2000 Server SP4 and a laptop running Windows 2000 Pro SP4. On the server I am running SQL Server 2005 SP2 complete installation, including workstation components. On my laptop I am running SQL Server 2005 SP2 workstation components.

I have used the Cube Wizard to create a cube without a Data Source (as described in Chapter 3) and then used the Schema Generation Wizard to create the schema which I then populated with data.

When I go to Deploy the cube using BIDS I see the status bar message Build started... and then Deploy started... and then I get an error that says The connection either timed out or was lost.

If I perform the same actions on the server so that BIDS is running on the server and all connections are to localhost the deploy works and I can then browse the cube.

From my laptop I can see all the AS objects on the server through SSMS, including the AS database I created from the server.

Thinking that there maybe some incompatability between the software on my laptop and the server, I did a clean install of the workstation components to a new machine, created a new project and I still get the same error.

I have followed all the advice from Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios (http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/cisql2005ascs.mspx) but I have not found any solution yet. I also tried increasing the connection and query timeout properties in BIDS (Tools/Options/BI Designers/AS Designers) - that didn't work either.

Really stuck now and any help would be greatly appreciated.

TIA
Caryl Wills
Hi,

U need to test the connectivity. Once u pass this test, u will be able to deploy the cube. On the deployment configuration window, make sure u properly give the name of the Server where u want to deploy. Else create the script file and execute it from the Management Studio..

Hope this will help

--Imran|||Hi Imran,
Thanks for your suggestions. I am trying to test connectivity and now seem to have a problem creating an Analysis Services database from my client computer. In SSMS Object Explorer I have the Analysis Services server. If I right click the 'Databases' node and select 'New Database' and then fill in the dialog with a unique database name and Impersonation set to 'Use the service account' and click OK the progress wheel just goes forever. Restarting the Analysis Services service is required to stop the process.

How do I trace the process and do you have any idea what might be preventing it from working?

Thanks for your help.
Caryl
|||Thanks for your help folks - all problems now solved by shutting down ZoneAlarm on server. For some reason ZoneAlarm will not allow connections to Analysis Services over my LAN even though the firewall is turned OFF for the trusted zone.

Can't Delete Meta Data Services Packages (Repost: No response on DTS SQL NG.)

Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:

>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>

Can't Delete Meta Data Services Packages (Repost: No response on DTS SQL NG.)

Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>

Can't create new datasource

I installed analysis services this last week and now when I try to add a new
data source in reporting services I get an error that says The OLE DB
provider SQLOLEDB has not been installed or is not valid. Do you wan tto
reset the connect string? It has a cancel and an OK button but no matter
which one you push it does nothing. It was working before I did the install
and when I did the install I just took the defaults and loaded up the latest
service pack. Any suggestions?
Thanks,
MelissaMy guess is that MDAC is messed up. One thing you might try is re-installing
the service pack for SQL Server. Either that or try re-installing the
appropriate version of MDAC.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Melissa" <Melissa@.discussions.microsoft.com> wrote in message
news:70F08879-5220-4681-9E31-852F7D542D4D@.microsoft.com...
> I installed analysis services this last week and now when I try to add a
new
> data source in reporting services I get an error that says The OLE DB
> provider SQLOLEDB has not been installed or is not valid. Do you wan tto
> reset the connect string? It has a cancel and an OK button but no matter
> which one you push it does nothing. It was working before I did the
install
> and when I did the install I just took the defaults and loaded up the
latest
> service pack. Any suggestions?
> Thanks,
> Melissa

Can''t Creat Subscriptions

We're new to SQL Reporting Services and have a new SQL 2005 server.

I'm having a problem activating scubscriptions.

- "New Subscription" is greyed out in Server Management Studio.

- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;

"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"

Any suggestions?

Found the problem.

When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.

Thanks for the tip!|||Be careful! This might sound very fool but sometimes the problem is that the paramethers are bad passed to the report, or the report's paramethers has non-english characters, like '?'.

I've passed 'a?o' (year, in spanish) as a paramether, and nothing seems to work'till I changed that.

I hope this help all of you.

Saludos desde el sur del mundo.|||What screen are you configuring the data source? I can't find the button you are referring to.