why Sql error 20599 is appearing

Posted on 2003-02-24
Medium Priority
Last Modified: 2007-12-19
Hai guys,

Im getting the error 20559 'cannot open sql server'
I am using connecting to sql serevr thru sql authentication.when i try to connect the report with VB its telling the error.

I have checked with Verify Database option,unchecked the Discard data and also unchecked with the 'save data with Report' option,but still the report is not coming.

I have created the DSN in both client and server machines exactly the same way in terms of description and the 'client configuration'.But the error remains the same

Could anyone guide me in solving this error

Its very very urgent .im in dire straits.please help me


Question by:RajaRajeswari
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 101

Accepted Solution

mlmcc earned 400 total points
ID: 8008631

Author Comment

ID: 8372564
Hai mlmcc

Thanks for the good link.sorry for the delay as i was away.
U have given me a good lin .so i would give u a grade B
once again Thanks.
LVL 101

Expert Comment

ID: 8392279
Glad I could help


Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question