Skip navigation
Contact Us
5920 Views 7 Replies Latest reply: Mar 22, 2010 2:14 PM by M Ali RSS
Pete Josephs Newbie 13 posts since
Jan 18, 2010
Currently Being Moderated

Jan 18, 2010 6:42 PM

Powercenter/SQL Server Express Config Issues

I have installed SQL Server Express on my desktop.  When I try to install PC, and I come to the 'Configure Domain Database' screen it asks for the following:

 

Database Type:

Database URL:

Database User ID:

Database User Password:

Database Service Name:

 

Where do I find these?  When I enter what I think is correct, I get 'Connection Test Failed'.

 

 

Regards

 

  • Prashant Kumar Apprentice 248 posts since
    Sep 18, 2007
    Currently Being Moderated
    Jan 18, 2010 9:12 PM (in response to Pete Josephs)
    MS SQL Server details..

    Hi Check the properties of your Database. Definitely you will get all details.

     

     

    Database Type:MS SQL Server

    Database URL: Your Computer Name (find it from MyComputer Properties)

    Database User ID: DB UserName

    Database User Password: DB Password

    Database Service Name: DB that you are trying to access (ex: NorthWind DB)

     

     

    --Prashant

  • Prashant Kumar Apprentice 248 posts since
    Sep 18, 2007
    Currently Being Moderated
    Jan 18, 2010 9:12 PM (in response to Pete Josephs)
    MS SQL Server details..

    Hi,

    Check the properties of your Database. Definitely you will get all details.

     

     

    Database Type:MS SQL Server

    Database URL: Your Computer Name (find it from MyComputer Properties)

    Database User ID: DB UserName

    Database User Password: DB Password

    Database Service Name: DB that you are trying to access (ex: NorthWind DB)

     

     

    --Prashant

  • hari krishna Newbie 1 posts since
    Mar 3, 2010
    Currently Being Moderated
    Mar 3, 2010 12:14 AM (in response to Pete Josephs)
    connection failed

    'Configure Domain Database

  • M Ali Newbie 2 posts since
    Mar 20, 2010
    Currently Being Moderated
    Mar 22, 2010 1:49 PM (in response to Pete Josephs)
    Configuring Domain Database at SQL Server

    Today, I have installed PC 8.6.0 at Vista Home Prem and I would like to share my little experience as it seems relevant to the people trying to configure a SQL Server database as a domain database.

    Apparently, PC does not support Windows Authentication. Therefore, if you have created a database in SQL Server and you are providing your Windows user credentials at Domain Configuration step for PC installation, you will get a connection error; something like connnection refused.

    1) Therefore create a SQL Server user, assign him essential roles to connect to the database.

    2) Change the Server authentication from 'Windows Authentication' to 'SQL Server and Windows Authentication Mode'. Restart the SQL Server.

    3) Provide that created user credentials as username and password inside the textboxes of PC installer along with other mandatory fields.

     

     

    It worked for me. Hopefully, will work for you.

     

    P/S Webmaster of technet.informatica.com: I am using IE 8 and the contents of this page (where I am writing my comment) are littebit (I think 1 character) cut/chopped from the left side for this whole page (vertically).

     

    Ali

    • M Ali Newbie 2 posts since
      Mar 20, 2010
      Currently Being Moderated
      Mar 22, 2010 2:14 PM (in response to M Ali)
      Remember to Open Essential Ports

      There is one thing, I could not write above. If you are using Windows XP, Vista or later, PC installer will not be able to connect unless either Windows Firewall is off Or you have added the program port numbers in Exceptions. The typical starting port number used by PC is 6001, SQL Server's default port is 1433.

      Also, I had run PC installer from Command Prompt that was opened by the Administrator user. I am not sure if this is necessary to do that but I did it.

       

      Ali

More Like This

  • Retrieving data ...

Bookmarked By (0)