Connecting to a SQL Server locally using SQL authentication

Question

0.00/5 (No votes)

See more:

I'm trying to connect to a local SQL Server installed on my PC (using my SQL login details), and for some reason, all the intuitive methods seem to fail. My connection string is something like this.

Data Source=localhost/127.0.0.1;Initial Catalog=TESTA;User ID=userid;Password=pass

(The slash is not really there, I tried both the options...)
What is missing?

Posted 30-Oct-11 22:03pm

ShacharK

Add a Solution

4 solutions

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)

Mehdi Gholam · Accepted Answer · 2011-10-30T22:06:00

Solution 1

Usually you just put the address 127.0.0.1 or (local)

Read this : http://www.connectionstrings.com/[^]

Posted 30-Oct-11 22:06pm

Mehdi Gholam

OriginalGriff · Accepted Answer · 2011-10-30T22:09:00

Don't know - but I know how you can find out.

In visual studio, open the Server explorer pane.
If you do not have a connection to your database, add one by Right clicking "Data Connections" and selecting "Add Connection...". Follow the dialogs until you have a connection.
In the Server Explorer pane, click your database to highlight it.
Look in the Properties pane where you will fine "Connection String" - copy and paste this and it will work.

phil.o · Accepted Answer · 2011-10-30T22:19:00

Solution 3

Also, check in SQL Services configuration, that TCP/IP is activated for the instance you are trying to connect to.

Posted 30-Oct-11 22:19pm

phil.o

Comments

ShacharK 31-Oct-11 4:21am

Well, I know that its activated, because there is another software installed on the destination PC that is using the same database... If I only had access to its connection string, life would have been easier.

ShacharK · Accepted Answer · 2011-10-30T22:27:00

Solution 4

Why the hell did they change the port from 1433? Annoying people :S

Posted 30-Oct-11 22:27pm