Knowledge Base

Knowledge Base
Advanced Search Search the Knowledgebase
"SQL Server does not exist or access denied" error
Author: Microengine Views: 17187 Created: 01-06-2015 05:38 PM 0 Rating/ Voters

This article contains steps to fix problem where error message "SQL Server does not exist or access denied" pop up upon login to xPortalNet Server.

Applies To:

  • Software xPortalNet     
 Problem
 

› Unable to run xPortalNet Server. Error message will be shown.  

 Symptoms
 

 Error message as shown below will be pop up.
   

 Cause (optional)
 

 Upon initializing database, the server name is not change from localhost to SQL Server name.    

 Resolution Summary
 

 Re-initialized the database.
 See small How to install xPortalNet? for complete xPortalNet installation steps.   

 Resolution
 

Please perform steps below to solve the issue.

  1. Please quit/ stop any running xPortalNet software. 
  2. Re-initialize the database.
    Please make sure the xPortalNet folder is not yet created at server location folder.
    WindowsDefault Server Location
    Windows XP
    Windows Server 2003
    Windows Server 2003 R2
    C:\Documents and Settings\All Users\Application Data\MicroEngine
    Windows 7
    Windows 8
    Windows 10
    Windows Server 2008
    Windows Server 2008 R2
    Windows Server 2012
    Windows Server 2012 R2
    Windows Vista
    C:\ProgramData\MicroEngine
  3. If the folder already created, please delete the folder. 
    Caution: You can only delete the folder if it is new database initialization. If it is existing database, please make a database backup before can delete it. 


  4. Run xPortalNet Service and xPortalNet Server again to re-initialize the database.
    1. Change the Server Name from localhost to the correct SQL Server name.
    2. Enter the correct password to access the SQL Server.
    3. Click Initialize Database.

  5. The following pop up message will be shown to determine that user has successfully created database. Click OK.

  6. Database initialization completed. 
  7. Login to the xPortalNet Server and xPortalNet Client accordingly.
Custom Fields
  • Summary: This article contains steps to fix problem where error message "SQL Server does not exist or access denied" pop up upon login to xPortalNet Server.
  • Search Tags: sql server does not exist or access denied, initialized xportalnet database, default server location
Related Articles
Comments
  • There are no comments for this article.
Submit Feedback on this Article