Cannot open database “databasename” requested by the login. The login failed. Login failed for user

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

This is the scenario.I'm creating a desktop application with VB.NET (Windows Forms), and using SQL Server 2008 r2 for its database.I have two computers(PC1 and PC2) and I want to connect PC2 to PC1 . PC 1 has the microsoft sql server database. What i do is i just copied .exe application in the debug folder of my vb project and create a notepad for its connection and put them into one folder and transfer it to PC2.

When i run my appplication to other PC, I got an error of

Unhandled exception has occured in your application. If you click Continue, the application will ignore this error and attempt to continue, If you click quit, The application will close immediately.

Cannot open database "DatabaseName" requested by the login. The Login failed. Login failed for user

My code inside the notepad

VB

Data Source=PC1;Initial Catalog=DBSAS;Integrated Security=True

Can someone please give me an advice about this. I am really confuse. Thanks

What I have tried:

What i have done so far is to enable remote connection of SQL server 2008.

Posted 1-May-16 17:29pm

Diether Silverious

Updated 3-May-16 11:08am

Add a Solution

Comments

PIEBALDconsult 2-May-16 0:06am

Are you in an Active Directory domain? If not, I don't think you can use Integrated Security.
Other than that, ensure that the proper port is open on the "server".

Herman<T>.Instance 2-May-16 7:17am

set Integrated Security=SSPI

Diether Silverious 2-May-16 20:47pm

i have tried this ,,set Integrated Security=SSPI. But not working

an0ther1 2-May-16 23:02pm

As PIEBALDconsult has said already, are you on a domain? If so you need to ensure the User running the application has access to the database you are attempting to connect to.
If not, you will need to use SQL Authentication and pass a Username & Password as part of your connection string.
Refer to http://www.connectionstrings.com/sql-server/ for Connection String information

Kind Regards

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bensonz · Answer 1 · 2016-05-03T11:08:00

Solution 1

hi

It sims you are using Windows authentication to connect to the database
try using sql authentication i find it more convenient for remote connectivity

Posted 3-May-16 11:08am

bensonz