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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2006-07-06 : 15:46:19
|
| I installed a SQL 2000 personal edition in on PC running XP pro. Now, I try to conncet it from my pc using EM but got error.What is wrong? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-06 : 15:55:03
|
| What is the error? Did you start the MSSQLSERVER service?Tara Kizeraka tduggan |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-07-06 : 16:03:22
|
| Error:Server does not exist or access denied |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-06 : 16:08:28
|
| So is the service started? On the PC that is running SQL Server, does it have WinXP sp2 installed? If so, then you'll need to disable the firewall as that's preventing remote users from connecting to it.Tara Kizeraka tduggan |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-07-06 : 16:38:32
|
| sp2 was installed and firewall was disable |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-06 : 16:48:52
|
| What about the service?Tara Kizeraka tduggan |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-07-06 : 17:01:29
|
| service is on and server is running in his pc |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-06 : 17:04:17
|
| Try adding an alias on your machine using Client Network Utility. Make sure to specify the port number that was selected during the installation.Tara Kizeraka tduggan |
|
|
|
|
|
|
Register personal version of SQL server