sql server msde: I had to reinstall sql 2005 server and express.etc

what services should I leave running so I can actually get the data itself.

when I tried to fill a dataset in .net 2 vb or preview in visual basic 2005
express database explorer, I get

---------------------------
Microsoft Visual Basic 2005 Express Edition
---------------------------
StringTmpDataSet.CodeTable.Fill,GetData () could not be previewed.

Failed to generate a user instance of SQL Server due to a failure in
starting the process for the user instance. The connection will be closed.
---------------------------
OK Help
---------------------------


I notice I no longer be able to find anything about attaching a user
database file in teh visual studio SQL express 2005

When you install Visual Studio, SQL Server 2005 Express Edition (SSEE) gets
installed on the development machine by default. When you test your
application on the development machine, the SQLEXPRESS instance is
invoked--the User Instance option tells the SQLClient provider and SQL
Server itself to clone all of the system databases (master, model, tempdb
etal.) along with the user database to the logged-on user's private area on
the hard drive. At debug time, this is your user area.
When you create and deploy an application that uses SSEE with the User
Instance connection string keyword, it assumes that SSEE is installed with a
SQLEXPRESS instance. This means that the target system must have an
adminstrator-installed instance of SSEE (usually SQLEXPRESS) installed
before the application is run.

I describe this in intimate detail in my book.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
[quoted text, click to view]