Post reply

Change to domain account for sql

  • December 20, 2006 at 1:54 pm

    #62691

    I changed the service account for sql server and sql agent from system account to a domain account. Now I can't connect with tcpip, I have to used named pipes.  Cant I use tcpip to connect when running sql under a domain account?

    thanks

  • December 21, 2006 at 9:27 am

    #679478

    Is your server listening on TCP/IP? Check the most recent SQL Server log. Look at the earliest times, which is the start up sequence. You should see something like this:

    SQL Server is ready for client connections

    SQL server listening on TCP, Shared Memory, Named Pipes.

    SQL server listening on 127.0.0.1: 1433.

    SQL server listening on 172.27.200.41: 1433.

    If TCP is not included in the list of protocols, then clients cannot connect using TCP/IP.

    See if this link helps:

    http://support.microsoft.com/kb/328306

  • December 21, 2006 at 1:23 pm

    #679540

    Did you change the account usinig Enterprise Manager/Config manager? If not, you could be missing permissions.

  • December 21, 2006 at 8:07 pm

    #679625

    No, nothing else changed other than set sql to start with domain account, then stop/start sql server and agent.  I haven't bounced the server yet but I don't see that it should change anything.  I checked the log and it shows that it is listening for tcp on 1433.  Weird huh.

  • December 21, 2006 at 9:45 pm

    #679631

    Responses thus far have focused on the server not accepting connections via tcp/ip. Could it be that the client requesting connection is at fault, instead?

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

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