Connect SQL server database RRS feed

  • Question


    Hi friends,


       I am new to dotnet development. I am developing a web application(ASP.NET, C#). Backend is SQL Server 2005,

    What is the best way to place the database file(.mdf)?

    Where can I put the file i.e in App_Data or SQL Server default location?


    If placed in App_Data folder, how can I connect from front end.


    If I have .mdf file, how can I copy to my SQL Server databases? Coz I am not able to see in SQL Server management studio. And how can I assign ASPNET account to that database?


    Pls reply to my question.


    Thanks in advance

    Tuesday, September 4, 2007 9:10 AM

All replies

  • U have to place the mdf along with ldf  in
    \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

    Open the management studio attach the database


    Thank u
    Tuesday, September 4, 2007 9:21 AM