I have a remote user (VPN connection) that can login to SQL 2000 using
the sa username and password, but cannot login with the username and
password assigned to him. I have also tried logging into SQL with
other usernames and passwords on this remote connection with not
success. His username and password works when logging into SQL from
any local computer on the network. I there any setting in SQL 2000
that needs to be set to allow remote logins?
The SQL log file entry is Login failed for user.
Is it possible to do Authentication with ASP.NET / C# over IIS ? ... I try to solve a problem: Some folder on an IIS Webserver should be ... But I want to have a SQL... database with the users which are allowed to login and just ONE System ... Make a login page and check Username and password against the entries ... (microsoft.public.dotnet.framework.aspnet)
Re: SQL 2000 login problem ... I assume the remote PC is not a member of your company's domain and the user didn't log into to the PC with the assigned Windows account.... You might try having the user map a drive to a share on the SQL Server using the Windows account before connecting. ... the sa username and password, but cannot login with the username and ... (microsoft.public.sqlserver.security)
Re: Only Remote Desktop password ... > not want that they would need to use it for local logins.... But for remote logins password would be required. ... > logged in remotely so it is quite simple for someone to try to login... > username to login locally). ... (microsoft.public.windowsxp.work_remotely)
Re: Delpoyment Issue ... you can attempt to call a stored procedure on the database. ... the connection string is wrong (username and password), ... and you know the login is invalid. ... I'm using is SQL 2000. ... (microsoft.public.dotnet.languages.csharp)
Only Remote Desktop password ... And I would like to enable Remote Desktop on this computer. ... that they would need to use it for local logins.... The other problem I found is that when I remotely login to this computer ... other were without it so they could only click on an username to ... (microsoft.public.windowsxp.work_remotely)
