asked on

SQL Server Install

I have installed SQL Server (Developer Edition) on my laptop using local windows authentication...By default the system gave me only public access. If I try to add BUILTIN/USERS to other roles like sysadmin I get the following error message:

"Add member failed for server role 'sysadmin'
Additional Information:
An exception occured while executing a Transact-SQL statement or batch
User does not have permission to perform this action (Microsoft SQL Server, Error 15247)"

Any Recomendations?

lexiflex

By default SQL Server installs the login "BUILTIN\Administrators" and gives this account sysadmin rights. This login represents all Windows accounts with administrator privileges. Are you trying to alter the permissions while logged in into SQL Server with a Windows administrator?

What Authentication Mode did you install SQL Server with? If you chose Mixed Mode, you should have a "sa" password you could use to alter permissions and add logins.

Which edition of Windows did you install on btw?

dwood1112

ASKER

I did not choose the mixed authentication on install...I chose local authentication. ..so I have no sa password. If I go into Security / Server Roles...only sa is showing...If I try to add BUILTIN /USERS it throws the same error that I referenced above....I'm running on Windows Vista

Should I just reinstall SQL and choose the mixed mode of authentication? If so, should I uninstall SQL first...or can I just simply reinstall over the current install?

lexiflex

Before taking such drastic measures, the reason I asked for the Windows edition is because there are some known issues involving Vista, SQL 2005 and authorization. My knowlegde about this is very limited but you can find more about this here: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_windows_vista

ASKER CERTIFIED SOLUTION

lexiflex

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dwood1112

ASKER

Great! I'm waiting on SP2 to arrive by CD...For some reason, everytime I go to the Microsoft site and hit the download button, I get a message that the web page cannot be opened.

Anyway...when it comes, I will load it up and give it a try.

Thanks for your help

lexiflex

Allright, good luck!
I myself am running Vista on my laptop but I have the development ed. of SQL Server installed on a vpc which is running XP. If your laptop is good enough (minimal 2GB RAM) that might be worth considering.