I try to access a same database using two different system,
a) a window based system and
b) a web based system.
Both are using VB.NET. But it seem like the there is either one of them can access the database at a time. When one of them running, the other system unable to access. The error is
"Cannot open user default database. Login failed. Login failed for user 'PY1234\Jen'."
PY1234/Jen is a window authoization.
I was using MS SQL Sever Express 2005 and the connection string are
<add name="WhyWhy.My.MySettings.BookShopConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\bin\Debug\BookShop.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
As a conclusion i need the database to be connected by multiuser at the same time
Any help is appreciated.