Search results for query: *

I figured it out. I had to make an exception for port 2383 (or whatever the default port is for Analysis Services) in Windows Firewall on the Analysis Services server.

From my client machine, I have no trouble accessing the Database Engine of my 2005 server in SQL Server Management Studio since I can use SQL Server Authentication. However, Analysis Services (at least how my server is configured right now) only allows Windows Authentication and I cannot...

We changed the data type from CHAR(10) to INT of a few fields from 2 TABLES in the DB. These 2 TABLES already existed in the Impromptu Catalog. We also created 2 new VIEWS in the DB that are based on the 2 TABLES that had a few fields undergo a data type change. I brought these 2 new VIEWS...

A correction. I meant SQL Server 2000 SP3, not SP4. The database server has MDAC 2.7 and my client had MDAC 2.7 as well. I just upated my client to MDAC 2.8 while leaving the server at 2.7 and still no luck.

Cindy, Thanks for the insight. We're using SQL Server 2000 SP4 as our database, which we connect to through Impromptu with an ODBC connection. Regards, Johnny

Gary, In short, I don't want to create a join to a Hot/SmartFile in the catalog for now. Dave, Please re-read my initial post to see how weird this issue is. With the inner join to the Smart/HotFile, one particular Supplier record is dropped. However, if I create a prompt to prompt for a...

I'll try my best to explain this behavior that I'm experiencing. I've written a report that relies on another report, i.e., a SmartFile. This report, let's call it Report A, essentially returns sales figures and other metrics on a per Product Line per Supplier basis. The SmartFile, let's call...