sql server new users: Hello,

i want to connect to another SQLEXPRESS server that is located inside our
local network. I am using "SQL Server Management Studio Express".

I have activated TCP/IP protocol for both servers and the SQL browser
service is running on both computers. To login i am using Windows
authentication with a user that is registered on both systems (both are in
the same domain, user is a domein user). When trying to connect i am
switsching the connection to TCP/IP.

When i try to connect to "OtherComputer\SQLEXPRESS" i get an error 26,
telling me that the remote computer cannot be found (i am able to "see" the
computer in the network neighbourhood and can PING it too).

Can anyone give me a hint what might be missing? Or is the management studio
express not able to do remote connections?

Thanks in advance,
Ralf

Hello, Ralf

I guess the firewall at the server is blocking the connections.
You need to configure an exception for sqlservr.exe and for
sqlbrowser.exe.

See also:
http://support.microsoft.com/kb/914277
http://blogs.msdn.com/sql_protocols/default.aspx

Razvan

"Razvan Socol" <rsocol@gmail.com> schrieb im Newsbeitrag
news:1182254690.307487.199810@p77g2000hsh.googlegroups.com...
[quoted text, click to view]

No. These both applications are defined in the firewall (both are XP
computers). Forgot that to mention in my original post. Sorry.

This should work, so check some of the unlikely problems.
- Did you restart the SQLExpress instance after enabling listening on TCP?
That's required.

- Is "OtherComputer\SQLEXPRESS" by any chance installed as another name?
SQLEXPRESS is the default name, but you can name it
"OtherComputer\ACCOUNTING" during installation if you want to.

- Is "OtherComputer\SQLEXPRESS" started? (I know this is a duh... but
sometimes people don't check and that would cause this error.)

- Is the client using TCP? Using the SQL Server Configuration Manager on the
client, make sure TCP is enabled, and move TCP ahead of Named Pipes.

- Can you connect to the other computer by IPAddress,port number, like
123.45.67.245,1433 ? SQL Express listens on a dynamic port by default, so to
get the port number that was dynamically selected, check the error log for a
statement similar to "Server is listening on [ 'any' <ipv4> 1433]"
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]