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
Can't Deploy AdventureWorks Database
Gy_Molvak
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)
Benyu
Diane Larsen
Great...!
Thanks...! It worked for me too.
SAAM
mistercain
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