Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Please sort out one issue regarding SQL Server instances. I have one instance of SQL Server named 'Test\Connect' and other one is 'local' by default.

So the issue is when I connect to local and Test\Connect instances, the databases seen are the same. I am not able to see the databases which I have created in my instance Test\Connect.

But when I connect through IP\Connect (IP address of Test and same instance name) then I can see the databases.

Please help me out and let me know the process how we can sort this out.

share|improve this question
    
Are you sure that Test resolves to the IP address you expect? –  Thomas Stringer Jan 3 '13 at 4:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.