Re: SA can not create users



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

.



Relevant Pages

  • Re: Microsoft SQL-DMO (ODBC SQLState: HY000) error when opening any ob
    ... I didn't encounter any difficulty using Query Analyzer. ... But this error message does pop up everytime I open an object in the ... database on the hosting company's server, when using SQL Enterprise Manager. ... Otherwise try asking the web host about it. ...
    (microsoft.public.sqlserver.server)
  • Writing empty string to SQL Server table using Db-Library
    ... I am experiencing problems in writing empty strings to ... the query from the Query Analyzer. ... table using the Enterprise Manager after ... The error message "Runtime Error: ...
    (microsoft.public.sqlserver.programming)
  • Writing an empty string to SQL Server using Db-Library
    ... I am experiencing problems in writing empty strings to ... the query from the Query Analyzer. ... table using the Enterprise Manager after ... The error message "Runtime Error: ...
    (microsoft.public.sqlserver.clients)
  • Re: adp connection to msde and exclusive rights
    ... I'd recommend not using Access as a development tool for SQL Server ... Use the Query Analyzer or Enterprise Manager instead. ... error message you're getting is an Access error, ...
    (microsoft.public.sqlserver.msde)
  • Error using EM to view data
    ... I have a rather annoying problem with enterprise manager. ... edition (SP3). ... and reinstalling SQL Server client tools + sp3, ...
    (microsoft.public.sqlserver.server)