SQL Server logins rejected
I have a database on SQL Server 2008 Express which I connect to over a
vpn via MS Access. The connection uses a login and password set in SQL
Server. When I or one of the other guys connect, then there is no
problem. However, when a new user connects, they are rejected.
The difference is that both I and the other guy have an Windows
account on the server.
I presume that there is a conflict here with the local windows
authentication. Can someone point me in the right direction as to what
I should be searching for? Is there a noobs guide to setting logins on
SQL Server.
ALJ
.
Relevant Pages
- Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
(microsoft.public.sqlserver.connect) - Re: cannot acees two databases as owner
... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
(microsoft.public.sqlserver.setup) - Re: Database security design with ASP.net and form-based authentication
... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
(microsoft.public.sqlserver.security) - Re: Credentials not being passed with remote access
... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
(microsoft.public.sqlserver.security) - Re: No db access after publishing web site
... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
(microsoft.public.dotnet.framework.aspnet) |
|
