Installing SQL Server 2000 on XP Pro

• Sue McKay

  Grasshopper

  Points: 23

  More actions

  March 9, 2005 at 11:07 am

  #166320

  I've heard of others successfully installing SQL server 2000 on XP Pro OS in the past.  I'm wondering if anyone has had consistent luck with this install, and how you installed this.  I realize Microsoft will not support this, but I've seen success in the past. 

  Any help or direction will be greatly appreciated!!!

  Thanks!!

   

   

• athurgar

  SSCrazy

  Points: 2816

  More actions

  March 10, 2005 at 12:20 am

  #546295

  SQL Developers Edition should install on this platform.

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  March 10, 2005 at 5:31 am

  #546335

  ...and is supported by Microsoft.

  Also, SQL Server Personal Edition, and of course MSDE, also install and are supported by Microsoft.

  
  
  Mark

• Sue McKay

  Grasshopper

  Points: 23

  More actions

  March 10, 2005 at 5:51 am

  #546340

  Once SQL Server 2000 and MSDE is installed on XP Pro, I can't get it to register/connect.  Error: SQL server does not exist or access denied | connection open.  I've tried using both the default server name ie: "computerxp." and "(local)", also using windows authenication and SQL authen.to connect?

   

  Any suggestions?

   

  Thanks!

• Sue McKay

  Grasshopper

  Points: 23

  More actions

  March 10, 2005 at 5:51 am

  #546339

  Once SQL Server 2000 and MSDE is installed on XP Pro, I can't get it to register/connect.  Error: SQL server does not exist or access denied | connection open.  I've tried using both the default server name ie: "computerxp." and "(local)", also using windows authenication and SQL authen.to connect?

   

  Any suggestions?

   

  Thanks!

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  March 10, 2005 at 6:57 am

  #546356

  Possible problems:

  • I assume that when say "computerxp." that the period is a typo, or do you actually have a period in the name?
  • Is the service running?  Check Services applet (under Administrative tools) to see if MSSQLSERVER service is there and running. 
  • If you see any MSSQL$xxxxxxxxx services, that would mean you have it installed as a named instance, and you would connect using the name <computername>\xxxxxxxxx instead.
  • Did you install with mixed authentication?  The default is windows authentication only, and SQL authentication will not work.  Also, I'm not sure that this is true or not, but if you are not local admin on your machine, you may not be able to connect using Enterprise Manager and using windows authentication.  Try using Query Analyzer.  Or, here's a quick trick to test SQL connections: create a empty text file (on your desktop or in a folder and name it <anything>.udl, then double click on this file and it opens with the DataLinks property window to be able to create and test a connection.  (Also a good way to quickly create a connection string for a program or script, as you can then open this file in notepad.)
  • Are you trying to connect to MSDE from another machine.  By default, MSDE (SP3 and Rev A) does not install with any networking protocols enabled.  You will only be able to connect on the local machine, and you will "SQL browsers" (like SQL Manager or the drop down boxes in EntMgr, QA, DataLinks dialogs) will not see the instance.  You still can type the instance name in directly in each of these and connect.

  Hope this helps

  
  
  Mark