Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeroena
Yak Posting Veteran
76 Posts |
 Posted - 2004-01-10 : 11:36:09
|
| Hi there,I'm trying to setup the Beta release of MS SQL Server Reporting Services. I'm installing this product on a laptop with Win XP Prof. This laptop has the SQL Server client tools installed.The setup needs to connect to my SQL Server server, which is on another machine, a standalone server with Windows Server 2003 S.E.I can connect to this SQL instance with the query analyzer from the laptop perfectly. But the reporting services setup claims:"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."The Security of the server is set to "SQL Server and Windows".Any help appreciated.Gr., Jeroen. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2004-01-13 : 15:06:26
|
| What service account is the remote SQL Server running under. In RS setup what account are you specifying to connect to the ReportServer database ? |
 |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2004-01-18 : 05:15:36
|
| For the remote SQL Server I both tried running it under the Local Systems account as well as under the NT local administrator account. I try to log on to this server using a SQL Server login which I created. This account has the "System administrator" server role.Gr., Jeroen. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2004-01-18 : 12:05:24
|
| have you tried using the query analyzer to connect to your sql server from your xp machine? |
|
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2004-01-19 : 10:27:10
|
| Yes, that works perfectly... |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2004-01-24 : 23:29:12
|
| If I remember correctly there is a config file that stores all the parameters specified at install make sure the accounts have the proper rights to login to the two reporting services databases.Also double check the accounts which the iis web site for reports and the web service for report server is running under. |
|
|
|
|
|
|
Connection problems trying to setup MSSSRS