Connection String Not Working

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi

I have a SQL server DB (SQL Server 2008 R2) that I use with my classic asp web app.

I recently created a login and user with matching credentials using SQL Server Management studio. I amended the login details to my connection string. I can no longer connect to the database.

Please assist, I am still learning in this field

My initial string: " Provider = SQLOLEDB; data source=(local);Integrated Security=SSPI; Initial Catalog= myDBName; Trusted_Connection=Yes"

New string: " Provider = SQLOLEDB; data source=(local); Database= JointsDB; Uid= myUser; Pwd= myPassword"

Posted 28-Aug-14 3:08am

Member 8654266

Add a Solution

2 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)

SteveyJDay · Accepted Answer · 2014-08-28T03:39:00

What did you set the server authentication to?
The two options are Windows Authentication Mode or SQL Server and Windows Authentication Mode.
You most likely need to change the authentication mode to the second one.
To do this open Management Studio and connect to your SQL Server.
Once connected right click the top server node and then select properties.
In the popup on the left hand side select the Security page.
On the security page the top option is the one you want to change to allow SQL Logins(connection string with username and password) and Windows logins(trusted connection strings).

hypermellow · Accepted Answer · 2014-08-28T03:42:00

Solution 2

Hi,

you don't seem to be creating your connection string properly.

Have a look here.

Something like this should be better:

C#

"Provider=SQLOLEDB;data source=(local);User id=myUser;Password=myPassword;Initial Catalog=JointsDB"

Hope it helps.

Posted 28-Aug-14 3:42am

hypermellow

Updated 28-Aug-14 3:43am

v2

Comments

Member 8654266 29-Aug-14 5:05am

I have not had a chance to try your suggestions but I feel positive about them.
I will let you know how it goes.

Thank you