Re: how do you set up an admin account?
- From: "Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 26 Jan 2006 19:21:48 -0800
If you log into Windows as an account that has administrative privileges on
the box and then log into SQL Server with Windows security, you are an
administrator in SQL Server and should be able to create logins to your
heart's content.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"middletree" <middletree@xxxxxxxxxxxxxxxx> wrote in message
news:udVR$4oIGHA.2928@xxxxxxxxxxxxxxxxxxxxxxx
> In a recent installation of 2005, I have been burned by the fact that I
> didn't set up something along the lines of SQL 2000's sa account. But in
> my defense, 2005 didn't ask me to do so. Now it won't let me into the
> account that I did set up, and I am probably going to have to uninstall
> SQL and reinstall.
>
> So when I do reinstall, where can I set up such an account?
>
.
- References:
- how do you set up an admin account?
- From: middletree
- how do you set up an admin account?
- Prev by Date: Re: Upgrade 500 databases from SQL 2000 to SQL 2005
- Next by Date: Re: Upgrade 500 databases from SQL 2000 to SQL 2005
- Previous by thread: how do you set up an admin account?
- Next by thread: SQL 2000 Standard and SQL 2005 Developer - Co-exist
- Index(es):
Relevant Pages
|
