April 28, 2008 at 11:51 pm
Hello,
I have SQL Server Enterprise Manager Console installed on my Windows XP Pro Client. When I try to connect to a named SQL Server 2000 SP4 instance (let's call it server1\instance1), I'll get to another named SQL Server 2000 SP4 instance (server1\instance2) on the same server. Now you may ask, how do I know that I am on the wrong instance? Well, on instance1 there should be 2 user-dbs and some logins (both sql-users and windows-accounts), but I just see the one user-db from instance2 and their logins.
When I log-in to the SQL Server via rdp and start Enterprise Manager on the server, everything works fine (with the same Account!!!). I am System Administrator on both instances.
Some facts about the SQL Server:
OS: W2k3 R2 SP2
SQL-instance1: SQL Server 2000 SP4
SQL-instance2: SQL Server 2000 SP4
Has anybody made similar experiences? It's very annoying, because now I have always login to the SQL Server and start enterprise manager directly on the server. Further, it is the only instance on which I can observe this case.
Greetings, Marcel
April 29, 2008 at 12:16 am
Hi
That sounds very strange. The way I would troubleshoot this is as follows:
* Check the services on each server and check the instance name in brackets - I have seen systems with default instances and named instances that cause issues
* When adding a server name - does this dialogue find the 2 instances maybe remove all servers in EM first)
* If you can stop the instance that it keeps finding and try adding the "other" instance by full name
* There are also third-party tools out there that can find instances
* One last thing that I have seen before is entiries in "HOSTS"/"LMHOSTS" - which reference IPs and server names - maybe entries are causing issues?
Let us know how you go
Thanks
Kevin
April 29, 2008 at 12:33 am
- do you have more than one named instance on that server ?
- can you connect using the instances portnumber ?
- I have a similar issue with one server hosting a standard install and two named instances, when accessing from another trusted domain.
Our workaround is to connect using the portnumber.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 29, 2008 at 2:28 am
thank you for your replies!
There are no default instances on this server, only 8 named ones!
All the services seem to be ok! lmhosts and hosts-file are standard, there are no entries!
When I try to connect with odbcad32 and the full servername (like server\instance1) I have the same problem. If I configure the port-nr in odbcad32, everything is ok! So there seems to be a problem with name resolution!
The strange thing about it is, on every other XP client, with the SAME credentials, I don't have this problem! I already tried to delete my profile on my client, but this didn't help at all! Ah, the problem persists since last week, two weeks ago everything was ok.
Thank you
Marcel
April 29, 2008 at 2:36 am
Did u try "ServerName\InstanceName , PortNumber"?
April 29, 2008 at 2:50 am
- do you use dynamic ports or fixed portnumbers ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 29, 2008 at 2:58 am
Have you tried loggin into Query Analyzer - do you get the same results?
Another option is to try connect using osql - see if this is also the same.
How about using the ip address instead of the name - e.g. \\10.1.1.1\instance1
let us know
Thanks
Kevin
April 29, 2008 at 3:13 am
I could resolve my problem. This is what I did:
open odbcad32, new System-DNS, typed in the servername (without instancename), in the next window I configured the port-nr in the clientconfiguration, went back to type in the servername\instancename and connected to the server. Now everything is ok again, even in Enterprise Manager. I guess, something in registry mismatched.
Thank you for your patience!
Marcel
April 29, 2008 at 3:20 am
great to hear - al the best
April 29, 2008 at 4:04 am
- dynamic ports in use ?
If an instance uses dynamic ports, it may receive another portnumber when it is (re) started !
Check your sqlserver errorlogs to figure out if a port changed at sqlinstance startup time.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 29, 2008 at 4:56 am
Thanks, but the problem is solved!
Each SQL instance has its own FIXED port-nr.
Greetings
Marcel
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply