Data Source Connection String problem

• Jan-1080019

  SSC Enthusiast

  Points: 121

  More actions

  September 8, 2009 at 8:20 am

  #204353

  Hi,

  We have a Reporting Server 2008 that is in another domain than a database server. I use a sql server account to access it.

  The database server is a named instance.

  How can I define a connection string in the report server?

  Server=SERVERNAME\INSTANCENAME;Database=dbname; doesn't seem to work.

  Server=IPADDRESS:PORT;Database=dbname; neither. (I also tried with a comma)

  Anybody any ideas?

  Thanks,

  Jan

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  September 8, 2009 at 8:29 am

  #1050554

  I was thinking IPADDRESS,PORT

  Can't remember..

  CEWII

• Jan-1080019

  SSC Enthusiast

  Points: 121

  More actions

  September 9, 2009 at 6:56 am

  #1051034

  Elliot,

  thanks. I already tried that, but I found out that it was a security issue on our local network.

  regards,

  Jan

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  September 9, 2009 at 9:14 am

  #1051211

  Ah, good to know..

  CEWII