Hello, I want to know whats the difference between managing the databse with management studio or directly putting the MDF file on the app_data folder in visual studio 2005. I tried to put one MDF file and tells me that users instances are not enabled.
If I put an mdf file onto my project it will be part of the installer and it will automatically install my database on the remote server If not why its useful if I can go to server explorer and see all my databases, tables and so on.
Tks
What are user instances?
Hot Topic
- Failing to install SQL2005 Express and Standard Edition on Via Eden CPU.
- Temporary table vs. Table Valued function
- SSIS Requests...
- Displaying AS hierarchy in ASP.Net
- How can I script object data in SMO?
- SQL Server 2000 and SQL Server 2005 have the different behavior
- Create DBF file from ADO.Net
- DBCC CHECKDB WITH NO_INFOMSGS Error
- Remove rtf code from text
- Scheduled Job Not Working
SQL Server
- SQL 2005 DB design
- sql express on server 2003 and vb6 program
- How do you add MSXML6.DLL in GAC?
- Table default value and data inserts using windows forms: It does not insert default value.
- Troubbles with SSIS
- Transaction context in use by another session.
- Two Phase Commit
- Report design scenario
- Error returning OLAP data in RS 2005
- User-Defined Datatypes based on abstract classes
What are user instances?
RSidhu
In a nutshell, "user instance" allows a non-admin user to start an application which start a sql server instance.
Here are some explanations from BOL:
User Instance is a feature that enables non-administrators to run a local version of SQL Server in their own account. With user instances, non-administrators have database owner privileges over the instance running in their own account.
The user instance, also known as a child or client instance, is an instance of SQL Server that is generated by the parent instance (the primary instance running as a service, such as SQLExpress) on behalf of a user. The user instance runs as a user process under the security context of that user. The user instance is isolated from the parent instance and any other user instances running on the machine. The user instance feature is also referred to as “Run As Normal User” (RANU).
Why User Instance
Some of the reasons that outline the benefits of using user instance model are listed below:
The primary goal of the User Instance model is to provide isolation between non-administrator users of SQL Server, thereby allowing users to attach arbitrary databases without the risk of compromising another user. This isolation is achieved by generating a separate instance of SQL Server for each user.
Besides isolation, the goal of SQL Server Express is also ease of use for non-administrator users. Many Windows users have accounts with administrative privileges. Unfortunately, running as an Administrator makes it easy for malicious software to take over a user's computer. However, malicious software run by non-administrator users cannot make system-wide changes and therefore can do only limited damage.
db_guy