[dba-SQLServer] Back to the login thing

Haslett, Andrew andrew.haslett at ilc.gov.au
Wed Nov 17 22:11:04 CST 2004


As we've suggested multiple times, why are you using Windows Only
Authentication?

If this is just an internal system, then there's no need.  Just set up some
accounts using SQL Authentication on the other boxes and connect to it using
this username and password.  Presto. You're done. 

-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Thursday, 18 November 2004 1:04 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Back to the login thing

I really need to get query analyzer able to run on Neo2 SQL Server from all
of my workstations.  I have gone through the systems setting security on the
servers to Windows only / System Account.  EM is now able to see Neo2 Server
from all the workstations, and can in fact browse the tables, open the main
table and return records etc.  

QA however fails at the login with a consistent "Login failed for user
'Neo2\Guest'".  Msg 18456, level 16, state1.  On Neo1, Neo2 and Soltek1 I am
logging in to Windows as Administrator with an identical password on each of
those three machines.  I can use QA on Neo2 but I cannot use QA on Neo1 or
Soltek1 against Neo2.

Can anyone help me figure this thing out?  I REALLY need to get all my
workstations banging queries against SQL Server on Neo2.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.



More information about the dba-SQLServer mailing list