Sql-server – Need help with SQL Server configuration

installationsql-server-2012

I was planning to buy the SQL Server 2012 standard edition for developing reports and SSIS packages. My company does not have a client-server architecture and the developers are working on their individual machines connected through the Lan.

I am really confused now on how should I configure the installation so that the developers will be able to connect to the server. Do I need to buy an individual licence for each machine (which is quite costly). Is there any alternative to the same?

I have searched the internet for similar solutions but was unable to find any. Please guide me in the right direction.

Thanks in advance.

Best Answer

Install the database engine on the server, then Management Studio on each developer's machine.

Assuming they have permissions, the developers can then use Management Studio to connect to the database on the server.

Because Management Studio is free, you only need to ensure the server-based SQL Server instance is licensed.