User Login Failed - SQL Server Exp 2008 -vb.net 2010

hello guys, I had created a Windows Form App project using SQL as DB. It's working fine on my computer.

But when I tried to run the application on other computer, it's unable to connect to database.

Error is: Cannot open database requested by the login. The login failed. Login failed for user

Is there any settings I need to set on the SQL Server?

Than

May 21st, 2015 3:37am

Is there any settings I need to set on the SQL Server?


Yes, the Login used by the application + database permissions, of course. See Managing Logins, Users, and Schemas How-to Topics
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2015 6:24am

1)share connection string

2) connection string username  login can able to login sql server ?

May 21st, 2015 10:32am

Error is: Cannot open database requested by the login. The login failed. Login failed for user

Hi cguan,

To overcome the above error, please check the following things.

Check the connection strings in your application and make sure it's pointing to correct database.

Make sure that a login (which is for the user reported in your error message) exists in Server/Security/Logins node of SQL Server. Also make sure the user exists in Databases/[Your database]/Security/Users node and has db_owner permission on the database.

Thanks,
Lydia Zhang

Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 3:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics