How Can I Connect To Remote Sql Server From Sql Server Management Studio

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hello all i am new to asp .net
can any one tell me if we can connect remote sql server by management studio
sql server 2008r2

Posted 26-Jan-15 7:52am

Member 8893861

Add a Solution

Comments

Prasad Khandekar 26-Jan-15 13:59pm

Counld not think of a better links than this (https://msdn.microsoft.com/en-us/library/ms189721.aspx) Or this (https://www.youtube.com/watch?v=ZNObiptSMSI)

Tomas Takac 26-Jan-15 17:11pm

Yes, you can connect to remote server using management studio. How? The same way you are connecting to the local server, you just need to put the correct server and instance name into the dialog. What is your question exactly?

Member 8893861 27-Jan-15 2:57am

Actually my DBA is saying that now a days we can not connect remote sql server by management studio , it get error 25 when i tried connecting server
i am using instance as 66.155.58.218:8443\HOMESQLSERVER
changed to : sql server authentication
username :
password :

can you tell me where i am wrong

Corporal Agarn 27-Jan-15 9:52am

You need permissions to connect.
Are you using ASP.NET or SSMS?
I do not know the whole story as to why the DBA would say you cannot connect. In general you can connect to a remote server using SSMS, however you need the permissions and infrastructure to connect. It might be that the company has locked down the remote server so you cannot connect.

Member 8893861 27-Jan-15 11:14am

I tried both asp.net as well as SSMS , i installed SQL server R2
I can connect local sql server , but when i add remote server ip address
, sql server authentication and username and password it gives error 25

Corporal Agarn 27-Jan-15 12:54pm

Please poet error text

Member 8893861 27-Jan-15 13:18pm

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: 25 - Connection string is not valid)

[no name] 4-Mar-15 7:36am

In SSMS open connect to server dialog box then
1.select browse for more from server name dropdown field.
2.click on network server tab and expand the database engine
3. select the server name which you need to connect from the network

and connect using username and password.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)