Re: 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.

Don't specify a userid and password in the connection string with Windows authentication. Instead, specify either "Integrated Security=SSPI" or "Trusted_Connection=True" in the connection string so that SQL Server will use your existing Windows security credentials.


--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Astley Le Jasper" <Astley.lejasper@xxxxxxxxx> wrote in message news:7454dea4-7bdc-4673-876b-862cce9b6796@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • SQL 2005 Express and VS .Net 2003 wizard error More options
    ... Open the server explorer panel ... Go to the Provider tab and select SQL NAtive Client (DON'T use oledb ... Go back to the Connection tab and carry on setting up the connection ... I have installed Visual Studio 2005 Professional and then Visual Studio ...
    (microsoft.public.sqlserver)
  • Re: Timeout problem with SS2K, VS03
    ... I noticed calls in sql profiler: ... This is the server side debug stored procedure. ... a timeout issue that I cannot identify the source of. ... transaction is committed and the connection is closed cleanly and all ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... listening on UDP 1434 using netstat -abn, ... And i double checked the connection string, and i did have it the right ... But I have another 2000 server that I can connect to fine, ... I am trying to connect from an XP SP2 machine remotely to a SQL Express ...
    (microsoft.public.sqlserver.connect)
Quantcast