Skip to main content

Fix: "Cannot connect to remote server" - login failed for user ''. the user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error 18452)

How to access to the local SQL Server through either SQL or Windows Authentication | Cannot connect to remote server" - login failed for user ''. the user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error 18452). 


In this post, let's learn how to connect the SQL Server available in different domain through Windows Authentication from Microsoft SQL Server Management Studio and that way we will learn how to fix the error "cannot connect to remote server", "login failed for user ''. the user is not associated with a trusted sql server connection. (Microsoft SQL Server, Error 18452).

We could connect to the local SQL Server through either SQL or Windows Authentication. Some times we may need to access the SQL Server that is hosted in the different domain, then a common approach could be using SQL login only, because local credentials would get fail with Windows authentication across the domains and there is no option to input the required credentials to access the external domain.


You may get this error when you try to connect,


=========================================================
Advertisement: Choosing .NET Core Worker Services OR Windows Services?

=========================================================



I was not able to find an appropriate solution form simple Googling, however, I found a solution from my research in MSDN documentation.

Connectivity can be achieved by using RUNAS command with below steps,

Step 1: Run the Command Prompt
Step 2: Execute below command with OTHERDOMAIN\USERID details

RUNAS /user:OTHERDOMAIN\USERID /netonly "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

That’s it. Now you can connect the SQL Server that hosted in the different domain through Windows Authentication.

Happy Learning!

Labels:

Comments

Anonymous said…
It is appropriate time to make some plans for the long run and it is time to be happy.
I have read this publish and if I may I desire to recommend
you some attention-grabbing things or tips.
Perhaps you could write subsequent articles regarding this article.
I desire to learn even more things about it!
My webpage > easy diets that work
Jan 23, 2013, 5:41:00 PM
Anonymous said…
cool work. I learned a whole lot, article even more inside the future.
appearing forward to hearing more.

Take a look at my web page ... network and computer security ()
Sep 20, 2013, 9:45:00 PM
Anonymous said…
It's great that you are getting thoughts from this paragraph as well as from our argument made at this
place.

Also visit my blog :: magento themes
Oct 1, 2014, 10:20:00 PM
Post a Comment

Popular posts from this blog

How to Implement Lombok in IntelliJ for Java Projects: A Step-by-Step Guide

Lombok in IntelliJ for Java Projects Implementing Lombok in your Java project can streamline your code by reducing boilerplate. Follow these steps to set up Lombok in IntelliJ: Step 1 :  Ensure Java SDK Version. Ensure that your project is using Java 8 or higher.  You can check and set the Java SDK version in pom.xml: XML <properties> <maven.compiler.source>1.8</maven.compiler.source> <maven.compiler.target>1.8</maven.compiler.target> </properties> Step 2 : Add Lombok Dependency to pom.xmlOpen the pom.xml file in your project. Add the following Lombok dependency inside the <dependencies> section: XML <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.24</version> <scope>provided</scope> </dependency> Step 3 : Download Lombok Plugin for IntelliJ IDEAGo to File > Settings (or press Ctrl+Alt+S). Navigate to Plugins. Search for Lombo...
Post a Comment
Read more

How to create a GenAI Talking Avatar ChatBot using Streamlit and Anthropic Claude LLM Model

GenAI Talking Avatar ChatBot   using Streamlit and Anthropic Claude LLM Model GenAI-Talking-Avatar-Chatbot is a web application that allows users to interact with an AI-powered talking chatbot with a static avatar. The chatbot uses AWS Bedrock for generating responses and Google Text-to-Speech (gTTS) for voice output. The backend is built with FastAPI, and the frontend uses Streamlit for the user interface. Features API Backend (api.py) Provides an API endpoint to handle chat requests. Uses AWS Bedrock to generate AI responses in a specified JSON format. Ensures the responses include the message, avatar expression, and voice tone. Includes a health check endpoint to verify the API status. Chat UI (chat_frontend.py) Chat Interface: Provides a chat interface where users can input their queries and receive responses from the AI assistant. Avatar Display: Displays an avatar that changes expressions based on the AI assistant's responses and actions (e.g., thinking, speaking). AI Respons...
Post a Comment
Read more

How to Implement Infinispan Cache in Spring Boot with Java 21: A Step-by-Step Guide for Efficient Caching

Infinispan Cache in Spring Boot with Java 21 : Let’s learn how to integrate Infinispan cache in your Spring Boot project using Java 21. This post covers adding dependencies, enabling caching, configuring Infinispan, and more to enhance your application’s performance. Step 1: Add Infinispan Dependencies Add the necessary Infinispan dependencies to your pom.xml file. XML <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-cache</artifactId> </dependency> <dependency> <groupId>org.springframework.session</groupId> <artifactId>spring-session-core</artifactId> <version>2.5.4</version> </dependency> <dependency> <groupId>org.infinispan</groupId> <artifactId>infinispan-spring-boot-starter-embedded</artifactId> <version>13.0.0.Final</version> </dependency> For Gradle, add the following dependencies to your build.gradle file: im...
Post a Comment
Read more