[dba-SQLServer] Back to the login thing

I agree.   

I don't have access to a p2p network but if it insists you are logging
on as Neo2\Guest I doubt you have many options.
It seems to me that as it can't validate the user (DHCP?) it defaults to
the guest account.  

Maybe this will do it...
>From BOL
The guest user account allows a login without a user account to access a
database. A login assumes the identity of the guest user when both of
the following conditions are met: 

The login has access to an instance of Microsoft(r) SQL Server(tm) but
does not have access to the database through his or her own user
account.


The database contains a guest user account. 
Permissions can be applied to the guest user as if it were any other
user account. The guest user can be deleted and added to all databases
except master and tempdb, where it must always exist. By default, a
guest user account does not exist in newly created databases. 

For example, to add a guest user account to a database named Accounts,
run the following code in SQL Query Analyzer:

USE Accounts
GO
EXECUTE sp_grantdbaccess guest


cheers

Michael M




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.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com