Access to database and connection string

Question

This is my connection string:

 <add name="modelConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename='D:\Documents and Settings\Dima\My Documents\Visual Studio 2010\WebSites\WebSite10\App_Data\ASPNETDB.MDF';Integrated Security=True;User Instance=True;" providerName="System.Data.SqlClient"/>

It stopped throwing exceptions, but the access to the database doesnt seem to work, cause when i answer the confirmation question, it says it is wrong and wont let me in!!

    <membership defaultProvider="MyMembershipProvider">

  <providers>
    <clear/>
    <add
   name="MyMembershipProvider"    
   type="System.Web.Security.SqlMembershipProvider"      
   connectionStringName="modelConnectionString"             
   minRequiredPasswordLength="1"          
   minRequiredNonalphanumericCharacters="0"
   enablePasswordReset="true"
   maxInvalidPasswordAttempts="1000"
   passwordAttemptWindow="4000"
   enablePasswordRetrieval="true"
   requiresUniqueEmail="false"
   passwordFormat="Encrypted" 
   applicationName="/WebSite10"

   />
  </providers>
</membership>

First check the authentication mode of Sql Server you are connecting and then let me know all the details. — Saurabh
– Saurabh, Commented May 27, 2011 at 8:40
did you made an aspnet user in sqlserver ?and what privileges have you given — Devjosh
– Devjosh, Commented May 27, 2011 at 8:44
The authentication mode is "Forms".. Unfortunately, i dont know the procedure of making aspnet user and privileges. — Dmitry Makovetskiyd
– Dmitry Makovetskiyd, Commented May 27, 2011 at 9:02

Ira Rainey · Accepted Answer · 2011-05-27 08:45:39Z

2

You haven't specified a database name in the connection string - in the top one you are specifying the database file where you should be declaring the database name.

Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname; Trusted_Connection=Yes;

If you're attaching a database file to a local instance of SQL then you need to use the AttachDbFilename property.

answered May 27, 2011 at 8:45

Ira Rainey

5,2152 gold badges36 silver badges42 bronze badges

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

13 Comments

Dmitry Makovetskiyd Over a year ago

Why do i need to use SQLExpress and not localserver.. the default server?.. well, i dont attach it. it is aspnetdb, which is created automatically by visual studio 2010

Ira Rainey Over a year ago

You don't need to use SQLExpress, that's just an example instance name. You need to specify where the server instance is for the database to be attached to.

Dmitry Makovetskiyd Over a year ago

i added your modification. now it doesnt throw an exception, it simply says the user name is not in the database. The instance is inside server explorer in visual studio. It was added by the program (VS2010) not by me

Ira Rainey Over a year ago

OK, the database connection is made then, now you've got enough to go on and work the rest out. That's nothing to do with the connection string, but to do with the membership provider. Look into using the WAT to manage the users for the membership provider.

Dmitry Makovetskiyd Over a year ago

Cannot open database "dbname" requested by the login. The login failed. Login failed for user 'DIMA-00AA1DA557\Dima'. -- Thats what i tried. it doesnt give me the old exception that i stated in the question. I still cant access the database. I wonder what you provide in the connection string or do in windows configuration to be able to enter the database

|

DevM · Accepted Answer · 2011-05-27 08:40:59Z

1

Can you not create the connection through the Visual studio server explorer. You can log into the server using the correct credentials then save the correct connection string to the config file.

There is a microsoft knowledge base article! on this.

answered May 27, 2011 at 8:40

DevM

94 bronze badges

1 Comment

Dmitry Makovetskiyd Over a year ago

Thanks for the link. But can u see why i fail to connect to the database with one of the connection strings from above?

Collectives™ on Stack Overflow

Access to database and connection string

2 Answers 2

13 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

13 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related