none
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

    Ok

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