SQL Server connection string problems

Question

I am trying to have access to my project from the browser, I have put it on my server .

My database is on SQL Server 2008 R2 .

When I try to login I have always this exception :

Invalid value for key 'attachdbfilename'

I think the problem is from my connection string but I can't fix it . I tried in many ways .

<connectionStrings>
  <remove name="LocalSqlServer" />
  <add name="LocalSqlServer" 
       connectionString="data source=.\SQLEXPRESS;Initial Catalog=DataUi;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|DataUi.mdf;User Instance=true"
       providerName="System.Data.SqlClient" />
 </connectionStrings>

Can someone help me ?

Thank you very much .

social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/… perhaps this will help — Oli
– Oli, Commented Nov 9, 2011 at 9:58

marc_s · Accepted Answer · 2011-11-09 17:53:18Z

3

The AttachDbFileName= feature is available ONLY in the SQL Server EXPRESS edition. It is NOT compatible and supported on a "full" SQL Server installation.

If you have a full SQL Server, you have to attach your database to the SQL Server instance, and then reference it by its (logical) database name - not the physical file name:

<connectionStrings>
  <add name="LocalSqlServer" 
       connectionString="server=.;database=DataUi;Integrated Security=SSPI;"
       providerName="System.Data.SqlClient" />
 </connectionStrings>

answered Nov 9, 2011 at 17:53

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Comments

krammer · Accepted Answer · 2011-11-09 10:01:42Z

1

You should "Database" rather than "AttachDbFileName" as it is not recommended for production servers.

Hence your connection string should be:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Initial  
Catalog=DataUi;Integrated Security=SSPI;Database=DataUi.mdf;User  
Instance=true"
providerName="System.Data.SqlClient" />
</connectionStrings>

answered Nov 9, 2011 at 10:01

krammer

2,6682 gold badges26 silver badges46 bronze badges

2 Comments

Kiwimoisi Over a year ago

I have just put this . <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=BESPIN\SQLEXPRESS;Database=DataUi.mdf;User Instance=true" providerName="System.Data.SqlClient" /> </connectionStrings> And now I get this strange error : System.Data.SqlClient.SqlException: Login failed for user ''.

krammer Over a year ago

does your user have permissions to access the SQL Server. Also check if the user has permissions to access the database and what commands are allowed on the database.

Pedram Behroozi · Accepted Answer · 2011-11-09 10:02:37Z

0

I think there's a missing \\ in your AttachDBFilename right after |DataDirectory|:

AttachDBFilename=|DataDirectory|\\DataUi.mdf

answered Nov 9, 2011 at 10:02

Pedram Behroozi

2,4973 gold badges28 silver badges48 bronze badges

2 Comments

Kiwimoisi Over a year ago

I can't have access with 2 \\ . And I got the same error with \ .

Kiwimoisi Over a year ago

I have just put this . <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=BESPIN\SQLEXPRESS;Database=DataUi.mdf;User Instance=true" providerName="System.Data.SqlClient" /> </connectionStrings> And now I get this strange error : System.Data.SqlClient.SqlException: Login failed for user ''.

Collectives™ on Stack Overflow

SQL Server connection string problems

3 Answers 3

Comments

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related