Failed to connect to SQL express on LAN

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




I have two machines in a workgroup. Both XP Pro. On \\DELL8300 is SQLExpress
2005 the other \\DELL4600C has SQL 2005 w/SQL Management Studio.

When I try to Connect w/SQL Management Studio I can Browse in the Connection
window and see the DELL8300\SQLEXPRESS listed. When I select that machine I
get Error: 18456 - login failed for user DEll8300\Guest
I am logged in with an administrator account.
How did Guest get used?
--
Thanks
Morris
.



Relevant Pages

  • Re: SMS Administrator Console
    ... my SMS server is also running SQL. ... local admin or even a power user (at least on the 2 machines that are ...
    (microsoft.public.sms.admin)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.windows.group_policy)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.sqlserver.security)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.win2000.security)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.win2000.windows_update)