I having some problems with my project, I'm programming with sql server 2008 and using AMO to create data access object.
I could connect to analysis server and created a database, but when i create data adapters from database tables and load schemas into data set then i have problem, it's "Cannot open database "" requested by the login. The login failed. Login failed
for user ''."
check at SQL server, you must provide access rights on required database for user you are using in application code.
Rohit Garg (My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.