Login fails on trusted connection to ms-sql 2000

From: Carlos Garcia (carlosg57@hotmail.com)
Date: 07/10/02 

From: "Carlos Garcia" <carlosg57@hotmail.com>
Date: Tue, 9 Jul 2002 20:48:26 -0700

Thank you for reading.
Upon running application on client, i get message 'Login
failed for user <SERVER>\Guest
( since the instance of sql server and the server machine
itself have the same name, i suppose <SERVER> refers to
the machine -couldn't make different)

I use Xp Professional as 'server' and W98 as client; both
on a workgroup. (do i need a Primary Domain Controller or
XP should do the job?)
The W98 client is configured on Settings | Network |
Access Level to get the login information from the
server. Actually they share the internet connection on
the XP Professional.

The primary logon in the client is Microsoft Network.

I log in in the client with this user i previously
registered on the server as part of the Administrators
group.
Since i can see either computer on each of them, i'm
assuming the client logged in with the rights i gave it
on the server (xp professional).
I tried adding the 'guest' account to the role on the
master database, just to try it, but same results 'Login
failed for user <SERVER>\Guest'
I also added a 'Login' to sql server with all rights
granted to all roles and databases, but to no success.

On MS-SQL 2000 Evaluation edition, i'm using
- Windows authentication
- Startup service account is administrator
- server is XP professional

Client is W98 with latest MDAC (however, computer
properties to this client on XP say is a W95, don't think
it matters)

I created this user on the server and added it to the
Administrators group, then i logged in on W98 client with
no problem to see the server.
The ADO application uses UDL on .../system pointing to
the SQL Server, if finds it just fine.
When running on client, i get 'Login failed for users
<SERVER>Guest'

Do you know where can i find info to solve this?
How to configue MS-SQL to accept login from windows user?
Hot can i make sure the login is being attempted using
that particular user?

Thank you very much for your help.

Carlos Garcia

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • Re: F$GETJPI doesnt match SHOW PROCESS/ACCOUNTING
    ... With Tier3 applications, you choose the default user name that execution ... server processes will be created under. ... without privileges) to assume the persona/rights/privileges of the client on ... if you left the "Login Confirmation" checkbox ...
    (comp.os.vms)
  • Re: Applet Consideration
    ... > the client applet to connect to the server. ... everything is sent as String. ... >> I made it so the client has absolutely no knowledge that the db exists. ... Each thread must be initialized by a login. ...
    (comp.lang.java.databases)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
Quantcast