Skip to main content

Posts

Showing posts from May, 2010

The credentials you provided for the SQL server Agent service are invalid. To continue, provide valid account and password for the SQL server Agent Se

The credentials you provided for the SQL server Agent service are invalid. To continue, provide valid account and password for the SQL server Agent Service.
Today, I have decided to install SQL SERVER 2008 on my PC. All was going fine until I came to server configuration page/tab. I was halted for half an hour to insert correct credential to move to the next page. If you are also getting the same trouble then just enter following data in Account name and password:
Account Name : "NT AUTHORITY\NETWORK SERVICE " Password : Blank
I hope this will resolve your issue.

FORMATTING NUMBERS IN SQL

To format numbers in sql queries in SQL SERVER 2005, use the following command
Select Convert(nvarchar,cast(123123323 as money),1)
This will convert the following number 123123323 to 123,123,323.00