Upgrading SQL

Viewing 1 post (of 1 total)
  • Author

  • swkent

    I am not very well versed in SQL. I have a client that runs their business on a SQL database with an Access 2003 front end. The database currently runs on a PowerEdge 2800 running Server 2003 and SQL 2000. The database and frontend were written by someone who basically sat down with a book 12 years ago and whipped the application together.

    The server is getting old and has had a few hardware problems recently and I was looking to get them into something a touch more modern. Server 2012 and at least SQL 2008. The only things that connect to this database are the Access frontends and their website pulls data from it.

    What do I need to do, aside from restore the database to a new server, to get this database moved and functional on a more modern platform? Or do I run SQL 2000 on server 2012? Or do I migrate the machine to a VM and run server 2003 virtually? (Don’t really like this option)

    Thanks for any insight you can offer


Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by: