Re: Login failed for user '(null)'

Chris
Any errors in event viewer, sql server log file?



"Chris Ford" <ChrisFord@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5DD31C06-D0ED-4DC1-9768-A072FBBBBA1B@xxxxxxxxxxxxxxxx
Uri

Thanks for replying so quickly.
Yes for the purposes of testing the connection, I've assigned the
developer
(an ordinary domain user) public access to Northwind.
I've also tried making them a member of the Sysadmin Server role to no
effect.

The same user can connect to another SQL server using Windows
Authentication
(SQL 2000 Workgroup Ed SP4 running on Windows 2003 SP1).
I've just tried the same user from a different PC and he can log in from
there too (that one runs Windows 2000 Professional SP4).

"Uri Dimant" wrote:

Chris
Do you grant access to SQL Server,for login? What is a default database
did you assign to him?




.

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)
  • Re: SBS Client Connection Problem
    ... The application that is connecting to SQL server gives "object doesn't ... In Windows Explorer I get "an error ... What's the exact problem symptom of the problematic workstation cannot ... Click the Services tab, click to check the "Hide All Microsoft ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)