Hello,
I have developed a desktop application to be used on Windows Server 2003. It is using SQL Express for the database. I am using the following connection string:
"Data Source=.\SQLEXPRESS;" + "AttachDbFilename=" + DBPath + ";" + "Integrated
Security=True;" + "Connect Timeout=30;" + "User Instance=True"
Here are the results I am getting:
On my development server, the SQL instance's memory keeps climbing. I used sp_configure to limit the memory, but to no effect.
Now. I went back and removed 'User instance = True', and the DB connects to the service instance of SQLE. The memory, although ignoring the memory limitation set with sp_configure is ignored, does level out at an acceptable level.
Once I move it onto the 2k3 server, I get the same results with 'User Instance = true', and with '= false', I get the 'an attempt to attach an auto-named database' error.
I would like to use the '= true' option, but I have to figure out how to limit the memory growth. However, if necessary, I can use the '=false' option, but I'm having the problem of getting the DB to work on the 2k3 server.
Any help would be appreciated.
take care, lee