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 |
|
Mauricio Moreno
Starting Member
18 Posts |
 Posted - 2007-10-11 : 15:52:51
|
| I have been using Sql Server Express for about 6 months now along with SQL Server Management Studio Express (i also use query analizer) . Everything was working fine until this morning... When none of the computers with Management Studio Express here could connect to the sql database. Query analizer is still able to connect to the database fine(with the same setting as studio), its just studio that cannot (My website is also connecting fine). I checked with my hosting company (this is a dedicated server) and they said that nothing was changed on my system. Does anyone have any idea's what could be wrong?This is the error message...TITLE: Connect to Server-----------------------------------------------------------ADDITIONAL INFORMATION: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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476Thank you for any suggestions. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-11 : 15:56:39
|
| Rather than repeat everything I've typed about troubleshooting this error in the past couple of days, take a look at this thread:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90787Make sure you perform all of the various things in my posts. If you are still unable to get this to work, let us know.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Mauricio Moreno
Starting Member
18 Posts |
Posted - 2007-10-11 : 16:42:23
|
| Hi Tara,Our Database server is located on a remote internet server that is not in the same domain as we are on. The thing that is strange is that this was all working perfectly until this morning... and both my computers that have studio express were not able to connect to the sql database (and query analizer can). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-11 : 16:47:33
|
| If it was all working perfectly this morning, then you need to figure out what changed. Are you doing anything different in Express than what you are doing in Query Analyzer?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-11 : 16:48:44
|
| Also, you really need to go through all of those things that I asked the other poster to do in that link. I certainly am not going to repeat them here. Let us know all of the items that you did and what errors you got after each.Doing the telnet step is rather important, so you should start with that.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Mauricio Moreno
Starting Member
18 Posts |
Posted - 2007-10-11 : 18:38:26
|
| I Tried the Telnet thing. I think it went in fine... i didnt get an error message just a blinking curser.. i tried putting in a port that i new wouldnt work and i got a nasty error... I dont have the sql configuration manager on my local machines, just studio express.Query analyzer and studio express have the same connection settings.. just studio doesnt want to connect. And it was not working fine this morning... it was working fine last night when i went to bed... when i came into work is when the it didnt want to work anymore... Is it possible some kinda automatic update to the software happened last night? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-11 : 23:45:40
|
| What's sql server edition? Possible to install sql2k5 client on your machine? |
|
|
|
|
|
|
|
|
Connection Failed