Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2007
    Posts
    28

    Unanswered: problem with mssql express 2005 connections

    i Have this stored procedure below that creates a backujp copy of tblpersons from database db1 into another database db2 with a table1 pressing f5 to create it it goes fine up to around 5 seconds and after that the error below appears and looking at the stored procedure it is not created either. I already activated the default settings SQL Server to allow remote connections but still the error appears.

    CREATE PROCEDURE makebackup
    BEGIN
    SELECT * INTO table1 FROM sql1.database1.dbo.tblpersons
    END
    GO

    OLE DB provider "SQLNCLI" for linked server "amps" returned message "Login timeout expired".
    OLE DB provider "SQLNCLI" for linked server "amps" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

    Msg 126, Level 16, State 1, Line 0
    VIA Provider impossible to find the module

    THANKS
    ALEX

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    KBA http://support.microsoft.com/kb/914277 to setup remote connections on that instance, http://geekswithblogs.net/narent/arc.../02/86904.aspx blog too.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2007
    Location
    ahmedabad
    Posts
    5

  4. #4
    Join Date
    Jul 2007
    Location
    ahmedabad
    Posts
    5
    hi this ma first thread about SQL hacking...........................!

  5. #5
    Join Date
    Jul 2007
    Location
    ahmedabad
    Posts
    5
    Hi Guys Hows U I Wan To Make Forum Sites Can Any Body Help Me.....~

  6. #6
    Join Date
    Jul 2007
    Location
    ahmedabad
    Posts
    5
    Quote Originally Posted by frndteq
    hi this ma first thread about SQL hacking...........................!
    HI SIR HOWS U

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •