How to create connection string for SQL Server 2012?

Question

This is my connection string.

Data Source=.\MSSQLSERVER2012; Initial Catalog=admissio; Integrated Security=False; User ID=amedb; Password=*******; server=66.7.223.250;

I am trying to connect to a database but I'm unable to do so. Also I changed Data Source=66.7.233.250,8880; or server=66.7.233.250:8880; or server=66.7.233.250,8880;

Is any other way to connect database?

Why do you use server at all, when you ask to connect to a local database? Are you trying to connect to a named instance called MSSQLSERVER2012 on your local machine or a database on a remote server with IP 66.7.233.250 ? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 16, 2017 at 10:53
Instead of writing the connection string by hand, add a Connection String setting in the project's Settings tab and edit it. This will display the connection dialog box that allows you to pick server, database, user and test the connection — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 16, 2017 at 11:02
You cannot have Data Source= and server= at the same time - these are synonyms - you need to use one or the other - but not both together — marc_s
– marc_s, Commented Mar 16, 2017 at 11:22

Dmitrii Bychenko · Accepted Answer · 2017-03-16 10:57:48Z

1

Try this:

Data Source=66.7.223.250; Initial Catalog=admissio; Integrated Security=False; User ID=amedb; Password=*******;

or

Data Source=66.7.223.250\MSSQLSERVER2012; Initial Catalog=admissio; Integrated Security=False; User ID=amedb; Password=*******;

edited Mar 16, 2017 at 10:57

Dmitrii Bychenko

188k20 gold badges178 silver badges231 bronze badges

answered Mar 16, 2017 at 10:54

Rahul M

913 bronze badges

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

2 Comments

marc_s Over a year ago

@PanagiotisKanavos: that is not correct - the default SQL Server service name for the default (unnamed) instance is always MSSQLSERVER (without any version numbers or anything)

Panagiotis Kanavos Over a year ago

@marc_s oops, you are right. I never use such names for named instances so I got confused.

Collectives™ on Stack Overflow

How to create connection string for SQL Server 2012?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related