how to solve this issue

[cfnew]

Hi i am calling stored procedure and it works fine before but noe i am getting error as

[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sam'.(when i use username and password attributes in cfstoredproc)

[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'getData'(when i removed usename and password fields from cfstoredproc)

my cfsoredproc consists of

<cfstoredproc procedure="getData" datasource="#dba#"  username="sam" password="password"></cfstoredproc>

[mack_]

Make sure that you can login to the database with the user and the

password you specified and that user has the right to execute the

stored procedure (you can check that by logging in to your db with a

program like EMS MS Manager).

Mack

[paross1]

Assuming that you have a user and password assigned in ColdFsuion Administrator for the DSN, what do you get if you try it this way?

<cfstoredproc procedure="sam.getData" datasource="#dba#"></cfstoredproc>

Phil