Solved

DTA and sql server 2000

Posted on 2014-12-04
2
327 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
2 Comments
 

Author Comment

by:enrique_aeo
Comment Utility
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 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
only working on SQL 2005 or higher
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

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