Changing connection of bi project | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing connection of bi project

Hi. I’m running the BI sample project that comes with AdventureWorks DB, and I’m trying to write some MDX sentences. First, I’ve tried to create an MDX query from the SSMS, but it raises the error that it can not find cubes metadata, so I went to BIDS and tried to deploy the solution (first I changed the server name in the Deployment tab of project properties) however I got a lot of errors (listed below). I tried also to create a named query (but i’m not sure if it will let me write an MDX sentence) and I get other error, but the server name here is not the one I changed in the deployment tab, so I assume there is another place where I must change the name of the server BIDS should connect to. Would you please let me know any solution to this?
ERRORS
———————————————————————
Error1OLE 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 AUTHORITYSYSTEM’.; 28000; Cannot open database requested in login ‘AdventureWorksDW’. Login fails.; 42000.00
Error2Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Adventure Works DW’, Name of ‘Adventure Works DW’.00
Error3Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Dim Product’, Name of ‘Product’ was being processed.00
Error4Errors in the OLAP storage engine: An error occurred while the ‘Category’ attribute of the ‘Product’ dimension from the ‘Adventure Works DW’ database was being processed.00
Error5OLE 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 AUTHORITYSYSTEM’.; 28000; Cannot open database requested in login ‘AdventureWorksDW’. Login fails.; 42000.00
Error6Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Adventure Works DW’, Name of ‘Adventure Works DW’.00
Error7Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Dim Product’, Name of ‘Product’ was being processed.00
Error8Errors in the OLAP storage engine: An error occurred while the ‘Standard Cost’ attribute of the ‘Product’ dimension from the ‘Adventure Works DW’ database was being processed.00
Error9OLE 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 AUTHORITYSYSTEM’.; 28000; Cannot open database requested in login ‘AdventureWorksDW’. Login fails.; 42000.00
Error10Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Adventure Works DW’, Name of ‘Adventure Works DW’.00
Error11Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Dim Product’, Name of ‘Product’ was being processed.00
Error12Errors in the OLAP storage engine: An error occurred while the ‘Color’ attribute of the ‘Product’ dimension from the ‘Adventure Works DW’ database was being processed.00
Error13OLE 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 AUTHORITYSYSTEM’.; 28000; Cannot open database requested in login ‘AdventureWorksDW’. Login fails.; 42000.00
Error14Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Adventure Works DW’, Name of ‘Adventure Works DW’.00
Error15Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Dim Product’, Name of ‘Product’ was being processed.00
Error16Errors in the OLAP storage engine: An error occurred while the ‘Safety Stock Level’ attribute of the ‘Product’ dimension from the ‘Adventure Works DW’ database was being processed.00
Open SSMS, and connect to analysis server where you deployed the solution.
Check the data source property to find out which SQL DB it is connecting to.
You can even change the SQL connection details there. Else, while deploying your solution deploy it with Proccessing option enabled, so that
after deployment it will even process the AS db.
Also keep in mind that AS uses Windows authentication so first try to connect to AS server using your windows credentials.
I’ve tried that and changed the connection details already. One problem that I found when trying to change the connection is that I had to manually enter the server name, that was this way because I was using a named instance (since I’ve got running both SQL Server 2000 and SQL Server 2005 on the same machine) to be able to get the list of databases. Thanks.
]]>