I have configured one remote sql server with 2 instances A,B. I have enabled TCP/IP,Port 1434, remote connections, sql browser running and firewall inbound rule. I've enable DAC using sp_configure 'remote admin connections', 1; and reconfigure. However when I try to connect via SSMS or SQLCMD using admin:hostmachine\sqlinstance or sqlcmd -S hostmachine\sqlinstance -U sa  -P pass -d master -A I'm getting the following error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 43 - An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number) (Microsoft SQL Server, Error: -1) I can connect using DAC but only as admin:hostmachine or sqlcmd -S hostmachine -U sa  -P pass -d master -A
Well, luckily I got this error on my test environment. I'm so scared about this error that I disabled all logon triggers I was using on production environment.   I created the famous logon trigger, and I put a database in offline mode just to mess with something else. Then I discover that because the trigger can't find the table, I can't access the instance anymore. There are plenty of questions related to this, but even doing everything I could find, I still can't acces the instance, not even with SQLCMD.  I'm doing this:  sqlcmd -S server\instance -U sa -P &lt;pass&gt;  -A   If I don't use -A I receive the famous error:  logon failed for sa due trigger execution.   If I use -A:     Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SQL Server   Network Interfaces: An error occurred while obtaining the dedicated   administrator connection (DAC) port. Make sure that SQL Browser is   running, or check the error log for the port number [xFFFFFFFF]. .   Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login timeout   expired. Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : A   network-related or instance-specific error has occurred while   establishing a connection to SQL Server. Server is not found or not   accessible. Check if instance name is correct and if SQL Server is   configured to allow remote connections. For more information see SQL   Server Books Online..   Why i'm not able to connect to the sql server    sql server express here.  I could enable SQL Browser, but I still can't access it.  I don't think this question is duplicated because is not about the trigger, is about Why I can't access the server with SQLCMD. I pretty much know how to fix this. I just don't know how can I acces sql server without triggering the trigger.
The cardinality of the set of all finite subsets of an infinite set Proving the identity functions is continuous iff $\tau_1\supseteq\tau_2$ Exercise: Let $\tau_1$ and $\tau_2$ be two topological spaces on a  set $X$. Then $\tau_1$ is said to be a finer topology than $\tau_2$ if $\tau_1\supseteq\tau_2$. Prove the identity function $f:(X,\tau_1)\to (X,\tau_2)$ is continuous if and only if $\tau_1$ is a finer topology than $\tau_2$.  Attempted proof: Let $A\in\tau_1$. If $f$ is continuous then $\exists B\in\tau_2$ such $f(A)\subset B\implies A\subset B$ for any $A\in\tau_1$ such that all open sets of $\tau_1$ are open sets of $\tau_2$ hence $\tau_1\supseteq \tau_2$. If $\tau_1$ is a finer topology than $\tau_2$, for any $B\in\tau_2\implies B\in\tau_1$ which implies that $f^{-1}(B)=B$, then $B\in\tau_1$ which proves $f$ to be continuous. Questions: Is my proof right? If not. What is wrong? What are alternatives? Thanks in advance! Drupal failed after update Torus object stretched in array curve modifier I have a chain object. And i have a curve it follows. I got it to work for following curve, but chain object is not circles but both parts are more like stretched circles (ovals). Object i made with 2 toruses one rotated 90 degrees and then joined them together. I tried single torus too. But same issue. on a curve it just looks stretched oval. What can be the issue?   Thanks Composition of two Riemann integrable functions Is it possible to add new predictions/autofill in Overleaf? For example, when I use the command (in Overleaf/ShareLaTex):  \begin{figure}[H]     \centering     \includegraphics{some_graphic}     \caption{some_caption}     \label{fig:some_label} \end{figure}   the \includegraphics{} comes without the [] parameter to change the size of the image, and \begin{figure} without the [H] option by default.   Is it possible to renew the command to make it default? By that I mean that when I type the \begin{figure} command it adds the [H] and [h] as well as [width=\textwidth] in the \includegraphics command, rather than making a global change in the preamble e.g. Computer doesn't boot up, shows PXE error and/or "operating system not found", "no bootable device", "insert boot media", or other similar error Sneak Attack has the same type , this is easy, unless there are multiple damage types.  A Flame Tongue does slashing (or piercing) damage, and fire. Can I chose the Sneak Attack damage in this case to be fire too? What is the percentage increase to any value when initial value is 0? This is a very simple maths problem, which doesn’t seems simple to me when I just put some extra thoughts on it. So need to borrow some extra brains for this.   Question: If cost of coffee in my office was Dollar 0 till yesterday and today it is Dollar 2.5 then what is the percentage increase in the cost of coffee?  Initially it seemed like 2.5% increase, simply by distributing number from 0 to 100, but this is not the case.   Some suggested it is infinitely more than the previous value, because we are calculating percentage by dividing by zero. But what about this if the cost of coffee was $0.25? Isn’t still infinitely more! Something is wrong here.   PS: Yes, coffee were free in our office but not anymore, and we are still recovering from this shocker. 😥 Is there a "theirs" version of "git merge -s ours"? When merging topic branch "B" into "A" using git merge, I get some conflicts. I know all the conflicts can be solved using the version in "B".  I am aware of git merge -s ours. But what I want is something like git merge -s theirs.   Why doesn't it exist? How can I achieve the same result after the conflicting merge with existing git commands? (git checkout every unmerged file from B)  UPDATE: The "solution" of just discarding anything from branch A (the merge commit point to B version of the tree) is not what I am looking for. I am trying to prove the following: Let $R=\mathbb{Z}[i]$, $a, b \in \mathbb{Z}, ab \neq 0$. Show that $a+bi$ is an irreducible element in $R$ if and only if $a^2 + b^2 ∈ \mathbb{Z}$ is prime. Since $R$ is a Euclidean domain, irreducible elements are prime. I think this is relevant, but am stuck on where to go from here. The attribute image.itemtype has an invalid value I am using JSON-LD format for Structured data. In home page @type=website &amp; in details page @type=Article. Logo property of Organization section in details page showing following warning in Google Structured Data Testing Tool But home page is not although in both page value is same.      (The attribute logo.itemtype has an invalid value.)   Home page JSON-LD  &lt;script type="application/ld+json"&gt;     {     "@context": "http://schema.org",     "@type": "WebSite",     "url": "http://kothaboli.com/",     "name": ".....",     "alternateName" : "....",     "description" : "......",     "potentialAction": {         "@type": "SearchAction",         "target": "http://kothaboli.com/search?keywords={search_term_string}",         "query-input": "required name=search_term_string"     },     "sameAs":[         "https://www.facebook.com/kothaboliDotCom/",         "https://twitter.com/kotha_boli",         "https://plus.google.com/+kothaboli"     ],     "publisher" : {         "@type" : "Organization",         "name" : "....",         "alternateName": "...",         "logo": "http://kothaboli.com/media/1018/ka.jpg"         }     } &lt;/script&gt;     Details page JSON-LD      &lt;script type="application/ld+json"&gt;     {     "@context" : "http://schema.org",     "@type" : "Article",     "url": "http://kothaboli.com/interviews/intellectual/arundhati-roy/",     "name" : "... ....",     "headline":  "...--’",     "datePublished" : "7/26/2016 1:10:05 AM",     "dateModified" : "8/12/2016 1:50:54 AM",     "image" : "http://kothaboli.com/media/1088/33333333.jpg",     "articleSection" : "....",     "articleBody" : ".....’ ",     "mainEntityOfPage": "..",     "author" : {         "@type" : "Person",         "name" : "....",         "alternateName": "Arundhati Roy"         },     "publisher" : {         "@type" : "Organization",         "name" : "...",         "alternateName": "Kothaboli",         "logo": "http://kothaboli.com/media/1018/ka.jpg"         }     } &lt;/script&gt; A not free $\mathbb{Z}$-module From  I see that $\mathbb{Z}^{\mathbb{N}}$ is not a free abelian group. Someone can explain me why?  Thanks a lot! I miss those pins I make in Windows.     How can I do the same in Ubuntu 17.10 with GNOME 3? Git keeps prompting me for a password Using the same variable as a fixed and random effect in Mixed Effect Models Equivalence of definitions of prime ideal in commutative ring Can we make the "expanded user card" privilege universal? Pursuant to discussion on the , several have asked how far they'll need to search to determine if a user has expressed their preferred pronouns. This requested feature could create an easy solution for that concern.  On sites where I've reached the  privilege level, users can hover over my picture to see a snippet of my profile:    This is where I've included my preferred pronouns, and where I see many others including them as well.  By making this feature universal, users could quickly and easily check for preferred pronouns without needing to navigate to another page. Find the highest order bit in C The classical book on commutative algebra Introduction to Commutative Algebra, by Atiyah and Macdonald, has the following as exercise I.11.       A ring is Boolean if $x^2=x$ for any $x$ of $A$. In a Boolean ring $A$, show that     i) $2x=0$ for all $x\in A$;    ii) Every prime ideal of $A$ is maximal, and its residue field consists of two elements;   iii) Every finitely generated ideal of $A$ is principal.     I can but solve the first two of them; for the last one, I cannot even perceive the situation here, for it will not, generally speaking, be a Dedekind domain, whereof my knowledge is somewhat more. I have hitherto tried to find one element for each ideal of two generators which can stand the stead of them, and then proceed by induction. But even the first step fails to produce any result. Thanks for any hints and inspirations in advance.