HPE EVA Storage
1748180 Members
4138 Online
108759 Solutions
New Discussion

Cant Host a SQL database

 
network storage
New Member

Cant Host a SQL database

I am stuck trying to host a SQL database. I have installed the HP ASM agent and SQLDMO on my SQL 2008 server but when I click "HOST A SQL SERVER DATABASE WIZARD" and type in the sql server name, it asks me to log in (even though I am logged in as the domain admin) and then gives me the following error
Error Details: Error connecto to SQL Server 'SERVERNAME' using user 'System.Security.Principal.WindowsIdentity'. SqlServer 2005 backward compatibility should be installed for hosting sql server 2005 and 2008 databases.

i have it installed on the sql server

thoughts?
1 REPLY 1
Michael A. McKenney
Respected Contributor

Re: Cant Host a SQL database

Use the SA account. Domain Admins don't always have enough rights in SQL.