How to Install SDS4 on a Network

For Domain Networks /Users

On the Server
Make sure your user is in active directory
In SQL Management Studio – (or enterprise mgr)
Be sure your Domain User is in the Master Security/User Logins Container Be sure your Domain User is in the [Your Database]Security/ User Logins Container

On the WorkStationFrom Control Panel /UsersBe sure that the Domain User Account is listed in the Users Container
We recommend giving the Domain User [administrator] rights
This gives them the freedom the will need to create spreadsheets, pdf’s html emails on the local hard drive.

You can now run setup.exe
Follow the onscreen directions of the installer

If prompted
Select Windows Authentication in the connection manager to automatically
give you access to your desired databaseClick Connect

For Workstation Networks (peer to peer)

On the Server (if you have one or the machine that has SQL installed)
Be sure your user is on the same IP subnet and is in the same workgroupYou should be able to first see all the computers in your work groupIf you can not see any other computers on the network check your NetBios/NetBEui/IPX SPX settings

In your SQL Server configuration Set Authentication to mixed mode
Write Down your sa password and store it in a safe place Your workstations may use this sa password to set sql connection. (it is the easiest)

On the other Workstations

Be sure your user is on the same IP subnet and is in the same workgroup
You should be able to first see all the computers in your work group
If you can not see any other computers on the network check your NetBios/NetBEui/IPX SPX settings
You can now run setup.exe
Follow the onscreen directions of the installer

If prompted
Use SQL Authentication in the connection manager to loginto your desired database

Username sa
Password [sa password]

Click Connect

Was this helpful?