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 |
|
kanucha
Starting Member
1 Post |
 Posted - 2010-07-29 : 14:54:05
|
Good afternoon,I'm not sure if this is the correct subforum, but I certainly considering myself "New to SQL Server Administration" so I thought I'd try here.  I have an application that uses SQLExpress to manage its data and user accounts. (Application is Repliweb's RMFT.) Twice now the application has stopped functioning. The only way I was able to resolve this issue was by doing a fresh install of the OS, and rebuilding the box from scratch the first time. I'm trying to avoid having to do that again. : ( I believe its happening because something changes on the server and prevents it from being able to log in to SQL. I say this because, initially after install the program works fine, and I log into SQL fine. However, once it breaks I can neither log into SQL or the application (whose log information is managed by sql).(Not sure if this is relevant, but I should also point out that the application ran for a year just fine. After the second install in broke again less than a week later.)Error details:Server is running Win 2003 R2, x64, SP2. The application, the SQL Server, and all my efforts have all taken place locally on this machine. (Though I remote into the OS, of course.)Once the application breaks, if I attempt to log into SQL though command like, using 'osql -U root' I receive the following errors:[SQL Native Client]Named Pipes Provider: Could not open a connection to SQLServer [2].[SQL Native Client]Login timeout expired[SQL Native Client]An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may be caused bythe fact that under the default settings SQL Server does not allow remoteconnections.Do you know what might be causing this for me, and how I could resolve it? Thank you for your time. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Failing to connect to the server.