Error Opening Crystalreport Viewer

I have this problem which I am trying to debug for a lot of time. The setup is like this: i. The application is a Windows application developed using VS2005, .net 2.0. ii. I use th

Solution 1:

Use datasource=servername or ip address\instance name if available,port number

Default port number is 1433 or 1434

My problem was solved with this. Posting for the use of others.

Solution 2:

If this is a standard installation of SQL Server Express, bear in mind that the only connection method installed by default is shared memory, and is only available on the server -- you would need to enable another connection protocol such as Named pipes or TCP/IP. To turn networking on, Use SQL Server Configuration Manager to enable relevant protocols and start SQL Browser.

Solution 3:

It's telling you exactly what's wrong.

Details:Logon failed.

Great, we can't logon.

(Invalid Instance()).]Invalid connection.

Okay. I bet we have "localhost" as part of the instance name in my connection string. Since I'm no longer on the "localhost", this obviously won't work. Let's try there first. Then perhaps it's the credentials that I'm using to query my database. Usually what I do is create a RO user that can only do selects on my db and use that for CR. If none of these are getting me close, let's try making sure that remote connections are enabled for SQLEXPRESS

Unable to connect: incorrect log on parameters.

Ok it's definitely a connection issue.