Results 1 to 11 of 11

Thread: Problem connecting Toad to SQL Server

  1. 05-09-2005, 11:36 AM #1
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16

    Problem connecting Toad to SQL Server

    Hi,

    I have the MS SQL Server 2005 CTP installed and working and I can access the database from Java and a free SQL Server Client called "Foxy SQL Free", but I am unable to connect to my database using Toad. When setting up the connection (Data Source Name (ODBC), User, password, etc) everything seems ok, I hit the Test Connection buton and says "Test Connection Succeded", but when I try to use that connection to start using the client, after putting the user and password information I received an error: "Named Pipes Provider: Could not open a connection to SQL Server".

    I've tryed to change the remote connection configuration of the server to make sure is nothing related to that, but same results. By the way, everything is local.

    Thanks!
    Reply With Quote Reply With Quote
  2. 05-09-2005, 01:37 PM #2
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16
    Well, since nobody seems to know about this problem, does anyone knows a free tool to access SQL Server databases where I could see graphically the tables definitions, content, etc?

    Thanks
    Reply With Quote Reply With Quote
  3. 05-09-2005, 02:35 PM #3
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    I've never heard of TOAD before, but check out MS's SQL Server Web Data Administrator. It's free: http://www.microsoft.com/downloads/d...displaylang=en

    I don't know if it will work with 2005 though.
    Reply With Quote Reply With Quote
  4. 05-09-2005, 02:45 PM #4
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16
    Thanks, but it need an old versionof the .Net framework and I had to install the new one to make SQL Server work.
    Reply With Quote Reply With Quote
  5. 05-09-2005, 02:56 PM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Tried connect with tcp/ip?
    Reply With Quote Reply With Quote
  6. 05-09-2005, 03:04 PM #6
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    I just tried, and SQL 2005 wouldn't allow me to connect with the web data administrator.
    Reply With Quote Reply With Quote
  7. 05-09-2005, 03:07 PM #7
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16
    I haven't seen where to change that in Toad so I've change that values directly in my SQL Server making it accept Local and Remote connections using both TCP/IP and Named Pipes Protocols.

    Let me know if you know how to change this values in Toad.

    Thanks!
    Reply With Quote Reply With Quote
  8. 05-09-2005, 03:08 PM #8
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16
    Originally posted by Rawhide
    I just tried, and SQL 2005 wouldn't allow me to connect with the web data administrator.
    Thanks anyway Rawhide.
    Reply With Quote Reply With Quote
  9. 05-09-2005, 04:43 PM #9
    kcowden
    kcowden is offline Registered User
    Join Date
    May 2005
    Posts
    1

    Post Toad to SQL Server

    I don't believe Toad will work with Named Pipes (Earlier versions of Toad won't work with MSSQL at all). Make sure tcp/ip is enabled under protocols in your SQK Server Configuration Manager.
    Reply With Quote Reply With Quote
  10. 05-13-2005, 04:39 PM #10
    tokyo
    tokyo is offline Registered User
    Join Date
    May 2005
    Posts
    1
    Aneto,

    I experienced a similar problem when I first setup TOAD to use with Oracle. For me, I had to place two files “sqlnet.ora” and “tnsnames.ora” at the following location: "\Oracle\Ora81\network\ADMIN" for my connection to work. These two files are probably different for SQL Server. Check with your CM team.

    Hope that helps.
    Last edited by tokyo; 05-13-2005 at 06:21 PM.
    Reply With Quote Reply With Quote
  11. 05-14-2005, 10:24 AM #11
    topinksy
    topinksy is offline Registered User
    Join Date
    May 2005
    Posts
    1
    Recently I found out that compatible ink cartridges saved me money. They don't cost me as much as manufacturer's. And they work on my printers, too.

    Steve

    http://www.top-ink.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules