Solved

User instances

Posted on 2007-12-03
6
2,155 Views
Last Modified: 2008-02-01
I know that I need to enable user instances. I know what the code is. I have tried using sseutil from microsoft. Can't figure it out. Could someone walk me through a simple explanation on how to enter the
"C:\SSEUtil>sseutil -c Console mode. Type 'help' for more information. 1> sp_configure 'clr enabled','1' 2> go Command completed successfully. 1> reconfigure 2> go Command completed successfully.". I am assuming command prompt... but no matter how I input it nothing changes.

Stupid questions, I am sure... but I am stumped.
0
Comment
Question by:Jacksgate
  • 3
  • 3
6 Comments
 
LVL 19

Expert Comment

by:weellio
ID: 20400887
start - run - cmd
C:\SSEUtil>sseutil -c

then type help

FYI


http://msdn2.microsoft.com/en-us/library/bb264564.aspx#sqlexpuser_topic5
User Instance Limitations
The unique User Instance architecture introduces some functional limitations as follows:

Only local connections are allowed.
Replication does not work with user instances.
Distributed queries do not work to remote databases.
User instances only work in the Express Edition of SQL Server 2005.
Common Issues
The User Instance architecture sometimes leads to confusion when databases don't behave the way we are accustomed to. Most of these issues are related to the database files that get attached to the user instance and how they are handled. Following are the more common issues.

The user instance cannot attach the database because the user does not have the required permissions. The user instance executes in the context of the user who opened the connectionnot the normal SQL Server service account. The user who opened the user instance connection must have write permissions on the .mdf and .ldf files that are specified in the AttachDbFilename option of the connection string. One common issue occurs when working with the Visual Web Designer. The application connects to a user instance database from the Visual Studio integrated development environment (IDE) and then fails to connect when the database is opened by the Web page. When the ASP page opens the database it is generally running as ASPNET. If ASPNET does not have write permissions on the database files, the connection fails.
Another common issue is when you open a database file successfully when the database is attached to the SQL Server Express instance, but fails when you try to open it from the Visual Studio IDE. This might occur because the SQL Server Express instance is running as "NT AUTHORITY\NETWORK SERVICE," while the IDE is running as you. Therefore, the permissions may not work.

A variation of this issue is when the user that opens the user instance connection has read permissions on the database files but does not have write permissions. In this case, SQL Server attaches the database as a READ_ONLY database. If you get a message saying that the database is opened as read only, you need to change the permissions on the database file.
The other main issue with user instances occurs because SQL Server opens database files with exclusive access. This is necessary because SQL Server manages the locking of the database data in its memory. Thus, if more than one SQL Server instance has the same file open, there is the potential for data corruption. If two different user instances use the same database file, one instance must close the file before the other instance can open it. There are two common ways to close database files, as follows.
User instance databases have the Auto Close option set so that if there are no connections to a database for 8-10 minutes, the database shuts down and the file is closed. This happens automatically, but it can take a while, especially if connection pooling is enabled for your connections.
0
 
LVL 19

Expert Comment

by:weellio
ID: 20400917
what is it specifically you are trying to do?

start - run  - cmd
C:\SSEUtil>sseutil -c

then type

!list
go

this will give you a list of databases to do stuff with

!consolewnd
go

this will open a console window to use instead,... hit F5 if you don't want to click 'execute'
0
 

Author Comment

by:Jacksgate
ID: 20402257
Here is what happens.

I go to the c:\ sseutil>

I type in sseutil -c after the above command line.

I get the result  of "Generating user instances in SQL server is disabled. Use Sp_Configure 'user instances enabaled' to generate user instances"
and it goes back to the above command line.

Then I put in Sp_configure.....code....

And I get that SP_con... is not rcognized.

Still stumped

0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 19

Accepted Solution

by:
weellio earned 500 total points
ID: 20405290
once you start the sseutil you'll see the following if it starts to work

C:\stuff\>SSEUtil.exe -c
Console mode. Type 'help' for more information.
1>

apparently it is disabled for you.
hmm,. what version of SQL do you have? are you the administrator of the server?
0
 

Author Comment

by:Jacksgate
ID: 20405447
Here is what happened. When I installed the original instance of SQL2005 I selected enable user instances and also Add user to administrator role, apparently this created a conflict. I finished reinstalling SQl and enabled the settings for user instances. I appreciate all your help.
0
 

Author Comment

by:Jacksgate
ID: 20405468
Just to let you know... after doing this, your solution works perfectly. I guess the conflict extended to the sseutil function also.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now