You can find a great reference to this topic at:
http://www.connectionstrings.com/sql-server-2005

Again because AC4's database is SQL Server, you should not, repeat should not, have to INSTALL THE APPLICATION on the server. The database should be installed on your Windows server, and each client machine would simply point it's connection string to the server.

If AC4 is using ODBC you would have to modify the ODBC connection, on each client, to point to the server.

If it is using ADO.Net you would have to modify the connection string in the App.config file.

Note: the INSTALLATION program should ASK YOU for the server information and create this connection string automatically.

In a Client-Server environment, the SOFTWARE is on the Client Machines and the Database is on the Server.


Last edited by gkfahnbulleh; 01/11/2009 2:28 PM.
"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler