How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!
SQL Server 2000 - MSDE 2000Is there a way to get the number of current users logged into a SQL 2000 Server (also MSDE)? Cant be distinct users as most users are logged into the database using the same login.-- Tim Morrison--------------------------------------------------------------------------------Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.http://www.vehiclewebstudio.com
View 4 Replies View RelatedHi,
could somebody please let me know what is the maximum number of simultaneous users/connection per single SQL Server 7.0 box? Licenses are not the issue here, rather the number of physical connections supported before another server needs to be purchased.
Another variation of this question would be what's the highest number of databases that 7can be created on SQL 7.0 server and what is the highest number of physical connections supported per database? Again, licenses are not the issue. Thanks a lot in advance.
Does SQL Server 2005 Workgroup Edition have a limit to the number of user logins I can make?
View 1 Replies View RelatedHow does one Determine the number of Active users logged into a SQL Server Database?
I want to use the info to control concurrent licensing for my Application
I have a db to manage the creation of invoice number designed for a web application.
My problem is how to manage the concurrency when the users need to create an invoice number.
Our development team wanted to create a database user for each application user in the application and use these for granular data access control, which at first, sounded like a good idea but our initial testing ran into some interesting results.
Our target user base was about 15 million users with an estimated 1% concurrency rate, and finding no MS documentation on an upper limit to the number of users a database can have we began some load testing to see how the database performed. In the hundreds of thousands of users range our test database had a hard time performing well under light loads (even without any concurrent connections).
When we purged the users and reverted back to just a handful of service accounts, performance went back to "normal" under the same loads. I began to wonder if this is a situation where throwing more hardware at the problem would overcome the issue or if there is a practical upper limit to the number of users a single database can handle well.
(There were of course other cons to this arrangement and I certainly was never going to expand the users tree in the object explorer for a database like this, but we thought it a solution worth investigating.)
What is the largest number of users any of you have had in a single database?
Quick question, is there a limitation on the number of users that can get into SQL server at one time? Say 1500 or 2000 users? If not, I wonder how many users can actually cause the performance of the server to have a significant drop.
Thanks
SHK
when i see the number of users on my local connection. It says 4 and another DB says 12. But nobody is connected to these DB but me. Why is it showing 4 and 12?
View 1 Replies View RelatedHello,
There was a 5 concurrent user limitation in MSDE (the version prior to SQL Express). Does that same limitation exist with SQL Express 2005?
Thanks.
Hi,
Can somebody let me know how many (maxi) no of users can be created to deal with MSDERelA ?
With kind regards,
Ashfaque
I need a small SQL server for up to 10 users. If I understand the EULAs and FAQs correctly, there is no limit on the number of users imposed by the SQL Server 2005 Express license. If so, then the number of users is only limited by the OS's license so all I need is SQL Server 2005 Express (free), Windows XP Pro (10 users limit) and no CALs for either Windows or SQL Server.
I'd be thankful if someone could verify this.
I'm looking to migrate a number of sql users to windows authentication, so I want a list of each login and for each login a list of all their roles. My plan is to write 2 WHILE loops that will go through each login and for each login the list of roles.The first Row_Number is not returning the order that I want, I was expecting results like this:
1 Aaron ...... 1 db_reader
1 Aaron ...... 2 db_writer
2 Ben ....... 1 db_reader
The first row_number used doesn't seem to use the partition.The second seems to work fine.I know I can break this up into 2 queries but I want to understand where this is going wrong.
Code used:
SELECT
ROW_NUMBER() OVER(PARTITION BY sp.Name ORDER BY sp.name asc) as UserRowNo
, convert(char(45),sp.name) as srvLogin
, 'WIN' + convert(char(45),sp.name) AS WinLogin
[code].....
Hi,
In one CPU installation of SSRS 2005, are there any restriction on number of users accessing the same concurrently?
Please let me know.
Regards,
TNR
I have table A(year int, month int, user varchar(20)), and I am trying to write a view that would show number of distinct users in the last 3 months, last 6 months, last 9 months and last 12 months(all from the most recent year/month) in following format:
3 months 6 months 9 months 12 months
number of distinct users x y z w
Is there any maximum cap on the number of users that could be created in a given database of MS-SQL Server?
View 4 Replies View Related
Hi all,
I want to raise one question which might not relevant to current discussion.
Prob:-- I have some SSRS reports. I want to know for a given time period
1. How many people hit the report.
2. Who are the users hit the report in that time interval.
Is there any query to get that data?
Or,
should I go somewhere to see the data?
NB:- There is not any table in the application which is storing the data
We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.
I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.
Is there any additional step I should/could take to get this active?
I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!
View 6 Replies View RelatedI am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.
View 2 Replies View Relatedhi alli've got two tables called "webusers" (id, name, fk_country) and "countries" (id, name)
at the meantime, i've a search-page where i can fill a form to search users. in the dropdown to select the country i included an option which is called "all countries".
now the problem is: how can i make a stored procedure that makes a restriction to the fk_country depending on the submitted fk_country parameter?it should be something like
SELECT * FROM webusers(if @fk_country > 0, which is the value for "all countries"){ WHERE fk_country = @fk_country}
who has an idea how to solve this problem?
Hi Team,
In SQL Enterprise Manager, when we expand "Database -->Users", we see the
users there. When we expand "Security --> logins" we see the same users there.
Can you differentiate these two.
Thanks
Santhosh
I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.
can this be done in SQL and if so how?
We are using Navision with SQL server 2003.
What kind of methods is there out there to reduce hwo often this happens?
Hello,
I am new to this forum, and ASP .NET 2.0. I watched the tutorial on how to use the login control with SQL Server 2005 Express, and was able to duplicate it easily. However, I tried to see if I could do the same thing with SQL Server 2005 that is hosted by my hosting company, and I was unable to get it to work. I am using Visual Web Developer 2005 Express, at least until I get VS 2005 in a few weeks, and I am able to connect to the SQL Server. I tried following the tutorial on this site step by step, and some of the things they used to set it up I could not use. In the tutorial VWD creates the table automatically. If I use the hosted database, do I need to create the table, or is there a way for VWD to do it that I haven't figured out yet.
Any help and additional information that I might need to know would be great.
Thank you for your help.
Ben
Hi there,
When conecting to a MS SQL Server 2005, I could define in my connection string Windows Authentication.
What account it will be used? The one used by IIS (I still don't know the user ASP.net runs, if it is independent of IIS or not)?
And if I whant that some aspx pages have diferente acess rights? I need to use SQL Server Authentication with diferent users created in MS SQL Server right?
In ASP.net, what is best practice: Have one SQL account, and make users access rights in Business Logic, or have different SQL Accounts por the diferent access rights I whant in every page?
Sorry if this are basic questions, but In the find's I made, I saw very confusion ideas.
Thanks in advance, and sorry my english.
Alberto Ferreira
I am looking for the stored proceedure to get all of the users and their rights on a server. I have tried sp_helpuser and this isn't giving me all of the users on the server, just per database, it doesn't tell me the username if the user isn't assigned to a database (for instance SA) I don't think. Also, sp_helprotect gives me way too much data. What I am looking for is a listing of all of the users on the server with their DB level permissions, e.g. datareader, datawriter, dbo. I need this to work on both SQL Server 2000 and 2005 and thus the desired use of a stored proceedure.
-Kyle
Hi All
IF some users are still connected to the database and I want to shutdown the server How can I disconnect them in order to shutdown.
Sincerely.
We are about to migrate SQL 7 databases from one SQL7 server to another SQL7 server, but we've run into an issue with transferring users/logins/passwords.
The problem is that one server is case-sensitive, and the other is not case-sensitive. This causes each server to encrypt passwords differently from the other.
Has anyone else experienced this before? Is there a workaround? Microsoft acknowledges this as an issue with SQL 7 (with case-sensitive to case-insensitive transfers), but offers no workaround.
Dan Tan
dan.tan@tekelec.com
www.Tekelec.com
hi everybody,
i ave transfered all the users from one of my sql server to another sql server but what the problem is that all the users that are on new sql server having a NULL password.....
so that means that when u transfer users from one sql servers to another the passwords will be remain as null for all users......
or any sql server patch is required for that.....
thanks in adv.
How would one go about printing a list of all of the users of a specific database?
View 1 Replies View RelatedI am trying to create a sql script that will check the database instance for any new objects that are created in any database on my system. These objects I want to audit are users, tables, databases, stored procs, etc.. I also want the script to email me and write the information to a text log file. Thanks in advance for any help.
View 2 Replies View RelatedHi,
how can i get all users of Database? Not of the complete sql server?
Is there a sql statement?
Can i get the roles or properties of these users too?
Thanx a lot,
Crean