Question

Locked

Sql express Installation problem

By narayananbabun ·
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.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Probably going to be easier to uninstall and start

by Tony Hopkinson In reply to Sql express Installation ...

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

Collapse -

Which server are you trying to connect to?

by jimmy-jam In reply to Sql express Installation ...

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

Try something like localhost\SQLEXPRESS

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums