SQL 2005 and Vista problem

D

David DB

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
 
L

Lloyd Sheen

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
 
D

David DB

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
 
K

Kerry Brown

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL 2005 Cannot INSTALL : IIS NOT FOUND ??? 2
IIS 7 & Sql Server 2005 Setup problem 4
SQL 2005 troubles 1
SQL Server 2005 and IIS 7 1
Windows Vista Administrator account 2
Using SMO for SQL Server 2008 Express AND SQL Server 2005 Express 6
troubles with dns-less connection to sql 0
Access 2003 to SQL 2005 Express connection problems 1

Top