CODEWITHSUNDEEP
sql-server-2008reporting-servicesssrs-2008remote-server
Chrisma Andhika
Chrisma Andhika

Reputation: 341

Cannot connect SQL Server 2008 Reporting Services and Database on separate server

I have two virtual machines runs on my laptop, let's say their name are VMApp and VMDB, and both are runs the same OS, Windows Server 2008 R2.

On VMDB, I installed all SQL Server 2008 features except the Reporting Services. in contrast, I installed only SQL Server 2008 Reporting Services on VMApp.

I run Reporting Services Configuration Manager on VMApp and point the Server Name to the VMDB's computer name, then I got an error message

"A connection to the computer cannot be established"

I enabled the named pipe from SQL Server Configuration Tools on VMDB, but I still get that error message on VMApp.

I think the problem is not network connection because the VMs are connected in same domain network and they could ping each other.

Sorry for this dumb case because I am newbie in SQL Server, and I really appreciate any help from you guys!

Regards, Chrisma Andhika

Upvotes: 2

Views: 7393

Answers (1)

Diego
Diego

Reputation: 36146

You cant set the DB path to SERVERNAME\INSTANCENAME on the configuration manager. There isnt even that option. First you set the server:

enter image description here

and then the DB: enter image description here

where exactly are you having your issue?

FYI: try to enable SQL Browser on VMDB or to connect by IP if you cant enable browser

Upvotes: 1

Related Questions