Hello
I am attempting to get a LNDB on a dedicated workstation to connect to our R&D SQL Server 2008 system. I created a local account and gave it ownership of a local database (set to SQL 2005 compatibility).
The machine doesn't use port 1433, it uses another port (yes, we still recall the slammer worm with great dread).
In the LNDB Manager - Select Database Dialog:
1. How do I put in the port number into the UI.. I've tried:
"fully qualified URL;xxxx" and "," and ":"
2. I can't seem to figure out how the Database Dialog persists information to "C:\Campbellsci\LNDB\sys\inifiles\login.xml" I though that I could manually fill in the XML, but it appears you hash the passwords (that is NOT a complaint btw).
And.. I can ping the server from the workstation.
Thanks!
DRG
After some more experimentation I hit the magic combination.
it is in the format of a ","
DNS name, port
I first connected using a domain account to my server, then I configured a new user account in SQL, and created a database. Then I created a new account on the server, with membership in the SQL group.
Then I changed the connection details and Viola! Connection.
Haven't started pushing data yet, that's next week's project.