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..
The os for the laptop is 2000 professional and the production server os is NT..