This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SUPPORT Q&A - The database is not available.

TobiasCzempiel - Tuesday, March 22, 2016 11:01 AM:

I'am trying to install Aras Innovator 11 on my Windows 8 Machine. 

 

While running the InstallationWizard i get the first Problem while configuring the databse.

 

After clicking "Ok" the "Next" Button in the Wizard is still not available.

When I open the SQL Server Management Studio i can see a new InnovatorSolution Database.

Therefore i tried to choose tje "Use an existing database". 

With that option I can click the "Next" button and the Wizard finishes the Installation as expected.

 

The issue apppears when I try to log into Aras (using both IE and Firefox):

 

I get the following error. Sorry that the language is German but I will try to explain the German parts.

The Database is not available: running as Databaseprinzipal is not possible,

because the Prinzipal 'aras_innovator' is not there,

for this Type of Prinzipal is no Idetity change possible,

or you have not necessary  rights.

 

Do you have any suggestions what I could do to solve this issue? I tried a couple of things without success.

 

Greetings



TobiasCzempiel - Tuesday, March 29, 2016 1:45 AM:

I solved my Problem by using the full Microsoft SQL Version instead of the SQL Express Version. I really thought that the difference between those two is just in the available size, i think Express is limited to 10 GB, but it is not working with Express Version.

 

Greetings



rneuber1 - Tuesday, March 29, 2016 4:32 AM:

This happened to me, too during installation of SQL Server express.

I had chosen "Windows authentication" first, which seems to be the cause of this issue. I reinstalled it

with "password authentication" and set a password for the "sa" user. This works and now I have running Aras with SQL Server Express.

 

 

 

 

 



TobiasCzempiel - Tuesday, March 29, 2016 5:16 AM:

I reinstalled it with "password authentication" and set a password for the "sa" user. This works and now I have running Aras with SQL Server Express

I don't know if i choose the SQL Server and Windows-authentication while installing SQL Express, but it shouldn't make a difference in behaviour if you configuere it after installation ... right?!

 

I will try if your solution works for me.

 

Greetings