Showing posts with label manage. Show all posts
Showing posts with label manage. Show all posts

Saturday, February 25, 2012

Access rights for surface configuration and managing sql services

If I need access rights to manage sql services(surface area config) in a
cluster server.
What kind rughts do I need? local admin?
Thanks
A SQL cluster and a regular SQL install require the same permissions and act
alike
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uNPSKbBtHHA.508@.TK2MSFTNGP02.phx.gbl...
> If I need access rights to manage sql services(surface area config) in a
> cluster server.
> What kind rughts do I need? local admin?
> Thanks
>

Monday, February 13, 2012

access front end

i am almost finished building the front end for an application to manage restaurants. i am developing the front end with access vba, and intend to use sql server as a back end for the service. i just came across a group of people bashing access developers on a different site. i have several restaurants interested in using the service, and believe that the service should be very successfull (i have a very specific customer base that is currently not being targeted). the access component would not be a multiuser application. before i distribute the app i would appreciate any input. am i getting myself into trouble using access vba? should i run scared and switch to a vb.net web service?
thanks in advance for any thoughts.I think an Access front-end with a SQL Server back-end is perfectly appropriate for small-to-midsize applications.

IF.....
you create an Access Data Project, and not just an mdb file with linked tables. That may get you into trouble.