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.
2006-08-23 10:29:29 · 3 answers · asked by Geni100 3 in Computers & Internet ➔ Computer Networking
You're still going to have to set up a network share, or you're not going to see it through the network.
2006-08-23 12:59:55 · answer #1 · answered by antirion 5 · 0⤊ 0⤋
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.
2006-08-23 11:10:26 · answer #2 · answered by Swordfish 6 · 0⤊ 0⤋
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.
2016-11-05 11:41:06 · answer #3 · answered by Anonymous · 0⤊ 0⤋