Concurrent Users...URGENT!!

Jul 20, 2000

I need to know how many concurrent users are allowed to access the database at any point of time.Will it depend on the type of licence?Where do we set this parameter.Some users are complaining 'time out' problem.Thanks for any help!

View 1 Replies


ADVERTISEMENT

Concurrent Users

Dec 16, 2005

Hi,Is it possible to have many different clients conncecting to a web basedserver all using, simultaneously, the same DSN-less connection string heldin a server side include file?Many thanksRay Allison

View 2 Replies View Related

Control Concurrent Users?

Aug 24, 2006

    is it possible to limit the concurrent users in SQL connection string? Now, i m using .net 2003.regards,

View 3 Replies View Related

MS Access Concurrent Users

Nov 7, 2000

Hi,

Does anyone know is MS Access has any limited no of users, or how many concurrent users MS Access has?

Thanks

View 2 Replies View Related

Number Of Concurrent Users

Apr 13, 2006

Hello,

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.

View 3 Replies View Related

Web Synchonization Performance && Concurrent Users

May 24, 2006

Hi

I need some rough figures for replication performance. Can anyone give an idea of the number of concurrent subscribers a single IIS server can safely handle before having to move to load balancing with multiple IIS servers.

I would estimate the average daily row changes to be in the region of 500 to 2500 per subscriber.

Any ideas?

Many thanks

RL

View 1 Replies View Related

SQL Express, Windows XP Pro, && Concurrent Users

Aug 18, 2005

When running SQL Server Express on a Windows XP Pro OS, is there a limit to the number of concurrent users or connections to the database?

View 3 Replies View Related

How Many Concurrent Users With SQL Server 2000 Standard && 2GB ??

Dec 16, 2004

Standard costs 2000 euros approx (5CALs)
Enterprise costs 40000 euros apprx

Standard only supports 2GB or RAM
How many concurrent users do you think standard edtion can handle in a Dual Xeon 2.8 with 2GB ram ?

Enterprise is very expensive. sucks that standard can't handle more than 2GB Ram

View 1 Replies View Related

Reserving Concurrent Users In MSSQL 2000

May 12, 2003

Does anyone know how to reserve a number of concurrent user licenses /per server logins in MSSQL 2000? I have a situation where I have more users than I have licenses for an enterprise SQL application and would like to make sure that a certain group of users always has access to the system. Individuals who only need inquiry access should only be allowed to login if there are licences available beyond the core group of users. Any Ideas? Thanks.

View 2 Replies View Related

Error 500, Maximum Concurrent Users Have Reached

Jul 20, 2005

We are running three web sites in a clustered environmentWLBS. The web servers are connected to a Database Serverrunning MS SQL server enterprise edition licensed as perCPU license. The Windows 2000 Advanced Server Licensingmode on all the servers is per SEAT license.Our customers are accessing our web servers and after sometime getting error 500, Maximum concurrent users havereached.We have been told by our software provider that theconnection problem lies with the ADO components whichcommunicating with the SQL server.We have been turning round and round, without any luck.Your help will be highly appreciated.Thanks and best regardsDaveLearning is a Never Ending process*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

SSRS 2005 && Number Of Concurrent Users

Jun 22, 2007

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

View 2 Replies View Related

Data Read / Write Problem With Concurrent Users On With Dll

Feb 6, 2007

Hi,I have a web app, that runs fine, except for one particular section that uses a class called by an event in the code behind. The class resides as a dll in the bin folder. We had no problems during testing, when only one user was running this dll. Problems soon occurred when multiple users tried running it. Here's the error & stack: 06/02/2007 09:25:26 ==> cburns ==> There is already an open DataReader associated with this Command which must be closed first.   at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)   at System.Data.SqlClient.SqlCommand.ExecuteReader()   at ESP.Validator.Data.DatabaseEvents.DatabaseEventManager.Read(IEventable eventObject, Int16 eventType, DateTime earliestDate, DateTime latestDate) in C:My PathValidatorValidator.NETDataDatabaseEventsDatabaseEventManager.cs:line 92   at ESP.Validator.Data.Translink.CATCard.GetDespatchDate() in C:My PathProjectsValidatorValidator.NETDataTranslinkCATCard.cs:line 94   at ESP.Validator.Data.Translink.ExistingSchemeEntitlement.ReadCards() in C:My PathProjectsValidatorValidator.NETDataTranslinkExistingSchemeEntitlement.cs:line 215   at ESP.Validator.Data.Translink.ExistingSchemeEntitlement.Read() in C:My PathProjectsValidatorValidator.NETDataTranslinkExistingSchemeEntitlement.cs:line 147   at ESP.Validator.Data.Translink.TranslinkApplicant.ReadEntitlements() in C:My PathProjectsValidatorValidator.NETDataTranslinkTranslinkApplicant.cs:line 369   at ESP.Validator.Data.Translink.TranslinkApplicant.Read() in C:My PathProjectsValidatorValidator.NETDataTranslinkTranslinkApplicant.cs:line 353   at ESP.Validator.Data.Translink.PrePrintedLetter.Read() in C:My PathProjectsValidatorValidator.NETDataTranslinkPrePrintedLetter.cs:line 282   at ESP.Validator.ValidationProcessor.Read(ValidationSubject subject) in C:My PathProjectsValidatorValidator.NETValidationProcessor.cs:line 82   at clear_applications_scan_applications.ProcessValidation() It seems the data reader is getting reused. We have ensured after each read the reader is closed. Though all users are using the same connection string. Could it be a connection pool problem, with the connection being overwritten during execution? Should i edit it according to the users logon?I am really at a loss for ideas, and I don't mind admitting I am a bit out of my depth with this one!! Any ideas/suggestions would be greatly appreciated. Thanks 

