.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

sharing website(asp.net) mdf database on a network in multiuser environment

Posted By:      Posted Date: October 03, 2010    Points: 0   Category :Sql Server

simple question:


I have create a web site in visual studio with form user authentication.  Thats create a mdf database in this path:



thats use Sql server


i would like to access this database with c# form application on a network with multi-user.

if i change the drive letter of the path above to f:\ (mapped drive) or \\server\c\, i got this message


System.Data.SqlClient.SqlException: The file "h:\Inetpub\wwwroot\website\App_Data\ASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:\Inetpub\wwwroot\website\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.


i read that

View Complete Post

More Related Resource Links

WCF P2P: How To Design State Sharing in a Peer Network


Learn how you can peer-enable business applications by allowing them to share state in a serverless peer network.

Kevin Hoffman

MSDN Magazine July 2008

Login database with visual studio 2010 asp website template


Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.

Post Website and database online


I know this is a simple thing but i  don´t how to.....

I have the website working on my pc .... but i want to get it online with the database.

Do i have to put debug to false to publish it?

thanks in advance for your patience Smile

Network failure in Cluster Environment,will it stop the SQL Server Instances?

Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

Create database at network drive?

Is it possible to create a SqlServer database at a network drive? Thanks, Ben

How to send an email to a website and enter it into the database

Is there a way to send an email to a certain email address and have the message inserted into a database?  The subject would be intered into "Subject" table field and the message body would be inserted into the "Message" table field.Thanks.

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

Can I have an SQL Express database open in VS2010E along with the website? "Login failed for user ..

Hi, as the topic says..Whenever I have my database open in Visual Studio 2010 Express, I get this error:Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.

Restoring 2008 Database with FileStream - CreateFile Sharing Violation

I've previously posted this question and turning off the anti-virus scan helped fix it. But I'm having same issue on a machine that doesn't have anti virus scanning enabled. Back story: I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked.  Also tried the with replace option. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. Msg 3634, Level 16, State 1, Line 1 he operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'R:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-00005fcf-005a'. RESTORE DATABASE is terminating abnormally. ' I found the file on filemon and below is the error, stack and processes running. Date & Time:    9/15/2010 6:33:48 PM Event Class:    File System Operation:    CreateFile Result:    SHARING VIOLATION Path:    R:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\

Ajax enabled website and MSAcess Database

Hi i have problem while connecting to my MSAccess  Database in App_Data Folder in Ajax enabled website. How to bind Gridview with MsAcess Databse in Ajax enabled website???? Can u please help me , i m new to Ajax and Asp.net.   Thanks in Advance    

how to download Database in sql from Website Control panel ?


Dear Professionals.....

My control pannel doesn't has any option to download database so i want to download database from control panel. is there any way to download it ? any software,?

i'm a new user so please explained answer will be apperciated.



Loading Static Files in a website from a network share


Hi everyone

Hopefully someone can give me some input on this problem

I have a secured network share which has folders arranged by user Identifiers. These folders consists of HTML files (and their content which is spread across sub folders). The content can be any static file (image,css) etc. All i know (through a config file) is the HTML file i need to load. Then i am blind to its content.

I cannot unfortunately import this folder/files under my web application due to certain security concerns.

Is there any way through my web application(Asp.net 2 and IIS 6) that i can load this file when the request comes through.



create database at network location


hiiii all.....

I am trying to create database to network location using DBCC Tracon and tracoff comman in sql..

I use following querey for creating database at network location

DBCC TraceOn(1807)
(NAME = a,
FILENAME = '\\mauleen\Public\TEST\a.mdf'
DBCC TraceOff(1807)

After commintin this sql command I am getting this error

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "\\mauleen\Public\TEST\a.mdf" failed with the operating system error 1265(The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


what is the way to creating database at network location???/ what should I do??

Website without any default membership Database. Is it possible?


I am in the initial stage of implementing a new webstie, which will use only twitter and facebook to login and use. So my approach is not use any Default memberhip database, just simple store the user data in my created "membership" database. I will set cookies and use sessions to restrict and grant access to various parts of the sites. So for example, the user creates an account and I set a cookie allowing him or her to traverse the site. And on each page request from the client browser check to see if my website cookie is there in the browser and if it has expired or not. Is this approach veasible? Thanks

Website Database Design




I hope this post is in the right section.


I am designing a new application and I am after some advice in regards to designing the database structure. The application is being built in ASP.NET 3.5, SQL SERVER 2005 Express and using the built in membership/profiling tables.

The website will allow a user to login and verify their account with a link in an email they will be sent. I have got this working fine using the createUserWizard control, but I also need them to select the type of membership they want when creating an account and I am a bit stumped at what stage this should be put in.

Do I put this in when creating the user before they verify their account? or do I have it listed when they first login to allow them to change their membership status from a free account to a paying account?

They will have four options list below:

  • free
  • bronze
  • silver
  • gold

The bronze, silver and gold accounts will be a monthly subscription which the user can signup to.


The second part to this post is the main bit in how do I design my database for monthly subscriptions? I was thinking something along the lines below.


MembershipSubscription Table:

UserID, SubscriptionID, StartDate, EndDate

12345, 1, 10-10-201

backup of database in public network system



i have to take backup of database in public network system..

that backup file should be in my system..i.e local network system.

share folder is not accessing..

so is there any other way?

Manage Database in Multi-User Environment



I am developing an application in VS 2005 and SQl Server 2005 Express which will be used by more than one user. Now, the problem is all user will work in offline situation i.e everybody will have their application along with the database(Database schema is same) in their system.They will update the master database once in a day and also update their local database once in a day.

How to approach this situation in SQL Server 2005 Express Edition.

Please Help. 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend