We have 1 TFS Build machine and 3 developer machines. I have installed SA Pro on the Build and logged in with Windows Authentication but with Administrator ( which was used to install the SQL instance ). All tables are created and everything is fine. But now I am installing SA on developers machines and they do not log in as Administrator and SA tells me that it "Could not connect to SQL server".
There is an excerpt at the end of the page on the first link for SQL authentication. I used it to try to connect with 'sa' and it works fine, but I can not put the 'sa' ( Server Administrator ) password in this plain xml file used for SA configuration.
From this excerpt I see two connections - the first for SA database and the second for 'master'.
I am at the conclusion that the regular domain user ( windows authentication ) needs privileges on both the SA and master tables ( as SQL auth. excerpt points that ) that I did not give.
My question is : What privileges do I need to set for a regular domain user account for both tables in order to make the Windows Authentication work?
More general : What privileges needs any type of account in order to user the SQL reporting
I have read this
http://www.red-gate.com/supportcenter/C ... 210448.htm
http://www.edsquared.com/2011/12/27/Int ... Build.aspx
but did not find any information regarding what privileges are required for Windows Authentication. The tutorial on the first page is not very useful in my case.
I read a ton of things for four days now for SQL ports and protocols and etc. on the net before posting here.
Thanks a lot for any help. I will appreciate it really.