TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ----------------------------------------------------------------------------
Hi. I have a customer who was installing RS. Everything works Ok apart from the user access between the EC and the database (MSSQL2K). If he uses the sa user it all works fine. If he uses the EventCollector user defined during installation it fails with the error: "Connection failed. SQL status '42000' SQL server error 40064 [MSSQL] cannot open user default database." Because the sa user works fine, this means that the Databases are there and working Ok on the SQL2K box, the ODBC config is correct, but that there is a problem with the permissions for the EventCollector SQL user. ISS Support came back to me and said the EventCollector user must have the following attributes: "EC Roles_memebership,Data_reader. data_writer, DB_ownerand Public" The question that ISS refused the answer was how can I verify that the account has been set up in this way...? I know a little about MSSQL but it relates to SQL 6.5 (*yeuch*) and I'm not willing to extrapolate across 2 major versions... Therefore please can someone fill the missing gap and give me an SQL statement (or SQL-EM guidelines) to see if the login exists and what permissions it has...? I did try to get this information out of ISS (call 578593) but they refused and told me I had to call Microsoft. Hence I am asking the list asking for your help. Any and all help would be much appreciated. Kind Regards, Jon Paine. Technical Lead. Allasso European Support Centre. SMTP - mailto:[EMAIL PROTECTED] WEB - http://support.allasso.com Tel. 0870 366 8533 (+44 118 971 1533) Fax. 0870 366 8544 (+44 118 971 1544) PGP Fingerprint: ADD3 07AC ED47 292A BF61 E124 E81F 9249 7AD9 6E0C Please note that: 1. This e-mail may constitute privileged information. If you are not the intended recipient, you have received this confidential email and any attachments transmitted with it in error and you must not disclose, copy, circulate or in any other way use or rely on this information. 2. E-mails to and from the company are monitored for operational reasons and in accordance with lawful business practices. 3. The contents of this email are those of the individual and do not necessarily represent the views of the company. 4. The company does not conclude contracts by email and all negotiations are subject to contract. 5. The company accepts no responsibility once an e-mail and any attachments is sent. Allasso Ltd Theale House, Brunel Road, Theale, Berkshire RG7 4AQ UK T: +44 118 971 1511 F: +44 118 971 1522
