Hi, I've done this dozens of times on my local XP, so this should be automatic, but now I am confused because I can't connect to the SQL Server 2005 instance databases on newly installed Windows Vista. The standard "localhost\instance_name" connection is not working. When I tried to connect a database on the default installation with just "localhost" string, it works fine. I would really appreciate if you could give any comment or suggestion. YC
Did you install SQL Server with an instance name or did you install it as the default instance? I would use "(local)\<instancename>" or simply ".\<InstanceName> to refer to the local named instance or "." to refer to the local default instance. These are not "database" instances but server instances. What exception are you getting? -- __________________________________________________________________________ William R. Vaughn President and Founder Beta V Corporation Author, Mentor, Dad, Grandpa Microsoft MVP (425) 556-9205 (Pacific time) Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) ____________________________________________________________________________________________ "YC" wrote in message news:epvQwDH2IHA.5944@TK2MSFTNGP04.phx.gbl... > Hi, > I've done this dozens of times on my local XP, so this should be > automatic, but now I am confused because I can't connect to the SQL Server > 2005 instance databases on newly installed Windows Vista. The standard > "localhost\instance_name" connection is not working. When I tried to > connect a database on the default installation with just "localhost" > string, it works fine. > > I would really appreciate if you could give any comment or suggestion. > YC >
