Solved

Crystal Reports and SQL Port Number Change

Posted on 2011-02-28
8
1,425 Views
Last Modified: 2012-05-11
I recently had a database restored from backups and the technician who did the job changed the port number for my database to a non-standard number.  Now Crystal Reports cannot access the SQL database unless I am running it on the machine that physically hosts the database. When I try to access the database from other machine son the domain I get cannot connect errors. I know the new port, but I can figure out where in Crsytal reports to enter it.  Can someone just point me in the right direction?  If you give me a direction I will go hunting for info. I realize this question probably generates more questions than it does answers so i dont mind being pointed toward a concept.
0
Comment
Question by:hitsend
  • 5
  • 2
8 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
How are you connecting to the database?  Native Driver? ODBC?

~Kurt
0
 

Author Comment

by:hitsend
Comment Utility
SQL driver I think I would call it.

In the data explorer I follow > More Data Sources > OLE DB > Make New Connection > MSoft OLE DB Provider for SQL Server > Select Next > SQL server is listed, selected > Specific User Name and Pass is entered > Login Fails
0
 

Author Comment

by:hitsend
Comment Utility
Using Windows NT Authintication works but only on the physical machine that hosts the database.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
Comment Utility
That is just OLE.

Can you test the connection?

mlmcc
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:hitsend
Comment Utility
I have that option near the bottom of the dialogue but it fails when I test.

The error is "Test connection failed because of an error in initializing provider. Cannot open user default database. Login failed.
0
 

Author Comment

by:hitsend
Comment Utility
Ahhhh, when I refreshed the list of server names, and tried to connect again it came to life. The server list didnt change any on the surface but maybe the ports behind the scene updated.  Spooky but Im glad its working.
0
 

Author Closing Comment

by:hitsend
Comment Utility
Great help!!!! Thanks alot.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I had never seen a need or way to enter/change the port so I didn't know what you were looking at.

mlmcc
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now