I have 2 machines and 2 users for MS SQL server 2008 R2
Both machines belong to the same domain network.
machine A is a windows 7 pro pc trying to setup an odbc connection to machine B ( sql server)running
machine B windows 2008 r2 server running sql server
I am setting up an odbc on machine a to access machine b
If i setup the connection as "sa" the connection works fine.
If i setup the connection as "myuser" i cant connect to the server getting error
As a suggestion i tried adding "sysadmin" role to "myuser" and i am able to connect ok, but i dont think this is the right way to do it. Looking to see what actually needs to be setup for myuser to be able to connect not as a sysadmin.