Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.

SQL Server >

SQL Server Forums >

SQL Server Security >

Cannot login analysis server in C# console application

Cannot login analysis server in C# console application

Tuesday, November 13, 2012 7:20 PM

0

Hi all,

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!
- Reply
- Quote

All Replies

Wednesday, November 14, 2012 4:28 AM

0

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
- Reply
- Quote
Wednesday, November 14, 2012 1:27 PM

0

check at SQL server, you must provide access rights on required database for user you are using in application code.

Regards,
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.
- Reply
- Quote

Frequently asked questions - Forums help