?
Solved

DTA and sql server 2000

Posted on 2014-12-04
2
Medium Priority
?
367 Views
Last Modified: 2014-12-24
good morning,

Do you know by chance if the database engine advisor can connect to a server with sql server 2000? I've created a user on that server sysadmin to login and access the database but I get an error when I connect: Could not initialize MSDB database

Note: When you start session with an instance of sql server 2012 I have no problem.

I think it's because the tool does not support a sql server 2000, but wanted to confirm.
0
Comment
Question by:enrique_aeo
[X]
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 Comments
 

Author Comment

by:enrique_aeo
ID: 40481759
Wanting to open the wizard engine optimization database and connect from there I went out this mistake, but now
shading want to analyze the code and give right click and select the option Analyze query. . . and now I get the following error:

Can not find the assembly DTAClient, Version = 11.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91. (Mscorlib)

Maybe it's something missing I install?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 40482416
only working on SQL 2005 or higher
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

770 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