Re: Login fails on trusted connection to ms-sql 2000
From: Steve Thompson (stevethompson@nomail.please)
Date: 07/10/02
- Next message: Nick Collins: "Rename Database Role"
- Previous message: Toni Lassila: "Re: Security and encryption"
- In reply to: Carlos Garcia: "Login fails on trusted connection to ms-sql 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Steve Thompson" <stevethompson@nomail.please> Date: Wed, 10 Jul 2002 10:35:09 -0400
It's not clear to me how your clients connect, IOW what type of access
methods or application is being used.
The error indicates that a trusted connection is being used, but fails
because the Guest account on the XP machine has no rights on the database.
As a troubleshooting measure, try enabling the Guest account on the XP
machine and give it rights in SQL Server (temporary only), also use SQL
Profiler to capture logon/logoff activity.
You could also experiment with changing the authentication mode to mixed,
and/or changing the default client side sql network libraries in use...
Steve
"Carlos Garcia" <carlosg57@hotmail.com> wrote in message
news:16cde01c227c4$a58eaee0$9be62ecf@tkmsftngxa03...
> 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
- Next message: Nick Collins: "Rename Database Role"
- Previous message: Toni Lassila: "Re: Security and encryption"
- In reply to: Carlos Garcia: "Login fails on trusted connection to ms-sql 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
