Posted on 2011-09-03
I am hoping to implement SQL Server as the server software at work. I am currently in the position where I am using Access 97 and Access 2003.
So far Access has performed well but I am concerned that the extensive use of Access within my organisation is worrying. Not because it underperforms but because all I read about is the lack of stability and security that it offers.
As a starting point can anyone advise me or guide me on how to begin to install SQL server. The requirements both in terms of sofwareand hardware, eg Do I need a Domain Controller?, do I need powerful servers? How do I integrate MSaccess with SQL Server? etc.etc. I have attempted to install the Express version on a standalone PC (with XP) but to no avail. I would prefer in my initial stage to read over readable and simple to understand "stuff" rather than Server manuals. I am looking for , websites, articles, etc.
Please note that I am totally new in this area (but willing to learn!)
Grateful, therefore for advice.