Re: SQL 2000 login problem
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 20 Nov 2006 06:53:21 -0600
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. Additionally, you may need to use named pipes.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Carl" <c.gros@xxxxxxxxxxxx> wrote in message news:1163694741.571208.282480@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
.
- References:
- SQL 2000 login problem
- From: Carl
- SQL 2000 login problem
- Prev by Date: RE: Proprietary data in SQL2005
- Next by Date: Re: Should you use local machine groups?
- Previous by thread: SQL 2000 login problem
- Next by thread: i have two inserts and one delete i want in one transaction, is there any issue with this tsql strategy: http://rafb.net/paste/results/uY2KYP16.html
- Index(es):
Relevant Pages
|
|
