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.BookShopConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\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 timeAny help is appreciated.
An example of a simple connection string to connect to an SQL Server should look like this:
"Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Integrated Security=True"
connectionString = "Data Source=.\SQLEXPRESS;Initial Catalog=BookShop;Integrated Security=True"