Crystal Report Wizard Problem
-
Hi all, I'm using sql server that is with VS2005.i want create CrystalReport with wizard,but in connection information step(in section 7 of below list), i don't know what name i should select for server in server drop down list (there is no name for server in drop down list) that my data bases comes in drop down list for section 8 to choice my data base, 1. Start a new CR report from the Project menu in VS2005 2. Choose the Standard report expert 3. On the Data form, Expand 'Create New Connection" 4. Expand OLE DB(ADO) 5. Select SQL Native Client 6 Click Next and check Integrated Security. This will grey out the Sql autentication. 7. Select your SqlExpress Server name from the drop down list 8. Select your database name from the drop down list 9 Click Finish. where is the problem? please help me. Thank You,
Hoda
-
Hi all, I'm using sql server that is with VS2005.i want create CrystalReport with wizard,but in connection information step(in section 7 of below list), i don't know what name i should select for server in server drop down list (there is no name for server in drop down list) that my data bases comes in drop down list for section 8 to choice my data base, 1. Start a new CR report from the Project menu in VS2005 2. Choose the Standard report expert 3. On the Data form, Expand 'Create New Connection" 4. Expand OLE DB(ADO) 5. Select SQL Native Client 6 Click Next and check Integrated Security. This will grey out the Sql autentication. 7. Select your SqlExpress Server name from the drop down list 8. Select your database name from the drop down list 9 Click Finish. where is the problem? please help me. Thank You,
Hoda
At the time of installation of SQL, You checked the SQL Server Authentication instead of Windows Authentication. That why when you check the integarted security there is no server found. Solution: 1- Write the system name + \SQLEXPRESS e.g. System Name is abc then write in the Server Combo abc\SQLEXPRESS 2- Uncheck the intgerated security and write username with password. 3- Reinstall the SQL with Window Authentication Mode.