SQL Server Step-Up Licensing Query
Jan 29, 2008
Hi,
I've recently purchased a number of SQL Server licenses, one was a single processor enterprise license with 2 years SA/Step-Up. The reason I purchased the SA/Step-up was that we plan to move to 2008 when it is released and I was given advice from our suppliers that the step-up would allow us to do this.
However, I've read a few things in the past few days that have made me questions this. Namely a comment that read: "SA Step Up is normally only used if you have for e.g. SQL Server Standard with SA and wish to turn it into SQL Enterprise..a completely different product"
What I'm now wondering is whether I've wasted money purchasing a step-up license. Can it be used to upgrade to 2008 when it is released? I'm going to buy another enterprise license shortly with the same upgrade intentions but if SA isn't going to help then I see no point buying it.
Thanks in advance.
Andrew
View 6 Replies
ADVERTISEMENT
Mar 12, 2008
Hi
I posted this on the sql server security forums too. Here is the error that i get when i change the type of the step to ssis
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Additional information:
An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.(Microsoft SQL Server, Error: 3930)
This error pops up right after i change the type of the step to "SQL Server Intergration Services Package"
I have made the following configurations:
The user group (windows group) that the user belongs has the following roles in msdb :
db_dtsadmin
db_dtsltuser
db_dtsoperator
SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole
i have made a proxy to sql server agent which has the following subsystems :
"SQL Server Integration Services Provider" the proxy is tied to the same login which has those SQLagent and dts roles in msdb database.
Im using windows authentication and the user that logs into the sql server is in the same group that i have set all of the rights.
Ps. Clearly im missing some role or right somewhere because as soon as i give the group sysadmin role then all the users in that group can create SSIS steps in the agent.
Ps. Ps. I have been living under the impression that i dont have to give sysadmin rights to people that create ssis packages and schedule then with the agent.
View 3 Replies
View Related
Jan 18, 2008
Hi All,
Please let me know where can i find the sample files and rs2005sbsDW database in msdn library as i dont have CD provided along with the book.
Please give me the link of the sample files so that i can download it for testing the sample application.
Regards,
Prabhanjana
View 1 Replies
View Related
Feb 4, 2007
Visual C# 2005 Step by Step John Sharp
Intel D975XBX 930 2GB ram HD 300GB - MatroxVD
Windows XP Sp2 + updates
Visual Studio 2005 Professional edition
SQL Sever 2005 Standard Edition
20070203
Install Practice Files at D:Program FilesMicrosoft PressVisual C Sharp Step by Step.
Configuring SQL Sever Express Edition
Hostname - xxxxxxxxx..
At sqlcmd s xxxxx...SQLExpress E got - Pipes error.
Open Microsoft SQL Sever 2005 - Configuration Tools SQL Configuration Manager select Protcols for SQLEXPRESS select Named Pipes enable close.
At sqlcmd s xxxxx..SQLExpress E get Sqlcmd: : Unknown Option. Enter -? for help.
Chdir C:Documents and SettingsAll UsersStart MenuProgramsMicrosoft Server 2005
Sqlcmd s xxxxxx..SqlExpress E
Hresult 0x2, Lvel 16, State 1
Named Pipes Provider: Couldnot open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
How do I fix this?
Need to be able to to use the Northwind Traders data base
Thanks
View 1 Replies
View Related
May 15, 2008
Friends -
Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.
My environment is Windows 2003 server.
Appreciate your support.
Cheers
VSH
View 1 Replies
View Related
Apr 26, 2007
I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:
select * from vProductProfitability
where year = 2003 and
MonthNumberOfYear = 1
The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.
I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?
BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.
This humble grasshopper seeks wisdom.
Respectfully Submitted,
Dave Matthews
Atlanta, GA
aka FlooseMan Dave
View 17 Replies
View Related
Oct 13, 2006
is there such a paper? if so, can you pls point me to it? thx in advance
View 4 Replies
View Related
Oct 3, 2007
hye everyone,
after finished do the report and deploy at IIS/report manager in local pc..
i want to know , what is the step /how to deploy the report project at the user's pc/ client pc /other server..
thanks in advance
thank you very much
View 16 Replies
View Related
Jun 18, 2012
I want to convert .rdlΒ to .rdc need full steps.Actually i created .rdl report using sp sucessfully.Now i want to convert it to rdlc while doing it iam getting some authentication error and some thing else.I created rdl in 2008 and i want to change it to rdlc 2010.
View 5 Replies
View Related
Jan 31, 2007
I have a package that has multiple data flow tasks. At the end of a task, key data is written into a raw file (file name stored in a variable) that is used as a data source for the next task. Each task requires a success from the preceding task.
Here's the rub:
If I execute the entire package, the results of the package (number of records of certain tasks) differs significantly from when I execute each step in the package in turn (many more records e.g. 5 vs 350).
I get the feeling that the Raw file is read into memory before it is flushed by the previous task, or that the next task begins preparation tasks too early.
Any help is greatly appreciated.
I am running on Server 2003 64 (although the same thing happens when deployed on a Server 2003 32 machine)
Thanks
B.
View 2 Replies
View Related
Jan 24, 2006
We are in the process of ordering Sql Server 2005 for a client application and I am interested in more detail about the various licensing models.
Our application is essential a web application which stores answers from users to a questionnaire. These answers are then processed by an application running on the server and a report is produced. I have seen that for the workgroup edition, a "Server + 5 CALs" licence is quite affordable, but am not sure whether his is legal for our purposes. Given that all internet users connect through the same account on the windows server do all the users count as one user? Or would we need a CAL for each potential user? Since we can never know the number of users for the system we would then need the per processor license.
Our db is not used for any other purpose and other than the admin user, there won't be any other users connecting to the DB (eg it is not used in an intranet environment or anything like that).
Thank you very much for your help.
View 3 Replies
View Related
Mar 2, 2008
Hi!
I hope the answer is as simple as the question -- but after reading all the documentation I could find (understand?) and a lot of posts here, I'm no closer to achieving the goal.
I have a Visual C# app, DAYTRACKER, developed in VS2005. It uses a database with several tables constructed using SQL Server 2005 Developer Edition.
I want to deploy the app plus the database plus SQL Express to another machine, to be used by a single user (the administrator) with no need for network connectivity of any kind.
What I have so far is:
1. The application is successfully deployed from a CD-ROM, having used the Publish process within VS2005, and opens on the new machine -- without database connectivity, however.
2. SQL Express is successfully deployed (it deployed as a 'prerequisite' when I went through the Publish process in VS2005)
3. I manually copied the database's .mdf and .mdl files, using SQL Server Managers 'Copy Database' function, then transferred the copies to the new machine into the ..MSSQL.1MSSQLdata folder (where they appear along with the master.mdg, mastlog.ldf etc files)
Now, the DAYTRACKER application's DAYTRACKERConnectionString under 'Settings' in the VS2005 studio reads 'Data Source=DELL3;Initial Catalog=DayTracker;Integrated Security=True' (which are the appropriate parameters for the machine, DELL3, on which I wrote the program.)
The problem, of course, is that SQL Express on the new machine doesn't connect the application to the database. When I go to the 'SQL Server Configuration Manager' and go to the 'SQL Server 2005 Services' and double-click on the 'SQL Server (SQLEXPRESS)' icon (the service is running) and the user is logged on using 'Local System Account'. Under the 'Service' tab the Host Name is 'MUSIC' (which is the name of the new machine I've installed the app onto -- which of course is not the name - DELL3 - that the app's connection string is expecting). Under the 'Advanced' tab, I've tried correcting the name of the Startup Parameters default .mdf and .mdl entries to ..DayTracker.mdf and ..DayTracker_log.mdl, but the server won't start up after I make the changes.
What I'm hoping for: a step-by-step way of doing this type of deployment, preferable getting it all onto one CD-ROM, and installing it on the new machine so that it all works seamlessly from the start, not requiring any 'tweaking' of the SQLServer Express settings by the end-user.
But I'll take pretty much anything that fixes the specific db connectivity problem I've described.
Thank you very much.
John F.
View 11 Replies
View Related
May 19, 2008
Hi,
I have to transport a big database table and can't read it at once with "select * from table" because the table is bigger than my system memory.
Is there a way to read the table step by step? I thought it was possible with ADO and his serverside cursors but I don't now how. I need an "universal" solution that works on SQL Server 2000/2005, MySQL and Oracle.
Regards,
harry
View 2 Replies
View Related
Dec 5, 2007
Connecting to a networked SQL Server Box from my local machine
Open Query Analyzer from Start menu, logging in using sa account.
from the object browser i select my stored procedure (WEA_InsertClaim) - right click and select Debug.
i am prompted to enter the parameter values, which i do, auto rollback checkbox is checked - click Execute.
T-SQL Debugger opens and runs through the stored procedure.
but only buttons enabled are the "Go", "Toggle Breakpoint", "Clear All Breakpoints"
so i can set breakpoints etc. but when i select Go it will not stop at the breakpoints it just runs through the stored procedure from start to finish. giving the correct return code as its output
is there something i need to enable in order to make it stop at breakpoints??
Cheers,
Craig
View 3 Replies
View Related
Jul 20, 2005
Hi,I've written a job to export user and database permissions for alld/b's on a server. As you can see below, the T-SQL commands are thesame for each d/b. Can anyone assist with regard to re-writing this sothat any new d/b's added do not require ammending the job (loop)?Thx,GC.use mastergoSELECT db_name()EXEC sp_helpuserEXEC sp_helprotect NULL, NULL, NULL, 'o s'use msdbgoSELECT db_name()EXEC sp_helpuserEXEC sp_helprotect NULL, NULL, NULL, 'o s'use test1goSELECT db_name()EXEC sp_helpuserEXEC sp_helprotect NULL, NULL, NULL, 'o s'use test2goSELECT db_name()EXEC sp_helpuserEXEC sp_helprotect NULL, NULL, NULL, 'o s'
View 1 Replies
View Related
Feb 15, 2006
Is there a good step by step guide to setting up an indirect configuration? I've followed the steps in Kirk Haselden's 'Keep your packages in the dark' article 3 or 4 times this afternoon and nothing seems to work. I cannot even get the XML configuration file to work by accessing it directly. I'm using the wizard to create the file.
Just wondering if there was something else out there....
Thanks in advance for any help.
MarkA
View 3 Replies
View Related
Jan 5, 2004
Can anybody explain how to do debug a stored procedure from SQL Query Analyser.
When i tried opening Query Analyser and pressing F8 i am able to see Object Browser on left side, i selected the d/b and expanded it then i selected a stored procdure by right click of mouse. I selected "Debug".
It shows me alert msg "SQL Debugging may not work properly if you log on as 'Local System Account' while SQl server is configured to run as a service. You can open Event Viewer to see details." DO U WISH TO CONTINUE- I selected "YES"
I am able to see 3 split windows on right side and GO, Toggle, Untoggle are enabled BUT Step Into, Step Over, Step Out...Stop debugging are disabled at menu bar.
The 1st right split window shows the proc code, 2nd split window shows Local-Global-Callstack none of them shows any values(blank), 3rd split window shows records(result) and
@RETURN_VALUE = 0 message
I had Toggled at each and every line of the procedure in 1st split window still it doesnt respond anything.
What might be the problem, how to solve it do i need to give any permissions.
i tried logging from wind Authentication and also from Sql Authentication (sa/sa), still same problem occurs. By the way i am using SQL Server 2000.
Pls help me out
Thanks in advance
Murali Kumar
View 1 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
