Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: SSIS scheduled package works one day, fails another. Nothing changed.

    I've been banging my head against the wall for 1.5 day. I read this posting and tried the delayvalidation to true and it fixed my issue. Weird. Thanks!

  • RE: Scripting Database Objects

    Russell,

    When I do this it only gives me the options to script a create or a drop. I do not see a way to create a script that contains both the...

  • RE: Unable to connect to SQL 2005

    Q: Have you tried specifying IP-address instead of server name?
    A: Sorry - thought we had tried it but had not. My developer just tried connecting his app via ip instead...
  • RE: Unable to connect to SQL 2005

    I did not install service broker as part of the setup. I have not read anywhere where it is required to connect to the server from a client. Are you...

  • RE: Unable to connect to SQL 2005

    Q: Can you ping the server?
    A: Yes
     
    Q: Have you tried specifying IP-address instead of server name?
    A: Yes
     
    Q: Can you connect using TCP/IP?
    A: Yes (tried w/query analyzer)
     
    Q: Is the server installed...
  • RE: Unable to connect to SQL 2005

    Yes;manually restarted each service as well as bounced the server.

  • RE: Unable to connect to SQL 2005

    Sorry - I should have included in my post that I already did that. The server is configured to allow Local and Remote connections over TCP/IP and named pipes.

  • RE: SQL Server Agent won''''t start

    What fixed the problem - I am getting the same message

  • RE: QOD 18th Nov

    Something that I have used for several years and works quite well (never had an issue) is to use:

    sp_change_users_login 'report'

    in combination with

    sp_change_users_login 'Auto_Fix', 'userid'

Viewing 9 posts - 1 through 9 (of 9 total)