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 |
|
antlane
Starting Member
3 Posts |
 Posted - 2007-07-03 : 10:21:30
|
| Hi, I wonder if someone can help me.I'm running SQL Server 2000 on Windows 2003 Server which I've been doing with no real problems for quite a while. I've recently tried setting up the newest version of PHPBB which automatically creates a new database and tables which it reported it had done succesfully. However, the database doesn't appear in Enterprise Manager and I can't access it through Enterprise Manager. I've even looked at the Profiler and I can see the datbase being accessed!I have a feeling it might be something to do with when I installed an evaluation copy of Sharepoint which installed SQL Server 2005. I removed it all but I wonder if something is still running. I discovered an instance of ##SSEE which I've since uninstalled but to no avail. Checking with SQLPing now reports only one SQL instance running on the machine.Can anyone give me any tips as to how to solve this?Many thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-03 : 12:50:17
|
| Run sp_helpdb in query analyzer to see if new db is listed. |
 |
|
|
antlane
Starting Member
3 Posts |
Posted - 2007-07-03 : 14:03:15
|
quote:
Originally posted by rmiao
Run sp_helpdb in query analyzer to see if new db is listed.
Thanks for your reply. Unfortunately, it's not there... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 00:04:33
|
| So db was not created. |
|
|
|
antlane
Starting Member
3 Posts |
Posted - 2007-07-04 : 02:40:47
|
| Hmmm, don't know what happened - I posted a message yesterday to say that I discovered all the tables in the master database and have sorted everything out. Not sure why it's missing from the forum. Anyway, thanks for everyone's help. |
|
|
|
|
|
|
Ghost SQL Server instance?