| Groups | Blog | Home |
sql server new users : SQL Server Pricing
Hello,
I am considering moving a company's Access App to SQL Server. I am confused about what I need to accomplish this in the way of Server Software. The pricing on the Microsoft website says, Standard Edition: $2249 with 10 Cals. The SQL Server would be running on one network server, only. Would this be sufficient with an Access front end? I plan to convert the front end to an Access Project. I am making the change for security, not functionality. The owner is worried about employees stealing the data. Thanks for any advice and God Bless, Mark A. Sam
How many users do you have? if its 10, then you read correctly. You need a
CAL for each user... save a little here: http://www.cdw.com/shop/products/default.aspx?EDC=233827 -- Kevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. www.experts-exchange.com - experts compete for points to answer your questions [quoted text, click to view] "Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message news:%23RyYs7QkFHA.1464@TK2MSFTNGP14.phx.gbl... > Hello, > > I am considering moving a company's Access App to SQL Server. I am > confused about what I need to accomplish this in the way of Server > Software. > > The pricing on the Microsoft website says, > > Standard Edition: $2249 with 10 Cals. The SQL Server would be running on > one network server, only. Would this be sufficient with an Access front > end? I plan to convert the front end to an Access Project. I am making > the > change for security, not functionality. The owner is worried about > employees stealing the data. > > Thanks for any advice and God Bless, > > Mark A. Sam > >
Yep...the basic SQL install is about 10 minutes. SP3 is longer, then you
should go to MS03-031 or SP4. I have not tested SP4 yet. If you are using Access MDB, you need a DSN on each client machine. If using ADP, you configure the connection under File>>Connection in the ADP front-end and distribute it to the users. It will work for all of them, assuming they can all see the SQL Server (i.e same LAN) -- Kevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. www.experts-exchange.com - experts compete for points to answer your questions [quoted text, click to view] "Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message news:Os2$RESkFHA.3164@TK2MSFTNGP15.phx.gbl... > Thanks for the reply. There will probably be less than 10 concurrent > users. > > Here is another question if you will. Does SQL Server install as easily > on > a network as on a desktop? I intalled the free version without a problem. > After I register a database, do I simply create DSN's to make it available > on the desktop? Is it that easy? > > God Bless, > > Mark > > > "Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message > news:etLi$3RkFHA.3288@TK2MSFTNGP09.phx.gbl... >> How many users do you have? if its 10, then you read correctly. You >> need > a >> CAL for each user... >> >> save a little here: >> http://www.cdw.com/shop/products/default.aspx?EDC=233827 >> >> >> >> -- >> Kevin Hill >> President >> 3NF Consulting >> >> www.3nf-inc.com/NewsGroups.htm >> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. >> >> www.experts-exchange.com - experts compete for points to answer your >> questions >> >> >> "Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message >> news:%23RyYs7QkFHA.1464@TK2MSFTNGP14.phx.gbl... >> > Hello, >> > >> > I am considering moving a company's Access App to SQL Server. I am >> > confused about what I need to accomplish this in the way of Server >> > Software. >> > >> > The pricing on the Microsoft website says, >> > >> > Standard Edition: $2249 with 10 Cals. The SQL Server would be running > on >> > one network server, only. Would this be sufficient with an Access > front >> > end? I plan to convert the front end to an Access Project. I am >> > making >> > the >> > change for security, not functionality. The owner is worried about >> > employees stealing the data. >> > >> > Thanks for any advice and God Bless, >> > >> > Mark A. Sam >> > >> > >> >> > >
Thanks for the reply. There will probably be less than 10 concurrent users.
Here is another question if you will. Does SQL Server install as easily on a network as on a desktop? I intalled the free version without a problem. After I register a database, do I simply create DSN's to make it available on the desktop? Is it that easy? God Bless, Mark [quoted text, click to view] "Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:etLi$3RkFHA.3288@TK2MSFTNGP09.phx.gbl... > How many users do you have? if its 10, then you read correctly. You need a > CAL for each user... > > save a little here: > http://www.cdw.com/shop/products/default.aspx?EDC=233827 > > > > -- > Kevin Hill > President > 3NF Consulting > > www.3nf-inc.com/NewsGroups.htm > > www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. > > www.experts-exchange.com - experts compete for points to answer your > questions > > > "Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message > news:%23RyYs7QkFHA.1464@TK2MSFTNGP14.phx.gbl... > > Hello, > > > > I am considering moving a company's Access App to SQL Server. I am > > confused about what I need to accomplish this in the way of Server > > Software. > > > > The pricing on the Microsoft website says, > > > > Standard Edition: $2249 with 10 Cals. The SQL Server would be running on > > one network server, only. Would this be sufficient with an Access front > > end? I plan to convert the front end to an Access Project. I am making > > the > > change for security, not functionality. The owner is worried about > > employees stealing the data. > > > > Thanks for any advice and God Bless, > > > > Mark A. Sam > > > > > >
Whether users are concurrent or not doesn't matter with licensing for SQL
Server 2000 (it did for SQL Server 7). You need a license for every user that accesses the server. But if the number of users is that small, and you are upgrading from Access, MSDE is probably suitable for your purposes. It is absolutely free to download from http://www.microsoft.com/sql/msde/downloads/default.mspx -- Jacco Schalkwijk SQL Server MVP [quoted text, click to view] "Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message news:Os2$RESkFHA.3164@TK2MSFTNGP15.phx.gbl... > Thanks for the reply. There will probably be less than 10 concurrent > users. > > Here is another question if you will. Does SQL Server install as easily > on > a network as on a desktop? I intalled the free version without a problem. > After I register a database, do I simply create DSN's to make it available > on the desktop? Is it that easy? > > God Bless, > > Mark > > > "Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message > news:etLi$3RkFHA.3288@TK2MSFTNGP09.phx.gbl... >> How many users do you have? if its 10, then you read correctly. You >> need > a >> CAL for each user... >> >> save a little here: >> http://www.cdw.com/shop/products/default.aspx?EDC=233827 >> >> >> >> -- >> Kevin Hill >> President >> 3NF Consulting >> >> www.3nf-inc.com/NewsGroups.htm >> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. >> >> www.experts-exchange.com - experts compete for points to answer your >> questions >> >> >> "Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message >> news:%23RyYs7QkFHA.1464@TK2MSFTNGP14.phx.gbl... >> > Hello, >> > >> > I am considering moving a company's Access App to SQL Server. I am >> > confused about what I need to accomplish this in the way of Server >> > Software. >> > >> > The pricing on the Microsoft website says, >> > >> > Standard Edition: $2249 with 10 Cals. The SQL Server would be running > on >> > one network server, only. Would this be sufficient with an Access > front >> > end? I plan to convert the front end to an Access Project. I am >> > making >> > the >> > change for security, not functionality. The owner is worried about >> > employees stealing the data. >> > >> > Thanks for any advice and God Bless, >> > >> > Mark A. Sam >> > >> > >> >> > >
Thanks Jacco. I did a check and discovered that this company has SQL Server
installed and I have already begun moving the data.
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |