Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2008
    Posts
    4

    Post Unanswered: 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:

    Code:
    "{"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.
    Last edited by dubeyparam; 01-05-09 at 04:02.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you using the express version of SQL Server?
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2008
    Posts
    4
    Hi georgev,

    I am not using Sql Express edition. I have already mentioned I am using SQL Server 2000 as backend.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    SQL Server 2000 comes in m any guises; express, developer, enterprise... Hence the need to clarify.
    George
    Home | Blog

  5. #5
    Join Date
    Sep 2008
    Posts
    4
    Do you have any idea what might be causing the problem?

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You may be in single user mode
    Code:
    ALTER DATABASE <your_database_name> SET MULTI_USER
    George
    Home | Blog

  7. #7
    Join Date
    Sep 2008
    Posts
    4
    Can you please tell me How can i check the mode? Is there any query available for that?

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    EXEC sp_dboption <your_database_name>, 'single user'
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •