Connection string format and SQL Server login error

Question

This is my first "code first approach" with SQL Server 2012 Express.

I'm trying to create a database but there is a problem with the connection string.

This is my connection string:

Data Source=AMBROGIO\SQLEXPRESS;Initial Catalog=TAP2014_15Project;Integrated Security=True;

This is the connection string which arrives to my setup function:

Data Source=AMBROGIO\\SQLEXPRESS;Initial Catalog=TAP2014_15Project;Integrated Security=True;

With a double \\ after the name of my Pc.

For a test I've tried to write something else as connection string and under debugging it arrives without modification (obviously it raises an error).

Someone can please help me ?

Thanks.

Filippo

Hi, sorry if I reply only now. Yes I was using the debugger to look the string.

Now the error that I have is an exception raise by my method:

 db.Database.CreateIfNotExists();

error:

Exception:Thrown: "Cannot open database "TAP2014_15Project" requested by the            
login. The login failed.
Login failed for user 'AMBROGIO\Filippo'."       
(System.Data.SqlClient.SqlException)
A System.Data.SqlClient.SqlException was thrown: "Cannot open database  
"TAP2014_15Project" requested by the login. The login failed.
Login failed for user 'AMBROGIO\Filippo'."

What do you mean by "which arrives to my setup function"? How are you determining the string? My guess is that you're looking under the debugger, which will automatically (and often unhelpfully) escape backslashes... — Jon Skeet
– Jon Skeet, Commented Aug 7, 2015 at 15:57
You should add what your problem is. Do you get an error message? What is the code that causes the error message? What is the error message? — Derek
– Derek, Commented Aug 7, 2015 at 18:14

Community · Accepted Answer · 2017-05-23 10:26:40Z

2

The following line should be in your config file:

<add name="ConnectionStringName"
     providerName="System.Data.SqlClient"
     connectionString="Data Source=AMBROGIO\SQLEXPRESS;Initial Catalog=TAP2014_15Project;Integrated Security=True" />

If you set the connection string from C# code then:

connectionString = @"Data Source=AMBROGIO\SQLEXPRESS;Initial Catalog=TAP2014_15Project;Integrated Security=True";

Example source.

UPDATE

As for the question about login error - there is the same issue aleady resolved. Check it.

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Aug 7, 2015 at 18:15

kyrylomyr

12.7k9 gold badges57 silver badges81 bronze badges

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

1 Comment

Greg Over a year ago

The '@' symbol is critical there, to magically escape the slashes for you. Without the @, you need to add escape slashes on your own. This style of defining string literals is very handy for defining filesystem paths, BTW, per Peter Gluck's answer.

Peter Gluck · Accepted Answer · 2015-08-07 18:18:26Z

1

The double backslash is an escape seqeuence that resolves to a single backslash when included in a double-quote-delimited string. The backslash is used in many contexts to denote the beginning of an multi-character escape sequence to represent special or non-printable characters. Unfortunately, Microsoft also chose the backslash as the path delimiter in their early DOS operating systems. So to express a path delimiter within double-quote-delimited string you need to use a double backslash.

answered Aug 7, 2015 at 18:18

Peter Gluck

8,2561 gold badge40 silver badges38 bronze badges

Collectives™ on Stack Overflow

Connection string format and SQL Server login error

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related