I am just learning. From one textbook I have one database that connects.. Now a new book different Database, different cube. This deploy does not work. I have tried to copy the other connection. the .ds says the connection is successful when I hit the test.
Yet when I deploy I get this error.
"Error 6 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000; Cannot open database "AdventureWorksDW" requested by the login. The login failed.; 42000"
I have migrated to the database and have added full permissions for "NETWORK SERVICE"
I am at a loss as what to try next..