I have SQL Server installed on a machine called SQLDEV. I log on to that machine and I run the command
sqlcmd -s SQLDEV -Q "select * from <db>.<schema>.<some_table> -E
This command works and returns a result set.
Next, I go to a different machine. On that machine I can use SQL Mgmt Studio to log on to SQLDEV using window authentication. However, if I run the same command as above, I get some kind of a connection error. The error says,
".... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections .....
Any suggestions/ideas why I am getting this error?
View Complete Post