SQL Authenfication

Hot Topic

Why System.Data.SqlserverCe.Dll doesn't appear in VS2005
Create DB using OSQL is SLOW
How to reduce the time when using a variable
Crystal Reports driver for SQL Server 2005
What are the best practices for a time dimension?
Virtual Cube Migration
Index was outside the bounds of the array
SQL Server Express License question
Top 20 ordered and rest grouped into 'others'
Can't connect to SQL Server 2005

SQL Server

Creating a project from an existing Database
Locks - Isolation Levels
Error when create a Server object using SMO
sql problem in stored procedure
Can I use SQL Server Management Studio Express to work with SQL Server Everywhere?
FailParentOnFailure not working?
Replication -- New Subscription Wizard SQL Mobile error, please help..
How to debug a script component task???
SQL Server 2005 and 2000
How to tie together all tabs

SQL Authenfication

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



Answer this question

SQL Authenfication

  • glebd

    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



  • ambujkn

    the problem is my wokrmate is using the sam odbc connection string and its works the only difference is he is using windows xp me windows 2000 , the server is on windows xp

  • Chris Greenwood

    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.



  • angi.w

    i m using odbc to connect to mssql both driver sql server and sql native client i didnt work

  • rca

    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;"



  • PaulMCiti

    Does your computer have the latest version of MDAC (2.8 SP1) You can download it from <a href="http://www.microsoft.com/downloads/details.aspx familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en"> Microsoft.com</a>

    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.


  • SQL Authenfication
Answer this question