I have the several workgroup PCs that must connect to a database hosted on SQL 2000 on a Win2k server on a domain. The database is configured for mixed mode. If I try to set up an ODBC System dsn using SQL Authentication, I get a Server does not exist or access denied error. I can connect to another SQL2000 database on a different Win2k server ok. I can successfully set up the System DSN using SQL Authentication if the PC is added to the domain. As soon as I try to access it when the PC is returned to workgroup configuration, I can't connect. so it looks like an issue with this particular server. NT auth does not work for obvious reasons. Any clues anyone?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problems connecting
- Thread starter bgfs
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Sounds like the SQL Server is setup for Windows only authentication. What's the exact error you are getting when you try to connect with a SQL Account? Can anyone else connect using a SQL Account?
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
My Blog
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question