I've been working on a tutorial to create ETL packages (See http://msdn.microsoft.com/en-us/library/ms170365.aspx
), and I've determined that my "localhost" is not mapped to my default server. As per instruction, from an Integration Service Project in Visual Studio 2008, I open the "New OLE DB Connection" and type "localhost" as my server name, but my dropdown list of available databases shows up empty. On the other hand, I do have a <ComputerName>/<UserName> combination that I can enter, and I do get the appropriate list of databases.
In my dropdown list of servers, I show a list of 3 Servers, only 1 of which shows the databases I expect to see. When I open SQL Server Management Studio, I only see 1 database, not the other 2 shown in the Integration Service project.
My questions are these: What application do I use to find out the server to which "localhost" is assigned; and, having checked, how do I reassign it to the relevant server? Your help is very much appreciated.