- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: Insufficient Rights to Database for Use SQL/MS...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2006 06:58 AM
тАО08-07-2006 06:58 AM
Insufficient Rights to Database for Use SQL/MSDE installation
The host specified is a SQL server 2005 SP1, and the account I am using is a domain admin for which the SQL server is a member of. The database name of SIM was created within SQL.
Any ideas, or other things to check?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2006 12:53 AM
тАО08-09-2006 12:53 AM
Re: Insufficient Rights to Database for Use SQL/MSDE installation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 06:05 AM
тАО08-18-2006 06:05 AM
Re: Insufficient Rights to Database for Use SQL/MSDE installation
I am installing SIMv5 on my XP workstation. I have installed a new MSDE database on my system per the HP SIM install. I created a database named "SIMv5" on my MSDE instance and I want to use THAT database instead of 'master' because I want to seperate my database files from my OS. I have tried every possible permutation of permissions on my MSDE database and still am recieving, "Insufficient rights to database."
What is driving me nuts is that I can delete all references and permissions to my user account in MSDE and still I have access to 'master'. I don't understand how I can have access to a database I have no permissions to, and a database I create I with DBOwner permissions and 'System Administrators' server role I am denied access (in the SIMv5 installation)
My thought here is that perhaps the installer is hard coded to use 'master' if the MSDE installation is on the local computer. If that's true, I want HP to rewrite their code. This won't be the first time I've ran into an app that defaults to 'master' when installing MSDE on the local computer.
Please advise.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 08:42 AM
тАО08-18-2006 08:42 AM
Re: Insufficient Rights to Database for Use SQL/MSDE installation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2006 06:53 AM
тАО08-28-2006 06:53 AM
Re: Insufficient Rights to Database for Use SQL/MSDE installation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2006 06:57 AM
тАО08-28-2006 06:57 AM
Re: Insufficient Rights to Database for Use SQL/MSDE installation
Regards, Matthew