Access MySQL from SQL Server Managment Studio

Have you looked at:

http://www.jamfsoftware.com/libraries/pdf/press_release/CasperSuite-SCCM_Integration-Press_Release.pdf

Don

http://jamfsoftware.com/kb/article.php?id=022
---
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

export the sql file from JSS setup tool open it and find the password for the DB.

--
Todd Ness
Technology Consultant/Non-Windows Services
Americas Regional Delivery Engineering
HP Enterprise Services

No. You need to allow remote access on the database. It's a security feature of MySQL. This is what step 3 of the KB article is doing. The <hostname> part is the machine you want to allow <username> access from. Use * if you want that user to access the database from any host.

Also, why would you ever ever ever use root for remote access to anything? Make a read only account.

Good lord.
---
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436

Just wanted to make sure.
On 6/20/11 9:13 AM, "Swanson Noah" <SwansonNoah at JohnDeere.com> wrote:

Are you aware that JAMF offers a JSS --> SCCM connector? Of course, this
wouldn't be a solution if you don't want to populate your SCCM with Mac
assets but since you already have that connection then this would be an
easy solution.

--

William Smith
Technical Analyst
Merrill Communications LLC
(651) 632-1492

The jamf KB says to "sudo mysql", then it prompts me for an admin password for sudo. I'm assuming it's passing those creds for mysql and not asking for another password.

No, it's not. MySQL has its own user structure.

j
---
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436