Hi all,
I hope I am on a suitable thread. Sorry if I'm not. I just need to know if I need a license in order to write a commercial application using Visual Studio 2005. And, if so, is this license necessary to me as a developer or to my customer that will purchase the application at the end?
And something more. ASP.NET runs on IIS, which is shipped with Windows Server, correct? So, once my customer purchases Windows, he doesn't anything more in order to run a ASP.NET application (which will finally access the SQL Server DBMS). Is this correct?
hello! i am getting the following error in the windows NT event viewer daily atleast twice or thrice... "The product Microsoft SQL Server 7.0 is out of licenses. Use License Manager from the Administrative Tools folder for more information on which users are out of compliance and how many licenses should be purchased. "
we have recently got an open license agreement also for sql server from microsoft.till now we were using a temporary license.how to apply the details in the certificate so that i don't get the error?
I have developed a system which has SQL server as a backend... Reading Microsofts Licensing required i m a bit puzzled if a CAL license is required for each user that is created on my system. i.e. If my system has 5 users, do i need 5 CAL licences.. however, in order to present the required data to these users i log to SQL server with the same single account.
Can you change your license setup if it was initially done by seat andyou want to change it to by processor? The server is already up andrunning in a production environment. If so how?
As I understand it, if I have a 4 CPU box and I buy 4 processor licenses for SQL Server 2005 Standard, I can run 16 instances of SQL Server on that box.
Now given a cluster set up for active/passive I understand that if I license the same way I can have 16 instances on one of the nodes of the cluster. In the event of a failure, the instances can fail over to the "passive" node and the licenses move with them.
So heres the question. Given my two node cluster, each node has 4 CPUs, if I have some of the resources on node 1, and others on node 2, so instances are running on node 1 and node 2, am I on the hook for 8 processor licenses?
I've just installed Workgroup Edition for the first time. I have copies on each of two servers, each ordered with five CALs.
My problem is that I don't know how to assign the licenses. I can't find anything in the documentation about it, nothing in the tools menus, and no reference to SQL Server in the Licensing application. The latter really looks like the right place, so if I had to guess, I'd think I've installed something incorrectly. Shouldn't SQL Server appear there as a product?
Of course, I'd also think this would be documented somewhere, but then it's probably one of those things that any idiot would know, so there's no need to explain it.
Once I get past that problem, I'll be setting up eight workstations. I understand from Microsoft Sales that since I've purchased a total of ten CALs, then all eight workstations will be able to access either server. Do I have to do anything special to make that work? Currently, there's no domain. The servers are just members of a workgroup.
I need to install some SQL Licenses but the Control Panel applet is non-functional (It states that I have an NFR version of NT). Is there another way to activate licenses?
I would like to know does it exist a relation between number of licenses (per server) entered when installing SQL Server and the maximum of connections obtained by @@MAX_CONNECTIONS ? how can i get the information about the number of licenses after the installation ? Thanks.
I was told that there is no relationship between max_connections and number of licences. So how can i know when the number of user connections exceeds the number of licenses per server (with the error 18458 - the maximum simultaneous user count of %d licenses for this server has been exceeded)? Because I did some tests by openning a number of connections greater than my number of licenses and i didn't get any error.
We are looking for a solution for a client that we will make software for. We are a ISV. After completion of the software, our client then wants to sell this software to their partners, people in that business, etc. We do not want to add any additional cost, by means of them(client(s)) purchasing a server, server software or licensing. Is there any solution that will make this work? A runtime or embedded database solution? If there is a license we need to purchase, what would that be? SQL Express Edition work?
My company uses a quad processor server connected to a SAN to load and summarize detail sales information from 2000 stores on a nightly basis. We poll and load around 5,000,000 rows of data each night. THis information is summarized up to various levels, then replicated to one or more secondary datamart servers for end user access via web reporting, BI tools like Proclarity/Analysis Services etc...
The initial data polling server is only touched by the development staff supporting the process (1-5 programmers) and is licensed for SQL server Enterprise using a CAL model. Each datamart server is licensed with MS SQL server processor licenses.
The question: We were told that the quad processor polling machine, which has no end user access allowed, must be licensed with processor licenses since it touchs the data ultimately consumed by end users. This makes no sense to me.
The Microsoft white papers discussing multi_tier environments don't seem to address this type of issue. They focus on applications that ultimately pass thru a data request to the SQL server machine. In this situation, user requests are handled by the datamart servers, which are licensed with processor SQL licenses.
Hello everybodyI've got a small system (~20 client machines) connected to one SQL Server2000. Two of these machines refuse to connect to the database. As I don'tknow how the license system is supposed to work, I haven't investigatedtoo much yet.My question is therefore:Will SQL Server 2000 Enterprise Edition refuse to accept any newconnections when all licenses are used?Is such case, what tool do I use to add more licenses?thanks in advance--Johnny Ljunggren
our company is using SQL Server 2000 Standard Edition as a backend for inventory and sales data storage.
The top management of our company has decided to web enable all the data for sales and inventory so that any authorized user can have access to the data from anywhere in the world.
now my question is that how many SQL Server licenses will we require if we are going to use it for the web?
I have got a licensed copy of MS SQL Server 2005 Standard Edition. I am wondering how I can go about telling how many Processore Liscenses or Client Licenses I have with it. I have just the disk set and product key, no box. Any clues?
we have a sql express - that comes standard with servers.I just wanted to know.....Is there any addition Client access licenses needed for this sql express or not.
Hello our organization has never had any problems getting users to connect to our SQL servers but we have grown a lot over the past year or two. Does SQL Server actually block connections if they go over the license limit? I don't have access to the servers to see the model used but I have been asked to look into this. I couldn't find any information on this so I decided to ask you guys. Thanks in advance.
I have been testing and developing with Sql 2005 enterprise eval. Now ready to deploy, and we have purchased a "device" and 5 "cal" licenses for each box. What is the recommended procedure for applying Sql 2005 "standard" licenses to existing boxes having 2005 enterprise eval. installed? I do not want to delete and re-install sql server if at all possible!
Hello,This is hopefully just a quick question. I'm looking to re-jig our in-house development infrastructure and part of that will be some sort of SQL Server product, and I'm hoping it will be the Developer edition.My question is, how many copies of the Developer edition would I need to purchase, if I have one Windows 2003 server (which will server the databases) and two client machines which will use it.My initial thought is 2 copies, one for each user (as the license states). But what about the server? Do I just install one of the two copies onto the server and the license covers the two client connections?This might seem a silly question with an obvious answer to you guys. However, am I right? I just need to get this clear in my head.Thanks in advance..
I was going to use Sql compact 2005 with vs2005 and use merge replication with MSDE2000. Unfortunately I found out this isnt possible (only possible if I use SQL Server 2000)
Has I can replicate with MSDE2000 with Sql CE 2.0 the question is:
Can I use sql ce 2.0 with vs2005 and windows CE 5??? Do I use the same System.Data.SqlServerCe assembly?
I am running VS2005 Pro edition. I have downloaded, but not installed, SQL Express with Advanced Services SP1. Can I install it over the VS2005 version of SQL Express or do I have to do some install work?
Also, regarding the Books Online July version, must I do a clean install or can I just install it over whatever came with VS2005?
Hi, i'm looking for SQL CE 3.5 for Visual Studio 2005. I am currently using SQL CE 3.1 and wish to use the System.Transactions support which has been included in v3.5.
I know Orcas includes v3.5 but i need to continue using VS2005. Is there an installer or similair so i can develop applications with SQL CE 3.5 with my current development environment? I see there is a new SQL CE sync installer which includes the 3.5 runtime files, however ideally i would like the sdk so i can use the dataset designer. Is it possible?
Hello I opened vs2005,new->project->analysis services project ,clicked OK, then dragged a data flow task from the toolbox to the area ,after I double clicked data flow task it gave me error message as shown in the link , what is wrong?
I'm a newbie to both Windows Forms development and SQL Server CE, so please bear with me...
I am developing a vocabulary builder application, and my data keeps reverting to the data set I originally imported. I keep losing the records I've added using the application I'm developing, or from within VS2005. I know about the 'Copy To Output Directory' option in the Solution properties and I set this to 'Do not copy'.
What gives? Not sure what other information you might need, but I suspect it's something really basic... Thanks!
When I try to add a new database to App_Data in a VS2005sp1 project I get "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user interface".
I have SQL2005sp2 and SQL Express on the system, both services are running, and an instance of the latter called SQLExpress which I can use through SQL Server Management Studio. sp_configure user instances enabled is set to 1. The SQL Server Instance Name in Options | Database Tools | Data Connections is set to SQLExpress ...
I have no idea how to proceed .. any ideas anyone?
Can someone explain the generated sprocs of VS2005 if one column can be nullableDependentOfSeqID = @Original_DependentOfSeqID OR ((@IsNull_DependentOfSeqID = 1) AND (DependentOfSeqID IS NULL))In VS2003 the generated sprocs would beDependentOfSeqID = @Original_DependentOfSeqID OR ((@Original_DependentOfSeqID IS NULL) AND (DependentOfSeqID IS NULL))Which is the best?
I am busy with handling connecting to Sql2000,It said some error occured while connecting to SQL2005. But actually i am using SQL2000.Can somebody give me a solution ? By the way,I am a greenhand.
Hi Guys,Have a strange problem at the moment on a page I am working on. Basicly there are 2 SQLDataSource Objects and 2 GridViews(I will call them GV1 and GV2 and DS1 and DS2 (GV = GridView and DS=SQLDatasource if you didn't guess)). Right the problem.... DS2 and GV2 don't display anything yet the SQL being executed is more or less the same.SQL from DS1 is
Hi everyone, I am attempting to drag the SQLDataSource control to my webpage to initiate a connection to my SQLServer Express instance on the same system. The control will drop correctly, but when I click on the "Configure Data Source" in the SQLDataSource Tasks popup panel, I get the following error message: Following error occured while getting connection string information from configuration."Cannot get web application service" It then sends me to the configure data source window where it asks me to choose my data connection. However, there is nothing in the pulldown, and the "New Connection" button does nothing. I have the SSE data connection defined and visible in the Server Explorer, and there is a connection string defined in the web.config file that points to the server and database I wish to access. I'm on day 2 of my excursions with VS2005 Pro, so I feel that I'm missing something huge, but otherwise obvious that's different in the configuration of VS2005 as opposed to VS2003, which I have no issues with. Thanks!Chris
I am working on a windows application (C#) that utilizes ODBC to acces paradox tables (works fine thought this would be the problem database) and a WinMobile database(.sdf) in order to sync table records. What I need to do is copy the .sdf file from the winmobile device then access it with this application to check for changed records on the PC and in the mobile database then copy it back to the mobile device via RAPI.
The program compiles fine but when I try to run the application I get this error. Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) .
I have already copied the System.Data.SqlServerCe.dll to my projects bin folder and then added a reference to it in the projects Reference dialog. These were also copied to the bin folder of the project
sqlceca30.dll
The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.
sqlcecompact30.dll
Provides the compact database functionality. Required if your application will use compaction.
sqlceer30[language].dll
Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.
sqlceme30.dll
Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.
sqlceoledb30.dll
Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.
sqlceqp30.dll
The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.
sqlcese30.dll
I also added using System.Data.SqlCE to the form and the dataset designer.cs
From this code in the dateset.Designer.cs file after the run is started the eroror occurs.
