InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 14:23:21 GMT20http://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxCheck for the maximum number of connections that the os allows to the workstation. It may be 10 for non-servers. Whatever the number, only that many SQL connections can be made concurrently at any given time.Thu, 06 Dec 2012 08:43:30 GMTvikingDBAhttp://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxEsentially that machine would have to be turned on all the time, so clients could connect to it and maintenance such as database backups, etc, could be run. That machine would have to be acting as a server. If it has Windows XP or 7 operating system on it, then I think there may be some licensing considerations as to how many clients could connect to it, but I'm not really an expert at that.Thu, 06 Dec 2012 07:08:10 GMTChris Harshmanhttp://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxWhat I mean is if the express edition is not installed in a system which is not configured as a server.. Can this be used to create a centralised DB which could be accessed from the client machines.Wed, 05 Dec 2012 22:53:05 GMTsripriya_khttp://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxI'm not sure what you mean by install on a TP (not a server)?Wed, 05 Dec 2012 13:01:47 GMTChris Harshmanhttp://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxThanks a lot for your response. Please do let me know if we can use the express edition in a normal TP for creating a centralised DB instead of having it on a server. Assume I have the express edition installed on my TP (which is not a server). I create a DB. This DB has to be linked to MS Access DB from various locations (a synchronisation of the two db's the local and the centralised). Would installing Express edition solve the above purpose. Also, let me know if Express edition is better than Mysql.Thanks in advance. Regards,K. SripriyaTue, 04 Dec 2012 22:10:47 GMTsripriya_khttp://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxManagement Studio Express is the client-side tool that you can use to create, setup, and administer a database that is local or on a server. If you're asking if SQL Server Express could act as that central database, the answer is, it depends. ;-) Check if Express has the features you need:[url]http://msdn.microsoft.com/en-US/library/ms143761(v=SQL.90).aspx[/url]Of course for a new system, you'd probably want to consider SQL Server Express versions 2008 R2 or 2012[url]http://msdn.microsoft.com/en-us/library/cc645993.aspx[/url]the newer versions allow a database up to 10 gigabytes in size instead of just 2, and will be supported longer. To synchronize an Express database with Access will require you to do the coding to update the data, and handle cases where data is modified in local Access and central SQL Server db between synchronizations.Tue, 04 Dec 2012 12:25:35 GMTChris Harshmanhttp://www.sqlservercentral.com/Forums/Topic1392632-149-1.aspxHello All,We are trying to create a centralised DB which could be used from a client location. Please let me know if Management studio express could be used for this purpose.Its not a complex one. Everytime a user logs in to a standalone application, the ms access db has to synchronise with the centralised db based on network availability and vice versa when required. Could this be achieved using Studio express 2005.Basically could Management studio express be used to create a Database?Thanks in advance.Regards,K. SripriyaTue, 04 Dec 2012 11:09:46 GMTsripriya_k