Help!!!Cannot connect to remote sql server by named pipe

Hi, all,

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.

I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.

In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.

According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.

Thanks.

Johonson Chan

By "remotely" what do you mean? Are you talking a VPN or across the Internet?

You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.

Use TCP/IP.

|||

I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.

Anyone had a luck with using the database connection feature in the Sharepoint designer?

Thanks.

|||

I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.

The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.

I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.

Anyone else had this issue? Or any ideas how I can solve it?

Thanks.

|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.

-Simon
|||

same problem trying to connect over the internet to sql server 2005 using sql server authentication .

the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.

tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh

Login failed for user 'xxxxxxxx'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Help!!!Cannot connect to remote sql server by named pipe

Hi, all,

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.

I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.

In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.

According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.

Thanks.

Johonson Chan

By "remotely" what do you mean? Are you talking a VPN or across the Internet?

You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.

Use TCP/IP.

|||

I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.

Anyone had a luck with using the database connection feature in the Sharepoint designer?

Thanks.

|||

I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.

The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.

I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.

Anyone else had this issue? Or any ideas how I can solve it?

Thanks.

|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.

-Simon
|||

same problem trying to connect over the internet to sql server 2005 using sql server authentication .

the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.

tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh

Login failed for user 'xxxxxxxx'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

HELP! sp_send_dbmail error

I'm having trouble sending an email through DBMail. I'm logged in a a SQL Login user named "ServiceUser". I have added this user to the msdb database and as a rolemember to "DatabaseMailUserRole"

USE [msdb]

GO

CREATEUSER [ServiceUser] FORLOGIN [ServiceUser] WITHDEFAULT_SCHEMA=[guest]

GO

USE [msdb]

GO

EXEC sp_addrolemember N'DatabaseMailUserRole', N'ServiceUser'

GO

When I try to send the email:

exec msdb.dbo.sp_send_dbmail

@.profile_name=@.DatabaseMailProfileToUse,

@.recipients=@.EmailAddress,

@.subject=@.Subject,

@.body=@.MessageBody,

@.mailitem_id=@.MYmailitem_id OUTPUT

I get the following error:

Msg 15404, Level 16, State 10, Procedure xp_logininfo, Line 62

Could not obtain information about Windows NT group/user 'ServiceUser', error code 0xffff0002.

I executed the following on msdb and it didn't help:

execsp_changedbowner'sa'

xp_logininfo also returns the error:

EXECxp_logininfo'ServiceUser'

What is wrong? HELP!

My database mail profile was not public! It needs to be public or set to private for the user that is going to access it.

HELP! New Virtual Server in existing Cluster

I have a 2 part question about adding a new 'named' Virtual Server to an existing Clustered SQL Server 2000 install.

I have a 2 node MSCS Cluster (WIN2K advanced Server sp4) with a default SQL Server instance. This has been in production and working fine. I created a new Cluster resource and reran SQL Server 2000 ENT setup and added a second Virtual SQL Server (named instance). After many problems, finally got the second Server installed. Now I have 2 SQL Server instances in the Cluster - from what I understand, you can have up to 16, each seperate installs with seperate Cluster resources.
Thus the problem:

For the Second Instance, I have specific instructions from the Applications vendor on how to install SQL Server to work with their APP. I need install SQL Server WITHOUT the Full Text Search component and WITH a specific Server Collation (Binary order for use with the 850 Multilingual character set). (I have done this same setup on standalone SQL Server installations for this APP and they have gone smooth).

When I installed the new Virtual 'named' instance in my Cluster, I Could NOT 'DESELECT' Full Text Search when I choose Custom install.. it does not appear as an option?

Also, I chose the "Binary order for use with the 850 Multilingual character set" during the installation, but that is not the Server Collation that is installed...

I have already installed SP3 for SQL Server against the Virtual Server on this Cluster, as well as a HotFix... and Now I'm thinking I need to rerun the SQL Server installation, uninstall the second server and reinstall to see if I can fix the 'Collation problem' .. but I'm not sure if this is the right course of action.

Does anyone know why I cannot 'deselect' Full text search component at install, and any ideas why it did not install with the SQL Server Collation that I specified at install??are you seeing the same collation on the named instance as the collation on the default instance? did you check the install log for the named instance? any clues there? event viewer system and app logs?|||Originally posted by ms_sql_dba
are you seeing the same collation on the named instance as the collation on the default instance? did you check the install log for the named instance? any clues there? event viewer system and app logs?

Yes. it DOES have the same collation as the default instance!!! I had already checked the install logs and I did not see anything unusual. I DO see where it set the Server Collation in the install log, which is the sme collation as the default (original) server. I don't understand why if, in this kind of configuration you can have up to 16 SQL servers, why it would pull configuration settings from the first install??

Microsoft Knowledge Base Article - 298568 references a rebuildm.exe utility which will allow you to rebuild the master database with the correct collation.. I found a rebuildm.exe and rebuildm.rll in the 'program files' folder for the original 'default' install, but I cannot find these files in the second 'virtual server' program files folder.

When running the virtual server installation, it seemed pretty straight-forward. the only settings I changed were collation and the path for the program and data files (i put the data files on my new cluster resource drive) and I put the program files on the 'D' drive which is a fixed drive found on both nodes. it wanted to install the program files on the same drive as the original 'default' server. maybe I shouldn't have changed the program files setting??

I'm stumped!!!