Maybe these links will clear some things up.
http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en SSMS Express
http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx Backing up Express
--
Andrew J. Kelly SQL MVP
[quoted text, click to view] "dan" <dan@company.com> wrote in message
news:eCG0gqMoHHA.4900@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> I've been using db2 and mysql for many years and had no major problems
> with connections. They just worked. I just switched to SQLExpress and
> what a mistake! I have 4 machines: 3 clients and 1 server. I can connect
> to the server from one of the client machines but can't from the other 2.
> It makes no difference if I try to connect from my app or Express Studio
> (installed on all machines). I use Windows authentication and I'm logged
> in as Administrator on all client machines. This is so frustrating and
> scary because if I can't do it in my lab then I don't even want to think
> what is going to happen on machines of my customers.
>
> I use the following connection string in my app (it might not be relevant
> since SQLExpress Studio cannot connect either):
> DataTypeCompatibility=80;MARS Connection=true;Integrated
> Security=SSPI;Server=myserver\SQLExpress;Database=mydatabase
>
> Is there 'standard' way of making sure that native SQL client is properly
> installed and configured on a given client machine?
>
> Thanks,
> Dan
>
>