View 1 Replies View Related

SQL Server 2014 :: Calculating Concurrent Users In A Database?

Feb 2, 2015

I am researching this and playing with using the syss.sysprocesses view and counting the dbid column. I would most likely want to store this information in a table with a date/time stamp because we really want to track our concurrent users during the day for awhile. Do you have any neat tricks in getting this done? Is there a DMV or Information_Schema view that could be used to accomplish this task? I found the following code on the internet:

SELECT DB_NAME(dbid) AS DBName,
COUNT(dbid) AS NumberOfConnections,
loginame AS LoginName,
nt_domain AS NT_Domain,
nt_username AS NT_UserName,
hostname AS HostName
FROM sys.sysprocesses

[Code] ....

View 1 Replies View Related

Urgent Regarding Users And Objects

Apr 12, 2001

i need to change the object owner from actuate to dbo

i wrote this script which will give me an execute process which i just need to run on query analyser it works fine for object owner change from dbo to new user but gives an error saying the object does not exist when i want to change it from user actuate to dbo...can some one correct me in this regard..here is the script.


Select "Exec sp_changeobjectowner", + name + ",dbo"
From sysobjects
Where type = "P" and
uid = 6 order by name

uid i found from sysusers table

it gives me some thing like this

Result : Exec sp_changeobjectowner MonthlyPerformanceSummary_Occupancy,dbo

This works the other way around

Exec sp_changeobjectowner MonthlyPerformanceSummary_Occupancy,kavitha

error: object does not exist


And the other issue is i have certain stored procedures for which i need to give permission exec for a specific user, i did create the user...what shold i do to grant exec privilage to this user..for all the stored procedures at a time finding the stored procedure name.

its like this the name always starts with sp_actuate...does this help in finding the stored procedure and then granting the exec privilage.

Thanks a lot in advance.


Kavitha

View 1 Replies View Related

Permissions To Users (Urgent Please Help)

Aug 14, 2001

Hi ,
I have a bunch of Users about 150 of them. I think they can't even run a SELECT .

When they try to run a select they get error messages :

"SELECT permission denied on object 'Object name', database 'Db_name', owner 'dbo'."

I have check out every thing !! All these Users are the members of public role on the database !!

They work fine on other Db's with the same settings !!

Not Sure what to do

PLEASE HELPP !!!

View 1 Replies View Related

Database Users...URGENT!!

Jun 15, 2000

I restored a database from one full backup.The users are missing now in the new databse.When I try to create the same users again it says that they are already existing!Please help what shall I do to restore/recreate the users?Do I need to do anything with the Master?

View 4 Replies View Related

Users & Login After Restore Of DB--URGENT!!

Jul 22, 2002

I made a backup of a production database and copied that backup over to a development server and restored the database. Now I have users saying that the application is failing on development. I have users that have NT authentication and some with SQL authentication.

What is the best way to get everything to sync up again?????

View 1 Replies View Related

Get @@trancount For All Users/ Connections URGENT

Sep 26, 2007

Hi all,

Is there any way to get the @@trancount for a connection from outside the connection?

The reason i'm asking is that a customer just lost a days work, and there is nothing in any table from a certain time onward. One theoy is that a backup was restored, but we checked and that is not the case.

So another theory is that a certain sproc began a transaction, but never finished because of an error. (We had some strange timeouts as well, so this is quite plausible.)

So the question: Can i get a list of current connections with their trancount? I could just run this to see if a certain connection would never get back to zero to check the transaction theory.
Thanks in advance,

Gert-Jan

View 7 Replies View Related

Moving Users And Permissions Between Servers--urgent

Nov 15, 2000

