SQL-Server access from a Workstation
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?
.
Relevant Pages
- Visual Studio .Net 2002 database connection error from server expl
... Server exploI have recently installed Visual Studio .Net 2002 on my ... I can connect to local Access and MSDE ... server exployer, I get as far as successfully executing the connection test. ... Servers section, I can see list mye MSDE database instance, but it has a red ...
(microsoft.public.dotnet.general) - Re: Cannot save document. Form Validation Error..Web Server is busy
... installed as a MSDE instance in the first place. ... on reconfigure SP to point to the right database server. ... > would be to stop MSDE copy the databases and log files. ...
(microsoft.public.sharepoint.portalserver) - Re: ADP/SQL Server 2000 Security Problem
... The server is running Windows 2003. ... I'll also test using a SQL Server account and see what happens. ... it worked in MSDE 2000. ... I have not created any new accounts for the production database. ...
(microsoft.public.access.adp.sqlserver) - Re: Self Contained SQL Database
... I am running an application that uses MSDE Server ... database that was copied from old computer. ... Any great install products that can manage a self contained ...
(microsoft.public.sqlserver.msde) - Re: Jet database
... Microsoft wants people to use MSDE even for single user database ... Installing a server in a standalone ...
(microsoft.public.vb.database.ado) |
|
