Networks

Ask something
Question Locked

Sql express Installation problem

0 helpful
3 replies

by narayananbabun

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have installed sql server 2005 express edition and when i try to login i am getting server does not allow remote connection so I tried to go to surface area configuration to enable remote connections but when i click surface area connections I get an error components are not Installed or u r not login as administrator any help will be appreciated.

3 replies

by tony hopkinson

again.
If logging in from the machine you installed it on doesn't work, it's nothing to do with erm remoteness.
Surface Area Config would be for say turning on TCP/IP so you could hit it from another box (given the port (default 1433) was open on the firewall).

Can't say from here but by default. The windows user you were logged on with when you installed it will be the sql admin, and you get the option of setting up an sa account, for sql login (not integrated). Only named pipes will be on by default so you can't connect from another machine, until you use surface area config, which requires you to be logged on as the user you installed it as.

HtHs

HtHs

by jiminpa

if you are using the IP of your local machine you will get that error.

Try something like localhost\SQLEXPRESS

This discussion is closed to new replies.