Cannot connect to SQL Server 2008 R2 remotely

Question

Cannot connect to SQL Server 2008 R2 remotely

Viewing 15 posts - 16 through 30 (of 34 total)

You must be logged in to reply to this topic. Login to reply

Jared SSC Guru Points: 61793 More actions · Answer 1

Ok, if your servername is SQLSERVER01, how are you typing in the servername\instance in your "Server Name" box? Also, just to be a stickler, are you positive that the instance is not named?

Jared
CE - Microsoft

emmanuel.constant Right there with Babe Points: 761 More actions · Answer 2

I'm typing the it as "Winser2008hostname\SQLSERVER01"

I don't understand the question "Also, just to be a stickler, are you positive that the instance is not named?"

Jared SSC Guru Points: 61793 More actions · Answer 3

The proper server name is this: serverName\instanceName

Where

serverName = the name of the server

instanceName = the name of your SQL Server instance

instanceName can be blank if SQL Server is installed as the default instance. To check this, go to SQL Server Configuration Manager and see what is in parentheses in the SQL Server Services. If it is (MSSQLSERVER), that is the default. If it is not, you must reference that in your Server Name when logging in.

Jared
CE - Microsoft

emmanuel.constant Right there with Babe Points: 761 More actions · Answer 4

In parentheses I have the right instance name and for the server name I have the right host name as well.

I have it as this:

Winser2008hostname\sqlServer2008instanceName

Where

serverName = Winser2008hostname

instanceName = sqlServer2008instanceName

Still get the error messages.

Jared SSC Guru Points: 61793 More actions · Answer 5

Well, at this point I think it is time to call someone in. Not much else we can help with without seeing exactly what you are seeing. and being able to troubleshoot directly.

Jared
CE - Microsoft

Jared SSC Guru Points: 61793 More actions · Answer 6

Are you sure you don't have these reversed?

DOMDEV\DOMDEVDBSERVER

This is what is in your error message, but intuitively I would think the server name is DOMDEVDBSERVER and the instance is DOMDEV.

Jared
CE - Microsoft

emmanuel.constant Right there with Babe Points: 761 More actions · Answer 7

I am sure.

I have it as this:

DOMDEV\DOMDEVDBSERVER

Where

serverName = DOMDEV

instanceName = DOMDEVDBSERVER

Luis Cazares SSC Guru Points: 183706 More actions · Answer 8

Have you tried connecting using the IP address and port instead of the server name?

That happened in a company I used to work.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

emmanuel.constant Right there with Babe Points: 761 More actions · Answer 9

emmanuel.constant

Right there with Babe

Points: 761

July 31, 2012 at 1:18 pm

#1519922

How would I do that?

Luis Cazares SSC Guru Points: 183706 More actions · Answer 10

emmanuel.constant (7/31/2012)
How would I do that?

Instead of using ServerName\InstanceName

Use IPAddress,port

Example: 192.168.0.1,1433

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

emmanuel.constant Right there with Babe Points: 761 More actions · Answer 11

Luis Cazares (7/31/2012)
emmanuel.constant (7/31/2012)
How would I do that?
Instead of using ServerName\InstanceName
Use IPAddress,port
Example: 192.168.0.1,1433

I use that to create an ODBC connection and log into the SQL studio?

Luis Cazares SSC Guru Points: 183706 More actions · Answer 12

Why are you trying to create an ODBC connection?

Are you trying to connect to SQL Server Management Studio?

Are you using a prompt window like this?

Or are you trying to create a data source from somewhere else?

Where are you configuring the values? Could you show us an image of what you're doing before the error?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

emmanuel.constant Right there with Babe Points: 761 More actions · Answer 13

Luis Cazares (7/31/2012)
Why are you trying to create an ODBC connection?
Are you trying to connect to SQL Server Management Studio?
Are you using a prompt window like this?
Or are you trying to create a data source from somewhere else?
Where are you configuring the values? Could you show us an image of what you're doing before the error?

Why are you trying to create an ODBC connection?

I'm creating an ODBC connection to use in a C# application that needs the data in the database.

Are you trying to connect to SQL Server Management Studio?

I have attempted to connect to SQL Server Management Studio and the error message is attached on the original post.

It's the same error message I get when I attempt to create the ODBC

Are you using a prompt window like this?

Yes it is the same prompt as your image

Or are you trying to create a data source from somewhere else?

Yes I am attempting to create the data source from my client machine.

My client machine is in one domain and the server is in another domain.

Also, I'm using SQL Server Authentication.

Where are you configuring the values? Could you show us an image of what you're doing before the error?

I've attached the UI for the ODBC connection to this post

Luis Cazares SSC Guru Points: 183706 More actions · Answer 14

In the part where it asks

Which SQL Server do you want to connect to?

Server:

Just put the IP Address and port. Example:

192.168.0.1,1433

If it works, that might be some problem with your DNS.

If it doesn't

Could it be a problem of Windows Server configuration?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jitendra.padhiyar SSCertifiable Points: 5824 More actions · Answer 15

emmanuel.constant (7/31/2012)
I did discover that I have the Win2008 server which host the SQL Server 2008 on one domain and I'm attempting to access it from a client PC from another domain.

First of all confirm that client pc on which you are working has the access on the machine which host sql server 2008, second the you must create one sql user that will get access to sql server 2008, bcos according to my knowledge windows authentication will not work as they are from two different domain.

Thanks,

Jitendra