Login problem

This is probably all due to my limited understanding of SQL Server security,
so any direction will be greatly appreciated.

Using Win2K, SQLServer 7, and VB.NET 2005..

My app requires a user to login to the database. Since the PCs running the
app are shared, I can't use the current logged in user so the app has a
login screen. The idea is to use the same uid and pwd used to login to their
Windows account. SQL Server is set up to use mixed authentication. So the
user logged in to the PC is Dave. Now Steve sits down to run the app and
logins in through the app's login screen. The app builds a connect string:
Server=server1;Database=homedb;User
ID=DOM1\Steve;Password=stevepwd;Integrated Security=SSPI

This always connects as the current user logged in to the PC. If I remove
the Integrated Security token, the login fails because the SQL Server login
DOM1\Steve does not exist.

What I'm after is letting SQL Server validate the user against an existing
Windows login which may or may not be the user currently logged in to the
machine. Is there any way to do this?

Thanks..

Michael White


.

Relevant Pages

  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... Do you want the Windows App ... This means that each application user will have to have a SQL Server login ... > Web service on a w2K3 server, using integrated authentication, web.config ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: SBS R2 Confused Computers/Users ??
    ... MyBusiness container to SQL Server security section. ... Please let me know whether these Windows user accounts can login to ... Are you get any error message when you add the user to SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Securing Connection string
    ... How do I assign rights to the SQL Server ... instance my app will be using and how to I assign the rights to my database ... recommended to avoid the users from having to login again and again (once on ... Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • Re: Login problem
    ... that MSDN article was exactly what I needed. ... you would not want to use a UID parameter, that is for SQL Server ... My app requires a user to login to the database. ...
    (microsoft.public.sqlserver.security)
  • Re: VB6 Using ADO to Login to SQL Server using NT Authentication
    ... SQL Login and NT Login are in the group that SQL Server security login ... The SQL Server is setup for NT ... achieve this your app will need to impersonate an NT account that is valid ...
    (microsoft.public.vb.database.ado)