Login failed for user 'XXXX'. Reason: Not associated with a trusted SQL Server c

Question

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXXX'. Reason: Not associated with a trusted SQL Server connection. 

J'ai le message ci dessus lorsque j'essaye de me connecter &#224; la base SQL.

Ma page Asp est la suivante.

<%
Set conn = Server.CreateObject("ADODB.Connection")
' chaine de connexion
connstring = "driver={SQL Server};" & "server=TOTO;uid=XXXX; pwd=XXXX; Mabase"
' ouverture de la connexion
conn.open connstring
' traitement
%>
J'ai pourtant v&#233;rifier le param&#232;tre de s&#233;curit&#233; de mon serveur SQL2000 la case Authentification s&#233;lectionn&#233; est bien "SQL Server and Windows".

Help SVP

kccja

moco1234 · Answer

http://support.adobe.com/devsup/devsup.nsf/docs/53766.htm try this web you will get the answer of your problem tu peux aussi suivre c est instruction qui pourrons resoudre ton problem bonne chance :-) The problem you describe typically occurs when a Microsoft SQL Server installation is configured to use only Windows authentication and not SQL Server authentication. To solve the problem, perform the following steps:

Start SQL Server Enterprise Manager (Start, Programs, Microsoft SQL Server, Enterprise Manager).
Navigate to the SQL Server system in the Microsoft Management Console (MMC) treeview pane by selecting Console Root, Microsoft SQL Servers, SQL Server Group, (or ); right-click the server; and select Properties from the context menu.
In the SQL Server Properties dialog box, select the Security tab.
In the Security section, make sure that Authentication is set to "SQL Server and Windows" and not "Windows only," as the figure at Figure shows. If necessary, change the selection and click OK
moco1234

rekik_mehrez · Answer

j'ai rencontr&#233; cette probl&#232;me et j'ai pu le resolu heureusement:
1-aller ouvrir SQL Server Enterprise Manager 
2-right clic on local windows (sous le console root)
3-select propri&#233;t&#233;
4-dans le section security choisir sql server and windows
5-restart now your sql server
 merci hallebh tunisie

rekik_mehrez · Answer

Veuillez utiliser ce code sous ASP.NET si vous &#234;tes s&#251;r qui tu as choisi le mode sqlserver et windows


string
 strRequete = "SELECT * FROM CHAUFFEUR ";


static string
 strConnexion = "data source=internet;initial catalog=pfe_tds;user id=enis;password=enis";
oConnection.Open();


SqlDataAdapter oAdapter=new SqlDataAdapter(strRequete,oConnection);


DataSet odataset = 
new DataSet("CHAUFFEUR");


oAdapter.Fill(odataset,"CHAUFFEUR");


DataView Source = 
new DataView(odataset.Tables[0]);


DataGrid1.DataSource = Source;


DataGrid1.DataBind();

bon courage [mailto:hal_habib@yahoo.fr hal_habib@yahoo.fr] Tunisie tatouine

Login failed for user 'XXXX'. Reason: Not associated with a trusted SQL Server c

3 réponses

Votre réponse

Discussions similaires