Can't connect to SQL Express using Windows Authentication

Hi

I have installed SQL Express with advanced services and all the toys
on 2 machines. A desktop and a laptop intending to use the desktop as
a "server". I followed instructions to enable the server installation
for remote connection by enabling TCP and the browser.

Using SQL Server manager from the laptop I can navigate and find the
SQL Express instance on the desktop but whe I try to connect using
Windows Authentication I get the following error

<Login failed for user ''. The user is not associated with a trusted
SQL Server connection. (Microsoft SQL Server, Error: 18452)>


I have successfully connected from the desktop using windows
authentication.
I have successfully connected from the laptop using SQL Authentication
so I think that the problem is not with the network settings of the
server rather with the way that the windows authentication is being
passed (or not) from the laptop to the desktop.

Any ideas?

Phil

.

Relevant Pages

  • Re: Performance really poor if calling data from sql clients
    ... The laptop where the ... database is running can be found via ping and nslookup. ... Andrew J. Kelly SQL MVP ... profiler to see what is happening on the sql server end. ...
    (microsoft.public.sqlserver.clients)
  • Re: Cannot generate SSPI context
    ... when i use a laptop on a domain. ... I can however connect using SQL Auth. ... Everything works fine when I use sql server ... but if I switch to windows authentication I get the error ...
    (microsoft.public.sqlserver.connect)
  • Re: Performance really poor if calling data from sql clients
    ... Is TCP enabled on the Laptop for SQL Server? ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: Login failed for ServerGuest
    ... SQL Server clients are authenticated as guests if Simple ... >| I have noticed that when I try to log in using Windows Authentication ... >|> You can enable the guest account but that's a security risk ...
    (microsoft.public.sqlserver.connect)
  • Re: integrated security over vpn
    ... SQL 2000 is using Windows Authentication, and I can access tables, Stored ... > Are you using Windows authentication with SQL Server or SQL Server ... > easy to do on a home machine scenario as I would expect the home machine ...
    (microsoft.public.dotnet.security)
Loading