connection to sql database problems in vb.net

Question

0.00/5 (No votes)

See more:

Hi,
I'm trying to connect to an sql database using the following connection string

VB

Dim strCon As String = "Data Source=DATABASE,2048;Initial Catalog=STUFF;User Id=domain\username; Password=12345678"

when using this i get login failed for domain\username

but if I use

VB

Dim strCon As String = "Data Source=DATABASE,2048;Initial Catalog=STUFF;Trusted Connection=Yes;

then is works fine as i am logged in under my own domain login details while coding.

I need to be able to use my username and password in the connection string as i will be running the application on a different pc under another user. Access to the databases in our company a strictly controlled so I can't get access for the other users.
Is there something else I need in the connection string.

Thanks
J

Posted 20-Sep-12 0:44am

johnjsm

Add a Solution

Comments

[no name] 20-Sep-12 6:53am

If you open the database and look at the security, does your username have a security role assigned and access to the "stuff" database?

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)

**Malli_S** · Answer 1 · 2012-09-20T00:50:00

Solution 1

Yes, need to visit http://www.connectionstrings.com/[^].

Have a nice day.

Posted 20-Sep-12 0:50am

Malli_S

Aarti Meswania · Answer 2 · 2012-09-20T01:11:00

Solution 2

"Data Source=ServerName;Initial Catalog=DatabaseName;User Id=username; Password=password"

Happy Coding!
:)

Posted 20-Sep-12 1:11am

Aarti Meswania

v3

Comments

johnjsm 20-Sep-12 7:17am

That is what i am already using and its not working

Aarti Meswania 20-Sep-12 7:19am

you have write - 'Data Source=DATABASE'
it is 'Data Source=ServerName'

and Database name will be assigned to 'Initial Catalog'

Aarti Meswania 20-Sep-12 7:21am

for example

Data Source=My-PC\SQLEXPRESS;Database=MyDatabase;uid=sa;pwd=sa

or

Data Source=My-PC\SQLEXPRESS;Initial Catalog=MyDatabase;uid=sa;pwd=sa

johnjsm 20-Sep-12 7:22am

sorry. this is what i have.
"Data Source=ServerName,2048;Initial Catalog=DATABASE;User Id=domain\username; Password=12345678"

Aarti Meswania 20-Sep-12 7:26am

open sql server copy server-name from sql's login window and paste it after
Data Source=________
from same window username & password
and then your database name

johnjsm 20-Sep-12 7:32am

I can't actually show those details here as its a corporate database

Aarti Meswania 20-Sep-12 7:37am

you are accessing it successfully using username & password so it is secure

johnjsm 20-Sep-12 7:43am

yes. but its against corporate policy to post information like that

Aarti Meswania 20-Sep-12 7:51am

no i am not saying that
it means your connection string is working well and you have id & pwd for sql login so, it is a secure sql connection.

you have id password for sql login, still you want more security?

johnjsm 20-Sep-12 8:38am

sorry. my bad. i think my only way around it is to Run As using my login details

BheemG · Answer 3 · 2012-09-20T20:48:00

Solution 3

Hi Try this,

Data Source=.\data123;Initial Catalog=DBDesign;Integrated Security=True;Integrated Security=True;User ID=sa;Password=*****" providerName="System.Data.SqlClient"

Happy coding....

Posted 20-Sep-12 20:48pm

BheemG

Chandrashekar Srinivasan · Answer 4 · 2012-09-20T21:28:00

Solution 5

Hi Please try the below one.

Data Source=ServerName;Initial Catalog=Database Name;User ID=UserID;Password=Password providerName="System.Data.SqlClient" connnectionType="SQL"

regards
Chandru

Posted 20-Sep-12 21:28pm

Chandrashekar Srinivasan