| Author |
Topic |
|
travich
Starting Member
19 Posts |
 Posted - 2007-08-09 : 13:18:07
|
| For SRS??? If so, what's the work around? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-09 : 15:18:56
|
Have a look at SQL Server Configuration Tool.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
travich
Starting Member
19 Posts |
Posted - 2007-08-09 : 15:22:13
|
| Okay... Where can I find the work around in the configuration tool.. I had saw in 2000 how you could have an alias for Reporting Services -- will this work as well? |
|
|
|
travich
Starting Member
19 Posts |
Posted - 2007-08-09 : 19:56:17
|
| Here's an explanation of my situation1. Reporting Server is on it's own server.2. Data Source is on another server. Communication is through TCP/IP only. I need to communicate to the datasource through TCP/IP and I'm assuming this is possible, correct? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-09 : 23:04:09
|
| Yes, create alias with tcp/ip protocol on RS machine. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-10 : 02:41:48
|
| You can add the alias as rmiao mentioned to force the protocol or you could change the default protocol to TCP/IP. Both can be done in the Configuration tool. You can also do it with regedit which I find to be easier since you can script out the keys so that you can easily import them into multiple clients. Here's the location:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectToIf you search on that string in the forums, you'll find detailed instructions from me on how to set it up through the registry.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
travich
Starting Member
19 Posts |
Posted - 2007-08-10 : 11:03:51
|
| TKI, thanks, that is very helpful! I have a test environment that I will try to get working with this info. I'll let you know how it goes. |
|
|
|
travich
Starting Member
19 Posts |
Posted - 2007-08-10 : 11:12:23
|
| Also -- these are both 2005 database servers. I hope that doesn't make a difference. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-10 : 11:47:13
|
| It doesn't make a difference. If you were using 2000, you'd just use Client Network Utility. But 2005 uses Configuration tool which is what we've mentioned in this thread. We assumed 2005 since the thread was placed in a 2005 forum.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
travich
Starting Member
19 Posts |
Posted - 2007-08-10 : 11:58:01
|
| Well, I received rsconnectionerror when trying to view a report, but then I realized I used server\instance name at the bottom part of the connection string. Testing again and will let you know. FYI, the dynamic port that was picked was 1204, I believe (according to SQL Server Manager). To specify a specific port I'm assuming I can just set the first IP section to the port that I want to use... I did a netstat and the port I want to use doesn't appear to currently be in use. |
|
|
|
travich
Starting Member
19 Posts |
Posted - 2007-08-10 : 12:08:44
|
| I got the following error -- I'm not using WINS credential, I'm using SQL so I'm not sure why my windows creds are being used. If I can figure out where this is set or screwed up I'll bet I'm golden.Reporting Services Error-------------------------------------------------------------------------------- An error has occurred during report processing. (rsProcessingAborted) Get Online HelpCannot create a connection to data source 'MyDdatabase'. (rsErrorOpeningConnection) Get Online HelpCannot open database "MyDatabase" requested by the login. The login failed. Login failed for user 'MyDomain\MyUser'. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-11 : 01:16:54
|
| You need review your RS connection settings, ensure sql standard login is used. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-11 : 11:34:26
|
| What are you clicking on to get this error? Is this in Report Manager in an actual report that you are trying to view? If so, you change the connection string for that folder inside Report Manager.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
Is it possible to turn off named pipes in 2005??