September 14, 2009 at 2:51 am
failed installation of the SQL server 2005 service pack 3 due to login issues at the installation step.
pop "message is your account information could not verified"
I tried login as administrator windows authentication , failed
and “sa” using SQL Server authentication but no success
I have selected instance datbase services and report services for instalation
when I am login as Sa database services is status is sucess but report service status is failed.
1.SQL Server login and password that has sufficient privileges
2.set the permissions for the data folder to the administrator being the owner with full control
it windows 2003 server 64 bit.
Please let me know how to solve longin issues.
September 14, 2009 at 3:14 am
prajeevan (9/14/2009)
failed installation of the SQL server 2005 service pack 3 due to login issues at the installation step.pop "message is your account information could not verified"
I tried login as administrator windows authentication , failed
and “sa” using SQL Server authentication but no success
I have selected instance datbase services and report services for instalation
when I am login as Sa database services is status is sucess but report service status is failed.
1.SQL Server login and password that has sufficient privileges
2.set the permissions for the data folder to the administrator being the owner with full control
it windows 2003 server 64 bit.
Please let me know how to solve longin issues.
the quick fix for this, is to use a local server admin account and grant that account/group sysadmin access temporary in order to do the service pack. it is not the cleanest or the most ideal but for a quick solution without knowing about your accounts and permissions it will work.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 14, 2009 at 5:23 am
I'm trying to install sqlserver SP3 and for some reason I'm getting an error on the authentication pop message
The warning error is: "Your account information could not be verified. Press Ok to return to Authentication Mode screen to determine the reason for failure." For setup to verify your credentials the services must be startable, connectable and you must be a SQL Server administrator." In the Reporting service status the value reads "Login Failed: ".
I'm a local admin on this machine
winodws server 64 bit
September 14, 2009 at 5:30 am
prajeevan (9/14/2009)
I'm trying to install sqlserver SP3 and for some reason I'm getting an error on the authentication pop messageThe warning error is: "Your account information could not be verified. Press Ok to return to Authentication Mode screen to determine the reason for failure." For setup to verify your credentials the services must be startable, connectable and you must be a SQL Server administrator." In the Reporting service status the value reads "Login Failed: ".
I'm a local admin on this machine
winodws server 64 bit
As I mentioned before in my previous post....
Is your account, a member of the sysadmin server role in sqlserver. if not add it in and it should work.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 14, 2009 at 5:41 am
yes sa member of the sysadmin server role in sqlserver.
September 14, 2009 at 11:53 pm
we have identified
SQL server Resource is in C\program file and master and log files are in D drive. Due to above change installation of service pack 3 failed.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply