February 26, 2007 at 7:52 am
I have a server with Sql Server 2000 SP4 Personal Edition in Windows XP SP2.
SQL connection and logins are configured as mixed mode connection, but in the client computers, i recieve the message: Login failed for user '---'. Reason: Not associated with a trusted SQL Server connection.
If i open/map a shared folder on the server, after i can connect with the sql...
What i do?
February 26, 2007 at 12:37 pm
It looks like the ODBC connection or whatever you are using to make the connection is trying to use the Windows Login. Somewhere the ODBC connection should have the option for trusted connection. Make sure that is unchecked.
-SQLBill
February 26, 2007 at 1:18 pm
Im not using odbc, i use php connection (mssql_connect)...
I reinstalled the sql server and sp4, now connect, but the configurations are equal... I do not know what happened. o.0
February 26, 2007 at 7:09 pm
A few means of diagnosing the problem:
a) Use SQL Profiler to capture event "Login Failed" (under "Security Audits") and columns loginame and hostname.
Then try to connect and Profiler will show you the loginame that is being used.
Is this the expected values for loginname ?
b) Active Directory/SQL Server authentication is based on SIDs and not on account names so if the AD account has been dropped and then readded with the same name, then the system id (SID) of the AD login will have changed and will not match the value in SQL Server
On the SQL Server, run in SQL Query Analyzer:
select loginame, sid from syslogins
Then: go to another SQL Server, add the same login and then run in SQL Query Analyzer:
select loginame, sid from syslogins
Are the SIDs the same? If not, drop and recreate the SQL Server login.
c) Integrated security is dependent on date and times of the various computers having similar dates and times. See "Maximum tolerance for computer clock synchronization" at http://technet2.microsoft.com/WindowsServer/en/library/64cdd612-fd7d-459c-a0f6-731ea0b2a8a41033.mspx?mfr=true
d) See "Security Account Delegation" in Books OnLine
SQL = Scarcely Qualifies as a Language
February 27, 2007 at 7:31 am
Check the PHP.INI file for this configuration item:
mssql.secure_connection = "1"
If this is "1", then Integrated Security will be used.
If it is "0" (the default value), then your SQL login and password will be used.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply