net shares and login credentials

On Windows 2000, I frequently have issues mapping drives, telling me about security conflicts or that the drive is already mapped even though it isn't any more. To solve this problem, you need to run the following from the command prompt:

net use * /d

List all DTS Packages in a query

Run this SQL against the msdb database:

SELECT DISTINCT name FROM sysdtspackages

Exporting Scheduled Task List to txt

This one works in Xp and also 2003 Server..

From the command prompt type:

schtasks > tasks.txt

The network is not present or is not started

If this happens to one of your XP clients (may also work on 2k and Vista)

1) Browse to your adapater

2) Uninstall File and Print sharing for Microsoft Networks

3) Click OK etc...

4) Browse to the adapter again, install File and Print Sharing

Everything should now be working again! Obviously if this happens a lot, then there is a bit of an issue here, however corrupt file and print sharing does seem to occur every once in a while.

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

In Reporting Services 2005 for some reason, you sometimes get this error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online HelpSQL Server does not exist or access denied.

Along with a reference to not having named pipes installed.

To fix it, just run the following command:

rsconfig -c -sMyServerName -dReportServer -awindows -uDomain\Account -pMyPassword

Repairing SQL Reporting Services 2000

Occasionally SQL Server Reporting Services 2000 seems to mess up and give you install errors, or permission errors. Listed below are 2 very good fixes which seem to fix the majority of issues:

1) run this command: RSActivate -c -r “C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config”

2) try this knowledgebase article: http://support.microsoft.com/kb/887787

enjoy...

Internet SQL Reporting Server 2000

This is far too complex and poorly documented for my liking!

Microsoft recomend that you add this tag to the Reportserver Virtual Dir rswebapplication.config file:

www.domainName.com/reportServer

HOWEVER This is much easier

Delete the info in the section of rswebapplication.config

/ReportServer

and ensure that the ReportServer virtual directory in IIS is pointing to:

"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager"

how good is that!