Post reply

Authenntication problem in SQL Server 2005 SP1

  • June 8, 2006 at 2:55 am

    #172749

    While Installing SQL Server 2005 SP1 it ask for authentication for Diferent services like Database and Reporting, After providing with user name and password for SQL Authhentication it says unable to connect with it, and same happend when selecting Windows Authentication.

    While these services run under both mode and able to loging to them.

    Checked everything like if services are running.

    Any one-Some One, Any Idea-Some Idea.

  • June 12, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 29, 2006 at 6:00 pm

    #646873

    I'm having the same problem.  I've checked that all the services are running.  I've tried both authentication methods.  Although it says to unselect the one that is causing the problem, I see no way to actually do this.  I've tried to deselect in the treeview all but the database engine upgrade, but it only allows all or nothing.  I can't deselect only one of them, as clicking the checkbox doesn't do anything.  I can click the node they are under and it will deselect everthing.  But I likewise cannot select only the ones I really need.  Seem to be caught in a catch 22. 

     

  • June 29, 2006 at 7:15 pm

    #646875

    OK, I found the problem.  It appears to be due to a machine rename problem.  Reporting Services was trying to connect to the original name.  I did not realize the machine had been renamed after SQL 2005 was installed.  SQL still have the old name registered, though parts of it were using the new name of the machine.  I renamed the SQL Server and the problem is fixed.

    Here is a script that should help fix the problem.  Be sure to restart the services after the name change so the new name will take affect.  

    -- get current SQL Server name\instance name
    SELECT @@SERVERNAME
    -- get current machine name and instance name
    SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY ('InstanceName')
    -- You should see different names.  If so, you've got the problem too.
    -- Now drop the old name and add the new (correct) name.
    sp_dropserver 'TX1-IMAGE-2K3'
    go
    sp_addserver 'TX1-VINE-2K3','local'
    go
    -- RESTART SERVER

     

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

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