Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Can I use Microsoft SQL Server 2000 Personal Edition as a stand alone server?

I have a low-transaction system, and I wanted to put SQL Server 2000 personal edition on an XP Pro box as a stand alone system and have other systems on the network look to this box for its database. I've read a bunch of Microsoft articles, and it does not say that it restricts personal edition from remote connections, but I have not been able to see the database remotely. I'm using SQL Server authentication, so I shouldn't need to share any file directories, right? Any advice/ideas would be great.

3 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    You're still going to have to set up a network share, or you're not going to see it through the network.

  • 1 decade ago

    Yes you can install MS SQL Server 2000 Personal Edition on an old XP Pro box; it meets the minimum criteria. As long as you have already established a domain with your other systems, you shouldn't have any problems. Simply add the standalone server to the network. Afterwards allow access two the files or database specified.

  • Anonymous
    5 years ago

    constructive you're able to set up MS sq. Server 2000 very own version on an previous XP expert field; it meets the minimum standards. as long as you have already time-honored an cyber web website which comprise your distinctive structures, you may no longer have any matters. fairly upload the standalone server to the community. Afterwards enable get entry to 2 the strategies or database precise.

Still have questions? Get your answers by asking now.