new to sql server 2000
hi,
i have winxp os.i installed sqlserver2000 client tools only in my computer as setup cd does not allow me to other installation.
when i try to start query analyzer it ask for server name but there is no active server in list. when i tried to connect it popup message unable to connect server: ganesh.
whether i will be able to use sqlserver2000 on my single winxp machine or not. please clear my doubts.what i am suppose to do to use it.please guide me
As i no nothing about sqlserver2000,please can u give me link of step by step good tutorials.
[602 byte] By [
ganesh4u] at [2007-11-11 7:36:20]
# 1 Re: new to sql server 2000
Do you have Windows XP Home or Professional Edition? SQL Server works fine on Professional; if you have Home, that may be the problem. You might try MSDE (http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147) or SQL Server Express (http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41) instead.
# 2 Re: new to sql server 2000
hi,
i have winxp professional. and sqlserver2000 enterprise edition.
when i started setup,popup message came,this os does not support server clients tools wiil be installed .and i am able to install client tools only.
now tell me what's problem
# 3 Re: new to sql server 2000
http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx
SQL Server Enterprise Edition requires a server operating system. On XP, you'll have to run Evaluation, Developer, or Workgroup Edition, or use MSDE or SQL Express as I recommended in my previous post.
# 4 Re: new to sql server 2000
hi,
as per your instruction , i installed sqlexpress on my pc . now please give me link or post for good tutorials
# 6 Re: new to sql server 2000
when i tried to install msde following message pops up
" A strong password is required for security reason.Please use sapwd switch to supply same.refer to read me for more details "
i gone through read me but i bit lossed there .
now how to solve this problem.
my os - winxp profession, server -windows server 2000,computer name -ganesh
Please guide me
