can't login to server

This post has 18 Replies | 3 Followers

Top 500 Contributor
Posts 2
Points 0
Chris Westervelt Posted: Wed, Jan 24 2007 12:53 PM

No matter what I have tried I cannot login to the Innovator server.  I am running SQL Express and have tried every trick I can but I still get an authentication error immediatly.  I checked the configuration file and everything looked as it shoul according to the install doc. I give up!

 

Chris

  • | Post Points: 0
Top 10 Contributor
Posts 199
Points 1,180
Bill replied on Wed, Jan 24 2007 1:25 PM

No problem, I'm sure we can get this sorted out.

So, you installed Innovator to your server, and you were able to complete the install without errors.

After this, you set up a .NET security policy on the client machine using the Manual .NET Security Config Tool.

Next you followed the steps outlined in the Aras Innovator - Internet Explorer Client Machine Configuration

(See http://www.aras.com/support/documentation/documentation.aspx for the download of this doc.)

Finally you opened the link to the Innovator login screen.

Example: http://machine/InnovatorServer 

Aras Innovator 8.1.0 Login Screen

You then enter the default login credentials on a new install:

Login:  admin

Password:  innovator

You then select the installed database from the dropdown and select login.

I assume this is when you recieve your error message.  Could you tell me what the error message says, or if the error message happens at a different point (and what it says then)?

 

Thanks,

Bill

  • Filed under:
  • | Post Points: 0
Top 150 Contributor
Posts 7
Points 35
chintsys replied on Thu, Jan 25 2007 12:14 AM

I have a similar problem in not being able to log in, except in my case all the fields in the login box are locked.

The database name appears ok in the drop-down (as configured during installation) and is locked as well.  No errors during installation but I'm not sure if the Vault is configured correctly.

Any thoughts?

Chris

  • | Post Points: 0
Top 500 Contributor
Posts 2
Points 0

You know Bill, I looked through all the documentation and I could not find anything on the admin login!  Would you be kind enough to direct me to the document that contained this info?

 Thanks,  admin--->innovator worked.

 

Chris

  • | Post Points: 0
Top 10 Contributor
Posts 199
Points 1,180
Bill replied on Thu, Jan 25 2007 10:45 AM

Chris W,

 

Glad it worked!

 

For future reference, connecting to Innovator for the first time is covered in section 6 "Connecting to the Aras Innovator Server" of the Aras Innovator - Installation Guide.  However, I can see how you could overlook this when having to setup the client first.  I have passed this feedback onto our documentaion people to help make this easier for others in the future.  Thanks!

 

-Bill

  • | Post Points: 0
Top 10 Contributor
Posts 199
Points 1,180
Bill replied on Thu, Jan 25 2007 11:52 AM

Chris (chintsys),

So the fields are loaded, like in my previous screenshot, but you cannot type in them?

I'm not sure what this is, yet, but I can start with a couple of recomendations.

 

1)  Review your IE settings with the Aras Innovator - Internet Explorer Client Machine Configuration document.

(http://www.aras.com/support/Documentation/documentation.aspx)

2)  Clean your internet cache (In case the file was corrupted during download.)

(http://aras.com/Community/forums/70/ShowThread.aspx#70)

 

Could you provide me with a few details about your client machine?

1)  Operating system (Windows 2000 or XP)?

2)  Internet Explorer Version (6 or 7)?

3)  .NET version (2.0 or 1.1)?

 

Thanks,

Bill

  • | Post Points: 0
Top 150 Contributor
Posts 7
Points 35
chintsys replied on Fri, Jan 26 2007 5:50 AM

Hi Bill,

I'm running XP Pro / IE7 / .NET 1.1 on my local machine.  The Innovator software is installed on a remote machine running WIndows Server 2003 with SQL Server 2000, IIS6 and.NET 1.1.  I access this remote machine over a VPN.  There is the same locked "login screen" using IE7 on the server as well as on my local machine.  I have followed the recommendations in the Client Machine Configuration manual.  The Internet cache has been cleared with no apparent change on my local machine.

I did have .ASP extensions disabled in IIS "Web Service Extensions" when I first started but have already corrected this (and restarted WWW Publishing Service).  The database tables appear to be ok in SQL Server and I can see three login accounts in the User table (with all three enabled for login).

