locked
Unable to access master database using SendSuite Installer on SQL 2008 R2 RRS feed

  • Question

  • Currently trying to install new database on an instance of Microsoft SQL 2008 R2 installed on Windows 2008 R2. Using installer supply by SendSuite on an application server for this and getting error ‘unable to access master database.’ Installer prompts for database sysadmin account, password valid ok when using the sa account for this.

    But SQL event logs shows access being tried via the account logged on to the application server and not the account requested in the SendSuite installer (e.g the sa account)

    Can anyone suggest what access permission/roles are required on master database to create this application database?Has anyone tried installing SendSuite and found similar issues?

    Thursday, January 30, 2014 10:20 AM

Answers

  • Hi Mark,

    I believe you may need to create the login under the SQL server for the account which is used on the application server.

    You can follow the steps mentioned in the following article to create a login and grant Db_owner permission on the master database.

    How to: Create a SQL Server Login

    http://technet.microsoft.com/en-us/library/aa337562(v=sql.105).aspx

    If this does not resolve. Please contact the SendSuite support for further troubleshooting.

    Regards

    Sathish SN

    Thursday, January 30, 2014 11:31 AM