ASP.Net Site not allowing multiple logins.
-
Hi Experts, I have a web site in ASP.Net with Sql Server 2000 as DB. My problem is that the web application is not allowing concurrent logins to it. Once a user logs into the site starts some process, the database get locked and other user can not get access to the site. For the first user it works fine but other concurrent connections it gives me following error message:
"{"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface..."I don't know whats the reason for this. I think I am missing some settings in my server. I have used following connection string"Data Source=MyServer; Initial Catalog=MyDb; User ID=un; Password=123456; MultipleActiveResultSets=True; pooling=true"Can anyone help me out. Its very urgent. __________________ Regards, Paramhans Dubey. -
Hi Experts, I have a web site in ASP.Net with Sql Server 2000 as DB. My problem is that the web application is not allowing concurrent logins to it. Once a user logs into the site starts some process, the database get locked and other user can not get access to the site. For the first user it works fine but other concurrent connections it gives me following error message:
"{"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface..."I don't know whats the reason for this. I think I am missing some settings in my server. I have used following connection string"Data Source=MyServer; Initial Catalog=MyDb; User ID=un; Password=123456; MultipleActiveResultSets=True; pooling=true"Can anyone help me out. Its very urgent. __________________ Regards, Paramhans Dubey.Check you code . Are you using
Conn.Dispose()any where of your application ?cheers, Abhijit
-
Check you code . Are you using
Conn.Dispose()any where of your application ?cheers, Abhijit
Hi Abhijit, Thanx For your reply. answer is No. I have not used Conn.dispose() anywhere in my code.
-
Hi Abhijit, Thanx For your reply. answer is No. I have not used Conn.dispose() anywhere in my code.
-
Hi Experts, I have a web site in ASP.Net with Sql Server 2000 as DB. My problem is that the web application is not allowing concurrent logins to it. Once a user logs into the site starts some process, the database get locked and other user can not get access to the site. For the first user it works fine but other concurrent connections it gives me following error message:
"{"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface..."I don't know whats the reason for this. I think I am missing some settings in my server. I have used following connection string"Data Source=MyServer; Initial Catalog=MyDb; User ID=un; Password=123456; MultipleActiveResultSets=True; pooling=true"Can anyone help me out. Its very urgent. __________________ Regards, Paramhans Dubey.Have you looked to see if anything is locked in your database after the first user has logged in?
-
Hi Experts, I have a web site in ASP.Net with Sql Server 2000 as DB. My problem is that the web application is not allowing concurrent logins to it. Once a user logs into the site starts some process, the database get locked and other user can not get access to the site. For the first user it works fine but other concurrent connections it gives me following error message:
"{"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface..."I don't know whats the reason for this. I think I am missing some settings in my server. I have used following connection string"Data Source=MyServer; Initial Catalog=MyDb; User ID=un; Password=123456; MultipleActiveResultSets=True; pooling=true"Can anyone help me out. Its very urgent. __________________ Regards, Paramhans Dubey. -
Are you able to connect to the DB server via Query analyzer or through remote desktop. Think you dont have rights to connect to the server.
Yes i am able to connect to database using query analyzer.
-
Yes i am able to connect to database using query analyzer.
Then the problem is in the transaction that you are using. Where is the transaction being controlled ? is it in the business layer or at the SQL level ? Have you closed all the transactions properly ? Have a look at the activity monitor, filter by the database and check.