Friday, March 9, 2012

Error in installing SP1 or sp2

I have a sql server 2005 developer edition installed on my windows xp system.

I apply sql server 2005 sp1 then sp2 all does successfully.

Now I have installed same sql server 2005 developer edition on windows 2003 server

When I installed sp1 or sp2 i get the following error


Invalid Login Information

Your account information could not be verified for one or more instances.

Ensure that you can connect to all the selected instances using the account information provided.

To proceed further deselect the instances to which connectivity cannot be established.

OK

I have done every thing.PRovided sql server as well as windows authentication.

I can easily login by both.But Can't able to apply any Service pack even I uninstalled or reinstall the product.

Please help me what can i do ?

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

Thanks,

Peter Saddow

|||.
I am simply getting the invalid authentication error I don't know Why it happens ?|||

I doesn't get any such Dialog

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

|||SQL Server Configuration Manager=>SQL Server 2005 Services=>SQL Server Reporting Services=>Properties
Log On Tab => Configure => Database Setup

No comments:

Post a Comment