I thought I would try the Kixtart community to see if anyone could understand my question and not point me in the wrong direction. (Microsoft tech on Google Groups reference)

Anyway, I have a fresh install of SMS 2003SP1 on a Windows 2003SP1 server. Everything is working great on the server. I'm trying to install the Administrator Console on my WinXPSP2 workstation. After installing the console I attempt to connect to the SMS site database and I get an error of, "database does not exist".

I went to the SMS server to check permissions. My account was in the SMS Admins group on the server (this should have been all I needed) but I wasn't connecting. For fun I placed my user account into the Local Administrators group on the SMS server and I could connect. This is a work-around, but it is not going to work as a solution in my environment where I have two other staff members who will need to Administrator Console on their computers. I don't want to grant them local Admin rights on the SMS server.

I have my XPSP2 firewall turned off. The Windows2003SP1 server has the firewall disabled. This is obviously a permissions issue, but so far, Microsoft has no resolution for this issue. I've also granted my user account dbowner permissions on the SQL server seperate from granting my account local admin rights. That didn't work. The only thing that works so far is granting my account Local Admin rights.

Does anyone have a solution or has heard of a solution?

Ugh.... Matthew