SQL server licenses needed for Back End Access

[kscheu via AccessMonster.com]

I have an Access front end application that links to Access Back end tables
located on a server. The Front End application is used by approx. 50 users,
some internal and some thru Term Server. I am planning to convert the
Backend access database to SQL server, but I am confused as to the version of
SQL server to purchase and the licensing required. Will I need a user
license for all 80 users ?
Can I create one SQL server login that all users are aliased to and consider
that one user license?

Thanks,
Karen

[Alex Dybenko]

Hi,
you can try to use a free SQL server express 2005, but looks like you need
to buy a standard version then.
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by kscheu via AccessMonster.com
I have an Access front end application that links to Access Back end tables
located on a server. The Front End application is used by approx. 50 users,
some internal and some thru Term Server. I am planning to convert the
Backend access database to SQL server, but I am confused as to the version of
SQL server to purchase and the licensing required. Will I need a user
license for all 80 users ?
Can I create one SQL server login that all users are aliased to and consider
that one user license?
Thanks,
Karen
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1

[kscheu via AccessMonster.com]

Hi Alex,

I figured I would need either workgroup or standard, but I really wanted to
know how the licensing works? If the users are linking to the back end SQL
Server , or if the front end executes a pass trhough query to sql server that
uses the same user id every time, do I need 80 User licences or just one for
the users?

Thanks,
Karen

Post by Alex Dybenko
Hi,
you can try to use a free SQL server express 2005, but looks like you need
to buy a standard version then.

Post by kscheu via AccessMonster.com
I have an Access front end application that links to Access Back end tables
located on a server. The Front End application is used by approx. 50

[quoted text clipped - 10 lines]

Post by kscheu via AccessMonster.com
Thanks,
Karen

[Alex Dybenko]

Hi,
I think you need 80 users license, but better ask company, which sells SQL
Server, they will know better
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by kscheu via AccessMonster.com
Hi Alex,
I figured I would need either workgroup or standard, but I really wanted to
know how the licensing works? If the users are linking to the back end SQL
Server , or if the front end executes a pass trhough query to sql server that
uses the same user id every time, do I need 80 User licences or just one for
the users?
Thanks,
Karen

Post by Alex Dybenko
Hi,
you can try to use a free SQL server express 2005, but looks like you need
to buy a standard version then.

Post by kscheu via AccessMonster.com
I have an Access front end application that links to Access Back end tables
located on a server. The Front End application is used by approx. 50

[quoted text clipped - 10 lines]

Post by kscheu via AccessMonster.com
Thanks,
Karen

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1

[kscheu via AccessMonster.com]

Thanks for your help. I will try to post again to see if anyone else may
know within this group.

Post by Alex Dybenko
Hi,
I think you need 80 users license, but better ask company, which sells SQL
Server, they will know better

Post by kscheu via AccessMonster.com
Hi Alex,

[quoted text clipped - 21 lines]

Post by kscheu via AccessMonster.com

Post by kscheu via AccessMonster.com
Thanks,
Karen

[Alex Dybenko]

AFAIK - there are 2 kind of licenses - per seat and per processor, so only
knowing details and price of each you can decide which one is best for you
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by kscheu via AccessMonster.com
Thanks for your help. I will try to post again to see if anyone else may
know within this group.

Post by Alex Dybenko
Hi,
I think you need 80 users license, but better ask company, which sells SQL
Server, they will know better

Post by kscheu via AccessMonster.com
Hi Alex,

[quoted text clipped - 21 lines]

Post by kscheu via AccessMonster.com

Post by kscheu via AccessMonster.com
Thanks,
Karen

--
Message posted via http://www.accessmonster.com