hi expert
i want to coonect sql server 2000 from my app
i create a login in enterprise manager with this user id and password
user id =mahdi
passwod = kiani

my connection string is
"data source=(local);initial catalog=test;user id=mahdi;password=kiani"

when i run application i get the fowing error
Login failed for user 'mahdi'. Reason: Not associated with a trusted SQL Server connection.

where is the problem?

thanks
regards
kiani,mahdi

Open enterprise manager --> Right Click on the SQL Server node you are trying to connect to --> Select properties --> Security Tab --> Use SQL Server and Windows Authentication.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Have you associated mahdi with a user for the Test catalogue?

--

Joe (Microsoft MVP - XML)

thanks dparsons

my problem has been solved
but i have another problem
i set permission on STUDENT table for mahdi
mahdi permission sets that can not select above table
but when i "write select * from STUDENT" , my data shows in my dataGridview
user 'mahdi' doesn't permission on STUDENT table
where is the problem?

How did you set the permissions? Maybe the account inherits rights somehow? Did you try an explicit deny?

Imar

P.S. Did you receive my reply to your personal message?


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

hi Imar
how can i set permission explicity?
and i dont recive any reply from you
if it is possible for you sent your reply to this email : [email protected]

thanks again
kiani,mehdi

I mailed you at your mb.santiago account.

If you click the check box for the permissions a few times it will change every time, from not set, to allowed to explicitly denied.

How did *you* set the permissions?>

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

hi Imar and thasks so much for your reply(s)
i realy don't recive any email from you
i check my account ([email protected]) every day but i don't found any mail from you
please resent to me,thanks again

but about setting permission :
I set permission according to following steps

in enterprise manager i right click on my table <STUDENT> and then i click on permission
in object comboBox I select STUDENT(dbo)
and in following the combo box i set permission for my user (mahdi)
I set SELECT,UPDATE,INSERT,DELETE permission for user(mahdi) to deny by checked (* red) character

and then I clicked ok button

I set permission according the above steps

is it right?

great apperciation dear Imar for your reply(s) again
and I'm waiting so for your personal message in my account([email protected])
thanks again dear Imar
kiani,mahdi

Only you can tell. What happens when you try to select data from the table?

But yes, this is generally how you would deny access to a specific table.
But why do you want a deny at all?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

just I want to see action of users permission

dear Imar
still..I don't recive email from you

do you resend it to me?
thanks