February 23, 2015 at 9:02 am
We have set up a 2012 sql box, and we are trying to get it working with our existing infrastructure, consisting of mostly 2008 boxes.
I noticed that from within 2008 SSMS, I can only connect to the box using Windows Authentication. Attempting to log in with stored credentials, either my own, the same account that windows auth would be using, or service accounts, it will not connect at all.
This also extends to BIDS and Report Manager where I am ultimately attempting to get a report to read data from a table that is moved to this 2012 environment.
I cannot find any references to this beyond the "Index Outside the bounds of the Array" standard fare of expected fwd compatibility issues.
please advise!
February 23, 2015 at 10:20 am
For the most part, tooling from Microsoft is backwards compatible, but not forwards compatible. Meaning, SQL Server Management Studio for SQL Server 2012 will connect readily to SQL Server 2008. But, you're trying to use 2008 to connect to 2012, and that's going to be problematic. Same thing goes for any other older piece of software trying to connect to newer instances of SQL Server.
"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
February 23, 2015 at 11:02 am
Hi Grant,
Understood, I was hoping that would not apply for something relatively basic, and also I had not seen anyone else encounter something similar in my initial searches. Is it or would it be documented anywhere official that it is not possible?
Hm, I thought your name sounded familar, I have been reading your book on tuning. Thanks so far!
February 23, 2015 at 11:21 am
Glad the book is helpful. You know where to go with questions.
I'm not aware of an explicit statement regarding forward compability, no. I know I've run into issues all the time over the years, and so have lots of others. I'm sure it's written down somewhere.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply