enrique_aeo
asked on
DTA and sql server 2000
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?