Post reply

change sql svr administration

  • March 29, 2005 at 12:46 pm

    #185573

    Originally our remote SQL SVR 2000 was installed under the builtin admin account; windows 2003 server. I want to change that and disable the builtin admin account but when I do I cant talk to the sql svr I get not associated with a vaild sql svr when I use another admin level account and create a datasource to talk to SQL.

     

    How can I change this?

    Thanks in advance for any help

     

     

  • March 29, 2005 at 12:54 pm

    #549394

    Is this a stand alone server? If so does that local user account have full permissions to all the data and executable paths?

    If a member of the domain - are you using a domain user account? And properly specifying the domain? Does the domain user have full permissions to all the data and executable paths?

    Just a couple of thoughts.



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.

  • March 29, 2005 at 2:50 pm

    #549424

    thanks Jim not a domain a workgroup and a stand alone server but I setup all the admins to have permissions both on the iis machine and the SQL svr machine.

     

    Hope this clears it up

     

     

     

  • March 29, 2005 at 2:58 pm

    #549426

    If you already have another account with admin privilige, you can add that account to sql server and grant it sysadmin privilige. And then remove the builtin\admin group. You can then set the account as the service account for SQL server. This will restrict everybody in the admin group from having access to SQL Server. You can now exclusively grant permissions to any users.

    Hope this helps.

  • March 29, 2005 at 3:04 pm

    #549429

    thanks sa24

    you are on to something how do make the new admin whomever I choose the service account for SQL SVR? That is exactly my problem b/c even when I use sa and password to create a datasource on the iis machine it is telling me not a trusted SQL SVR

    hope this adds more

     

  • March 30, 2005 at 6:58 am

    #549529

    If stating that it's "Not a trusted SQL Server connection" when using a SQL Account, it appears that the authentication is set to Windows only.  Make sure that both are selected.  You can do this via Enterprise Manager.

  • March 30, 2005 at 12:25 pm

    #549622

    thanks ritterd where can I make this change in enterprise manager to recognize both I see a radio button that looks like it picks one or the other

    webdaddy13

     

  • March 30, 2005 at 12:44 pm

    #549632

    On the Security tab.  Select the radio button that states "SQL Server and Windows"  should be the first listed.  If that doesn't resolve your issue, make sure that you aren't using the trust connection or the /E parameter on your datasource.

  • March 30, 2005 at 2:15 pm

    #549667

    I am not following you please send screens if possible or detailed info I am running SQL svr 2000 In the security screen I see only logins server roles and etc.

  • March 30, 2005 at 2:55 pm

    #549676

    Right click on the Servername in enterprise manager. Click on properties. Select the Security tab and select the radio button Sql server and windows instead of Windows only. I can't post screen shots over here.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply