Mobile 5.0 app can not connect to SQL 2005 Express

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.
All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.
The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.
Any clue? thanks in advance!Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.|||I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> Apparently, that's not a supported configuration. I'd seen that some
> people had tried it and gotten it to work, so maybe MS did something
> active to turn it off.
>|||Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.
phx.gbl...
>I don't know why it wouldn't be supported. I assume you are using
>SQLClient to connect to SQL Express? Do you get an error message on the
>client? Are there any errors in the SQL Express error log?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
> The problem here is it works for SQL 2005 Express in the begining.
> But it's failed after applying windows 2003 patches.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>

Mobile 5.0 app can not connect to SQL 2005 Express

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.
All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.
The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.
Any clue? thanks in advance!Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.|||I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> Apparently, that's not a supported configuration. I'd seen that some
> people had tried it and gotten it to work, so maybe MS did something
> active to turn it off.
>|||Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> glsD:OXJ020chGHA.3756@.TK2M
SFTNGP02.phx.gbl...
>I don't know why it wouldn't be supported. I assume you are using
>SQLClient to connect to SQL Express? Do you get an error message on the
>client? Are there any errors in the SQL Express error log?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
> The problem here is it works for SQL 2005 Express in the begining.
> But it's failed after applying windows 2003 patches.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>

Missing SQL Server Project template

I have VS2005 Beta 2 (build 8.0.50215.44) and the June CTP of SQL Server 2005 Developer Edition installed.

Within VS2005, when I go to File -> New Project, I don't have the "Database" project type under either VB or C#. Which also means that the "SQL Server Project" template is not being offered.

Is there a manual way of adding the template, or some other workaround/solution?

Which SKU of Visual Studio are you using? Visual Studio Express does not have SQL Server project support.

Thanks,
-Vineet.

|||It's the full version of Visual Studio 2005, Beta 2, that was released in mid April.|||Actually database projects are not availble in VS Express and VS Standard editions. It sounds like that is what you have. Can you confirm?|||Which editions of VS.Net 2005 do have the "SQL Server" project templates? Or can they be downloaded from somewhere? (I have not been able to find such a place...)
Many thanks.
|||Nevermind. I have VS.Net 2005 Beta2 and didn't notice that if I expanded the Visual C# under the project types tree, there was a database node which contained the "SQL Server" project template.
Take care.