Re: Reporting - SQL Server connection error

"Paul Chin" <Paul Chin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1F5EC708-FCEB-49F3-B028-D66123A6AE3E@xxxxxxxxxxxxxxxx

I have a senario where the SMS database is installed on another SQL server
and the SMS server is configured as Primary Site & Reporting Point.

When i trying to generate a report from the SMS server, the report
returned
me error as below:

An error occurred when the report was run. The details are as follows:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Error Number: -2147467259
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 18452


I was trying to review the site status but everthing seem fine, the SMS
server also can successfully update the database at the SQL server.

The SMS service account and the SMS computer account is belong to local
administrator group for SQL server. During the setup there was no error at
all.

Can anyone give me some advice on this issue?

I realize I'm late replying to this issue (just found it)... hopefully you
have solved it by now?

Could be a couple of things...
-- check that the spn's are set correctly
http://support.microsoft.com/kb/829868/en-us
http://support.microsoft.com/kb/886143/en-us
-- set up an alias from the reporting point to the sms site system. From the
RP run cliconfg.exe and set up a TCP/IP alias (use the server name running
sql server).

ST


.

Relevant Pages

  • Re: Fehlerhafte ODBC-Datenerweiterung bei den Reporting Services
    ... MSDN Webcast: Intelligent Reporting: Using the Visual Studio 2005 Report Viewer Controls ...
    (microsoft.public.de.sqlserver)
  • Re: MP Control Manager detected MP is not responding to HTTP requests
    ... IIS lockdown isn't needed for Windows server 2003. ... Did you get an error status message in the SMS admin console for MP control ... The SQL server site system is turned off, ...
    (microsoft.public.sms.setup)
  • Does anyone know how to fix this??
    ... Basically sms secondary site reports me 3 kind of error.... ... This site's SMS Service account or the site server's machine ... http error is Internal Server Error. ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Move SMS Database to new SQL Server
    ... Because you aren't just backing up the database, you're doing a full SMS ... later and move database from a remote server back to the SMS site server.) ... >>> I have SMS running right now on its own SQL server. ...
    (microsoft.public.sms.setup)
  • Problems installing Security Scan and Office Scan
    ... I have been to the MS Managing SMS 2003 class. ... I have installed SMS 2003 on a Win2003 server and placed the database on one ... installed the SMS Provider on the SQL server. ... I initially had some problem getting the reports to install. ...
    (microsoft.public.sms.tools)
Loading