License Of Developing And Distributing Based On SQL Server XE

Jul 2, 2006

Hi all,

I need to find all information about distributing SQL Server XE and applications using it . Is it legal ?? should it be used just for educational use?!!! could it be used to develop a commercial software !! what limitations are controlling this ??

thanks in advance !!

View 6 Replies


ADVERTISEMENT

SQL Server 2005 Workgroup Edition Licensing (How To Install Without A License, Then Require License On First Run)

Oct 13, 2006

I have a VERY Legitmate use to install sql 4 workgroups on a pc without licensing it. I am making a disk image for MANY pcs to be imaged and load licensing after the imaging is completed.

I have been able to do this with Windows XP Professional, MS Office 2003 and a couple non-Ms programs. The information for MS software even came from their KB, so I know what I am doing is legit. I just can't find any information on doing this for my sql app.

Any suggestions??

Respectfully,

Frustrated

"Frustrated"

View 1 Replies View Related

Distributing Sql Server Database

Jun 25, 2007

Hi,



I am new to SQL Server. I want to email my database and the diagram to a friend of mine so he can review my work.



I noticed that the sql server databases that I have downloaded had an extension of .msi. I don't know if I need to do something to make my database have the .msi extension before I can email it to my friend.



I have been able to copy and paste both the database and the log file to a folder on the desktop. I can't seem to open these though. I have right and left clicked on the

the databse file that is on my desktop. When I do both of these it prompts me to select a program to open it with. This is where I have problems. I go to the programs folder and then to the sql server folder hoping to be able to open it. I haven't been able to find anything to open it with. I have looked at every file in the folders but none seem to be appropriate.



I am using sql server 2005 express edition. Is this a limitation of the database that are made with this free edition?



thanks,



Krist

View 3 Replies View Related

Selling/Distributing SQL Server Express

May 3, 2007

Hello all,

Thanks for all your great forum topics; it gives me a nice break from coding all day!

I know the answer to this question is in the documentation that comes with the SQL Server Express [9] download, but I've been unable to find it. What I was wondering is what the restrictions were if you were to incorporate the "free" SQL Server Express for selling or general distribution? Any help would be greatly appreciated!

Thanks,

P.

View 5 Replies View Related

Distributing VB 2005 And SQL Server Express

Feb 4, 2008

I have written a Visual Studio 2005 vb application the accesses SQL Server 2005 Express. How do I create a distributable CD with everything necessary on it. Can I use One-Click?

View 3 Replies View Related

Distributing Setup Files SQL Server 2005

Apr 16, 2007

Hi



I would like to know, if it is at all possible for Setup files of SQL Server 2005 to be distributed. We have clients who currently use our software which makes use SQL Server 2000. We are looking ahead at distributing our new version with SQL Server 2005 and would like create an Installation package that will upgrade the database engine to the Workgroup or Enterprise editions of SQL Server 2005. Are there any suggestions around this topic, we are looking at ways in making this task of upgrading the engine as streamlined and automated for our Client. Please include advise with regards to licensing.



cheers

Kevin

View 1 Replies View Related

Sdk For Developing Sql Server Front-end

Feb 1, 2006

I am in the planning stages of a front-end to access sql server databases. The project involves analysis of stored data as well as storing results of the analysis. The classes for the analytical part is fairly complex so I would like to speed up the data manipulation part of the project. I am already familiar programming with ADO but I was hoping for a more complete solution. Is there a sdk or example code (third-party OK) that could facilitate this?

The client is not especially fond of .NET and would prefer to use VB6. However, with the right solution, C# or VB.NET would be acceptable languages.

View 1 Replies View Related

Developing A SQL Server DB (noob Question)

Jul 31, 2007

I'm beginning development on a medium/ sized in-house web based system.  Well moving from asp/mysql to asp.net/sql server.  Re-doing DB design as well.My question is does it make sense for me to develop the SQL DB in Visual Studio 2005 pro, and then later move it to a real SQL server?  Or basically what is the best and/or most practical way to do this development.  Any other IDE's out there?Thanks 

