Hi,
i m trying to connect to msssql 2005 with SQL Authentication .but without success.
"Server authentication is set to SQL Server and Windows Authentication mode".
on connect i recive this error
"Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT:]"
any help would be nice
Luka
SQL Authenfication
Ulrich Straus
I have not so many ideas left.
Have you tried this connectionstring using the sql native client
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
Your machines might have different sql client settings and therefor behave differently. I would assume that this either works or fails on both your machines.
Aarvee
Junnys
I would guess your connectionstring might be incorrect. Use the link I provided. It has example of many connectionstrings, windows and sql auth for obdc, oledb, sql native to mssql.
From www.connectionstrings.com
ODBC to SQL
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
Ranjit Charles
How are you trying to connect Programmatically with a connection string or some tool
It seems as the connection is still attempted to be made with windows authentication.
If you need help with the connectionstring try http://www.connectionstrings.com
If you use a tool, what tool
wjcyg
brunozck
Is your user account specifically attached to the database you are connecting to Or is your user account part of a group account attached to the database Have your database administrator check your permissions on the database.
Are you logged in as the User you think you are Are you trying to connect to the database through a program you are writing If you are writing an ASP.NET application, you may be connecting to the database as IUSR_<machinename>.
Their may be a clue in the Event Logs on the server. See if there are any entries that match up with the time that you fail to log on to it.