Registered users    
MembershipMembership:
Latest New UserLatest:Mary Reiman
New TodayNew Today:11
New YesterdayNew Yesterday:9
User CountOverall:23414
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12968
Marina Roos12627
Eriq Neale2117
Stan Guinn1917
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren650
Stewart Brown620
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Can't connect unless have admin rights.
Prev Next
You are not authorized to post a reply.

Author Messages
king raoh User is Offline
United States
Member since
7/12/2007

Registered Users
Posts: 2
7/12/2007 06:44 PM  
I have a new sbs 2003 r2 server and I have installed a company specific app that uses sql 2000 sp3. I am unable to connect using a workstation unless I give the user admin rights. If I try to connectwithout admin rights the app just shows that splash screen and disappears.
 
I am not sure what the problem is, and I am pretty sure the incorrect solution is to give all users admin rights.
 
Thanks in advance.
Michael Patrick User is Offline
United States
Member since
10/26/2005

Platinum Membership
Posts: 1914
7/12/2007 07:05 PM  
You should be able to allow for a group to have access to the database and assign the users to the group. But yes, admin rights are not suggested unless its just for that one particular database and the app requires it. (Too many applications still require admin access for some reason)
Michael Patrick

"Technology Interpreter Extraordinaire"
CAD, BIM & SBS
king raoh User is Offline
United States
Member since
7/12/2007

Registered Users
Posts: 2
7/12/2007 07:17 PM  
How do I do this? The application requires a sql login. Let's call the login "aaa", and this login already exists in the sql database. Do I create a group in windows called 'aaaGroup' and give it admin rights and then add users to the group?
 
If possible please be detailed on where in windows sbs I need to go in order to add these items. The extent of my knowledge of permissions and groups is small as I usually add and remove rights until things work the way I want. In this case it is production machine so I can't revert to my old ways.
 
Also if you have a link where I can read and learn more it would also be appreciated.
Edwin Sarmiento User is Offline
Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133
7/13/2007 11:47 AM  
The question here is this - does your application really require SQL admin account to log in to SQL Server? If yes, then just give the login "aaa" sysadmin privileges. In SQL Server Enterprise Manager, expand Console Root > Microsoft SQL Servers > SQL Server Group > (local)Windows NT > Security > Logins. You can create a new login (for a new account) by right-clicking on the Logins window and select New Login. For the "aaa" login, right-click on the login and select Properties. Go to the Server Roles tab and check the System Administrators check box - you're gonna regret doing this ;-)
MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA
http://bassplayerdoc.blogspot.com
Need a remote SQL Server DBA?
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
7/15/2007 11:59 PM  
Hi King,
 
You need to apply SP4 for that SQL instance as the SP3 isn't supported anymore.
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Can't connect unless have admin rights.


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.312502 seconds.   :   Terms Of Use   :   Privacy Statement