How many open connections does SQL server 2005 express allow to .mdf file

Hi Guys, how many connections does sql 2005 express allow to .mdf file. I stumpled on info on a microsoft site (actually a forum post on msdn) that sql server express allows only a single connection to an .mdf file.

Iam intrested in this because i developed reporting services reports in BIS and iam having problems. If i run a report from report manager, i have to wait for close to 20 minutes before i can be able to run my asp.net application agian. Else if i insert data or retrieve data from my asp.net application, then i have to wait again for 20 minutes or more before i can be able to run my reports else i will get an error that a connection can not be made to the database or that the database is being used by another process.

So in all cases, i have to wait for 20--30 minutes before a connection can be made to the .mdf file. i.e after running a report or after inserting or retrieving data from the database through my asp.net application.

Iam using sql sever 2005 express with advanced services and visual web developer on windows server 2003.

Any ideas or help.

Hi Nick,

Sql Express Allows multiple connection to a mdf file. The important thing to note down is are you using different connection string and the limit on sql express is set to 1. coz if u will change the connectionstring it will try to create a new connection and in case if the limit is set to 1. you need to wait till the earlier connection is close or inactive.

I have developed a asp.net site hosted on server with Sql express MDF file and i am able to open page from different browser at the same time and can get different response at the same time.

Hope this will help

Satya

|||

Thankssatya_tanwar,

Yes with my application here i can open different pages or the same page in very many windows and from very many computers but problems crop up when i try to run reports hosted on a reporting services report server from report manager. If the application is open and i try to run my reports i get an error that the database is being used by another process. Likewise if i run my reports before running the application, they run correctly but then iam unable to run the application, it will also tell me the database is closed. My work around so far is to wait for close to 30 minutes for the connection to open it self with out my intervation but this is undesirable for the users.

Then most importantly from your replyt, please give more light on the use of different connection strings. I have a connection string in my web.config file of my asp.net application. Then when designing sql server reporting services reports in business interlligence development studio, your prompted to provide a connection string to the database file your attaching and you either type or paste it manually or you click edit and browse to location of your database. If you browse to the database, the connection string is build for you and this is the approach i take. so i woould imagine that the connection strings will be the same in the web.config and for my report datasource because the location of the database is the same.

I had not thought about this connection string issue but iam going to verify if they match. In the mean time though, give me your take from what i have explained. I badly deadly need to deploy sql server reporting services.

sql