Multiple User Logins??

Question

Multiple User Logins??

MBatesPTI

SSC Enthusiast

Points: 171
More actions
February 19, 2004 at 1:36 pm

#83833

I have a dynamic website that pulls the news stories from a SQL Server 2000 database which is on a seperate server. I am using a hosting service, so therefor I doubt all admistering options are left open for me. I am using ASP.net and an OLEDB connection.
My problem is, making sure that the user can always log in to the database.
Currently, I only have on user, when I am logged into the control panel or enterprise manager, and someone hits the site, they get an error saying couldn't log in.
I had figured I would be making one guest user account that the site would use for accessing the database for viewing. Another account would be the admin for updating.
How can I assure that the guest account can always log in even if 10 or so people are hitting the site at the EXACT same time?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

"Currently, I only have on user, when I am logged into the control panel or enterprise manager, and someone hits the site, they get an error saying couldn't log in."

What is the exact error message?

Lots of applications use generic login to access the database. Multiple connections will be established between the applications and databases if more than one users accessing application.

Is your database in single user mode? Check it in the options tab from database property using EM.

MBatesPTI SSC Enthusiast Points: 171 More actions · Answer 2

The exact exception message is "Cannot open database requested in login '<databasename>'.

Login fails."

<databasename> being the actual name

I'm gonna check on the single user mode, I can't get my EM to work with the database, and I don't think I can check that with the web based EM so I will ask the webhost.

MBatesPTI SSC Enthusiast Points: 171 More actions · Answer 3

Yes it was set in Single User mode

Problem is, I do not have the rights to change it myself, and the tech support people do not seem to understand my problem.

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Hello Techie.....

I need your help to fix an issue with an SQL Server database. The database is currently in SINGLE USER mode which only allows one connection at a time. We need to allow multiple users access to this database. As I don't have access to change the mode, can you please make the change for me?

If the tech doesn't know how to make the change...explain it to him/her.

-SQLBill