Licensing Details For SQL Server CE Cab Files To Be Used In Custom Installer
May 16, 2007
Hello All,
We have a licensed version of VS2005 and we are developing commercial C#.net mobile applications targeted for Pocket PC 2003, Windows CE etc.
We are currently making use of System.Data.SqlServerCe.dll and are using the Sql Server CE for storing and retrieving information required for the application. We use this information and send it to our hosted web server for processing.
We use NSIS installer to develop the installer for mobile application. Can we make use of the Sql Server CE CAB files (sqlce30.dev.ENU.ppc.wce4.armv4.CAB) to install or should we only use the Sql Server CE dlls that are mentioned in the REDIST.txt?
We would like to know if we would be in agreement with the EULA if we make use of the CAB files for installation instead of the direct dlls.
Best Regards,
Manasvini
View 3 Replies
ADVERTISEMENT
Mar 26, 2008
I'm trying to create a custom bootstrapper for SQL Express SP 2 Which enables the replication features of SQL Express. I read an article telling me that I could use the same command line arguments in the bootstrapper as does SQL Server 2008 unattended installation
How to install SQL Server 2008 from the command prompt :
http://msdn2.microsoft.com/en-us/library/ms144259(SQL.100).aspx
Arron Stebners WebLog suggests using the following:
http://blogs.msdn.com/astebner/archive/2006/03/19/555326.aspx
SQLEXPR32.EXE -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=2 SQLAUTOSTART=1
What I€™m trying to do is something like this with my parameters:
-q /norebootchk /qn reboot=ReallySuppress addlocal=all SECURITYMODE=SQL SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 FEATURES=SQL SQLSVCACCOUNT="NT AUTHORITYSYSTEM" SQLSVCPASSWORD="<password>" SQLSYSADMINACCOUNTS="sa" AGTSVCACCOUNT="NT AUTHORITYNetwork Service" INSTANCEDIR="C:Program FilesMicrosoft SQL Server" SQLBACKUPDIR="C:Program FilesMicrosoft SQL ServerBackup" INSTALLSQLDATADIR="C:Program FilesMicrosoft SQL Servermssql.1mssqldata" /instancename=SQLEXPRESS /SQLSVCStartuptype=2 SQLAUTOSTART=1 ERRORREPORTING=2 ADDUSERASADMIN=0
This fails with an error code 110:
Here is the full install log:
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package 'Windows Installer 3.1', phase BuildList
The following properties have been set for package 'Windows Installer 3.1':
Running checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true
Result of checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
'Windows Installer 3.1' RunCheck result: No Install Needed
Running checks for package '.NET Framework 3.5', phase BuildList
Reading value 'Install' of registry key 'HKLMSoftwareMicrosoftNET Framework SetupNDPv3.51033'
Read integer value 1
Setting value '1 {int}' for property 'DotNet35InstallSuccess'
The following properties have been set for package '.NET Framework 3.5':
Property: [DotNet35InstallSuccess] = 1 {int}
Running checks for command 'DotNetFX35dotNetFx35setup.exe'
Result of running operator 'ValueEqualTo' on property 'DotNet35InstallSuccess' and value '1': true
Result of checks for command 'DotNetFX35dotNetFx35setup.exe' is 'Bypass'
'.NET Framework 3.5' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor', phase BuildList
Running external check with command 'C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmpSQLEXPRESS_PROJECT_ENDEAVORSqlExpressChk.exe' and parameters ''
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE' is 'Bypass'
Running checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE' is 'Install'
Running checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.2': true
Result of checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE' is 'Bypass'
'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor' was accepted.
Copying files to temporary directory "C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmp"
Copying from 'C: empEndeavorInstallerSQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE' to 'C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmpSQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE'
Verifying file integrity of C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmpSQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE
WinVerifyTrust returned 0
File trusted
Running checks for package 'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor', phase BeforePackage
Running external check with command 'C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmpSQLEXPRESS_PROJECT_ENDEAVORSqlExpressChk.exe' and parameters ''
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE' is 'Install'
'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor' RunCheck result: Install Needed
Verifying file integrity of C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmpSQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE
WinVerifyTrust returned 0
File trusted
Installing using command 'C:DOCUME~1CarrollDLOCALS~1TempVSD381.tmpSQLEXPRESS_PROJECT_ENDEAVORSQLEXPR.EXE' and parameters '-q /norebootchk /qn reboot=ReallySuppress addlocal=all SECURITYMODE=SQL SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 FEATURES=SQL SQLSVCACCOUNT="NT AUTHORITYSYSTEM" SQLSVCPASSWORD="Bade#doo" SQLSYSADMINACCOUNTS="sa" AGTSVCACCOUNT="NT AUTHORITYNetwork Service" INSTANCEDIR="C:Program FilesMicrosoft SQL Server" SQLBACKUPDIR="C:Program FilesMicrosoft SQL ServerBackup" INSTALLSQLDATADIR="C:Program FilesMicrosoft SQL Servermssql.1mssqldata" /instancename=SQLEXPRESS /SQLSVCStartuptype=2 SQLAUTOSTART=1 ERRORREPORTING=2 ADDUSERASADMIN=0'
Process exited with code 110
Status of package 'SQL Server 2005 Express Edition SP2 (x86) Build for Project Endeavor' after install is 'InstallFailed'
View 5 Replies
View Related
Nov 9, 2007
Hi,
I've a doubt regarding deploying and creating package (MSI and EXE files) for SQL Stored procedures,views,tables,functions,triggers etc.,just like ASP.NET application by publishing and deploying..Is it possible in the same way for sql objects.If so,pls help me how to do it?
Thanks in advance.
View 1 Replies
View Related
Aug 8, 2007
hi,
I have a custom code that can gets string from an array:
Public Shared FormatArray() As Object
Public Shared Function GetFormat(ByVal _Col As Integer) As String
Return FormatArray(_Col)
End Function
However if I place the code in a Table details value expression =Code.GetFormat(0), It will give me #ERROR
But if I put in the Table Header row value, then it shows me the String correctly, same for in Footer of the table.
Its only within the details rows that is not working
Does anyone know what is the problem??
many thanks
Jon
View 6 Replies
View Related
Nov 14, 2007
Hello
I'm developing a simple visual basic.net application and I have a licensing question about database files.
If I were to use a MSSQL database file as a data source (just like you would use a MS Access database file) no server.
Would I have to pay any sort of licensing, and if so what would that be?
View 5 Replies
View Related
Jun 30, 2015
We have several hundred very simple ETL SSIS 2K8 package files (*.dtsx).
I'd like to be able to interrogate them to determine source and destination fields.
There's no great need to map source to dest or to extract data types.
So far, the most promising candidate is to load them using OPENROWSET into an XML field in a SS table.No problem there, but querying using OPENXML has me stumped.
The package files will change a couple of times per year, so the process needs to be repeatable with minimal manual intervention.
View 3 Replies
View Related
May 9, 2007
is there any free downloadable sql server installer...???
View 1 Replies
View Related
Nov 6, 2004
Can we embed the SQL Server Express in the windows installer jsut like the XML files or the Ms access database?
View 2 Replies
View Related
Sep 11, 2007
Can anyone tell how can I create an installer for sql server database.
View 4 Replies
View Related
Jul 25, 2006
Okay, this must be the silliest question of the day. I downloaded SSE, but when it ran, it noted that I needed Win 3.1 Installer. Went and got that, installed it, and restarted. But where is my SSE download? I tried to go back to the SSE download, but it won't download the file again. Nothing happens when I click on the download link.
TIA,
MaryMary
View 1 Replies
View Related
Jul 19, 2007
Hi,
I have created an installer for deploying Sql Server Express. My installer will start the process of installing Sql Server Express. However the installation of SqlServer Express will fail because it says another installer is currently running (which is my installer). Is there anyway to work around this problem?
The reason why I would like to create an installer for the installation of Sql Server Express is because I would like to configure the SqlServerExpress without the user fiddling with the ini file.
Thanks
View 1 Replies
View Related
Aug 15, 2006
Good Morning..
We're having a heck of a good time trying to implement our first CDE project in SSRS 2005.
In our SDE class library we have included an App.Config file where we want to store configuration settings..
Trouble is that when we view the configuration settings or connection string settings in debug mode, they're not being read for some reason..
Here's our app.config file:
-------------------------------------------------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<appSettings>
<add key="eventLogName" value="FocusDPEEventLog" />
</appSettings>
<connectionStrings>
<add name="PassConnString" connectionString="Data Source=SOMEDATASOURSE;Persist Security Info=True;User ID=SOMEUSERNAME;Password=SOMEPASSWORD;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>
</configuration>
-------------------------------------------------------------
Here's what our Immediate window Debugger is tellin' us about our configuration settings:
-------------------------------------------------------------
ConfigurationManager.AppSettings
{System.Configuration.KeyValueInternalCollection}
[System.Configuration.KeyValueInternalCollection]: {System.Configuration.KeyValueInternalCollection}
base {System.Collections.Specialized.NameObjectCollectionBase}: {System.Configuration.KeyValueInternalCollection}
AllKeys: {Dimensions:[0]}<----incorrect should be 1
ConfigurationManager.ConnectionStrings
Count = 1 <----ok, is one, but the wrong 1, see 3 lines down...
base {System.Configuration.ConfigurationElementCollection}: Count = 1
ConfigurationManager.ConnectionStrings[0]
{data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}<--Should be PassConnString
base {System.Configuration.ConfigurationElement}: {data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}
ConnectionString: "data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
Name: "LocalSqlServer"
ProviderName: "System.Data.SqlClient"
Now notice the stuff in bold...I have NO IDEA where this gosh-danged thing is reading, but it doesn't seem like it's the app.config file in our class library...
thanks..
Doug
View 1 Replies
View Related
Mar 8, 2007
Hi,
I am creating a custom transformation component, and a custom user interface for that component.
In
my custom UI, I want to show the custom properties, and allow users to
edit these properties similar to how the advanced editor shows the
properties.
I know in my UI I need to create a "Property Grid".
In
the properties of this grid, I can select the object I want to display
data for, however, the only objects that appear are the objects that I
have already created within this UI, and not the actual component
object with the custom properties.
How do I go about getting the properties for my transformation component listed in this property grid?
I am writing in C#.
View 5 Replies
View Related
Apr 10, 2002
If SQL Server 2000 is loaded onto a 8 processor machine, can I legitimately
load Standard Edition, which will only use 4 of the 8 processors, or as
some interpretations of the license suggest, must I purchase Enterprise
Edition (i.e. you are not permitted to load SQL Server on a machine which
has more processors than the Product is capable of using) ?.
I know the "reasonable" answer, but what is the legal position ?
Ian
View 1 Replies
View Related
Jan 8, 2004
Hi,
My company is embarking on a data warehousing project. We are going to purchase a Windows 2003 server. It would be a dual processor. The specs are not certain yet so cannot give more details on that.
1. The data in the warehouse would be close to 150 GB.
2. There will be maximum of 10 users needs a SQL Server license.
3. Do not need analysis services.
What edition do I go with -Enterprise OR Standara? I want the least priced edition. I looked up the various links on Books Online but I am still not able to decide.
Say I need only 2 GB of RAM. Then here are my questions.
1. Since we are going with a dual-processor, do I need to purchase processor license for each of the two? Why can't I have one license on one processor only? What are the implications of this?
2. The 10 users that I am talking about will be remotely connecting to this Windows 2003 server and accessing the databae.
3. What exactly is Failover clustering? Do I really need it for my warehousing project?
4. Please help me pick the correct license. Here is the link -
http://www.microsoft.com/sql/howtobuy/default.asp
Thanks,
Vivek
View 12 Replies
View Related
Jan 9, 2004
Is there a way to find the SQL Server licensing information after the software is installed? I mean is there a way to say that it was licensed per cpu or per cal?
View 1 Replies
View Related
Jan 15, 2004
I have a Windows 2000 Operating System with 4 processor, out of which I'm planning to use only one Processor for the SQL Server and leave the rest of the three processor for the OS.
My question is that do I need to buy the license for all the 4 processors or I can do with the only 1 that will be used for running the SQL?
View 1 Replies
View Related
Mar 27, 2007
Env.: SQL 2005 on Win2003
I am a DBA and I have a SQL Server 2005 license for each server. To manage the servers, I want to install SQL Server 2005 on my local desktop. Do I need a license for it as well?
Thanks,
Canada DBA
View 3 Replies
View Related
Jul 23, 2005
How does one find out what type of licensing is employed on a SQLServer Box. i.e is it Per Process or Per CAL?Martyn
View 6 Replies
View Related
Feb 16, 2007
I have a three server network. One SQL Server, One Web Server, and a backup.
The web server is ASP.NET, and uses the database. I do not track the number of users hitting the web server.
What type of sql server license is needed? Processor? Device CAL? User CAL? I have read all the white papers and licensing info and can't find an aswer to this question.
Please help
View 5 Replies
View Related
Jun 20, 2006
What kind of license do I need to run a single web site on a web server that needs SQL server to operate? it's a public site that runs DotNetNuke but it's the only site on that box.
View 5 Replies
View Related
Mar 27, 2007
Env.: SQL 2005 on Win2003
I am a DBA and I have a SQL Server 2005 license for each server. To manage the servers, I want to install SQL Server 2005 on my local desktop. Do I need a license for it as well?
View 1 Replies
View Related
May 6, 2004
I am a developer in need of setting up a SQL Server test environment for many users.
Can the Dev Edition be used as a back-end to handle this type of testing? Are my limited to one connection from my development machine?
As you can tell, <sarcastic tone>i am having a real fun time with this one</sarcastic tone>. Licensing terms are an area that i tried but sometimes cann't stay out of.
I appreciate your input.
View 1 Replies
View Related
Mar 10, 2006
Hello all,
I have a question concerning the ridiculous quagmire of SQL Server licensing…
How is SQL Server licensed when used to store session state information? Is MS claiming that this is an end user use of SQL Server functionality? Or, can we be realistic and say that I need a server license plus a device license for each web server?
Personally, I like everything about SQL Server except the licensing. Management at my company has already said that we’ll most likely be moving to either Firebird or Postgres after they found out how much it would cost to move from SQL 2k to SQL 2005. If MS wants us to buy processor licenses for SQL state servers, I guarantee we’ll be doing something else there as well. I wonder if Microsoft has any clue how much business they’re losing. Not just in SQL Server, but in their OS business as well.
View 1 Replies
View Related
May 2, 2006
Hello,
I am very confused about the licensing of SQL Server 2000 and 2005 (various editions), and any light you can shed will be greatly appreciated. I am learning VS2005, and need to build a website.
1. I know what a Client Access License (CAL) is.
2. I know what a processor license is.
My ASP.NET website might have 10 users, 100, or maybe 1,000 (I don't know at this point).They will have anonymous access to a main page from which they will have to log in, and from that point on be using SSL for anything they do.
I am getting conflicting information regarding licensing.
Questions:
1. Can SQL Server 2005 Express support what I need to do? (possibly many users)
2. Other than some of the fancy replication, analysis, etc that Express does not have, is there a good reason not to use Express Edtion?
3. Regarding SQL Server 2000 or 2005 (NOT Express): Does a single web application act as a single user thus the web application requires only one CAL. In other words: I am the only person who has direct access to the database. The ASP.NET web application will also have access to parts of the database. Will this scenario count as 2 "CALs"?
View 1 Replies
View Related
Oct 26, 2000
In order to use Replication, sql server installation must use per seat licensing. What if I have per server licensing, how can I change the licensing to per seat so I can use replication
Ahmed
View 3 Replies
View Related
Apr 9, 2001
I am so confused and I am getting no help from the Microsoft, two months and only stammering
from their representatives. I need to set up a Sql Server database that will allow internet access.
This is not an e-commerce situation. At most there will
be 10 known users of this system accessing statistical data. I had priced this system to use Backoffice,
but as I now read this is not legal for internet use. It also appears that a processor license is required for
internet access (not entirely clear on this). Access and MSDE also don't appear to be legal for internet access.
The customer is on a shoe string budget. If I use stand-alone
components the budget only covers an one processor SQL Server 2000 license. I don't like the idea of setting up
a database system with only one processor. Is there another Sql Server based option I am not aware of?
Its looking like a linux/mysql option - Yikes!
View 1 Replies
View Related
Jun 4, 2004
Is there any way I can see what is the existing license mode and no. of devices/processors allowed for the existing SQL Server setup
Thanks
Babu
View 3 Replies
View Related
Jul 20, 2005
How can one identify the current licensing model on an existing(production) SQL Server?
View 8 Replies
View Related
Feb 6, 2007
Sorry in advance for the potentially boneheaded question: I would like to purchase SQL Svr 2005 Std Edition in a 2 proc licensing config. All my retailer has is 1proc and doesn't have answers for 2proc... Can I buy a 1proc and upgrade thru MSFT? If not, how do I buy a 2proc copy...? Thanks! JohnWoo
View 3 Replies
View Related
Aug 8, 2006
How do I tell what SQL licensing option (processor, device CALS or user CALS) was taken when the server was installed? I have taken over a SQL 2005 server and I would like to check how many CALS (if any) it is licensed for.
View 2 Replies
View Related
Feb 22, 2008
I want to retrieve SQL server licensing information e.g. License type, Count, License Code etc.
Any help?
RK
View 4 Replies
View Related
Mar 18, 2007
I have a SQL Server 2005 Standard per processor license (My server has a dual core processor). How many client machines can I install the SQL management studio so they can register the SQL Server and query data if need be?
Thanks
View 1 Replies
View Related
