Hello Friends
We are getting a strange error while installing CMS on SQL Server 2005 box. We are able to login SQL Server 2005 box using username and password but when we are trying it from CMS, its saying Login failed for user. Detailed error message is Unable to connect to the database using the provided connection string. reason [Microsoft][ODBC Sql Server Driver][SQL Server] Login failed for the user.
WE are using generic username for SQL Server 2005 and password is almost 20 characters and it includes special characters. Do we need to fallow any specific password standards here.
Any help will be greatly appericiated.
Thanks
bhuvanasai (BOB member since 2007-05-24)