How to install CMS database on Sql Server

[Former Member]

Hi

Now I am installing Crystal Reports Server 2008, current environment is windows server 2003 + Sql Server 2005.

During the installing, because I want to use Sql Server 2005, so I picked "use a existing database server", however when I get into "select existing cms database" step, and selected "Sql Server(ODBC)" there is nothing show on the ODBC(DSN) list, I have already create a new ODBC on Data Sources(ODBC), when I click "browse" I can not find any data source, so that is mean I have to install a new mysql database in my server, but I don't want to, I just want to use the Sql Server, could you tell me why or how to do it?

Thanks in advance.

[former_member145588 · Accepted solution]

If you select SQL Server as your CMS database make sure that the datasource you created is a Machine DSN and not a User DSN. Make sure that you have created a blank SQL Server database and have your Machine DSN point to it.

I hope that helps

[Former Member · Accepted solution]

Thanks