Home > Reporting Services, rsReportServerDatabaseUnavaliable, sp_addserver, sp_dropserver, SQL Server 2005 > SQL Server and SQL Reporting Server SSRS – Quick Reference –FAQ’s

SQL Server and SQL Reporting Server SSRS – Quick Reference –FAQ’s

SQL Server

  1. Add a Database user to a Database role:
    EXEC sp_addrolemember ‘db_owner’, ‘yourdbusername’
    More here
    http://technet.microsoft.com/en-us/library/ms187750.aspx?PHPSESSID=rr1g5nuj29l79hrpjk7k0g1461
  2. When you rename the SQL Server name:

In case if you have renamed the SQL Server recently and find a trouble to connect to the server using code. Try the below items.

  • Use Query Analyzer and Connect to the SQL Server.
  • Execute the command SELECT @@SERVERNAME AS ‘Server Name’
  • You will find the old name reflecting there.
  • First run the command sp_dropserver ‘old server name’
  • And then run sp_addserver ‘new server name’, ‘local’
  • You should be good to go

SSRS Reporting Servers:

  1. To change the User Name or the Server name of the Reporting Server instance [SSRS].
  2. When you get rsreportserverdatabaseunavailable error when connecting to SQL Server Reporting server.

For the above case you have to use the tool rsconfig that will change the user and server details.

http://msdn.microsoft.com/en-us/library/ms162837.aspx

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: