Connecting to SQL Server on local Network

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I'm Using SQL Server 2012 Express & VB.Net

On my development machine everything is perfect with with SQL Server 2012 LocalDB as data source

Localdb Connection String:

"Data Source=(LocalDB)\v11.0;Integrated Security=true;AttachDbFileName=C:\TestData\Test.Mdf"

On the testing machine with SQL Server 2012 Express everything went perfectly on same pc on which SQL Server was installed

SQL Server Express Connection String.
1. Attach DB File

'For Connection
"Server=.\SQLEXPRESS;Initial Catalog=Master;Trusted_Connection=Yes;"
'For Attaching DB File to above Connection
"exec sp_attach_db @dbname='Test', @filename1='C:\TestData\Test.Mdf', @filename2='C:\TestData\Test.ldf'"

2. Connect to DB File Attached Already

"Server=.\SQLEXPRESS;Integrated Security=true;Database=Test"

Everything went perfectly with above details.
Now I connect from another PC and it gave me an error

Invalid Username & Password

What should I do?

Please help

Posted 10-Jun-14 21:05pm

A N Saraf

Add a Solution

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)

OriginalGriff · Accepted Answer · 2014-06-10T21:11:00

Provide the correct username and password.
Normally, development machines use "Integrated Security=True" because the instance is local to the app being tested: for production DB systems, that is a lot less normal because you need to restrict who can do what to which database: You don't want everybody having access to sensitive information such as address lists for example, because there are legal restrictions in most companies on how available such info is (in the UK it's called the Data Protection Act).

So you need to talk to whoever administers your production DB server, and get a "proper" username and password from him - which you can then use in your application.