I'm wondering if this problem has something to do with the Directory Security settings in IIS.  Right-clicking "Properties" under the "InnovatorServer" entry in  "Default Web Site" and selecting the Edit button under the "Directory Security Tab" in my installation shows a user called IUSR_NEWSERVER enabled for Anonymous Access.   The only other box checked on this page is "Integrated Windows Authentication".  The dialog box looks a little different to the one shown in the Installation Guide manual which is presumably IIS5.   Currently, IUSR_NEWSERVER is only a member of Domain Users and Guests on the Windows 2003 Server.  The Installation Guide suggests this user should be an Administrator.  Is this correct?  I am a little hesitant to grant Administrator rights to an anonymous login.

Not sure if this is relevant, but the MDAC version on the our server is different to the one shown in the documentation:

HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\Version = 2.82.1830.0

Any thoughts you have on this would be appreciated.

Thanks,

Chris

 

  • | Post Points: 0
Top 50 Contributor
Posts 26
Points 60
natek64 replied on Fri, Feb 16 2007 1:08 PM

Hey Chris,

 Did you ever get this figured out?  I've got the same problem.  I'm thinking it might be something to do with the connection string, but I'm a complete novice when it comes to SQL Server/ASP.net.  Any suggestions would be great.

 

Thanks,
n8

~ n8
  • | Post Points: 0
Top 10 Contributor
Posts 199
Points 1,180
Bill replied on Fri, Feb 16 2007 1:44 PM

Hi nate64, and welcome to the forum.

Chris and I emailed about this issue, but we never put the result in the post.  My apologies.  Chris was able to work around this issue by using his machine IP address to connect, rather than his machine name.

Example:

http://192.168.168.16/InnovatorServer

Let me know if this helps.

-Bill

  • | Post Points: 0
Top 50 Contributor
Posts 26
Points 60
natek64 replied on Fri, Feb 16 2007 2:03 PM

Hi Bill,

I'm having the same issue as Chris.  I get the login screen with both Login and password fields "disabled" and the database pull-down grayed out.   If you have a minute to review this, my client machine setup is:

OS = Win XP Pro

Browser = IE7

.NET version = 2.0

 I first tried to set up a trusted connection for myself, but kept getting "Access Denied" messages when trying to create  a Database.  So I enabled windows & SQL authentication and changed the login to sa +password and that allowed the installation to complete.  So, I think I'm almost there, but just need a little help on this.

 

Thanks,
~ n8

~ n8
  • | Post Points: 0
Top 50 Contributor
Posts 26
Points 60
natek64 replied on Fri, Feb 16 2007 3:29 PM

Bill, 

Thanks for the response.  Is this in IE?  I get a .NET error when I use the IP address in IE.  Do I need to edit the web.config file?

 Thanks,

~ n8

~ n8
  • | Post Points: 0
Top 10 Contributor
Posts 199
Points 1,180
Bill replied on Fri, Feb 16 2007 3:47 PM

The .NET security policies are URL specific.   

You need to set a new .NET security policy for the IP address.

1) Close all IE windows.

2) Run the Manual .Net Security Tool (sdns.exe) using the new URL (http://192.168.168.16/InnovatorServer)

3) Open a new IE Window and login.

-Bill

 

Please also see:  http://aras.com/Community/forums/thread/66.aspx

  • | Post Points: 0
Top 50 Contributor
Posts 26
Points 60
natek64 replied on Fri, Feb 16 2007 4:44 PM

Hi Bill,

OK, Now the login fields are no longer greyed out. But no login that I've tried works:

admin+innovator

innovator+innovator

sa+password

myusername+password

I get an error in my connection string I think.

I'm pretty sure I've messed up the web.config file or the InnovatorServerConfig.xml file...

Suggestions where to start looking?

Thanks,

~ n8 

~ n8
  • | Post Points: 0
Top 10 Contributor
Posts 199
Points 1,180
Bill replied on Fri, Feb 16 2007 5:04 PM

What did you change in these files?

Roughly, if not exactly.

-Bill

  • | Post Points: 0
Top 50 Contributor
Posts 26
Points 60
natek64 replied on Fri, Feb 16 2007 6:13 PM

Hi Bill,
 

OK, got past that, now I'm getting the following error: 

"Exception during initialization (InnovatorDatabaseException: Login failed for use "admin'.)" 

  Installation error?

 thanks,

~ n8
 

~ n8
  • | Post Points: 0
Page 1 of 2 (19 items) 1 2 Next > | RSS