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 |
|
Apples
Posting Yak Master
146 Posts |
 Posted - 2008-01-09 : 12:42:26
|
| I'm running SQL Server Express 2005 on Windows XP.I've been using SQL Server Express for the past month or so, and I've always been able to connect. Now all of a sudden I can't connect, it's giving me error 26.I've always used Windows authentication with no need for a password. |
|
|
stowellg
Starting Member
9 Posts |
Posted - 2008-01-09 : 13:27:05
|
| Error 26..Error Locating Server/Instance Specified? or is there a different message?Is the SQL Server service running, and are you sure you typed the right server name when trying to connect?I have a stupid question for you... |
 |
|
|
Apples
Posting Yak Master
146 Posts |
Posted - 2008-01-09 : 15:37:54
|
| Yes, "Error Locating Server/Instance Specified"The server name hasn't changed either, I've been running the same one since I've installed it. |
|
|
|
Apples
Posting Yak Master
146 Posts |
Posted - 2008-01-09 : 21:50:10
|
| Anyone? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 22:05:39
|
| Did you check sql service status? |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
|
|
Apples
Posting Yak Master
146 Posts |
Posted - 2008-01-09 : 22:43:10
|
| rmiao: How do I do that?dataguru: As far as I know, I've done all those things listed, except adding sqlbrowser.exe to the firewall exceptions. I couldn't find that file.The only thing I can think of is that I just ran a Windows update, could that have messed something up? I guess I should also mention that I'm using SQL Server Management Studio Express 2005, but I don't know if that changes anything.Thanks for all the replies by the way, I appreciate the help. |
|
|
|
Apples
Posting Yak Master
146 Posts |
|
|
|
|
|
|
|
Suddenly cannot connect