Simultaneous Users
Starting to get an error when we added another user to the system. It says something about the maximum nbr of 5 simultaneous users has been exceeded for the standard sql edition. We have 25 cals.
Lost in SQL land
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Number Of Simultaneous Users/connections On SQL Server
Hi, 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.
View Replies !
View Related
How Do I Scale A Database To Handle A Billion Simultaneous Users?
Hi everyone. I hope that my question isn't too broad, but here it goes... I am trying to figure out the best way to scale a SQL Server database so that it can handle a billion simultaneous users querying the same tables, and can easily scale to handle many billions of simultaneous users. The database must also have 999.99% availability. The number of licences and amount of hardware needed is not an issue. Thanks in advance.
View Replies !
View Related
Simultaneous Snapshots?
If multiple snapshots for the same report attempt to generate at the same second, is there something in place to prevent them from conflicting with each other? Our SSRS 2005 application will use a console app that we are writing to change the default parameters on each report and call the CreateReportHistorySnapshot method. This application will be multi-threaded, so there is a possibility that multiple versions of the same report with different parameters will attempt to run at the same time. We need to be sure that these snapshots will not conflict and return the appropriate SnapshotHistoryID for that report run. From looking at the History table in the ReportServer database it looks like there are uniqueIDs and other keys that would prevent duplicates, but what if the requests come in at the same time? Is SSRS 2005 smart enough to delay for a second so that there is not a duplicate? Since the way you reference these snapshots in your URL is with the Snapshot Time in UTC format, that only goes out to full seconds (2006-05-02T00:00:00). Sorry for the length, but I could not think of how to condense this. Thanks, Steve
View Replies !
View Related
Simultaneous DB Access
I have C# Express and the SQL Express Management Studio CTP installed. So far, I've been forced to disconnect from the server in one app to connect to it in the other. I understand there is something around a 4 connection limit in SQLServer Express, so I don't see the problem. During one of these episodes, SQL Mgmt Studio hung while opening DB properties, then the SQLServer service couldn't be stopped. Now the DB can't be opened even after a reboot. Help?
View Replies !
View Related
SSIS Simultaneous Connections
Using the Import/Export Wizard, it is easy to set up SSIS jobs to import multiple tables in one task. However, SSIS appears to grab a connection to the source database and the destination database for each table indicated in the task sometime prior to doing the actual data transfer. Even though the transfer seems to be done a few tables at a time, all the connections are held throughout the execution of the task. This has two effects: 1. The task may fail if the number of connections exceeds the limit of user connections set for the database 2. There is a severe impact on the other users of the databases (in my case, the source is a production system) Is there any way to control the number of simultaneous connections that SSIS data transfer packages initiate? I can, of course, define the package to have a small number of tables (thus limiting the connections), but in real life I need to transfer almost 700 tables, so limiting the number of tables per task to 20 or 25 produces an awkwardly large, and error prone, number of tasks. And since this definition must be done for multiple (not quite identical) databases, the extra effort of defining small collections of tables is signifcant.
View Replies !
View Related
Maximum Simultaneous Connections
Hi All, I have a Windows 2003 Server. Planning to use SQL Server to act as the main Database Server which needs to cater to over 100's of simultaneous connections. Can anyone share with me the default maximum simultaneous connections and the maximum allowed simultaneous connections for the following versions: - MSDE - 2000 - 2005 Express - 2005 Hope I can get more professional advice from you guys. Thanks.
View Replies !
View Related
How Are Simultaneous Queries Handled?
Hi, I have an application resource that is accessible from multiple clients applications that all have access to a common SQL Server db. By this, I mean, multiple clients can potentially connect to this resource at any given time. I want to limit the usage of this resource to one client at a time and was thinking about simply using SQL to maintain the name of the client that currently has "control" of the resource. My question pertains to the case where two clients are executing a SQL query, simultaneously, to check whether someone has control of the resource or not. If two users were to simultaneously execute this query, do i have to lock the table in order to ensure that both users are not viewing data in an incorrect state? Or, does SQL Server ultimately execute the queries in a specific order? Meaning, the requests are simultaneous from a human standpoint but one request may have actually come in a millisecond before the other one and SQL server executes that query first, and then the second query. Is this how it works? Thanks, Paul
View Replies !
View Related
Prevent Simultaneous Package Executions
How can I prevent a package, or a section of a package, from being run more than once simultaneously? The package makes use of a staging database table, and if two copies of this package are run at the same time, there will be a race condition and possible corruption of the data in the database table. I have also noticed that the SSIS logging gets messed up and starts overwriting itself if I have more than one of these packages run at the same time. What I am thinking of should work the same way as a serializable transaction lock on a normal query, where one query has to wait if another query has a lock on the table. I don't want the package to throw an error, I want it to wait until the other one is done. I have been trying to use transactions in a test SSIS package, but they are not quite doing what I want them to do. I put various SSIS steps in a sequence container and require a serializable transaction. I have also tried putting the transaction at the package level, but that is not preventing simultaneous package runs. Is there a built-in way to do this that is easy to implement? Otherwise, what I could do is insert a flag into the database indicating that a package is running, then make sure to reset the flag on any error or on completion. It seems like this alternate method could be error-prone though. I am using SP2.
View Replies !
View Related
Simultaneous Entry In Both Master & Detail
Hi, can anyone help me? I want to know whether is it possible to insert records simultaneously in both master & detail tables? For elaboration, say there is a master table contains (orderid,orderdate,amount) and details table contains (orderid, productid,qty,price). 1 record of master table associated with n records of details table. Can it be possible to insert both the 1 record at master table with n records in details table in a single sql statement?
View Replies !
View Related
Inserting Simultaneous Tables Using Stored Procedure
I am trying to insert into two tables simultaneously from a formview. I read a few posts regarding this, and that is how I've gotten this far. But VWD 2005 won't let me save the following stored procedure. The error I get says “Incorrect syntax near ‘@WIP’. Must declare the scalar variable “@ECReason� and “@WIP�.� I'm probably doing something stupid, but hopefully someone else will be able to save me the days of frustration in finding it. Thanks, the tables and procedures are below. I made up the two tables just for testing, they are: tbltest ECID – int (PK)
View Replies !
View Related
Simultaneous Execution Of The Same SSIS Package From Code
Hello I am trying to call the same package with different starting parameters using asynchronous method calls. My code is namespace ReconHost { public partial class HostContainer : Form { public delegate void InvokePackageHandler( Microsoft.SqlServer.Dts.Runtime.Application app, int var ); Microsoft.SqlServer.Dts.Runtime.Application app; public HostContainer() { InitializeComponent(); for (int i = 0; i < 2; i++) { app = new Microsoft.SqlServer.Dts.Runtime.Application(); InvokePackageHandler asyncInvokePackageHandler = InvokePackage; asyncInvokePackageHandler.BeginInvoke(app, i, null, null); } } public void InvokePackage(Microsoft.SqlServer.Dts.Runtime.Application app, int var) { Package pkg = app.LoadPackage(@"c:GRSGRSGRSTest_Async.dtsx", null); pkg.Variables["intVar"].Value = var; pkg.Execute(); pkg = null; } } } If I set the for loop to loop just once, the package is executed fine. Any more than once and only one instance of the package is executed. Does anyone know what I am doing wrong? I know it is possible to execute the two package instances simultaneously because you can use DTexecUI.exe on two clients to do this. Thanks in advance Tomo
View Replies !
View Related
SQL Express, Operating Systems, Simultaneous Connections
I was going over this article , and was intrigued by this statement "If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server 2005 Express." What are simultaneous connections? Is this related to Max worker threads defined as 255 on other editions? How does underlying OS impose how many connections can be done to SQL server. And finally how many simultaneous connections can be done in Windows Server 2003?
View Replies !
View Related
HELP: Strange Blocking Performance Problem With Simultaneous Queries
Hello everyone, I am hoping someone can help me with this problem. Iwill say up front that I am not a SQL Server DBA, I am a developer. Ihave an application that sends about 25 simultaneous queries to a SQLServer 2000 Standard Edition SP4 running on Windows 2000 Server with2.5 GB of memory. About 11 of these queries are over views (all overthe same table) and these queries are all done from JDBC but I am notsure that matters. Anyway, initially I had no problem with thesequeries on the tables and the views with about 4 years of information(I don't know how many rows off hand). Then we changed the tables toreplicated tables from another server and that increased the amount ofdata to 15 years worth and also required a simple inner join on 2columns to another table for those views.Now here is the issue. After times of inactivity or other times duringthe day with enough time between my test query run I get what lookslike blocking behavior on the queries to the views (remember these allgo to the same tables). I run my 25 queries and the 11 view queriesall take about 120 seconds each to return (they all are withinmilliseconds of each other like they all sat there and then werereleased for processing at the same time). The rest of the queries arefine. Now if I turn around and immediately run the 25 queries again,they all come back in a few seconds which is the normal amount of time.Also, if I run a query on one of views first (just one) and then runthe 25 queries they all come back in a few seconds as well.This tells me that some caching must be involved since the times are sodifferent between identical queries but I would expect that one of thequeries would cache and thus take longer but the other 10 would befast, not all block for 2 minutes. What is more puzzling is that thisbehavior didn't occur before where now the only differences are:1) 3 times more data (but that shouldn't cause a difference from 3seconds to 120 and all tables have been through the index wizard with aSQL trace file to recommend indexes)2) There is now a join between 2 tables where there wasn't before3) The tables are replicated throughout the day.I would appreciate any insight into this problem as 120 seconds is waytoo long to wait. Thanks in Advance.Chris
View Replies !
View Related
SQL Server Express, Simultaneous ,Multiple Application Access?
Hi Everyone, I have a software solution that consists of two separate applications that share a SQL Server Express database on a single computer. Everything is working great, except when both of the applications want to access the database at the same time. All I can find is information on configuring multi-user access in a distributed system. I'd appreciate any information on configuring multi-application access on a single computer. Thanks, Mike
View Replies !
View Related
Store Procedure LOCK. How To Solve The Problem Of Simultaneous Call?
Hello, I have one store procedure that writes something data to one physical sql table 'MyTable' and on beginning I first call:DELETE FROM MyTableProcedure returns at the end data from 'MyTable' as on SELECT. PROBLEM:I started SQL Manager on my Laptop and on Computer near me and all pointed to same database (on Server) and I run that procedure simultaneously on Laptop and Computer at the same time (two hands on F5 button on these computers). Occasionally when clicking with both hands at the same time I got no records at the end of execution (on both computers), otherwise I got the results.WHAT I THINK IS PROBLEM:Somhow one SP start working and it did not come to the end and another computer called this SP and execute first command (DELETE FROM MyTable) and I got empty records at the end..WHAT I NEED:I need to prevent this situation to get empty records. All computers must get these records always. How I can use some sort of LOCKs to do this?Or to do that on C# application level using LOCK command? Thanks in advanceAleksandar
View Replies !
View Related
Stored Procedure To Get All Users Or All Users Of A Specific Country
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 Replies !
View Related
Db Users Mix Up
Hello: I am having a problem understanding the db users. I am working on a DNN site, and having troubles with db users permissions. I want to know what is the DBO? I have a user in my database, that is assigned "public". In my application usually, what should i do: 1- Login with the public user, create tables, views, sp, add data ... 2- Use the dbo always? In my application, I will be using the public user in the connections string. Can you help please.
View Replies !
View Related
SQL 7 Users
Hiya, I need to get a copy of the users table from the master DB to another machine I have. This is to include permissions / passwords etc anyway this can be done? Cheers!
View Replies !
View Related
Dbo Cannot Add Users In SQL DB
I'm using SQL 2000 and I'm the database owner. I have been running tests with stored procedures to add logins, revoke logins, add db access, revoke db access etc. Now I can't seem to add users to the database. I've tried using 'dbo' and 'domainmy_username' but I'm denied permission to run any stored procedures to try and add myself to the db_accessadmin or sysadmin roles. I've tried the New Database User dialog and choose <new> under login name. I browse for the user name on my domain, click OK, and I get the message 'You must be logged in as 'sa' or a member of sysadmin or securityadmin to perform this operation.' I thought the dbo always had full permissions on his database. This doesn't make sense to me. :confused: The only thing I can figure is my permissions have been revoked on the master db. Can anyone help?
View Replies !
View Related
SQL 7 Users
I have moved several SQL 7 databases from one server to another. The databases are attached, and I can see all the tables,etc. However, I can only see 1 user, that being dbo, therefore users cannot log into the db. HELP
View Replies !
View Related
No Of Users
Hi, I am using sql server express edition. I have centralised database running in windows XP home edtion version. I can connect only 5 clinet computers at a time to the main database. I need to connect 8 clients to the main database. Each client is running with windows xp home edition. Thanks in advance Anil
View Replies !
View Related
Users !!
hi can you tell me how to creat users in MS SQL Server 2005 ?? i tried but i cannot.. my server name is : TOOLSBOXSQLEXPRESS can you guide me to lesson or book talking about how to creat users ?? and can you guide me to book talking about how to creat users and roles ... etc thank you
View Replies !
View Related
Users
My database is being moved from SQL 2000 to SQL 2005. Is there a way to copy a User from the old database to the new one, call it a different name and let it have all the same rights as the old one.
View Replies !
View Related
Different SQL Server Users On ASP.Net
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
View Replies !
View Related
.NET Membership And SQL Users (not Sa/dbo)
I recently moved my .NET project out to production, the server is Windows 2003 running SQL 2005. My developement server was a Windows XP running SQL 2005. Here is my issue. Under development I created a specific user to log in as, created a role and specified exactly what application specific stored procedures etc. that user was allowed access to. Everything worked fine. Backing that database up and restoring it to the new server, when I attempt to log in as the user (and yes I re-created the login, with the user, just as I did on the development server), I get this error... EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'MoldKit', schema 'dbo'. So I attempt to login as SA, and everything works... so I assign the db_owner role to my user and login, everything works... problem being they shouldn't be db_owner. And they're most definitely not assigned this role on development. I even went so far as to delete the database, and recreate it from scratch using the aspnet_regsql.exe and I get the same error. Anyone have any idea why this is happening, or the proper roles I need to assign so the user isn't a dbo, but can still call all the required aspnet procedures. Or could this be some other issue caused by 2003? I've seen this error in a lot of posts, but never once saw a definiative answer to what causes it and and what the fix is.
View Replies !
View Related
SQL Server And Users
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
View Replies !
View Related
Users Question
Hi All, Probably this is an easy question to many of you, but I'm not quite sure. I have imported a database to my local, and there are a lot of (system) users attached to it. My goal is to update the password for the system user. I have researched for a while, I find a way to update the Master.. sysxlogin. So I wonder it is ALWAYS the users who have added to individul databases, their username will always in the Master..sysxlogin table? As I have imported the database from my client, so the username are not in the sysxlogin table. Thank you for your help.
View Replies !
View Related
SA Can Not Create Users
Even Sa account is in sysadmin role it is not able to create users usingenterprise managerAlso not able to create users from local admin who is alo on sysadmin roleBut using query analyzer we can create usersIs some thing wrong with master databaseSanjit
View Replies !
View Related
Concurrent Users
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 Replies !
View Related
Managing Users
Hello,Has anyone ever come across a reason why someone would manually create auser table incl. permission flags and not use the inbuilt user/rolesprovided by that database? The only reason that stands out for me is tomake the database that bit more portable?Thanks,Craig.
View Replies !
View Related
Backup Users
I am currently using the BACKUP DATABASE method to backup my database.Everything works fine, except for users. I created various users withsp_addlogin to access this database and they are located in the xloginstable. The problem is for example, if I backup, remove some users anddo a restore, i won't have them back because i just backup thedatabase.So the question is, how can I backup specific users and restore them ?Do I have to do it manually ? It seems I can't alter the xlogin tableso I'm pretty confused.
View Replies !
View Related
How Can I Know How Many USERS Are In Agroup.
HI allI just wana know that is there is any TSQL Statement which will give methe list of all user groups,names of user in each group and thierPermssions in any database/server.Actually I have to create a report in wich i have to show that howmany groups we have any whi is the member of wich group with suchpermissions.I ckeck through Interprise Manager but i guess it will takealot of time to note every user group then users and their permissions.So please any HELP will be greatly Appriciated.ThanksArman
View Replies !
View Related
Total SQL Users?
I am writing a paper for a computer programming college class and Ineed to know how many companies worldwide use SQL server? How manyservers does this constitute? At what rate is SQL use growing? If youcan't provide close to exact numbers, could you point me to a sourcewhere I could find them?
View Replies !
View Related
View && SP's For Just A Few Users
I have read about Views vs. SP's and I have question to which I could notreadily find the answer.The database I'm creating will only have 1 user from the start and up tothree maximum. Is there any reason that I shouldn't just use SP's foreverything or might there be an advantage to using views.This is not a heavy I/O project either and most of the day to day use willbe record manipulation and reference rather than new record entry.Thanks-Jake
View Replies !
View Related
|
TRACKER
