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 |
|
sbt1
Yak Posting Veteran
89 Posts |
 Posted - 2005-08-04 : 14:56:24
|
| I have been running MSDE 1.0 on a machine for years, no problems. Recently I had to upgrade to XP Pro. Reinstalled MSDE 1.0, no problems except the SQLServerAgent would not start, could never connect to the database.Upgraded to MSDE2000A, now the SQLServerAgent starts and runs fine, BUT other PCs cannot access the database, they get the "server not found or access denied" error, even though it's using the same account info and strong password it was before. The PC with MSDE running the same app works fine.thoughts? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-04 : 15:10:50
|
| Are you running service pack 2 for XP? If so, you'll need to disable the firewall as that's what's blocking other users from connecting.Tara |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-04 : 15:26:31
|
| by default MSDE 2000A does not enable support for network connections to the database. If you read through the README that came with the install you will find the information for how to enable TCP/IP access. As Tara noted, you may also find that you have an issue with the WinXP firewall blocking port 1433 requests. There are notes in micorosft's knowledgebase regarding how to configure the firewall to work with MSDE or SQL2K installed. Just do a search and you will find them.-ec |
|
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2005-08-04 : 15:33:28
|
| yeah it was the network protocols issue. set it and it works fine.thx much. |
|
|
|
|
|
|
Replaced MSDE 1.0 with 2000, now access issue