Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL install problems with SQL 2000

Status
Not open for further replies.

Rugerx

IS-IT--Management
Apr 10, 2002
4
US
I need to install SQL standard on a laptop for demo purposes. (We access the Database on the same machine our software is on instead of connecting to the Server database.) This laptop will also access SQL server 2000 on our production server. sort of a duel datbase access for our software. First time I loaded the standard 2000 SQL on laptop it worked fine with our software. The user then connected to the production server after that and the SSQLSERVER service log on account was able to change to our production server account and connect. After that I was unable to use our software to connect to the laptop's own SQL. I cahnged the SSQLSERVER service to log on to localMachine to no avail. I then tried to uninstall and reinstall SQL on the laptop and it would no longer load giving me the message that it would only install client connectivety options. Why Does SQL do this when loaded on a so called client machine? and why can't I use my software to connect to my production server and the SQL database located on the same machine? HELP!!!
The os for the laptop is 2000 professional and the production server os is NT..
 
You cannot install sql server standard on a non server machine or more specifically a non server operating system. Win 2000 pro is not a server os. You can install either the development version or MSDE on a non server os.

When you try to install sql server on a non server os, it just installs the client tools (enterprise manager, query analyser etc.)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top