Mark Minasi's Reader Forum - How to connect MAP to external SQL server?

Mark Minasi's Reader Forum

Username:	Password:
Save Password
Forgot your Password?

All Forums

HALP! Questions on Windows and Windows Server

Deployment: Windows and apps

How to connect MAP to external SQL server?

New Topic

Reply to Topic

Printer Friendly

Author

Topic

ervi
Seasoned But Casual Onlooker

Finland
67 Posts
Status: offline

Posted - 08/08/2012 : 10:40:48 AM

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 server with MAPS instance with right collation order:

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 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?

ervi
Seasoned But Casual Onlooker

Finland
67 Posts
Status: offline

Posted - 08/10/2012 : 01:29:24 AM

Answer is that MAP cannot use external database :(

http://social.technet.microsoft.com/Forums/en-US/map/thread/40e4b604-ff0a-4424-af0b-b77045ad0c1b?prof=required

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

Mark Minasi's Reader Forum

This page was generated in 0.09 seconds.

Snitz Forums 2000