How to fix problem in opening database of other computer?

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

I have SQL Server 2014 and I made a system using VBNET 2015 in PC1. Then I connect my database through WLAN in PC2.. The SQL Server 2014 of PC2 is now allowed to open my database and its tables.. So, I open the .exe files of my program in Debug folder using PC2.. I made a Login Form in the program that I made but everytime I log in the error occurs saying

VB

" Cannot open database "NEWCMO" requested by the login. The login failed. Login failed for user "ACE\LOUSA""

What I have tried:

I never try anything but to access only by PC2 the database of PC1

Posted 7-Mar-17 3:29am

Member 12905345

Updated 7-Mar-17 6:02am

Add a Solution

Comments

Dave Kreskowiak 7-Mar-17 10:00am

Show us the connection string you're using. Chances are really good your PC's are NOT in an Active Directory and you're using a Trusted Connection, which won't work in your situation.

OriginalGriff 7-Mar-17 10:02am

Absolutely!

Member 12905345 7-Mar-17 11:33am

"Server=.\SQLEXPRESS;database =NEWCMO; integrated security=True; "

Dave Kreskowiak 7-Mar-17 12:38pm

First, if you're going to talk about SQL Server, you MUST sya you're using the Express edition. Things are setup quite a bit differently under Express than they are under the full Server versions.

Next, Express doesn't allow remote connections by default and, since that is a named instance ("SQLEXPRESS"), it doesn't listen on port 1433.

If you've got the SQL Server Management Tools installed with your Express installation, setting this up is easy. Just follow this guide[^].

Member 12905345 7-Mar-17 12:53pm

I am using SQL Server express.. I have tutorial on how to open the database of PC1 by PC2 using 1433.. What I am trying to do sir is to allow PC2 to login in my dental system but errors occurs above.

Dave Kreskowiak 7-Mar-17 14:25pm

Because you haven't setup SQL Server Express properly to allow it to work, as I've already told you.

Member 12905345 7-Mar-17 22:06pm

Sir, thank you... the PC2 has successfully open my server in PC1 using SQL Server Authentication.. But when PC2 run the Debug of my Dental System to Login (by the way I made a Login form using vbnet) the error occurs saying "Login failed for user "computername/Guest".
How to fix it? Thanks

Dave Kreskowiak 7-Mar-17 23:03pm

Not enough information to tell. I have no idea where this "Guest" login is coming from.

Member 12905345 8-Mar-17 0:57am

The computername in "Login failed for user "computername/Guest" is the computername of pc1

Dave Kreskowiak 8-Mar-17 8:34am

Still not enough information. I have no idea what process is requesting that login.

Dave Kreskowiak 7-Mar-17 12:43pm

The next problem is you can't really use a trusted connection. Create an SQL login for your database and use that account in your connection string.

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)

F-ES Sitecore · Answer 1 · 2017-03-07T06:02:00

Solution 1

Try without integrated security, ie create a SQL User with a username and password via the SQL Server Management Studio and add the credentials to the connection string. See "Standard security" in the following link

.NET Framework Data Provider for SQL Server Connection Strings - ConnectionStrings.com[^]

Posted 7-Mar-17 6:02am

F-ES Sitecore

Comments

Member 12905345 7-Mar-17 12:33pm

So, I created Assisstant as User under of Security of my Database..

Server=.\SQLEXPRESS;database =NEWCMO;User Id=Assisstant; Password=glen;

is it correct?