Installation problems

I have installed MSDE locally on Windows XP Pro, just for
testing SQL Server CE 2.0 on a PocketPC.
I know that one other application can create and access
data tables,
but osql does not work at all, except for the statement
osql -E -Q "SELECT * FROM syslogins"
I assume that 'Pubs' is a default database that is
supposed to be installed. How can I verify that?
hi Nils,
Nils wrote:
> I have installed MSDE locally on Windows XP Pro, just for
> testing SQL Server CE 2.0 on a PocketPC.
> I know that one other application can create and access
> data tables,
> but osql does not work at all, except for the statement
> osql -E -Q "SELECT * FROM syslogins"
what kind of error are you reported with?
if your login account has been granted database access to master database
and have read permission on system table (bad :D) you should be able to
query it, else you will be reported with something like
Server: Msg 230, Level 14, State 1, Line 1
SELECT permission denied on column 'password' of object 'syslogins',
database 'master', owner 'dbo'.

> I assume that 'Pubs' is a default database that is
> supposed to be installed. How can I verify that?
the Pubs and Northwind sample database are not installed by MSDE in order to
limit it's distribution size, so you have to download them separately at
http://msdn.microsoft.com/library/de...ionutility.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I found another useful hint by you: I will try that!
MSDE installs by default disabling network protocols to prevent external
mailcius attacks...
you have to manually enable them, bot at install time providing the
DISABLENETWORKPROTOCOLS=0
parameter to setup.exe boostrap installer and/or later using the Server
Network Utility (svrnet.cn.exe) to enable the desired/required network
protocol (usually TCP/IP)
Andrea Montanari (Microsoft MVP - SQL Server)
"Andrea Montanari" wrote:

> hi Nils,
> Nils wrote:
> what kind of error are you reported with?
> if your login account has been granted database access to master database
> and have read permission on system table (bad :D) you should be able to
> query it, else you will be reported with something like
> Server: Msg 230, Level 14, State 1, Line 1
> SELECT permission denied on column 'password' of object 'syslogins',
> database 'master', owner 'dbo'.
>
> the Pubs and Northwind sample database are not installed by MSDE in order to
> limit it's distribution size, so you have to download them separately at
> http://msdn.microsoft.com/library/de...ionutility.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>