Olav wrote:
> Hi,
> we are installing our app at different sites. Normally it is a easy
> job, but today we got problems.
> The user had MSDE from before with Win NT authenticaton only. We
> changed this to mixed mode. Then we used OSQL and sp_addlogin.
> Yesterday at another customer this was enough to get access from the
> whole local network. But here we could not access the database from
> even the server! We then used OSQL and sp_addsrvrolemember on the
> login. This enabled us to access the database from the server, but
> still not the workstations!
> The server is NT 4.0 with IE6.0. The workstations has XP (not SP2)
> Any suggestions?

"Andrea Montanari" wrote:

> hi Olav,
> Olav wrote:
> > Hi,
> > we are installing our app at different sites. Normally it is a easy
> > job, but today we got problems.
> > The user had MSDE from before with Win NT authenticaton only. We
> > changed this to mixed mode. Then we used OSQL and sp_addlogin.
> > Yesterday at another customer this was enough to get access from the
> > whole local network. But here we could not access the database from
> > even the server! We then used OSQL and sp_addsrvrolemember on the
> > login. This enabled us to access the database from the server, but
> > still not the workstations!
> > The server is NT 4.0 with IE6.0. The workstations has XP (not SP2)
> > Any suggestions?
>
> are Network protocols enabled on the server (Server Network Utility ,
> svrnetcn.exe)?
> are the same Network protocols enabled on the remote workstations (Client
> Network Utility , cliconfg.exe)?
> are there connectivity issue in the lan?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>