SQL Server Management Studio Express - TCP/IP | Tech Off

yman

i have read that you can use the free sql management studio express to manage sql server 2000. I tried connecting using the management studio but it wants to connect to my sql server using named pipes which I cant use. The sql server is behind a firewall with port 1433 forwarded, I need to connect to it using the TCP/IP network library.

Does anyone know how to tell sql management studio express to use the TCP/IP library to connect?

edit: I am quite new to sql server management, so if I am talking rubbish, tell me Smiley

Quantux
Boot to the Head.

Not sure quite what you're looking for. I use it to connect to remote sql2k servers using ipaddress, dns and machine names all the time. Maybe a screenshot of the error you're getting?

yman

Well, it errors when it tries to connect, saying that a connection can not be made. It says in the error message that it is using 'Name Pipe Provider' as the connection library. I want it to use the TCP/IP connect library.

Quantux
Boot to the Head.

Looks like from what the error is saying, the sql server is not set up for remote connections. Now looking at the address, I'm wondering if this server is on your network, or if you're connecting from outside the network. If from outside the network, the server itself (windows) may not be set up for allowing the connection. I only have experience connecting to machines from inside the network. While the firewall that controls access to the server may be forwarding traffic on that port, windows or sql server might not be listening.

figuerres
???

yman wrote:
i have read that you can use the free sql management studio express to manage sql server 2000. I tried connecting using the management studio but it wants to connect to my sql server using named pipes which I cant use. The sql server is behind a firewall with port 1433 forwarded, I need to connect to it using the TCP/IP network library.

Does anyone know how to tell sql management studio express to use the TCP/IP library to connect?

edit: I am quite new to sql server management, so if I am talking rubbish, tell me

well IMHO and FWIW I would not let a production server be internet addressable -- to many problems like traffic sniffing.

aside from that let's see:

do you have connection to the remote server at the TCP Level??

for examplw what happens if you open a CMD window and try this:

TELNET 123.123.123.123 1433

if you get a "connect" then look at the tool's settings
if Telnet can't connect to the port then you have a firewall somewhere blocking the sql port.

I know that SQL Express by default has TCP and other network protocols shut off to help new users keep from beeing so open to attack. check to see if that also affects inbound connections also.

prog_dotnet

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

yman

prog_dotnet wrote:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

I am using SQL 2000, I read that you can still use the new express manager to administrate sql 2000.

prog_dotnet

sure you can, but you are connecting from at sql 2005 express edition that is secure out of the box. In sql 2005, the tcp/ip stack is disabled and remote connections are not allowed. Thats by default. So you first have to configure the sql 2005 express edition correctly, and take it from there.

yman

This is all I have installed once I downloaded the management studio from http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

blah, my image store is done, I am sorry

blah, my image store is done, I am sorry

blowdart
Peek-a-boo

yman wrote:
i have read that you can use the free sql management studio express to manage sql server 2000. I tried connecting using the management studio but it wants to connect to my sql server using named pipes which I cant use. The sql server is behind a firewall with port 1433 forwarded, I need to connect to it using the TCP/IP network library.

Does anyone know how to tell sql management studio express to use the TCP/IP library to connect?

Try bringing up the SQL server configuration tool. You don't have the icon, so run

C:\WINNT\system32\mmc.exe /32 "C:\WINNT\system32\SQLServerManager.msc"

Select the client protocols option and enable TCP/IP

MooseBreath

You need to configure an alias using the SQL Configuration Manager\SQL Native Client. You can specify the IP and Port.

This link helped me.

http://kdc.kapowtech.com/tip/tipWeek65.html