• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 65
  • Last Modified:

error msg " server has not yet been opened"

i got this msg when preview the report(cystal report 8.5) after i change the server n database SQL server 2012 express
0
LC Pee
Asked:
LC Pee
  • 4
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are the SQL Server versions the same in the old and the new servers?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Also check if the same credentials work for old and new SQL Server databases. If they are different you need to provide the new credentials.
0
 
LC PeeAuthor Commented:
No SQL Server is different version
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
mlmccCommented:
Did you change the database connection?
You need to use the 2012 database drivers
Are you connecting with ODBC?

I suspect CR 8.5 cannot connect to SQL 2012.  I know at one time you couldn't use CR  with SQL 2000
There were some restrictions on the express editions at one time.

mlmcc
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You'll need to have SNAC 2012 to be able to connect to SQL Server 2012 version database. You can download it from here.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Recommendation to close this question by accepting the above comments as solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now