SQL Express database disappears upon connection attempt from Visual Basic Express

I realize that the Visual Studio Express editions only allow one to use the wizards to connect to local data so I thought I'd try to code the connection to SQL Server 2005 Express. Using the first couple of chapters of ADO.net StepbyStep and a trusted connection string "Data Source=jeff;initial catalog=Adostepbystep;integrated security=SSPI;" I get an error that the login has failed. What's worse is that every time there is an unsuccessful login, the original database disappears from SQL express. The only thing that remains is the database name -all the associated tables, views, etc are gone! Is there an online guide or book I can purchase to learn how to properly connect VB 2005 express to SQL server express databases. I will eventually purchase the Professional software products but have to wait for FY 07 - can anyone please help? Thanks
DOHMHAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

imran_fastCommented:
Check this site
www.connectionstring.com

also try to use this connectionstring
connection string
<add key="ConnectionString" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Adostepbystep;Data Source=Jeff;U=xxx;P=xxx" />
0
imran_fastCommented:
hi do you still need assistance
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.