What Can I Do When the Database Connection Fails During the Upgrade or Secondary Installation and the System Prompts Me to Verify the Database Name
Question
What can I do when the database connection fails during the upgrade or secondary installation and the system prompts me to verify the database name?
Answer
- Log in to the eSight server as the Administrator user.
- In the CLI interface, run the following command to connect to the SQL Server:
> osql -E
- Run the following command to query the database name:
> select @@servername;
> go
If the command output is NULL, run the following command:
> EXEC sp_addserver @server =eSightServer , @local ='LOCAL';
> go
- In the task manager, restart the SQL Server service.
On the Services tab page, right-click MSSQLSERVER and choose Stop Service from the shortcut menu. Then right-click MSSQLSERVER and choose Start Service from the shortcut menu.
- Perform the upgrade or installation again.