to connect crystal report with sql server

[kkshansid]

i can not connect my crystal report with sql server.at my home pc i can connect it on local host by making new ado connection but same process is not working to connect with server.its givig error logon failed.native error 18456

[Dököll]

Where is the server you are attempting to connect to housed?

You may need permissions to connect to that server, if this is relating to a work server (Look into VPNing in)...

[kkshansid]

working with vb form

i can connect sql server database with vb other forms that means i can have acess wth that user name & password but not with crystal report
i can connect with same database on local host but i have to update that regularly.

[charlesbecon]

check this one....Crystal Reports Tutorial

Hope this will help you.

Charles.