VB.net Connection string to local SQL Database

Posted on 2014-10-10
Medium Priority
Last Modified: 2014-10-10

I use a connection string such as the following to connect to a remote server
I want to connect to a new database that I have created on my desktop
How do I alter the connection string?

Question by:Murray Brown
  • 4
  • 2
LVL 34

Accepted Solution

Brian Crowe earned 2000 total points
ID: 40373500
assuming you used the default instance name:


Author Comment

by:Murray Brown
ID: 40373522
I never set up any username or password

Author Comment

by:Murray Brown
ID: 40373536
I think I used Windows Authentication
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

LVL 34

Expert Comment

by:Brian Crowe
ID: 40373542
You must have set up something even if it was using windows authentication.  Access the database using SSMS.

BTW, here is a good reference for different connection string formats.


Author Comment

by:Murray Brown
ID: 40373599
I am in SSMS. looking at the database
I have attached a screenshot
The database is Test2
How do I build the connection string?

Author Closing Comment

by:Murray Brown
ID: 40373621
Thanks very much

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question