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...
>
Showing posts with label app. Show all posts
Showing posts with label app. Show all posts
Friday, March 23, 2012
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...
>
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...
>
Monday, March 12, 2012
Missing system stored procedures
I developed a Pocket PC app that uses merge replication in an isolated
development environment. It worked fine. The I moved to the operational
environment. Synchronization fails with error 2812, "Could not find stored
procedure 'sp_MSgetmakegenerationapplock'". A little investigation shows that
in the development environment, that stored procedure exists, but it does not
exist on the operational SQL Server. (The total sp count on the development
server is 969, on the operational server 930, so other sp's are also
missing). I disabled replication on the operational server and then
reconfigured it, but that didn't help.
The operational SQL Server is SQL Server 2000 Standard Edition running sp3a.
Any ideas why those sp's didn't get created, and how to fix this problem?
There's a message thread out there that suggests that xp_cmdshell is needed
to properly create some replication-related sp's. Is it possible that
xp_cmdshell is missing or disabled? However, when I configure the server for
replication, I don't get any error messages.
You need to reapply the sp. This problem has been observed before.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"PGallez" <PGallez@.discussions.microsoft.com> wrote in message
news:8A112E32-D0BB-4FB5-9A51-B62BBAFBAB01@.microsoft.com...
> I developed a Pocket PC app that uses merge replication in an isolated
> development environment. It worked fine. The I moved to the operational
> environment. Synchronization fails with error 2812, "Could not find stored
> procedure 'sp_MSgetmakegenerationapplock'". A little investigation shows
that
> in the development environment, that stored procedure exists, but it does
not
> exist on the operational SQL Server. (The total sp count on the
development
> server is 969, on the operational server 930, so other sp's are also
> missing). I disabled replication on the operational server and then
> reconfigured it, but that didn't help.
> The operational SQL Server is SQL Server 2000 Standard Edition running
sp3a.
> Any ideas why those sp's didn't get created, and how to fix this problem?
> There's a message thread out there that suggests that xp_cmdshell is
needed
> to properly create some replication-related sp's. Is it possible that
> xp_cmdshell is missing or disabled? However, when I configure the server
for
> replication, I don't get any error messages.
|||Thanks much, I'll give that a try.
"Hilary Cotter" wrote:
> You need to reapply the sp. This problem has been observed before.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "PGallez" <PGallez@.discussions.microsoft.com> wrote in message
> news:8A112E32-D0BB-4FB5-9A51-B62BBAFBAB01@.microsoft.com...
> that
> not
> development
> sp3a.
> needed
> for
>
>
development environment. It worked fine. The I moved to the operational
environment. Synchronization fails with error 2812, "Could not find stored
procedure 'sp_MSgetmakegenerationapplock'". A little investigation shows that
in the development environment, that stored procedure exists, but it does not
exist on the operational SQL Server. (The total sp count on the development
server is 969, on the operational server 930, so other sp's are also
missing). I disabled replication on the operational server and then
reconfigured it, but that didn't help.
The operational SQL Server is SQL Server 2000 Standard Edition running sp3a.
Any ideas why those sp's didn't get created, and how to fix this problem?
There's a message thread out there that suggests that xp_cmdshell is needed
to properly create some replication-related sp's. Is it possible that
xp_cmdshell is missing or disabled? However, when I configure the server for
replication, I don't get any error messages.
You need to reapply the sp. This problem has been observed before.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"PGallez" <PGallez@.discussions.microsoft.com> wrote in message
news:8A112E32-D0BB-4FB5-9A51-B62BBAFBAB01@.microsoft.com...
> I developed a Pocket PC app that uses merge replication in an isolated
> development environment. It worked fine. The I moved to the operational
> environment. Synchronization fails with error 2812, "Could not find stored
> procedure 'sp_MSgetmakegenerationapplock'". A little investigation shows
that
> in the development environment, that stored procedure exists, but it does
not
> exist on the operational SQL Server. (The total sp count on the
development
> server is 969, on the operational server 930, so other sp's are also
> missing). I disabled replication on the operational server and then
> reconfigured it, but that didn't help.
> The operational SQL Server is SQL Server 2000 Standard Edition running
sp3a.
> Any ideas why those sp's didn't get created, and how to fix this problem?
> There's a message thread out there that suggests that xp_cmdshell is
needed
> to properly create some replication-related sp's. Is it possible that
> xp_cmdshell is missing or disabled? However, when I configure the server
for
> replication, I don't get any error messages.
|||Thanks much, I'll give that a try.
"Hilary Cotter" wrote:
> You need to reapply the sp. This problem has been observed before.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "PGallez" <PGallez@.discussions.microsoft.com> wrote in message
> news:8A112E32-D0BB-4FB5-9A51-B62BBAFBAB01@.microsoft.com...
> that
> not
> development
> sp3a.
> needed
> for
>
>
Friday, March 9, 2012
Missing SQL perfmon counters - Problem Solved
SQL perfmon counters are missing. Running SQL 2005 Workgroup (which is a 32 bit app) on a 64 bit OS. Could the counters be missing because of running a 32 bit app on a 64 bit OS? Anyone know? Thanks.try running x86 perfmon (i.e. %windir%\SysWOW64\perfmon.exe).|||Thanks! This worked.
Missing SQL perfmon counters
SQL perfmon counters are missing. Running SQL 2005 Workgroup (which is a 32 bit app) on a 64 bit OS. Could the counters be missing because of running a 32 bit app on a 64 bit OS? Anyone know? Thanks.try running x86 perfmon (i.e. %windir%\SysWOW64\perfmon.exe).|||Thanks! This worked.
Subscribe to:
Posts (Atom)