SMS install
I am trying to install SMS and SQL on seperate servers in seperate domains. I
have gave sa and local admin rights to the computer account and to the
account that is installing SMS. During the install wizard, I have choosen Adv
security and selected SQL security. The account I use for SQL security has
full access to the SQL server. In the SMS log file, it states that user does
not have access to the database. Can someone please assist me and clarify
this situation. Cheers.
.
Relevant Pages
- Re: sql problem
... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ... (comp.databases.oracle.server) - Re: sql problem
... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ... (comp.databases.oracle.server) - Re: sql problem
... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ... (comp.databases.oracle.server) - Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ... (microsoft.public.windows.server.security) - Re: Problems connecting to SQL Server
... Maximo is specifically stating that you must use the SA user ... to be the SQL 7 Product ID while scrounging around in some boxes. ... I will also try MDAC. ... And they specify the SA account. ... (microsoft.public.sqlserver.clients) |
|