tag:blogger.com,1999:blog-6444609270251748954.post2859354475450093887..comments2024-03-11T23:12:21.225-07:00Comments on Delphi Code Monkey: A very frustrating issue with Microsoft SQL Express Warrenhttp://www.blogger.com/profile/04053407632823479165noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6444609270251748954.post-75128622244841876442014-04-30T06:02:40.013-07:002014-04-30T06:02:40.013-07:00basically you have to understand that SQL Express ...basically you have to understand that SQL Express is FREE and is configured as a single-system-workstation database out of the box on purpose. When you need TCP/IP you configure it. They are not being mean, just thinking about reducing the surface area for attackers. It is good technical sense that they do it this way. These manual steps are part of a way of protecting systems from abuse.Warrenhttps://www.blogger.com/profile/04053407632823479165noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-44490382595955036572014-04-29T14:47:23.166-07:002014-04-29T14:47:23.166-07:00I had to install SQL Express 2008 R2 as a prereq ...I had to install SQL Express 2008 R2 as a prereq to an application. Struggled with local connection to the database until I discovered TCP/IP enabled and named pipes needed to be enabled. I was wondering if there could be something during install that would allow you to enable these.Unknownhttps://www.blogger.com/profile/17111741626440057925noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-53965029515840001222013-08-14T01:59:55.276-07:002013-08-14T01:59:55.276-07:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/07942910170683356275noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-76351042064488776322013-05-24T03:38:02.757-07:002013-05-24T03:38:02.757-07:00Yep, SQL Browser should be set to auto-start. IMO,...Yep, SQL Browser should be set to auto-start. IMO, the reason it isn't by default is reducing attack surface, the same as allowing only local connections and Windows authentication at first. Also don't forget to check Windows firewall for both *\Microsoft SQL Server\MSSQL.INSTANCENAME\MSSQL\binn\sqlservr.exe and *\Microsoft SQL Server\NNN\Shared\sqlbrowser.exe are allowed programs there.<br />You might also want to consider running SQL Server service under LocalSystem account to reduce possibility of SPN (setspn -L) record not created/deleted on service start.IlyaShttps://www.blogger.com/profile/08819308219512123442noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-69829594120898335542013-05-20T13:42:17.139-07:002013-05-20T13:42:17.139-07:00SQL Browser solves exactly that issue. But it is n...SQL Browser solves exactly that issue. But it is not enabled by default on Express. More here:<br /><br />http://msdn.microsoft.com/en-us/library/hh510203.aspxAnonymoushttps://www.blogger.com/profile/03048279992510491008noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-34050101441514754292013-05-20T05:39:10.745-07:002013-05-20T05:39:10.745-07:00Ah. Perhaps the SQL Browser service is supposed t...Ah. Perhaps the SQL Browser service is supposed to handle this dynamic situation properly?Warrenhttps://www.blogger.com/profile/04053407632823479165noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-30433553191659741822013-05-20T04:23:51.236-07:002013-05-20T04:23:51.236-07:00Did you check that SQL Browser service is running?...Did you check that SQL Browser service is running? That service returns connection info to clients. Forcing 1433 on single server can work only if you are running only single SQL Server instance on that one computer. Anonymoushttps://www.blogger.com/profile/03048279992510491008noreply@blogger.comtag:blogger.com,1999:blog-6444609270251748954.post-47630926474387893532013-05-17T07:36:19.560-07:002013-05-17T07:36:19.560-07:00Indeed, the slowness of the new Management Studio ...Indeed, the slowness of the new Management Studio is ridiculous. I can't beleive that this made it through QA.Uwe Raabehttps://www.blogger.com/profile/08727704609084298159noreply@blogger.com