change sql svr administration

Question

change sql svr administration

webdaddy13

SSC Enthusiast

Points: 193
More actions
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

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

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

Jim P. SSCrazy Eights Points: 8725 More actions · Answer 1

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.

webdaddy13 SSC Enthusiast Points: 193 More actions · Answer 2

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

sa24 SSCrazy Eights Points: 8027 More actions · Answer 3

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.

webdaddy13 SSC Enthusiast Points: 193 More actions · Answer 4

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

ritterd SSC Journeyman Points: 83 More actions · Answer 5

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.

webdaddy13 SSC Enthusiast Points: 193 More actions · Answer 6

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

ritterd SSC Journeyman Points: 83 More actions · Answer 7

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.

webdaddy13 SSC Enthusiast Points: 193 More actions · Answer 8

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.

sa24 SSCrazy Eights Points: 8027 More actions · Answer 9

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.