View 3 Replies View Related

Developing App That Will Use SQL Server Express On Back End...

Sep 21, 2007

Hi...

I have the full version of SQL Server installed on my machine and am developing an app using BI DTS packages, VB.Net, SQL SPs, etc.. I will need to deploy this app w/SQL Server Express (SSE).

-Do I have to install SSE on my development machine for the purpose of creating the install package of my application? I am afraid that if I do install SSE on my machine, it may mess up my installation of the full version of SQL Server... will it?

-Can you point me to a link with information about how to do the development with the full version of SS, and create the installation package using the SSE?

Thanks for your help.

Steph

View 4 Replies View Related

How To Connect To My Local SQL Server (For Developing)

Apr 20, 2007

I can't found my way to connect to local SQL server (On My Computer)

can any body help me

Ahmed Gaber

View 1 Replies View Related

Developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework

Aug 13, 2007

We are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
public bool Replicate()
{ bool ret = true;
SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
repl.PublisherLogin = this.PublisherLogin;
repl.PublisherPassword = this.PublisherPassword;
repl.Publication = this.Publication;
repl.Subscriber = this.Subscriber;
repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgent

View 3 Replies View Related

SQL SERVER LICENSE

Oct 20, 2006

Hey Gang,

I was wondering if there was an alternative to using SQL SERVER and not having to spend all that money on a license?

View 5 Replies View Related

SQL Server License ISSUE

Aug 27, 1998

Hi,

My Sql server License mode is set to Per Seat, is there a way to change that to Per Server? If yes what are the ramifications.

Please let me know ASAP

Thanks
vIVEk

View 2 Replies View Related

SQL Server Per Processor License

Jul 20, 2004

If I install an instance of SQL Server on a box with 4 processors but specify in the licensing part of the installation procedure that it's a '2 processor license', does that really mean that SQL Server will only use 2 of the 4 processors? I ask because, having done this, if I check the SQL Server instance's properties, on the Processors tab, there are 4 processors ticked - giving the impression that 4 processors are being used by this SQL Server instance. Can anyone throw some light on this?

Another question... If I wish to reconfigure the same SQL Server instance from a 2 to a 4 processor 'per processor' license, how can this be done?

Clive

View 1 Replies View Related

SQL Server License Checker

Jul 23, 2005

Hi all,I am performing a consolidation of all SQL servers in my environment. Ihave run the tool to find out what level patching they have and whatedition they are running on, but is there a tool so I can scan thenetwork and find out what licensing they are setup for (processor vs.seat)?Even if I have to enumerate each one, one at a time I would be OK withthat. I just don't want to have to login to each server and go toControl Panel and click on the Licensing.Command line is super-duper.Thanks,Josh

View 1 Replies View Related

Mode Of License Do SQL Server Is In?

Oct 11, 2007

Dear All,

How would I know what mode of License do SQL Server 2000 and 2005 is running.

Thanks,

View 3 Replies View Related

SQL Server 2005 License

Mar 24, 2007

Hi,
We have MSDN subscription and got VS2005 and SQLServer2005. Our developer develops applications bey using them. One of the application that he has runs periodically and export data from SQLServer2005 to xml files in development machine. We are wondering if we need to buy SQLServer 2005 license for this process.
Thanks for your help.

View 1 Replies View Related

Distributing Jobs In SQL

Mar 22, 2001

I want to know if there is anyway to distribute jobs to a non system
administrator. In other words do they have to have System Admin rights, to be able to modify a job and run the job.

View 1 Replies View Related

Distributing Database With App

Jun 21, 2006

Sorry if this something beaten to death already...

What is/should be required for a target client machine to use and connect to a local copy of a SqlExpress database? Can't seem to get a db connection established to a different machine through a VB6 app. Installed the sql native client on the machine, but still can't connect. What am I missing, or do I have to distribute/install the entire SqlExpress client? Working fine from my development machine.

Rick

View 11 Replies View Related

Distributing DTS Workload

Apr 14, 2008

Suppose I create a DTS package (I am an old timer from SQL Server 2000 days but I suppose with 2005/2008 integration services there is a similar concept of package) which essentially reads data from a set of csv files, transforms it, and loads it into a SQL Server database. There are two scenarios:

i) The transformation involves applying functions on the columns before loading to the database.
ii) The transformation involves joins of data from multiple files.

