Vista Tutorial - SQL 2005 and Vista problem

Hi,

When using Vista it cannot connect to a SQL 2005.

We first discovered this in our ptogram, and then I tested it in the ODBC
control panel. It says that it cannot find the SQL server.....

When connecting to a SQL 2000 it works fine.

This is only a problem in Vista. Works great in 98/2000/XP

Thanks,
David

Are you trying to connect from local machine to local SQL Server?

I just installed both and have no problems. If you are trying to connect
from another workstation this I have not tried. It may have to do with
computer browser service which I notice is not turned on.

LLoyd Sheen

"David DB" <er_fortsatt@hotmail.com> wrote in message
news:OnwAKMyRHHA.2228@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> When using Vista it cannot connect to a SQL 2005.
>
> We first discovered this in our ptogram, and then I tested it in the ODBC
> control panel. It says that it cannot find the SQL server.....
>
> When connecting to a SQL 2000 it works fine.
>
> This is only a problem in Vista. Works great in 98/2000/XP
>
> Thanks,
> David
>

Hi Lloyd!

On the same machine I also have Win XP, and there it works.

The SQL 2005/SQL 2000 is on a Win 2003 server.

David

"Lloyd Sheen" <a@b.c> wrote in message
news:CB042C96-DAB6-4617-B108-A4EEF319B7A2@microsoft.com...
> Are you trying to connect from local machine to local SQL Server?
>
> I just installed both and have no problems. If you are trying to connect
> from another workstation this I have not tried. It may have to do with
> computer browser service which I notice is not turned on.
>
> LLoyd Sheen
>
> "David DB" <er_fortsatt@hotmail.com> wrote in message
> news:OnwAKMyRHHA.2228@TK2MSFTNGP03.phx.gbl...
>> Hi,
>>
>> When using Vista it cannot connect to a SQL 2005.
>>
>> We first discovered this in our ptogram, and then I tested it in the ODBC
>> control panel. It says that it cannot find the SQL server.....
>>
>> When connecting to a SQL 2000 it works fine.
>>
>> This is only a problem in Vista. Works great in 98/2000/XP
>>
>> Thanks,
>> David
>>
>

What authentication mode does the sql server use? If it's Windows make sure
your Vista user is added.

--
Kerry Brown
Microsoft MVP - Shell/User
http://www.vistahelp.ca


"David DB" <er_fortsatt@hotmail.com> wrote in message
news:OnwAKMyRHHA.2228@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> When using Vista it cannot connect to a SQL 2005.
>
> We first discovered this in our ptogram, and then I tested it in the ODBC
> control panel. It says that it cannot find the SQL server.....
>
> When connecting to a SQL 2000 it works fine.
>
> This is only a problem in Vista. Works great in 98/2000/XP
>
> Thanks,
> David
>

Search for Vista in "Readme for Microsoft SQL Server 2005 Service Pack 2":
http://download.microsoft.com/downlo..._windows_vista


"David DB" <er_fortsatt@hotmail.com> wrote in message
news:OnwAKMyRHHA.2228@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> When using Vista it cannot connect to a SQL 2005.
>
> We first discovered this in our ptogram, and then I tested it in the ODBC
> control panel. It says that it cannot find the SQL server.....
>
> When connecting to a SQL 2000 it works fine.
>
> This is only a problem in Vista. Works great in 98/2000/XP
>
> Thanks,
> David
>