Re: Problems Using Laptop As SQL Server - Log On Failed

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 18:34:19 +0100

hi KennyZ,
"KennyZ" <mahonk2000@yahoo.com> ha scritto nel messaggio
news:f80501c3f18a$e9273eb0$a601280a@phx.gbl...
> I loaded the MSDE (SQL Server7) on my laptop (logged in
> as a network user). I restart the computer (not
> connected to the network and no password for windows.
> Just cancel). My SQL Server Service Manager starts
> running. I double click the SQL Query Analyzer and
> choose Windows authentication and local as well as i try
> the name of the laptop as name of the SQL Server. i
> click ok and get the following error.
>
> UNABLE TO CONNECT TO SERVER KOMAZA:(this is the name of
> my laptop)
> Server:Msg 18452, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login
> failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection
>

in order to login with a SQL Server authenticated connection instead of
WindowsNT trusted connection, you have to change the authentication mode...
login with a sysadmin trusted login in Enterprise Manager, select the server
node, right-click and open the SQL Server properties... in the Secuity tab
change the authentication setting...
or open regedit and modify a registry key
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode
    set the value to 2, which allows both trusted and SQL Server
authenticated connections..

hth 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.6.0  -  DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
MSDE installs by default on WinNT platform with Windows Authentication
setting...
to

Relevant Pages

  • 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: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • 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)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)
Loading