Re: logon failure

Tech-Archive recommends: Fix windows errors by optimizing your registry


Alas, if it were that easy, I wouldn't be here :)

The SQL Server Enterprise Manager states "a connection could not be
established" and "Reason: SQL Server does not exist or acess denied."
It then tells me to right-click on "edit the SQL Server Registration
Properties" I've done that, and the properties currently state "Use
Windows authentication."

I tried selecting "Use SQL Server authentication" and entered a log-in
name & password thinking this would allow me to view the properties
page, but that didn't work so I have changed it back to windows
authentication and am still getting the error.

Perhaps the easiest thing would be to temporarily change the Admin2
name back to Administrator? See if that lets me log in, then create
your SQLAdmin user and add it to the permissions? -- But I'd rather
hear this from a voice with experience, because the one in my concience
flies blind and is what led to my original SBS server's downfall.

Seriously, I'm out of my depth and I would like to not bugger the new
system, so your guidance would be appreciated.


--
JiAngelo
------------------------------------------------------------------------
JiAngelo's Profile: http://forums.techarena.in/member.php?userid=30319
View this thread: http://forums.techarena.in/showthread.php?t=839621

http://forums.techarena.in

.

Relevant Pages

  • Re: logon failure
    ... It then tells me to right-click on "edit the SQL Server Registration ... Windows authentication." ... I tried selecting "Use SQL Server authentication" and entered a log-in ... Perhaps the easiest thing would be to temporarily change the Admin2 ...
    (microsoft.public.windows.server.sbs)
  • 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: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • RE: IIS (ASP) -> SQLServer Authentication Issue
    ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ...
    (microsoft.public.sqlserver.security)
  • Re: SBS Premium Edition .. what way is SQL licenced
    ... Another thing to note in using your SQL Server as a backend database is the ... concept of Forms-based authentication and Integrated Windows authentication. ... thereby requiring individual CALs to access SQL Server. ... Chad A. Gross - SBS MVP ...
    (microsoft.public.windows.server.sbs)