Is there any easy way to move users between SQL Servers for a particular database?
We have tests and development servers I would like to make sure the user lists are in sync for that db.

Thanks

View 1 Replies View Related

Reporting Services :: Adding (new) Child Domain Users To SSRS As System Users?

Jul 28, 2015

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?

View 5 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

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 Related

SQL Security :: Did Not Create Any New Users And There Are No Other Users Listed In Accounts Section

Sep 28, 2015

I 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 Related

Stored Procedure To Get All Users Or All Users Of A Specific Country

Apr 30, 2008

hi 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?

View 9 Replies View Related

25 Concurrent Connections

Mar 16, 2004

Hey,

MSDE 2000 allows 25 concurrent connections.

If these are all used up, and a 26th connection comes in. What happens? is the connection rejected? or does it sit in a queue, waiting to be given a connection?

Thanks,
-Ashleigh

View 2 Replies View Related

Ms-sql 7 Concurrent Connections

May 8, 2002

hi
i hv developed an application that runs on the local windows system and interfaces with the MSSQL 7.0 database server using ODBC DSN Connections. This application will be deployed over the LAN with over 100 users.

The MSSQL 7.0 server has only 5 user licenses that limits the concurrent usage to 5 users.

I need a solution whereby all users can access the SQL server database without adding more licenses

Is there a way out.

Please help

Regards
JD

View 2 Replies View Related

Concurrent Connections

Nov 30, 2007

Morning

I have been searching hi and low on the web to try and find out typically which version of sql server should be used based on the number of concurrent users you will be having.

I believe that Sql Server 2005 Express should only really be used for up to 10 concurrent users while I seem to remember that Standard edition supports up to approx. 33,000 connections.

Does anybody have this information to hand as I need to write a business case to justify the potential upgrade.

Many thanks

James

View 3 Replies View Related

Concurrent Run Of A Package

Feb 29, 2008

what happens when a package is run concurrently by 2 or more users. will the flow be in a queue, if not how is it going to be.

Thanks .

View 11 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

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

View 1 Replies View Related

MDSE Concurrent Connections.

Nov 6, 2003

hey all,

MSDE will only allow 5 concurrent connections to ...

a particular database?
a particular instance?
or a particular server?

ie. if i have one application running on one instance of MSDE with 5 connections and i have another application running on another instance of MSDE with 5 connections. would i actually have 10 connections? **both instances on the same machine...

can someone please clarify.

TIA

Chris

View 2 Replies View Related

Concurrent User Information

Nov 29, 2007

dear folks,

Does anyone know how can I get concurrent user information on Microsoft SQL Server 2000/2005….?

Thanks

cheers
sbahri

View 2 Replies View Related

Concurrent Stored Procs?

Mar 8, 2004

Hi all

I have a stored proc that runs every 4 hours - as a job. The stored proc takes about 3-5 minutes to comple, depending on number of records.
To do testing we run that stored proc manually, also.
Sometimes 2 or more people may run the same stored proc without knowing that the other person is running. This may create duplicates entries once processed.

What I want to know is, Is there a way to check if that stored procedure is currently running. If so it wont run second time concurrently.
(May be semapohres,mutex or something like that?)

(I am trying not to use a table to store whether the stored proc is running or not)


Thanks in advance.

Rochana

View 10 Replies View Related

Concurrent Queries Error

Jul 23, 2005

On my server running SQL Server 2000 (SP3). I frequently get thisinformational message in the Event Viewer log.17052 :This SQL Server has been optimized for 8 concurrent queries. This limit hasbeen exceeded by 2 queries and performance may be adversely affected.The application that I am running is a vendor application so I do not haveaccess to the code. I contacted the vendor, but they have never seen thisproblem and cannot recreate it. I checked the Microsoft Knowledge Base forhelp, but I came up empty. It seems like it should be a simpleconfiguration change.Any advice?Thanks,Jeff

View 1 Replies View Related

Technique For Concurrent Access?

Jul 20, 2005

I've been asked to turn our single-user database system into a multi-usersystem. At present, each user has a copy of the MSDE on their desktopmachine and uses our program to access it. In future, we would like tocentralise our MSDE instance and allow multiple users to access it. Inorder to facilitate this, we are going to only allow one user write accessto the system at a time (I know, its a kludge, but the system was neverdesigned for multiple users in the first place).I have a single, simple question this being the case: can I update a single"read-only" bit field in a table of the database in order to flag to otherusers that the system is in read-only mode in a way that avoids concurrencyissues? ie. does an "UPDATE" query lock and unlock? ( I suspect the answeris yes! ). If anyone else has experience of these things, I would alsoappreciate some tips on how best to proceed.ThanksRobin

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved