search

jspraul / sql-dbdiff

Automatically exported from code.google.com/p/sql-dbdiff
0 stars 0 forks source link

Problem to connect to remote sql server by using named pipe and server name. #14

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. to connect to remote sql db
2.
3.

What is the expected output? What do you see instead?
connected to the remote sql server db. Error message. Could not connect to 
the target sqlserver db

What version of the product are you using? On what operating system?
version 0.3.0.0 on Windows XP SP3

Please provide any additional information below.
problem to connect to the remote sql server by using named pipe.
Could not connect to remote sql server by server name instead of ip address 
and alias.

Original issue reported on code.google.com by azriaz...@gmail.com on 26 Mar 2010 at 3:23

Attachments:

GoogleCodeExporter commented 9 years ago 
Did you provide the instance name?

I.e. my machine is

dean-dev\SQLEXPRESS and this works as does
192.168.1.101\SQLEXPRESS however
192.168.1.101 will not work, because the instance hasn't been specified

Original comment by dean.tho...@gmail.com on 26 Mar 2010 at 9:45

GoogleCodeExporter commented 9 years ago 
Hi dean,

Need to double check.

Let say I've installed my sql server 2008 on this path 
'C:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\'

and the server ip address is 128.247.95.131.

Which one should I take as an instance name?

Based on the error produced, I've provided such as below:

128.247.95.131\MSSQL10.MSSQLSERVER

Is it the correct one?

Original comment by azriaz...@gmail.com on 29 Mar 2010 at 7:54

GoogleCodeExporter commented 9 years ago 
Hiy,

Well, if you did provide an instance name, it would have been provided during 
setup.

How do you connect to the SQL Server using SQL Server Management Studio?

Original comment by dean.tho...@gmail.com on 29 Mar 2010 at 9:36

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Try http://connectionstrings.com/.

Should be able to get your perfect connection string.

Original comment by dean.tho...@gmail.com on 3 Apr 2010 at 9:52