My question is, can I run this DTS package on a machine which does NOT have SQL server installed for scenario i) and scenario ii) above? The idea is to distribute the actual processing across a set of computers to take off load from the main database server. If it can be done for either case then can u please explain how? Thanks in advance for your help.

View 1 Replies View Related

SQLCe Errors When Doing Developing A SQL Mobile Application With Visual Studio 2005 And SQL Server 2005 Tutorial

Feb 26, 2008

I'm attempting to use RDA to synchronize a pocket pc emulator with SQL Server 2005 database by following tutorial http://msdn2.microsoft.com/en-us/library/aa454892.aspx, which uses AdvWorksMobile database that comes with SQL Server 2005.

When get to testing of "To test application features " ( step 4 of the merge replication setup lab ), I am receiving SQLCe Exception errors.

ORIGINALLY, I was able to deploy an application and view the local database on the emulator, but once I clicked "InitSinc" button, I received an error.

"Failure to connect to SQL Server with provided connection information. SQL Server does not" exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
Found this error listed in Server Agent Errors log http://technet.microsoft.com/en-us/library/ms172357.aspx, but it wasn't very helpful since it doesn't provide any suggestions on fixing the problems.

I am brand new to SQL CE Server , mobile programming and .NET framework in general so please bare with me



All the connections / security settings, etc that were set up were taken from a tutorial so I am not sure what SQLCeServer is complaining about. Reading up on the error on the web didn't help, it all pointed to making sure that the snapshot folder had correct permissions set up. I verified that MACHINENAMEUISR_MACHINENAME guest user had Read rights to the database so I don't think that piece is the problem. Otherwise ,Merge publication has been setup in Microsoft SQL Server Management Studio by following the tutorial.


I am trying to run this sync on my home pc so there should be no issues with any user permissions


I have IIS installed


I did NOT have SQL Server Agent running in management studio at this time


I am trying to run this tutorial on an XP machine, which is my regular home PC so I dont think there are any special networking settings to consider


I am able to hit http://localhost/AdvWorksMobile/sqlcesa30.dll from my pc OK, but when I try to hit it from a cradled emulator ( after replacing "localhost" with "MACHINE_NAME" ), Internet Explorer on the emulator gives me a "Cannot Connect With Current Settings" error message. This part wasn't part of tutorial but decided so not sure if I am supposed to be able to hit it from my emulator..so I am not sure if the fact that I can't hit it is related to the problem.
AFTER STARTING SQL SERVER AGENTin Microsoft SQL Server Management Studio, I killed the application, and after relaunching it, it hits "The Specified table does not exist [Vendor]" error. This time it doesn't even launch first - that is I dont even get to pressing "InitSinc" button. Debugger is showing that this error is hit on the following line in AdvWorksMobile.AddWorksDataSetTableAdapters

int returnValue = this.Adapter.Fill(dataTable);

I am not sure why the errors changed on me after starting SQL Server Agent.
What can I do to fix this connection problem?

Thank you so much for your help!

Irina


View 3 Replies View Related

SQL Server 2000 License Query

Jan 5, 2006

Hello.After searching Microsoft's website for hours and confusing myself morethan I was before I started...Can anyone explain to me what the current state of affairs is for SQL2000 licensing?In particular with a server that has multiple processors and multipleinstances of SQL Server 2000 running - for both Standard and EnterpriseEditions of SQL Server 2000.Please help!Regards,Taz

View 1 Replies View Related

