SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-20-2008, 12:47 PM
| ||||
| ||||
 Problem connecting to a SQL 2005 DB Dear all I am having "issues" connecting to the sample DB's on a fresh install of SQL 2005 via ODBC. I can create a working ODBC connection on the server, but am unable to connect from an XP SP2 workstation. No domain, but all machines in the same WORKGROUP. I believe I have eliminated all firewall issues already. The errors I receive refer to the user account not having a "trusted connection. Varous searches for soloutions have yielded no success. I have created and identical users and passwords on the 2008 Server and XP SP 2 workstation. I have tried MANY configuration for creating the ODBC on the workstation, yes, the server name is automatically seached in the first phase of the ODBC setup screeen. Ideas ?      |
|
03-20-2008, 12:47 PM
| |||
| |||
| RE: Problem connecting to a SQL 2005 DB - FIXED ! Hi all, Dont bother replying, I got it t work ! It was a user rights/security issue. Thanks anyways ! "John" wrote: > Dear all I am having "issues" connecting to the sample DB's on a fresh > install of SQL 2005 via ODBC. > > I can create a working ODBC connection on the server, but am unable to > connect from an XP SP2 workstation. > > No domain, but all machines in the same WORKGROUP. > > I believe I have eliminated all firewall issues already. > > The errors I receive refer to the user account not having a "trusted > connection. Varous searches for soloutions have yielded no success. > > I have created and identical users and passwords on the 2008 Server and XP > SP 2 workstation. > > I have tried MANY configuration for creating the ODBC on the workstation, > yes, the server name is automatically seached in the first phase of the ODBC > setup screeen. > > Ideas ? |
|
03-20-2008, 12:47 PM
| |||
| |||
| RE: Problem connecting to a SQL 2005 DB FIXED ! "John" wrote: > Dear all I am having "issues" connecting to the sample DB's on a fresh > install of SQL 2005 via ODBC. > > I can create a working ODBC connection on the server, but am unable to > connect from an XP SP2 workstation. > > No domain, but all machines in the same WORKGROUP. > > I believe I have eliminated all firewall issues already. > > The errors I receive refer to the user account not having a "trusted > connection. Varous searches for soloutions have yielded no success. > > I have created and identical users and passwords on the 2008 Server and XP > SP 2 workstation. > > I have tried MANY configuration for creating the ODBC on the workstation, > yes, the server name is automatically seached in the first phase of the ODBC > setup screeen. > > Ideas ? |
|
03-20-2008, 12:47 PM
| ||||
| ||||
| RE: Problem connecting to a SQL 2005 DB FIXED !!!!!! "John" wrote: > Dear all I am having "issues" connecting to the sample DB's on a fresh > install of SQL 2005 via ODBC. > > I can create a working ODBC connection on the server, but am unable to > connect from an XP SP2 workstation. > > No domain, but all machines in the same WORKGROUP. > > I believe I have eliminated all firewall issues already. > > The errors I receive refer to the user account not having a "trusted > connection. Varous searches for soloutions have yielded no success. > > I have created and identical users and passwords on the 2008 Server and XP > SP 2 workstation. > > I have tried MANY configuration for creating the ODBC on the workstation, > yes, the server name is automatically seached in the first phase of the ODBC > setup screeen. > > Ideas ? |
Linear Mode
