Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 I am unable to install sql server 2000 on lan.

Author  Topic 

spacetake123
Starting Member

4 Posts

Posted - 2009-03-12 : 07:59:30
I am new to sql server. I have an .exe file which does not run until you install sql server on your pc and and change your pc name to "server" along with attaching the given database files which have come with the .exe file in the sql enterprise manager. How ever I have a LAN connection where 15 pcs are connected. I am unable to change each and every computers name to server so I am unable to access the .exe file on the LAN. I want to install sql server in one pc and access it from all computers. Help me!!!!!!

Anubhab Satapathy

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-12 : 10:42:47
Do you have the setup disks for SQL Server 2000? Which edition? And what Operating System are you trying to install it on?



--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/
Go to Top of Page

spacetake123
Starting Member

4 Posts

Posted - 2009-03-13 : 01:00:12
Dear Mr. Gupta, I have a set up disk of SQL server 2000 personal. It is of the personal edition and as far as operating system is concerned it is Windows XP (SP-2). I have 19 systems on LAN, I want to access it on all the systems.

Anubhab Satapathy
Go to Top of Page

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 01:10:18
If you are using personal edition be aware it is limited version of SQL Server and does not allow full size DB work. But you should be able to install it it on WIndows XP, ref: http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx.

When you run the setup on your computer, using setup.exe from the CD; is there an error message?

Thanks.



--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/
Go to Top of Page

spacetake123
Starting Member

4 Posts

Posted - 2009-03-13 : 01:38:23
Dear Mr. Gupta, thank you very much for your replay. How ever I would like to tell you that I am not fetching any kind of problems with installing sql server 2000 personal edition on a standalone PC. The PC which is not connected to any other PCs. If you do not mind can I make you a call?

I just need to access the same on my LAN. I want each and every computer to be connected with SQL on LAN. Thanking you..

Anubhab Satapathy

Anubhab Satapathy
Go to Top of Page

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 01:43:06
Phone Call? Not possible, its 11:45PM here I am heading bed soon heh. Beside I prefer to answer on the form; no worries we'll figure it out.

Okay if you got SQL Server installed on the computer; can you not connect that computer to the network? After you connect it, make your you enable remote connection and try connecting from other computers. Thanks.


--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/
Go to Top of Page

spacetake123
Starting Member

4 Posts

Posted - 2009-03-13 : 01:47:10
Dear Mr. Gupta, thank you very much for your replay. How ever I would like to tell you that I am not fetching any kind of problems with installing sql server 2000 personal edition on a standalone PC. The PC which is not connected to any other PCs. If you do not mind can I make you a call?

I just need to access the same on my LAN. I want each and every computer to be connected with SQL on LAN. Thanking you..

Anubhab Satapathy

Anubhab Satapathy
Go to Top of Page
   

- Advertisement -