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

<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.

[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