You can create a new SSRS project and add the existing RDL files (i.e. C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard). You can then extract the DDL/DML used to produce the reports from...

If it returns a blank screen, that is a good thing 🙂 Ruling out any FW issues. Can you reproduce this from the server that is hosting the linked server...

A simple verification - on the server in question, execute a

select @@servername

If this returns the correct server name then you are all done. If not use the sp_dropserver, sp_addserver method...

I would recommend measuring Avg Disk Sec/Read, Avg Disk Sec/Write, and Avg Disk Queue Length within performance monitor. You can use SQLH2 to help capture this information over a period...

Can you telnet to the instance on TCP 1433? i.e. Start -> Run -> Cmd

telnet MYSERVER 1433

NP, Good luck 🙂

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=451474&SiteID=17

In that case, IBM will be your best resource. A good place to start -

http://www-03.ibm.com/systems/i/software/access/windows/database.html

After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.

use master

go

exec sp_dropserver 'old server name'

go

sp_addserver 'new server name', 'local'

go

Any reason not to backup/restore the database?

NP, You too 🙂

Are you using IBM's OLE DB provider or Microsoft's OLE DB provider? If MS, refer to http://support.microsoft.com/kb/218590/%5B/url%5D

From the default trace file (refer to T-SQL in the post above).

NP 🙂 You can also filter your resultset by querying the trace file directly - i.e.

BEGIN TRY

DECLARE @enable int

SELECT TOP 1 @enable = CONVERT(int,value_in_use) FROM sys.configurations WITH(NOLOCK) WHERE name =...

NP - the runtime component is available in the package labeled "Microsoft SQL Server 2005 Backward Compatibility Components". Have you installed this as well?