Post reply

Win2K Security

  • July 29, 2002 at 4:34 am

    #78997

    Hi,

    Please can someone help. I have installed an instance of SQL2K on win2K and set up a Local Administrators account. I have been unable to connect to it accross the network, even thouhg my windows account is an Admin one. I have never done this before - what have I missed? Do I need to set up a login??

    Thanks

  • July 29, 2002 at 4:20 pm

    #433598

    Sounds like you used a local account to authenticate in SQL Server instead of using a domain account.

    Try authenticating to it using this syntax:

    \\machinename\username instead of just username.

    where machinename is the machine that SQL Server is installed on and username is the admin account that you set up.

    On a related note, I find it easier to use the SQL authenication rather than dealing with integrated Windows / SQL authentication, but that's a personal preference.

    HTH,

    Brandon



    -Brandon

  • July 30, 2002 at 4:24 am

    #433615

    Thanks, I managed to connect at last. I agree about connecting via SQL, but I don't have an option, company policy etc.

    I am getting really twisted up with global groups, Domains, Service Accounts, domain cotrollers etc.

    Anyone know a good Windows Forum??

    Thanks again

  • July 30, 2002 at 8:08 am

    #433628

    You can try http://www.swynk.com. I usually use them for Exchange-related stuff, but they have a decent just-Windows section too.

    -Brandon



    -Brandon

Viewing 4 posts - 1 through 3 (of 3 total)

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