CINXE.COM
How to connect to default SQL Server installation ?
<!DOCTYPE html> <html lang="en"> <head> <title>How to connect to default SQL Server installation ?</title> <meta name="description" content="Hello I have a new installation of SQL Server Developer edition, and nothing I tried has worked to connect with HeidiSQL to my server. So I do not know the right settings to connect, but I can connect easily using the native SSMS tool (SQL Server Management Studio). Is it possible for HeidiSQL to pr" /> <link rel="canonical" href="/forum.php?t=43725" /> <link rel="alternate" type="application/atom+xml" href="/rss.php" /> <meta name="Content-Language" content="en" /> <meta name="author" content="Ansgar Becker" /> <meta name="viewport" content="width=device-width" /> <link rel="search" type="application/opensearchdescription+xml" title="HeidiSQL Board Search" href="/searchboard.xml" /> <link rel="stylesheet" type="text/css" href="/basic.css?v54" /> <script type="text/javascript"> // Log JS errors per AJAX call window.onerror = function (msg, url, line, column) { let headers = "Method: GET\n"; let img = new Image(); let maxValLen = 250; // column may be 0, or even unsupported in old browsers if(typeof column === 'undefined') { column = (window.event && event.errorCharacter) || -1; } for (let p in navigator) { let tp = typeof navigator[p]; let val = navigator[p]; switch (tp) { case "string": case "number": // Normal case - do nothing specific break; case "boolean": val = val ? "true" : "false"; break; case "object": try { val = JSON.stringify(val); } catch(err) { val = "[" + tp + "]"; } break; default: val = "[unknown]"; } if ((typeof val === "string") && val.indexOf("function") !== 0) { if(val.length > maxValLen) { val = val.substr(0, maxValLen) + '...'; } headers += p + ": " + val + "\n"; } } img.src = "/logjserror.php" + "?domain=" + encodeURIComponent(window.location.host) + "&url=" + encodeURIComponent(window.location.pathname) + "&referrer=" + encodeURIComponent(document.referrer) + "&headers=" + encodeURIComponent(headers) + "&message=" + encodeURIComponent(msg) + "&jsurl=" + encodeURIComponent(url) + "&jsline=" + encodeURIComponent(line) + "&jscolumn=" + encodeURIComponent(column); return false; }; </script> <script src="/jquery-3.5.1.min.js" onload="window.jQueryLoaded=true"></script> <script src="/xads.js" defer></script> <script src="/jquery.selection.js"></script> <script src="/helpers.js?v1"></script> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4114345487694759" crossorigin="anonymous"></script> <script> window.onload = function() { window.download_started = false; let links = document.querySelectorAll('.download-link'), i; for (i=0; i<links.length; i++) { links[i].onclick = function() { window.download_started = true; }; } // auto download? // Forum preview and handle paste if(window.jQueryLoaded) { let postMessage = $('#post_message'); postMessage.keyup(debounce(postPreview, 250, {maxWait: 3000})); postMessage.on('paste', handlePaste); } }; </script> </head> <body> <div id="header"> <div id="inner-header"> <a href="/"> <img src="/images/heidisql_logo_mwd.png" id="logo" alt="HeidiSQL Logo" width="260" height="66" /> </a> <div id="inner-right-header"> <!-- horizontal --> <ins class="adsbygoogle" style="display:inline-block;width:640px;height:100px" data-ad-client="ca-pub-4114345487694759" data-ad-slot="2718443743"></ins><script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> <ul id="menu"> <li><a href="/">Home</a></li> <li><a href="/download.php">Downloads</a><ul><li><a href="/download.php?download=installer">Installer</a></li> <li><a href="/download.php?download=portable">Portable</a></li> <li><a href="/download.php?download=portable-64">Portable-64</a></li> <li><a href="/download.php?download=app">App</a></li> <li><a href="/download.php?download=source">Source</a></li> <li><a href="/download.php#nightlybuilds">Nightly builds</a></li> </ul></li> <li><a href="/screenshots.php">Images</a><ul><li><a href="/screenshots.php">Screenshots</a></li> <li><a href="/themes.php">Themes</a></li> </ul></li> <li class="highlight"><a href="/forum.php">Forum</a><ul><li><a href="/forum.php?t=43753#p43754"> 29 Nov - bootleeg: Connect to MySQL Router r/w split acce <span title="... ss mode auto">...</span> </a></li> <li><a href="/forum.php?t=43621#p43752"> 28 Nov - cleverpg: Log error, invalid characters </a></li> <li><a href="/forum.php?t=43728#p43751"> 28 Nov - nadeemcoorg: I want to run a query with CMD file </a></li> <li><a href="/forum.php?t=43749"> 27 Nov - d: Insert images in MariaDB </a></li> <li><a href="/forum.php?t=43739#p43742"> 25 Nov - Jakko: Bulk import of CSV with some columns only </a></li> <li><a href="/forum.php?t=43736#p43737"> 24 Nov - ansgar: heidi sql grid editing error: column #4 <span title="... not available">...</span> </a></li> <li><a href="/forum.php?t=43734#p43735"> 23 Nov - ansgar: Unlock the Power of PostgreSQL Date Data <span title="... Types">...</span> </a></li> <li><a href="/forum.php?t=43725#p43727"> 18 Nov - TimothyMadden: How to connect to default SQL Ser <span title="... ver installation ?">...</span> </a></li> <li><a href="/forum.php?t=43720#p43724"> 16 Nov - sakim: heidisql for Postgresql </a></li> <li><a href="/forum.php?t=6073#p43723"> 16 Nov - Reinier: Unable to see query results ... </a></li> <li><a href="/forum.php?t=5331#p43722"> 16 Nov - Reinier: how to enable Resut panel in Query tab </a></li> <li><a href="/forum.php?t=43713#p43719"> 12 Nov - ansgar: Can you use multiple databases from dife <span title="... rent connections for doing a statement">...</span> </a></li> <li><a href="/forum.php?t=43709#p43712"> 07 Nov - artvandelay: Un/comment in toolbar or shortcut </a></li> <li><a href="/forum.php?t=43710"> 07 Nov - ATRICA: Error at connection to a FIREBIRD DB </a></li> <li><a href="/forum.php?t=43698#p43708"> 03 Nov - luvheidi: Newbie. Cannot log on. Consistent 1006 <span title="... 0 error. Please help.">...</span> </a></li> <li><a href="/forum.php?t=43706#p43707"> 03 Nov - ansgar: Lost connection to server at 'hands <span title="... hake: reading initial communication packet&#039;, system error: 0uery">...</span> </a></li> <li><a href="/forum.php?t=43696#p43697"> 30 Oct - ansgar: parameters fonts size </a></li> <li><a href="/forum.php?t=43685#p43694"> 29 Oct - ansgar: Why did my grid go? </a></li> <li><a href="/forum.php?t=43691"> 24 Oct - SQL_Hack: Problem with User-Defined Variables an <span title="... d Run Routine function">...</span> </a></li> <li><a href="/forum.php?t=39507#p43690"> 23 Oct - LAIS: Incomplete display of store procedure </a></li> </ul></li> <li><a href="/donate.php">Donate</a><ul><li><a href="/donate.php#howto">How to donate</a></li> <li><a href="/donate.php#donors">List of donors</a></li> </ul></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues">Bugtracker</a><ul><li><a href="https://github.com/HeidiSQL/HeidiSQL/milestones">Milestone Roadmap</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues?q=is%3Aissue+is%3Aopen+label%3Abug">Bug reports</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues?q=is%3Aissue+is%3Aopen+label%3Afeature">Feature requests</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues?q=is%3Aissue+is%3Aopen+label%3Aenhancement">Enhancement requests</a></li> </ul></li> <li><a href="/help.php">Help</a><ul><li><a href="/help.php#requirements">Requirements</a></li> <li><a href="/help.php#connecting">Connecting to a server</a></li> <li><a href="/help.php#commandline">Command line switches</a></li> <li><a href="/help.php#dbtree">The database tree</a></li> <li><a href="/help.php#createtable">Creating a table</a></li> <li><a href="/help.php#createview">Creating a view</a></li> <li><a href="/help.php#createroutine">Creating a stored procedure</a></li> <li><a href="/help.php#createtrigger">Creating a trigger</a></li> <li><a href="/help.php#createevent">Creating a scheduled event</a></li> <li><a href="/help.php#data">The Data tab</a></li> <li><a href="/help.php#queries">Running SQL queries</a></li> <li><a href="/help.php#sqlexport">SQL export</a></li> <li><a href="/help.php#import">Importing files</a></li> <li><a href="/help.php#portable">HeidiSQL portable</a></li> <li><a href="/help.php#license">License</a></li> <li><a href="/help.php#credits">Credits</a></li> </ul></li> </ul> </div> </div> <div id="content"> <h1>How to connect to default SQL Server installation ?</h1> <div class="forum_toolbar"> <form action="/forum.php" class="inlineform"> <input type="text" name="s" value="" size="20" /> <button type="submit" title="Find"> <img src="/images/icons/magnifier.png" alt="Find" /> </button> </form> <form action="/forum.php" class="inlineform"> <input type="hidden" name="post_action" value="add" /> <button type="submit" title="New topic"> <img src="/images/icons/add.png" alt="Add" /> New topic </button> </form><form action="user.php" class="inlineform"> <button type="submit"> <img src="/images/icons/user_add.png" alt="Register" /> Register </button> </form> <form action="login.php" class="inlineform"> <button type="submit"> <img src="/images/icons/application_go.png" alt="Logout" /> Log in </button> </form></div><div id="forum-thread"> <div class="forum-post" id="p43725"> <div class="forum-user"> <div class="forum-user-img" title="TimothyMadden" style="background:url('//www.gravatar.com/avatar/9a2a6c49fe5c2d3c43812d06a981952e?d=identicon&s=100') no-repeat; background-size:cover;"> </div> <div class="forum-user-posts"> <a href="/forum.php?u=17825" title="Click to find all posts from TimothyMadden">2 posts</a> </div> </div> <div class="forum-post-wrapper"> <div class="forum-post-header"> <img class="forum-user-img-mobile" src="//www.gravatar.com/avatar/9a2a6c49fe5c2d3c43812d06a981952e?d=identicon&s=100" alt="TimothyMadden's profile image"/> <strong>TimothyMadden</strong> posted <span title="16 Nov 2024 21:41">2 weeks ago</span> in <a href="/forum.php?c=11" title="Click to find all posts in category Creating a connection">Creating a connection</a> <span class="floatright"> <a href="?t=43725#p43725" title="Permalink to this post"> <img src="/images/icon-permalink.svg" alt="Permalink" /> </a> </span> </div> <div class="forum-post-content" id="msg43725"><p>Hello</p> <p>I have a new installation of SQL Server Developer edition, and nothing I tried has worked to connect with HeidiSQL to my server.</p> <p>So I do not know the right settings to connect, but I can connect easily using the native SSMS tool (SQL Server Management Studio).</p> <p>Is it possible for HeidiSQL to pre-fill the expected connection settings that would just work with the default installation of SQL Server please ?</p> <p>Since I do not have ports 1433 or 1433 open (using netstat command), I assume the right protocol is to use Named Pipes. But HeidiSQL still says <strong><em>Server doesn't support requested protocol (0xFFFFFFFF)</em></strong></p> <p>I know I need to use Windows Authentication and I need to "Trust Server Certificate", but the SSL tab in the Connection windows in HeidiSQL is disabled, I can not even enable SSL ... !!!</p> <p>Can anyone please help me connect to a local installation for SQL Server Developer edition ?</p> <p>Here is what I tried (my "best match") for connection settings in HeidiSQL:</p> <p><img src="/uploads/paste/17825-2024-11-16_21-37-45.png" alt="image.png" /> and the resulting error: <img src="/uploads/paste/17825-2024-11-16_21-37-04.png" alt="image.png" /></p> <p>Here is the connection window in the native SSMS tool (these are the settings that are known to work): <img src="/uploads/paste/17825-2024-11-16_21-35-17.png" alt="image.png" /> <img src="/uploads/paste/17825-2024-11-16_21-38-59.png" alt="image.png" /></p> <p>-- Thank you, Timothy Madden</p> </div> </div> </div> <div class="forum-post" id="p43726"> <div class="forum-user"> <div class="forum-user-img forum-user-donor" title="ansgar" style="background:url('//www.gravatar.com/avatar/f6630ffe8b3c60e183e902a63a476f98?d=identicon&s=100') no-repeat; background-size:cover;"> <img src="/images/icons/money_euro.png" title="Donor" /> </div> <div class="forum-user-posts"> <a href="/forum.php?u=2" title="Click to find all posts from ansgar">10364 posts</a> </div> </div> <div class="forum-post-wrapper"> <div class="forum-post-header"> <img class="forum-user-img-mobile" src="//www.gravatar.com/avatar/f6630ffe8b3c60e183e902a63a476f98?d=identicon&s=100" alt="ansgar's profile image"/> <strong>ansgar</strong> posted <span title="17 Nov 2024 10:55">2 weeks ago</span> <span class="floatright"> <a href="?t=43725#p43726" title="Permalink to this post"> <img src="/images/icon-permalink.svg" alt="Permalink" /> </a> </span> </div> <div class="forum-post-content" id="msg43726"><p>You may try to use the other library SQLOLEDB (where you have MSOLEDBSQL selected). SQLOLEDB is outdated and insecure, but probably helps you with a hint what is happening here.</p> </div> </div> </div> <div class="forum-post" id="p43727"> <div class="forum-user"> <div class="forum-user-img" title="TimothyMadden" style="background:url('//www.gravatar.com/avatar/9a2a6c49fe5c2d3c43812d06a981952e?d=identicon&s=100') no-repeat; background-size:cover;"> </div> <div class="forum-user-posts"> <a href="/forum.php?u=17825" title="Click to find all posts from TimothyMadden">2 posts</a> </div> </div> <div class="forum-post-wrapper"> <div class="forum-post-header"> <img class="forum-user-img-mobile" src="//www.gravatar.com/avatar/9a2a6c49fe5c2d3c43812d06a981952e?d=identicon&s=100" alt="TimothyMadden's profile image"/> <strong>TimothyMadden</strong> posted <span title="18 Nov 2024 10:46">2 weeks ago</span> <span class="floatright"> <a href="?t=43725#p43727" title="Permalink to this post"> <img src="/images/icon-permalink.svg" alt="Permalink" /> </a> </span> </div> <div class="forum-post-content" id="msg43727"><p>Hello,</p> <p>Thank you, using the other library worked as intended.</p> </div> </div> </div><p>Please login to leave a reply, or <a href="/user.php">register</a> at first.</p><form method="post" action="/forum.php" id="loginform"> <label for="login_username">Username:</label> <input type="text" name="login_username" id="login_username" value="" /><br /> <label for="login_password">Password:</label> <input type="password" name="login_password" id="login_password" value="" /><br /> <input type="checkbox" name="login_remember" value="1" checked="checked" id="login_remember" /> <label for="login_remember">Remember me</label><br /> <input type="submit" value="Login" /><input type="hidden" name="t" value="43725" /></form></div> <script> var forumReadOnly = false; if(forumReadOnly) { $('#postform').html('<p style="color:maroon;">Forum registration and posting is currently disabled, due to a spamming flood.</p>'); } </script> </div> <p id="footer"> <a href="//mariadb.org"> <img src="/images/icons/server-mariadb.png" alt="MariaDB" /> Database powered by MariaDB</a> <a href="https://www.embarcadero.com/de/case-study/heidisql-case-study?utm_source=Eloqua&utm_medium=web&utm_content=HeidiSQL-website-footer"> <img src="/images/icons/embarcadero-rad-studio.png" alt="Embarcadero Delphi" /> HeidiSQL is proudly built with Embarcadero Delphi</a> <a href="https://www.facebook.com/HeidiSQL" title="HeidiSQL on Facebook"><img src="/images/facebook-icon.png" alt="Facebook" /></a> <a href="https://www.instagram.com/heidisql.official/" title="HeidiSQL on Instagram"><img src="/images/instagram-icon.png" alt="Instagram" /></a> <a href="/imprint.php">Imprint</a> </p> <div class="sticky-right"> </div> </body> </html>