April 10, 2015 at 6:47 pm
Intro: we have sql server 2008R2 cluster where few DBs are in 80 (i.e.2000) or 90 (2005) compatibility level- CL. We would like to change CL for DBs to 100 (2008). To check compatibility I installed on the server 2008R2 Upgrade Advisor (UA) but have issue connecting to local instance (default)- "Unable to connect to server"
Question: is this error because of UA looking for 2000 or 2005 instances (and my sql server is 2008) or there is another reason?
Thanks
April 11, 2015 at 4:32 am
No. Unable to connect to server suggests that you're trying to connect to the wrong server, are running the Upgrade Advisor from a login that doesn't have permission to the server, or, possibly, you're running the wrong version of the advisor (although I think the error would be different). The error you're getting is just a connection error. It's down to connection string or permissions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2015 at 2:21 pm
Not sure what can be wrong from 3 options you listed: 1) cluster instance name I know for sure as have connection (from SSMS) opened in front of me; 2) permissions- I am member of sysadmin role; 3) version- I can see title- Upgrade Advisor (UA) for 2008 R2.
Anyhow most important I got confirmation that UA can analyze DBs with lover compatibility level on sql server 2008 R2 (not only on lower versions- 2000/2005). Thanks Grant.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply