Forum Discussion
I'm a bit limited in my knowledge with SQL management. Years ago I did some very light stuff in SQL 2005 mgmt studio.
Mgmt stduio wasn't installed so I downloladed and installed that. For Server Name I brosed, found the server and instance for BLACKBERRY. When I open it, by default it wants Windows Auth. Default domain admin I use was already there so I went ahead. However clicing on various item sin the hierarchy often gives errors about not have rights.
Just for the record, though it may not be relevant, the SQL services in Windows that runs this instance has Local System in the Log On tab - just FYI.
In tems of logging into SQL mgmt stduio to make changes, do I log in as sa? There is also a Login there called BDSMgmt with BDS meaning the BlackBerry server so perhaps that's hte user I should try. Howefvfer I don't know the password for either of these two users as we had an outside consultant set up the Blackberry server.
So, do I need to log into SQL Mgmt Studio with one of those two accounts? I'm really quote confused about this whole process.
If BE can't "get into" SQL to enable GRT restores, I assume that means it cannot access the db to effectively "log in". But the question is, what's trying to log in? The Log On account that starts the Agent for Windows service? If so, that is just Local System.
Or is BE using the sa account from within SQL? Thisis where I'm getting lost, what account is BE trying to leverage to gain that access to the BLACKBERRY instance so it can do it's GRT itemization.
Please take a confused fellow and show him where to check for these things :)
Related Content
- 12 years ago
- 11 years ago
- 12 years ago
- 14 years ago