March 25, 2005 at 1:15 pm
I Have a personal version of SQL Server sp3a running on Xp.
Recently I was using a program that shows all the tables in a particular DB that is in the SQL SERVER. To my suprise some of the tables shown for that DB where not showing in the SQL Enterprise Manager (SEM). After sometime I discovered that the tables shown were in another db with the same name but in ANOTHER SERVER (not registered). I registered thah server and now I can see it in the SEM.
One of the servers is named (local) and the other alfa (the computer name) .
Can somebody tell me how i can remove a server (not unregister).
And may be explain me how I endup with two servers (which seem to use the same .mdf and .ldf files !!)
Thanks in advance for any help you can give me.
March 25, 2005 at 1:56 pm
You might have two instances of SQL Server on your machine (which is legitimate, SQL Server Std/Personal/MSDE allow up to 16 instances). Or you might have one instance and registered it under two different names.
To see if you have 2 instances, check you services (under Computer Management). If you have MSSQLSERVER and MSSQL$<something> (like MSSQL$alfa), then you have two separate instances.
If you have only one service running, it's possible that you created an alias for it (using Client Network utility), then in EM registered a separate connection for that alias. And if you registered the connection with a different account that cannot see all databases and/or tables, it would appear that some are "missing".
Mark
March 25, 2005 at 3:24 pm
Thank you.
I only have one instance of SQL (local).
Do you know how I can remove this other server or alias ?
Thanks again
March 28, 2005 at 7:38 am
Use the Client Network utility.
Mark
April 1, 2005 at 12:07 pm
Thank you.
I used the Client Network utility but no aliases in the alias tab !!
Do you have any other idea I should try?
José
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply