Monday, February 20, 2012
New Data Source showing only default instance
I have two instances in SQL on my machine. When creating a New Data Source in BIDS, I can only see the default instance. I have checked the SAC manager to make sure the second instance allows remote connections and the setting are exactly the same as the default. Any ideas? Thanks.Yeah, but does the second instance run on a different port? Can you type in the second instance's name and have it work?|||I checked the Config Mgr and the port number was blank for the second instance. When I changed the port number to the same as the first instance, I was unable to restart the second instance until I removed the port number. Should I use a different #?|||After changing the ports and changing them back to get the second instance to start again, the test connection in BIDS was successful this time. Go figure. Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment