We have a win2003 server box that is using MS-SQL 2000. We have a 20
user license on this server at the present time. We have a need to
allow up to 5 simultaneous additional users access to a subset of this
data from our IIS server. How does this affect my current SQL Server
License? We can restrict access via connection pooling, etc. Can we
use a 30 user license or must we go to a CPU license? Does anyone
know where to find Microsoft licensing information on this?
The computers here at work run Windows 2000 5.00.2195 SP4. Everything checks out with the minimum requirements at http://msdn.microsoft.com/vstudio/express/support/sqlreadme/#_3462_setup_issues_238p
However, one of the "Reports" from the installation says the machine does not meet the minimum requirements, but provides no details. It installs and I have Admin rights on this machine, but I can't even connect to the Northwind database that I downloaded.
Is this due to our logging process where the "system" is actually in another country? (ie, "CITYNAME/Username"
I have to audit a number of servers and tally with source installation CDs. How can I tell which CD license key has been used on a server , i.e. where (I assume in registry) is the license key held ??
SQL 2000 pricing and licensing is quite confusing, and even more pain including the upgrading pricing from sql6.5/sql7.0.
I got very clear Windows2000 pricing and upgrading from one Microsoft web address. But just could not find a ONE Microsoft web sit explicitely describe the $ pricing for each of SQL2000 edition (per processor vs. CAL..., including upgrading from SQL 6.5, SQL 7.0). May be I missed that site?
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
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.
We have a product which uses SQL Server 2000 Enterprise Edition with Per Seat licensing option. Going forward with a new release of the product, we intend to upgrade to SQL Server 2005. Till now our product was being used in non web based scenarios so the Per Seat licensing option helped our case. In the upcoming release which would use SQL Server 2005 we need to break off from the non web based scenario as the product would use SQL Server over internet. So isn't it correct to go for the Processor based licensing instead of the Per seat licensing ?
If so then what would be the ideal manner to upgrade the license from Per Seat (in SQL Server 2000) license type to Processor based (in SQL Server 2005) license type ?
I have heard of Software Assurance providing assistance in version upgrades. Would it help in case I need to upgrade from one license type to another ? Or is it applicable only in case of upgrade where the license type is fixed ?
Hi, I have downloaed microsoft's Best Practice Analyser for SQL Server 2000. I would like to recomend this tool in our organisation. Before that i want to confirm that is there any restrictions to use this tool or it is an free ware tool.
This is taken directly from a job requirement (names are not mentioned to protect the ignorent...I meant Innocent): The employee must occasionally lift and/or move up to 25 pounds. While performing the duties of this job, the employee is frequently required to stand; walk; sit; talk or hear; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl.
I am considering buying a new home PC but want to make sure it can handle SQL 2005. Most of what Im looking at comes with XP Home edition. I found this:
saravanan writes "hi, At present i am a B.E. i am quite intrested in sql servers. i want to be a full fleged DBA. so please guide me , what are the basic requirements and necessary exams to be given for the same and become a DBA in a minimum required time?"
For SQL 2000, what are the licensing requirements for a clustered environment? I thought you needed datacenter for the OS, is there a clustered version of sql server, or do you need 2 copies of enterprise edition. Also, if you cluster can you license sql cals for clients, or do you have to do by processor?
I have a sql server (2k sp4), a web server and a development machine. I need to install sql server reporting services and am confused as to the prerequisites and as to what gets installed where. Is there a server install and a client install or do I run the same install on both (and deselect what's not required on each). Sorry it's a bit vague but in my research various people have told me various different things.
I couldn't find an answer anywhere on the site, if there is one, could you please let me know where to go? Thanks.
Here goes. We receive large csv files, around a million records a month. What we need to do is: - Of course, import these records - Be able to run failry heavy reports on around 3 months worth of data (about 3 million records) - Wanting to store at least a years worth of data
What I need to know: - What server(s) spec (CPU, HDD, memory, etc) would we need to import and run reports quite fast. Don't want the reports/imports to take days to run. The reports will need to be run by about 3-5 people at the same time - What OS and database type should I use (I was looking at Windows/Linux and MS SQL/MySQL) - If we run these types of reports, can we use the same SQL server to run/store other applications (eg. CRM, etc) with no real impact on performance. There would be at least 20 people using the CRM database at the same time.
Can 2005 be installed on XP Media Center Edition? I looked on the SQL site, but it only references Windows XP, not this particular version. Any whitepapers, links, etc., would be especially appreciated.
What are the minimum requirements for setting up replication ? i mean, the connection requirements, bandwidth requirements, minimum hardware and software requirements ?
Is it possible to setup a replication across the internet ?
I have seen it mentioned that, unlike with the MSDE where DTS runtime was covered, the new SSIS is not covered by the SQL Server 2005 Express.
Does anybody know of an official microsoft web page detailing comprehensively what is required.
As far as I can gather the client will need a full version of SQL Server 2005, enabling the installation of the client tools, which as far as I can tell are required for the running of the SSIS.
This statement could be totally wrong but clear information seems hard to come by and seems mainly hearsay.
What security settings are needed to allow users to veiw reports using SQL Server 2005 Reporting Services Web interface. We have tried adding users to Active Directory Groups and adding these groups to: the security of the folder containing the reports in Reporting Services and the security of the individual reports in Reporting Services. What am I missing? Does something need to be set when creating the report itself?
Just one quick question, will installing reporting services require the server to reboot or sql to restart? I'll do this to a production server and just wonder if I can do while the box is in use.
I recently was moved into an applications developers position here at the lawfirm I work at. Thusfar, its been alot of straight ASP, SQL2000, and Access. I know the need for me to know .Net is coming, and Ive decided to start playing with ASP.net so I can look a bit proactive.. Ive looked over what I need to get started, in liu of Visual Studio I know of the VS Express options. However, I currently have SQL Server 2000 installed locally on my machine along with IIS 5.1. All the VS Express information Ive found keeps referencing SQL2005 express. Can I get away with using what I already have with 2000? Or if not, can SQL2005 express be run alongside with SQL2000? Any assistance would be greatly appreciated. Brian
hello, What are the requirements to install sqlserver2005 in my pc.I am using windows xp sp2 in my pc. One of my friend said, windows server2003 is compulsory(to get data base functionality in sqlserver 2005 and other features) in local pc .Is it correct? And i am not getting database features in xp sp2. Can any one help me?
Does anyone know where can i find an information about hardware requirements for SQL-Server 2000. I mean information of different kind of cases (amount of users and transactions etc).
I had some issues yesterday with the fact that some of the tables I had indexed views for did not have a unique/clustered index. The tables had unique indexes and clustered indexes but not a unique/clustered index. What I was seeing were rows that should have been in the view, not showing up in a regular select but they would showup in a with noexpand hint.
To fix the problem I created a unique/clustered index on each of the underlying table but cannot find that requirement anywhere, is this a requirement and if so can someone tell me where to find it.
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
We€™re doing a website for a TV station, and they want to have a live TV broadcast on their website, our experience is basically in CMS and portal solutions, but we never had any experience in live streaming, so this is all new to us, so we€™re looking for a technical and financial proposal with your suggestions and recommendations, this is the details of the project with some of the inquiries we have: -The signal is SDI (Pal 25 fps) -The output (online streaming) 15 fps -The user will have two options to view the movie in: 1. Low: 56K 2. High: 300K -The video should come within a customized designed page, probably as a code we can place inside an html table€™s cell, not as a link for external link -We€™re expecting about 200 users for the video each month; each user€™s logon time expected 10 min. -We have a Red hat Linux on our server that will host the site, and we use php/MySql technology.
Inquires: 1. Why Windows media is better then Real in terms of performance, can you provide us with a comparison table to include it to our client? 2. If we choose Windows media, what are the requirements we need to have, form both; the TV station side, and in our Linux server? And how much would it cost? 4. Is there any hardware required from the TV station side such as DVR, or some sort of encoder, if so; what€™s you€™re recommendations (type/ brand), please note that this is a TV station and it needs a high quality professional hardware 5. How (and this is probably the most ambiguous task) 5.1. Do you broadcast the digital signal coming from the encoder (I guess) to the server? 5.2. And then place this signal on a PHP page? Do you give us a link to embed in our code? 6. If we choose to host the live streaming on a separated server and include the URL in our code, would that still required from our server to support Windows media, or it doesn€™t matter as long as the video streaming is hosted on a Windows streaming server 7. How much disk space does it need to host a live streaming (with the details mentioned above)?
We would really appreciate your comments and suggestions, as this is our 1st time to dealing with live streaming.
Hi all. First, please accept my apologies for any obvious questions, as im very new to this!Anyway, 2 small questions: I dont have the 'server running' icon in the system tray... The little grey box with a green arrow. have i installed SQL incorrectly? This leads my to my other question:- After installation (which, i think went fine), i learnt that SQL Server Express cannot run with more than 1 CPU. But i have a Duel-Core. Would this cause problems?
Again, sorry if if missed any previous posts on this.
I have been advised to design multidimensional model based on the operation data model. What I have is ---- Couple of documents about the application. Data model of operational data. Now I have been told to create a datawarehouse from which any type of wuestion can be answered. This seems horrendous. Please guide.
We need to create a SQL server login that should not be having permissions to do any changes (CREATE/ALTER/DROP) on database objects like (Tables, views).But should be able to (CREATE/ALTER/DROP) stored procedures. Also using this login they should not be able to (CREATE/ALTER/DROP) databases.
Please let me if this is feasible in SQL Server 2005.
I'm developing a website that will be suported by a SQL Server database. The estimated number of records for that database will be around one million. I'm concerned with the possibility of my machine being unable to respond to the needs of such a database so i decided to acquire a new one. How do i calculate the hard disk and RAM i'm going to need for this database to function properly ? I know that i can make a HD prediction by adding the sizes of each field of my database and multiplying by one million but i don't know how much KBs each field occupy (some of them -few- will even be free text fields). And the RAM ?
