I am trying to connect to a local instance of SQL Server 2008, and I can't seem to figure out what "service name" is actually referring to in the connect dialog in Map3d 2009.
Is this the IP address? should i use "localhost"? Should I use the name of the windows service (MSSQLSERVER)? There is no documentation that I can find anywhere that says what this actually means, and I can't seem to find anyone on the internet who has actually gotten this to work. I saw a video on channel9.msdn.com where the Autodesk guy did it, but the screen was so blurry I couldn't tell what he was typing in.
Also, does this allow me to use Windows Authentication to connect? Or do I have to create a SQLServer user account? The documentation seems to be specific to ORACLE, and generic for everything else. It's extremely confusing, fyi for any Autodesk technical writers reading this. I'm not a total idiot when it comes to connecting to databases etc... and I am completely stuck.
Anyways, I'm desperate now, this thing is driving me crazy. Also, the bulk copy command doesn't seem to work on sql server. I was able to connect to the SQL Server instance by creating a system DSN and using the ODBC driver, but it doesn't seem to recognize my geography data in my database. It only recognizes a table where I have a field called latitude and one called longitude.
Any help would be greatly appreciated. This is a Windows Server 2003 box with SQL Server 2008, Visual Studio 2008, Autodesk Map 3d 2009 with sp1, etc...