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
<connectionStrings>
<add name="WhyWhy.My.MySettings.BookShopConnectionStrin g" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\bin\Debug\BookShop.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
As a conclusion i need the database to be connected by multiuser at the same time
Any help is appreciated.
