Hello,
I have developed a desktop app that will be used on a WIndows Server 2k3 server. I used VB.NET and SQLEXPRESS. I’m having a very odd problem with the User Instance setting.
Here is the connection string I am using:
“Data Source=.\SQLEXPRESS;” + “AttachDbFilename=” + DBPath + “;” + “Integrated Security=True;” + “Connect Timeout=30;” + “User Instance=True”
User Instance = true
The instance eats memory. I used sp_configure to set a memory limit, but there is no effect.
User INstance left out of the connection string
In my test environment, the service instance of SQLE us used. It’s memory, although ignoring the memory limit I set, eventually settles at a good place.
On the 2k3 server, I get the ‘an attempt to attach an auto-named database…’ error.
I’m looking for a way to limit the memory usage of User Instances or some possible reasons for the error I am getting on 2k3.
Your help is greatly appreciated.
take care,
lee
