Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2008-02-25 : 10:22:09
|
I just got a dedicated server to run my websites and SQL Server and MS SQL 2005 Express was installed as it will be more then enough to handle the needs of my DBs right now. The problem I am getting is that when I try to connect to the server from Management Stuido Exrpess (from the server it's self) I recive this error:quote:
provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server Microsoft SQL Server, Error: 2
And when from a remote computer I get: quote:
provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server Microsoft SQL Server, Error: 53
I have gone into the Service Area Configuration and made sure that it is set to accept TCP/IP and Named Pipes connection from remote computers and then restarted the dataebase engine.Can anyone help me? Since this is a dedicated server I have to pay for there support and want to see if I can avoide that-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 10:25:01
|
| Check your application log. What do you see? |
 |
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2008-02-25 : 10:32:33
|
quote:
Originally posted by sodeep
Check your application log. What do you see?
The app logs are empty. Also I did completely disable the built in Windows 2003 firewall.-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2008-02-25 : 11:08:00
|
| Ok, I am having the host reinstall express. Thought my searching on google this was a fix that worked for a few people so I figure I will give it a shot and if I am still having problems I will start a new post-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
|
|
|
|
Can not connect form Management Stuido to Express