Server Management - Systems Insight Manager
1834914 Members
2688 Online
110071 Solutions
New Discussion

No option to specific SQL login type during installation

 
Steve Pham_2
Occasional Contributor

No option to specific SQL login type during installation


All,

Is there a way to change the sql login type from using windows to sql during the initial installation? I ran setup and failed during the database creation because it uses the Windows login name.

Steve
4 REPLIES 4
Ivan KOVAC
Respected Contributor

Re: No option to specific SQL login type during installation

Hello

HP SIM uses only Windows authentication with SQL Server or MSDE.

i.
Steve Pham_2
Occasional Contributor

Re: No option to specific SQL login type during installation


The strange thing is that I could run the query analyzer on the server using windows authentication but when HPsim tried to use the Windows login to create the database, it failed. The log shown domain\username login failed.

Any ideas,

Steve
Ivan KOVAC
Respected Contributor

Re: No option to specific SQL login type during installation

What kind is that user,Domain user or DomainAdmin?

Are you have localy database or remotely?

i.

Christian Mentschik
Regular Advisor

Re: No option to specific SQL login type during installation

hi,
you have too less right´s on the sql-server (not in windows). put databasecreator to your sqllogin. if there is the same failur put system administrator to your login.

best regards christi