The service account cannot access SQL server

[Langward]

Hi all,

" Pass credentials across multiple computers to connect" This error occurs when i use Windows authentication and Kerberos 5 protocol is not enabled, then pass credentials across multiple computers to connect this error will occur. To clear this error, consider using stored credentials or prompted credentials. About how to deal with this issue. please suugest. I am using Sql server 2005 version.

[Modifier]

This error by the host report server database returns an instance of the database engine. In most cases, this error because the SQL Server service to stop. Or, if you are using with Advanced Services SQL Server Express or a named instance, then, if the report server URL or report server database in the connection string is incorrect, this error occurs. To resolve these issues, please do the following:

# Ensure that the SQL Server (MSSQLSERVER) service is started. Database Engine instance that hosts the computer, click"Beginning"、"Management Tools"And"Services", Then scroll to SQL Server (MSSQLSERVER). If not started, right-click the service, select"Properties"In"Startup Type"Select"Automatic", And then click"Application", "Start" and "OK".

[kelfro]

You also need to ensure that the report server URL and the report server database connection string is correct. If the Reporting Services or the database engine as a named instance, is created during the installation process the default connection string will include the appropriate instance name. For example, if installed on the server named DEVSRV01 advanced services with the default instance of SQL Server Express, the Report Manager URL is DEVSRV01 \ Reports $ SQLEXPRESS. In addition, the connection string in the database server name will be similar to the DEVSRV01 \ SQLEXPRESS. The SQL Server Express, URL and data source connection string details. To verify the report server database connection string, start Reporting Services Configuration tool and view the "Database Setup" page. Check and reply.

[Katty]

To resolve this error, you can modify the connection string to use the server name, but also for services to enable TCP / IP. Follow these steps to enable TCP / IP:

1. Start SQL Server Configuration Manager.
2. Expand"SQL Server Network Configuration".
3. Select"MSSQLSERVER Agreement".
4. Right-click TCP / IP, And select"Enable".
5. Select"SQL Server Service".
6. Right-click SQL Server (MSSQLSERVER), And select"Restart".

[Praetor]

To resolve this error, reinstall the software. For all other cases, as a temporary solution, you can connect to the report server SOAP endpoint:
# In the Management Studio in"Connect to Server"Dialog box, in the"Server Name"Type the report server's URL. By default, the URL is http:// <Server name> / Reportserver. If you are using with Advanced Services SQL Server 2008 Express, then the URL is http:// <Server name> / Reportserver $ sqlexpress.
All the best.

[MindSpace]

If this error also contains the following text, it indicates the database engine used to run an instance of the account's password has expired: "Error connection with the server. When connecting to SQL Server, this failure may be because of SQL Server in the default settings do not allow remote connections and triggered. (Access Interface: SQL Server Network Interfaces, error: 26 - Positioning the specified server / instance of an error). "To resolve this error, please reset your password. Check and reply.