My program uses a database. Does the end-user have to have SQL server 2005?

My program uses a database. Does the end-user have to have SQL server 2005?

It uses it to keep track of members so the database is in the installation folder and does not need to be accessed remotely

http://i130.photobucket.com/albums/p247/tarkster2/screen.gif

the above shows this error on another persons computer. they do not have sql server.

It depends on your application. If it is a web application, then you only need SQL server for the application itself but the end users don't need. If it is a client server application, it will depend on how the client is implemented. If the client accesses the database directly then you will need a client access license. If only the server does, then you only need 1 SQL Server for the server application.

Read the following articles that discuss the licensing schemes:

http://www.microsoft.com/sql/howtobuy/default.mspx

http://www.microsoft.com/sql/howtobuy/faq.mspx

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

I'm not sure if I helped but I hope I answered your question. If not, please give more details on how the application is implemented.

Best regards,

Sami Samir

|||

End users do NOT have to have SQL Server -however they MUST have a license to use SQL Server -even if their usage is through a web server. Each user MUST have either a 'Client Access License' (CAL), or if there are many users, it may be less expensive to purchase a Server based 'Processor' license -which allows unlimited users without each user needing a CAL.

However, in your situation, it seems that the user is receiving an error because the remote SQL Server is not allowing remote connections. Remote connections MUST be allowed in order for other user at other computers to access the SQL Server.