asked
How to connect ssms 2005 to sql server 2014 (Index was outside the bound of array) ?
Hi experts. I really need help. I have a server with sql server 2014 Standard Edition with sp1, and I also have a sql server 2005 Standard Edition with sp3 in a different server. Within the named instance in sql server 2014 I have two users one user is just a sql server user called dba_teste and the other user is domain user called contoso\dba and this account has SA. The problem occurs in the following way, when I start the ssms 2005 within the sql server 2005 and try a connection using the domain user a error message is issued "Index was outside the bound of array", but when from the same server I try a connection using the sql server account I have no problem, and the connection works like a charm. So I don't know what to do, any suggestions ?
Yes JohnM, but I can't figure out where is the problem, one solution is to use a new version, when I try a connection from another server running sql 2012 both connections work. For me this is a very strange behavior, if it is a compatibility problem, the problem will not affect both types of connections ?
It seems to be a protocol port problem, recently I changed the settings from dynamic ports to a static port 1433, so I changed back to the old configuration and the problem still not showed up again.
18 People are following this question.
