jpatto Posted October 31, 2004 Share Posted October 31, 2004 If i installed SQL on a server (WinServ 2003) and required my users to connect to a database that i have on SQL - would i need to install SQL on every machine in order for them to connect to the database? If no how would this be done? and finally how many copies of SQL can i use on different machines?Thanks Link to comment Share on other sites More sharing options...
dneumannjr Posted November 1, 2004 Share Posted November 1, 2004 I have just been working with SQL pretty heavily the last few weeks. You will need an SQL client access license for each workstation that will be connecting to that database and all that needs to be done on the workstation is a database for that connection for the application to use.I am sure that there are others here with more SQL experience that can elaborate for you on this a little more. Link to comment Share on other sites More sharing options...
tguy Posted November 23, 2004 Share Posted November 23, 2004 jpatto is right, you will need an SQL CAL (client access license) for each machine connecting to the SQL server.You can then create ODBC connections to the server to connect your application like Microsoft Access or something to the SQL database. If your users will need to actually create and run queries against the database, create views, create DTS packages, etc. they will need the SQL client install tools.These can be installed by inserting the SQL Server CD-ROM in their CD-ROM drives and selecting 'Client Tools' as the installation option.Hope this helps. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now