Tuesday, November 13, 2012 7:20 PM
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 ''."
Can you give me some solutions?
Thanks and best regards!
Wednesday, November 14, 2012 4:28 AM
What is the state parameter of this error?http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
What is the default database specified for that login? Does it exist on the server? Does the login have access to?
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance
Wednesday, November 14, 2012 1:27 PM
check at SQL server, you must provide access rights on required database for user you are using in application code.
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.