Unable to create repository connection

hboekel · Post by **hboekel** » Fri Mar 23, 2007 6:34 am

Hi,

I installed ProfileStage on my laptop (windows): all components on 1 machine. For the repository i downloaded and installed SQL Server 2005 Express edition.

Using the MS SQL Server Management Studio Express tool I can see that the PSDB is created and that it contains tables.

After starting PS i first need to create a repository connection for my analysis server using Connection Manager. However, when clicking the appropriate button (Lightning) / double click on the analysis server, nothing is happening. The Edit Connection dialog box does not appear.

What am i doing wrong?

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2007 6:50 am

Have you created an ODBC DSN for your PSDB?

hboekel · Post by **hboekel** » Fri Mar 23, 2007 6:56 am

Yes, i created an ODBC system DSN called PSDB. From the ODBC adminiatror i can test the connection and it works ok.

When i start ProfileStage client this PSDB is the DSN i use to logon.

hboekel · Post by **hboekel** » Fri Mar 23, 2007 7:05 am

Don't know what exactly happened / changed but it's working now.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2007 5:12 pm

also

Thamilton · Post by **Thamilton** » Thu Sep 24, 2009 8:36 am

Awhile back (2007) you had a post saying you couldn't connect to the Repository. You later said it started working. Did you ever find out why it wasn't working to begin with

DSXchange

Unable to create repository connection

Unable to create repository connection

ProfileStage - Getting connected to Repository