Service accounts in installing sql server 2005
-
Hi
I'm a developer who has used sql server for a number of years. As seems to be the case in a lot of places, all the jobs I've had have had dbas or admins who installed sql server. I've had no experience in this area.
However I've purchased sql server 2005 developer for my laptop and, of course, had ot install it. I tried a number of different web pages that gave advice regarding windows authentication, service accounts, etc. I installed the developer edition many times using varous instructions and found I couldn't log in to the management studio. I finally found a page that had me choose "use builtin system account" with "local system". After that the web page had me choose mixed mode authetication and provide a password for the built in sa account.
This, at least, allowed me to log into the management studio and create databases, etc. but I had to explicitly log in using a sql server login (sa). The default windows authentication didn't work. I thought that would be an option with these installations instructions. I have read quite a bit about using windows authentication and it seems to be the preference. However I haven't found any way to make it work.
Any help would be appreciated.
Thanks,
Fig
-
Fig your new laptop is probably running Windows 7 or Vista, right?
thos operating systems changed, compared to XP; they no longer make your login an sql administrator when you install 2005/2008, you have to do it as a seperate step.
on my brand new HP laptop running Win7,
when installing 2005, I had to use the surface area configuration to add a new Administrator(myself):
and the next step was to simply add myself:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowell (5/24/2010)
thos operating systems changed, compared to XP; they no longer make your login an sql administrator when you install 2005/2008, you have to do it as a seperate step.
Really? I installed SQL 2008 Express on my Windows 7 machine and it allows my (local admin enabled) account to administer the server no problem! The only possible difference I can think of is that my machine is a member of a domain, so I'm using a domain account to log in to it; the said domain account is not a domain admin, though.
-
to add to Lowell's entry, you can also launch the account provisioning immediately after installing the SQL Server service pack (click the check box before clicking finish)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply