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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote

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" <asppsa (AT) hotmail (DOT) com> wrote