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 |
|
dav1djed
Starting Member
10 Posts |
 Posted - 2007-04-05 : 06:56:07
|
| When I try to log onto my system I get the following error!"TITLE: Connect to Server------------------------------An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"The application utilizing the DB crashed and has been restarted. I was hoping not to reboot the DB in hopes of picking up the process where it left off. Does anyone know if there is a configuration setting which will allow me to log on? |
|
|
irs2k3
Starting Member
22 Posts |
Posted - 2007-04-05 : 08:06:00
|
| Are you sure you have an instance of Sql Server 2005 installed on your system? |
 |
|
|
dav1djed
Starting Member
10 Posts |
Posted - 2007-04-05 : 09:10:14
|
quote:
Originally posted by irs2k3
Are you sure you have an instance of Sql Server 2005 installed on your system?
Yes. The issue appears to be that the tempdb file is full and was set to grow larger then the disk space. Now I can not log onto the DB and reset the size. |
|
|
|
|
|
|
Error at Log In