Forum Replies Created

Viewing 15 posts - 76 through 90 (of 173 total)

  • RE: Connect To Database Engine does not respond

    monietamarind (8/25/2010)

    Would you mind posting step-by-step instructions as I am not too familiar with SQL Server 2008? Thanks.

    Here are the steps to get to the SQL Server Configuration Manager...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 25, 2010 at 9:13 am

    #1211706

  • RE: Remote Connection Error to MSSQL 2008

    DavidZahner (8/24/2010)

    The error is indicating it is using Named Pipes so be sure that protocol is enabled in Configuration Manager. You also mention connecting via Management Studio, but if you...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 24, 2010 at 9:36 am

    #1211111

  • RE: Remote Connection Error to MSSQL 2008

    Twinsoft SME (8/23/2010)

    You may want to try connecting by IP:Port? Could be a DNS issue?

    I checked and SQL Browser is started. About DNS issue I am not sure that...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 24, 2010 at 7:00 am

    #1210975

  • RE: SSIS - Can't execute package to extract MS Access db file

    nano2nd (8/23/2010)

    A proxy account was the solution. I created a credential, a proxy and change the job to run under the proxy. Thanks to both of you.

    Thanks for posting your...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 23, 2010 at 2:33 pm

    #1210697

  • RE: SSIS - Can't execute package to extract MS Access db file

    nano2nd (8/23/2010)

    I built an SSIS package on Server A to extract data from an MS Access file on Server B. My domain account has access to the Server B and...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 23, 2010 at 9:39 am

    #1210540

  • RE: Connect To Database Engine does not respond

    monietamarind (8/23/2010)

    that's the thing. i haven't logged in for a number of days. and I don't believe I've changed the username/password/any settings.

    Connect To Database Engine does not respond...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 23, 2010 at 9:30 am

    #1210531

  • RE: Restore SQL 2005 Enterprise backup to SQL Express 2005

    GilaMonster (8/19/2010)

    MostInterestingMan (8/19/2010)

    Excellent!!! Thanks for the information, Gail.

    Emphasis 'should'. I don't have an express instance around to try it out on.

    Yep.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 19, 2010 at 8:37 am

    #1209162

  • RE: Restore SQL 2005 Enterprise backup to SQL Express 2005

    Excellent!!! Thanks for the information, Gail.

    I am getting an enterprise bak copy from a client this afternoon and I will post the results to this thread for future reference.

    Thanks,

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 19, 2010 at 8:16 am

    #1209140

  • RE: SSIS Package not using the XML Config File

    AndrewSQLDBA (8/12/2010)

    Found a fix for this issue:

    Once you change or edit the config file, and then copy it up to the SSIS server, you need to remove and add the...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 13, 2010 at 7:07 pm

    #1206978

  • RE: SSIS Package not using the XML Config File

    WayneS (8/11/2010)

    I thought that to use a configuration file, that you had to specify it in the SSIS package itself? I thought that was how it knew to load it.

    Actaully...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 12, 2010 at 11:40 am

    #1206237

  • RE: SSIS Package not using the XML Config File

    AndrewSQLDBA (8/11/2010)

    Hello Everyone

    This is actually for SSIS 2008

    I am in the process of troubleshooting a package migration from the Dev box to the SSIS Server. There is an XML config...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 11, 2010 at 1:09 pm

    #1205679

  • RE: Cannot execute SSIS package

    MostInterestingMan (8/11/2010)

    Aspg (8/11/2010)

    Hi All ,

    I have created a SSIS package on my local machine .

    Now i want to run it on server .I am using sql server authentication with user...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 11, 2010 at 1:07 pm

    #1205678

  • RE: Cannot execute SSIS package

    Aspg (8/11/2010)

    Hi All ,

    I have created a SSIS package on my local machine .

    Now i want to run it on server .I am using sql server authentication with user name...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 11, 2010 at 1:05 pm

    #1205672

  • RE: sysjobactivity table in msdb question

    SSIS.COM (8/11/2010)

    I have tried with 100000 total rows and 10000 rows for each job and selected the keep history option and changed to 52 weeks. But, once I click Ok...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 11, 2010 at 10:37 am

    #1205517

  • RE: DT_DBTIMESTAMP Not Displaying Properly in .CSV Destination File

    da-zero (8/11/2010)

    Phil Parkin (8/10/2010)

    Excel is helpfully (:crazy:) doing the conversion for you. Try opening it in Notepad and you'll see that it's just the same as the .txt.

    Excel always screws...

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

    August 11, 2010 at 9:45 am

    #1205472

Viewing 15 posts - 76 through 90 (of 173 total)