Probably a dumb question.
I've successfully installed Report Server, and am trying to input a Data Connection, and enter the provider (SQL) and the connection string, which the Report Server accepts. I then use IE to create a report,however, when I chose the Data Connection I entered, I get an error saying that there is an error in index 107.
So I'm guessing I'm not putting in the data string correctly even though it is accepted. Can someone give me the format of the conneciton string for SQLClient Data Provider (seems like a dumb question; however, it is not working with the one I'm entering).
In advance, thanks for your help.