SqlServer ??C#

  • Thread starter Thread starter perspolis
  • Start date Start date
P

perspolis

I used SqlSerlver as a database in my c# program.
I made a connection string ot connect to my database.
I want to use authentication and login name.
If in connection string wizard I use Windows Authentication ,I can connect
to it, but if i want to use sql server login I can't :(.
with predefined user,mean sa,I can't login.event I grant it all of permisson
but it can't still connect. and give me an error "Login failed for user
'sa'.Reason Not associated with a trusted Sql Server connection."
 
In the security tab of the server properties in Enterprise Manager, you have
authentication set to Windows only instead of SQL Server and Windows.
Choose SQL Server and Windows authentication and restart the SQL Server
service.

DalePres
MCAD, MCDBA, MCSE
 
thanks DalePres
DalePres said:
In the security tab of the server properties in Enterprise Manager, you have
authentication set to Windows only instead of SQL Server and Windows.
Choose SQL Server and Windows authentication and restart the SQL Server
service.

DalePres
MCAD, MCDBA, MCSE
Click to expand...
 
Back
Top