I am trying to create a dynamic connection string to a remote machine. Initially I used the wizard to create a fixed connection, which created Data Source=126.96.36.199 (changed from original);Initial Catalog=Testmaster I opted to use the windows authentication option. All was well and the report linked to it returns data.
Now i'm trying to link the data source to a parameter (textbox) and im getting the Error40 my current string is......
="Data Source=" + Parameters!Server.Value + " Catalog=Testmaster Integrated Security = SSPI "
I cannot figure out where I have gone wrong here.