Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server 2008 Express Edition Multiuser support

Author  Topic 

evrimagha
Starting Member

5 Posts

Posted - 2009-07-20 : 10:44:59
Hi

I want to develop a database using sql server 2008 express edition. This database will be hosted on win server 2003 and a simple application (in vb .net) that accesses this database will be installed on 6 clients (win xp).

Is it possible to enable network access and multi-user access on sql server express 2008? Can you advise on performance issues?

Many thanks

SkotCollinz
Starting Member

8 Posts

Posted - 2009-07-20 : 10:58:40
This won't answer your question but have you thought about using Enterprise edition? Unless of course you're just testing, in which case i'll shush

http://msdn.microsoft.com/en-us/library/cc645993.aspx
Go to Top of Page

evrimagha
Starting Member

5 Posts

Posted - 2009-07-20 : 11:04:53
Thank you for your feedback.

At this stage, it is a test but if all goes well with application development and database implementation, other versions of SQL Server will be seriously considered.

So what do you advise?
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-07-20 : 11:22:30
I always go the cheap route to start,
But i would give your boss the pricing for sql now. soften the blow when you need to grow.
Go to Top of Page

SkotCollinz
Starting Member

8 Posts

Posted - 2009-07-20 : 11:33:19
As tripodal said, in the test stage express will be fine, soften the blow with the price for one of the larger versions.

I haven't had a in-depth look at the link above but i think Standard or Enterprise will be your best bet, purely for the behind-the-scenes stuff such as recovery, indexing and more importantly, backups. That said, i've never used Express and i'm sure one of the more experienced guys will be able to tell you more. But Enterprise would get my vote
Go to Top of Page

evrimagha
Starting Member

5 Posts

Posted - 2009-07-20 : 16:29:02
Thank you for your suggestions
Go to Top of Page
   

- Advertisement -