Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
How to connect MAP 7.0 to an existing SQL server?

Answered How to connect MAP 7.0 to an existing SQL server?

  • Wednesday, August 08, 2012 11:21 AM
     
     
    Sign In to Vote
    2

    MAP documentations says that one can use existing SQL server for MAP database as long as non-default instance named MAPS is created. Also documentation mentions that instance is blocked from remote usage.

    So if i have SQL 2008 server with MAPS instance:

    1. Do i have to do any tweaks (open firewall ports etc.) to be able to use external database? I mean when documentation says MAPS is blocked from remote usage does that mean that firewall blocks network traffic?

    2. Can MAP be installed to separate workstation when database used is located on external  SQL server?

    When i install MAP it by default install local database. (I remember that earlier versions there was an opportunity to download and install SQL Express and use that but thats gone. ) It doesnt mention anything about MAPS instance on Installation Requirements page. When installed MAP it doesnt show Change button under Data source so i could change to external SQL server?

    When SQL server is installed on same workstation than MAP, i can switch to use MAPS instance instead of local database.

    What i am missing here?



    • Edited by Jouni J Wednesday, August 08, 2012 2:39 PM
    •  
     

All Replies

  • Thursday, August 09, 2012 4:52 PM
    Moderator
     
     Answered
    Sign In to Vote
    2

    1. MAP cannot use an instance of SQL Server located on a remote machine. SQL Server must be on the same machine that will have MAP installed. This also means that there isn't any firewall configuration necessary.

    2. No, MAP must be installed on the same machine that has the 'MAPS' SQL Server instance. The option to change from using "SQL Server 2012 Express LocalDB" (which is installed when you install MAP) to using the 'MAPS' instance is only available when there is a 'MAPS' instance already on the machine when you install MAP.

    One thing to note, the 'MAPS' instance can be from any edition of SQL Server, so if you had been using MAP prior to MAP 7.0 and had SQL Server 2008 R2 Express installed, then MAP will allow you to switch between the two editions (2008 R2 Express and 2012 Express LocalDB), but they both have the same 10GB limitation. The benifit of LocalDB is that it does only runs SQL Server when the MAP application is running, instead of SQL always running on the machine and taking up resources like previous versions.

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

     
  • Friday, August 10, 2012 5:27 AM
     
     
    Sign In to Vote
    1

    Thanks for the anwer. I was pretty sure that MAP couldn not use remote SQL database but still needed an answer from experts :O)

    1. MAP cannot use an instance of SQL Server located on a remote machine. SQL Server must be on the same machine that will have MAP installed. This also means that there isn't any firewall configuration necessary.