Database login failed

[kwankwan08]

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

<connectionStri ngs>
<add name="WhyWhy.My .MySettings.Boo kShopConnection String" connectionStrin g="Data Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\bin\Deb ug\BookShop.mdf ;Integrated Security=True;C onnect Timeout=30;User Instance=True"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

As a conclusion i need the database to be connected by multiuser at the same time
Any help is appreciated.

[Atli]

Hi.

I've moved this thread over to the Microsoft SQL Server forum.
Please try to post your questions in the appropriate forums.

Thanks.
MODERATOR

[ck9663]

You will need to allow multiple concurrent connection on your server. I'm not sure if SQL Express allows that.

-- CK