SQL Server License Control And Management

Mar 22, 2006

Today many applications (SAP, SIEBEL, MANUGISTICS, PEOPLESOFT, and soon) does not have a client direct access to connect to the database.They use an Application Server that has only one connection to thedatabase and the users get connected to this application server.THE QUESTION: How to control SQL Server User License in this new model,automatically?You cannot enable SQL Server Audit because users are not connecteddirectly to the database.You cannot use Identity Management applications because they do notwork on NOT Enterprise Business software.How to do that if you have hundred of applications and database?Regards,Marcio

View 9 Replies View Related

SQL Server 2005. Please Advise On License

May 9, 2007

Hi,



We have a .NET Remoting application whose "server instance" connects to SQL Server Express and send data via remoting to its client application. There is no need for other direct access to SQL Server except for the "server instance". Now my software vender advices us to upgrade to SQL Server WorkGroup edition and now we are facing the question which license to buy. Could you advice us?



BR,

L

View 1 Replies View Related

Is SSRS Free With SQl Server License?

Jun 5, 2007

Any ideas if SSRS come free with SQL server?

How does it work?
I have a friend who have a sql server license but don't know which one

Does SSRS come by default with Sql server

Thanks

View 1 Replies View Related

SQL Server Express License Question

May 4, 2006

Do I need a license to use the SQL Server Express in a production environment ?? I thought I needed an existing SQL Server license such as SQL 7 ?? Please let me know. :)

View 4 Replies View Related

SQL Server Replication License Requirments

Apr 5, 2007

I'm setting up SQL Server 2005 Replication. I have purchase a processor license for SQL Server 2005. Do I need a Windows CAL for each device that will be accessing the replication via IIS?



Thanks!

Matt

View 1 Replies View Related

SQL Server Express License Issue

Mar 16, 2008

I'm a .net developer creating applications that depends on SQL Server as a back end database engine.

I read about the features and pricing options of the different SQL Server 2005 editions here, I also read the SQL Server 2005 express EULA and knew that it's now alright to use it in commercial applications.

I use the SQL Server express engine only for the purpose of development and testing, is this use is lawful?

And if the answer is yes, what's the need for the "Developer Edition" mentioned in the page referenced above?

View 5 Replies View Related

SQL Server 2005 License Issue

Dec 14, 2006

Hi all,

We have installed the SQL Server 2005 Enterprise trail version for 180 days. As it specifies in the documentation that it exprires after 180 days and in the mean time we have actually made a purchase of the License. Now...do we need to uninstall the trail verision and reset/restart everything again? Please advise.

Thanks.

View 3 Replies View Related

SQL Server 2005. Please Advise On Which License

May 7, 2007

Hi



I would like to setup about 20 websites (each with database search engines) and would like to use SQL Server 2005. This setup will be run by myself (i.e. single user)



I'm a little confused about which license I need. Do I go for the $23k full version or free license (Express) or something in between??



Could someone please advise. Would be happy to submit further details if required



Many thanks



Mike

View 4 Replies View Related

License Information In SQL Server 2005

Jan 17, 2008

How do we determine on a SQL 2005 server what license type was selected during the install? Where is the informationkept and how it is tracked by SQL Server 2005.

Thanks in Advance.

Admindba

View 3 Replies View Related

Distributing OLAP Cubes

Aug 18, 2000

I'm looking into adding OLAP Cubes as part of our software to be distributed with our OLTP and eventually OLAP databases.
Is there any books that deal with distributing OLAP Cubes and or security.
Our clients will have SQL Server with our databases.
Thanks

View 1 Replies View Related

Distribution Items... Well Not Distributing

Aug 24, 1999

Hi

I had replication set up and working but had to unbind the Pub/Sub and re add. Now on the ditribution task in Executive I am getting the following error

The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 2147.

This is SQL Server 6.5 by the way.

Does anyone know what has caused this and what the solution is?

Steve

View 2 Replies View Related







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