MS SQL Server OLAP data access with oledb

[vla75]

Hi there,
I made a webpage in asp.NET that access data trough Oledb and everything
works fine if the webpage and the Olap database are on one and the same
computer. When I moved the OLAP Database to a different computer our Database
Server I get an error when I try to open the OledbConnection. I am accessing
the data trough a connection string like this:
string myConnStr="Provider=msolap.2;Data Source=192.168.0.10;Initial
Catalog=VendorReport;";
The ip address 192.168.0.10 is for our database server.
Please help me if you can.

[Frans Bouma [C# MVP]]

vla75 wrote:

Hi there,
I made a webpage in asp.NET that access data trough Oledb and everything
works fine if the webpage and the Olap database are on one and the same
computer. When I moved the OLAP Database to a different computer our Database
Server I get an error when I try to open the OledbConnection. I am accessing
the data trough a connection string like this:
string myConnStr="Provider=msolap.2;Data Source=192.168.0.10;Initial
Catalog=VendorReport;";
The ip address 192.168.0.10 is for our database server.

1) if you get an error, please state this error. We can't help you if
we don't know what's wrong. Any error info can be helpful.
2) you don't specify any username/password. This means you've used
integrated security. While this might work on one system, the user
you're using with asp.net is likely ASPNET. This is a local user, not a
domain user. This means that on the system your database is on now,
ASPNET isn't known. Either use a domain user for the website and for
logging on at the database (not recommended, a website shouldn't be in a
domain together with the db server) or use sql server security (i.e.:
UID=foo;PWD=bar; )

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------