|
Home > Archive > Microsoft SQL Server forum > September 2005 > SA can not create users
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SA can not create users
|
|
| sanjitg via SQLMonster.com 2005-09-28, 9:23 am |
| Even Sa account is in sysadmin role it is not able to create users using
enterprise manager
Also not able to create users from local admin who is alo on sysadmin role
But using query analyzer we can create users
Is some thing wrong with master database
Sanjit
| |
| Simon Hayes 2005-09-28, 9:23 am |
| If it works correctly from Query Analyzer, then the problem is most
likely Enterprise Manager, but you don't say exactly what happens - is
there an error message? If you haven't applied the latest MSSQL
servicepack (SP4) to your client, then that would be worth a go - if
that doesn't help, then you could try uninstalling and reinstalling the
client tools completely.
Even if you fix the problem, I would continue to work with QA for this
purpose, because then you can save your admin scripts, put them in
source control, run them against multiple servers and databases etc. EM
is certainly useful, but QA is preferable for many tasks:
http://www.aspfaq.com/show.asp?id=2455
Simon
| |
| sanjitg via SQLMonster.com 2005-09-28, 9:23 am |
| Yes i have SP4 installed
In security—logins when you right click to create new login that option is
disabled
I am not able to se properties of existing users
There is no error msg or error number
I also thought it may be enterprise manager but if I register different
server on same enterprise manager I am able to create users for that new
server
Sanjit
Simon Hayes wrote:
>If it works correctly from Query Analyzer, then the problem is most
>likely Enterprise Manager, but you don't say exactly what happens - is
>there an error message? If you haven't applied the latest MSSQL
>servicepack (SP4) to your client, then that would be worth a go - if
>that doesn't help, then you could try uninstalling and reinstalling the
>client tools completely.
>
>Even if you fix the problem, I would continue to work with QA for this
>purpose, because then you can save your admin scripts, put them in
>source control, run them against multiple servers and databases etc. EM
>is certainly useful, but QA is preferable for many tasks:
>
>http://www.aspfaq.com/show.asp?id=2455
>
>Simon
| |
| Simon Hayes 2005-09-28, 9:23 am |
| It sounds as if the server was registered in EM with a non-sysadmin
account, but I assume you've already checked that? You might try
removing the registration and re-creating it with a sysadmin account,
just to be sure.
Simon
| |
| dbahooker@hotmail.com 2005-09-28, 9:23 am |
| do you have SP4 installed on the client AND the server?
you need that right?
| |
| sanjitg via SQLMonster.com 2005-09-28, 11:23 am |
| i try to reregiter server using local admin and Sa account
and both accounts are in sysadmin
and i have sql 7 with sp4 on server and i am trying this directly on server
Simon Hayes wrote:
>It sounds as if the server was registered in EM with a non-sysadmin
>account, but I assume you've already checked that? You might try
>removing the registration and re-creating it with a sysadmin account,
>just to be sure.
>
>Simon
| |
| Simon Hayes 2005-09-29, 3:24 am |
| If you're absolutely sure that the registration is using a sysadmin
account, then I have no idea why you can't create logins. Can you do
other sysadmin tasks successfully in EM, such as creating scheduled
tasks owned by sa?
It may be a bug of some sort, but if so it's very unlikely that you'll
find a fix - there will be no mainstream support available for SQL 7
from the end of this year. And since you can manage logins from QA
anyway, it's probably not a critical issue.
Simon
| |
| sanjitg via SQLMonster.com 2005-09-29, 11:23 am |
| i also saw sp_columns was not working
there are other admin function i was not able to do
so i did rebuild master database and it worked out fine
Simon Hayes wrote:
>If you're absolutely sure that the registration is using a sysadmin
>account, then I have no idea why you can't create logins. Can you do
>other sysadmin tasks successfully in EM, such as creating scheduled
>tasks owned by sa?
>
>It may be a bug of some sort, but if so it's very unlikely that you'll
>find a fix - there will be no mainstream support available for SQL 7
>from the end of this year. And since you can manage logins from QA
>anyway, it's probably not a critical issue.
>
>Simon
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200509/1
|
|
|
|
|