Finding Database address and connecting to it through code

Question

I've just made a new SQL Database with Microsoft SQL Server Management Studio and I'm trying to connect to it through some C# code. However, I'm having some issues doing so.

I'm trying to connect to my database with the following line:

  String DBConnection = "Data Source=unknown; Database=SQLExpress\\Darkride; Language=English";

However my program can't find my database as I have no idea where my data source is. I've been trying to find it for hours now, but I'm getting nothing.

Does anyone know where I can find out my databases Data Source?

Please update your title with your specific problem meta.stackexchange.com/questions/10647/… — Soner Gönül
– Soner Gönül, Commented Apr 10, 2013 at 8:07
Your question has nothing to do with mysql (wrong tag) or the SQL management studion (wrong title). — Daniel Hilgarth
– Daniel Hilgarth, Commented Apr 10, 2013 at 8:09
'.\SQLEXPRESS' or 'localhost\SQLEXPRESS' or '127.0.0.1\SQLEXPRESS' — Mehdi Bugnard
– Mehdi Bugnard, Commented Apr 10, 2013 at 8:35

outcoldman · Accepted Answer · 2013-04-10 08:10:02Z

3

Take a look on the connection string examples here http://connectionstrings.com/sql-server-2012

Looks like it can be something like:

Server=.\SQLExpress;Database=Darkride;Trusted_Connection=True;

answered Apr 10, 2013 at 8:10

outcoldman

11.9k2 gold badges29 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Neil Thompson · Accepted Answer · 2013-04-10 08:13:57Z

1

you are missing Initial Catalog in the connection string:

 String DBConnection ="Data Source='localhost';Integrated Security='SSPI' Initial Catalog=Darkride;";

check here for more options.

edited Apr 10, 2013 at 8:13

Neil Thompson

6,4652 gold badges33 silver badges55 bronze badges

answered Apr 10, 2013 at 8:08

Mohammad Arshad Alam

9,8626 gold badges41 silver badges63 bronze badges

Comments

Stavros Zotalis · Accepted Answer · 2013-04-10 08:10:24Z

0

Add "Data Source=127.0.0.1; Database=SQLExpress\\Darkride;Initial Catalog=YourDataBase;User Id=user;Password=pass"

You can use the SqlConnectionStringBuilder class to build your connection string.

A good site for refenrence is http://www.connectionstrings.com/

answered Apr 10, 2013 at 8:10

Stavros Zotalis

7264 silver badges24 bronze badges

Comments

Freelancer · Accepted Answer · 2013-04-10 08:10:26Z

0

Have connection string format as:

String DBConnection = "Data Source=27.0.0.1;;Initial Catalog=Darkride;User ID=userIDText;Password=PasswordText";

answered Apr 10, 2013 at 8:10

Freelancer

9,1027 gold badges46 silver badges81 bronze badges

Comments

BizApps · Accepted Answer · 2013-04-10 08:14:12Z

0

Change your code to this:

Server=.\SQLExpress;Database=Darkride;Trusted_Connection=True;

And take a look on the link below

Connectionstring.com will help : Connection strings for SQL Server 2008

Best Regards

answered Apr 10, 2013 at 8:14

BizApps

6,1409 gold badges42 silver badges65 bronze badges

Collectives™ on Stack Overflow

Finding Database address and connecting to it through code

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related