Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem connecting to a SQL 2005 DB

  
   Database Forums (Home) -> ODBC RSS
Next:  ODBC Error with Terminal Server  
Author Message
John

External


Since: Mar 03, 2006
Posts: 43



(Msg. 1) Posted: Tue Mar 18, 2008 10:17 pm
Post subject: Problem connecting to a SQL 2005 DB
Archived from groups: microsoft>public>sqlserver>odbc (more info?)
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 ?

 >> Stay informed about: Problem connecting to a SQL 2005 DB 
Back to top
Login to vote
John

External


Since: Mar 03, 2006
Posts: 43



(Msg. 2) Posted: Tue Mar 18, 2008 10:48 pm
Post subject: RE: Problem connecting to a SQL 2005 DB - FIXED ! [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ?

 >> Stay informed about: Problem connecting to a SQL 2005 DB 
Back to top
Login to vote
John

External


Since: Mar 03, 2006
Posts: 43



(Msg. 3) Posted: Tue Mar 18, 2008 10:48 pm
Post subject: RE: Problem connecting to a SQL 2005 DB [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 ?
 >> Stay informed about: Problem connecting to a SQL 2005 DB 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Connecting to Paradox - Hello, I am trying to connect to paradox database for the purpose of updating the record(s) in DTS ActiveX Script Task. I used the following connection string. But I get an error while connection. I have "UMTest.db" and "UMTest.px" ...

Connecting to remote server without sending user/pass - Is there a way to connect to a remote server using only the DSN? I have configured a DSN on my machine and typed the user/pass.. the connection test works fine. Now I would like that my application connects using only "Dsn=DsnName" connection...

SQL 2005 Express - I'm attempting to create an ODBC connection to SQL 2005 Express accross a workgroup but the computer does not see the server. I also have SQL 2000 Developer on the save computer and the ODBC does see that server. The computer that I'm trying to..

Jet4 and Merge Replication on 2005 - I have experienced problems when using Jet4 linked tables and Merge Replication on SQL Server 2005. I have not been able to find a resolution to this except to use SQL Server 2000, and this was two years ago. The basic problem is when I insert a new....

SSIS package Informix to SS 2005 - Hello - We are running Sql Server 2005 in a Windows Server 2003 environment. I have been unable to create an SSIS package to copy four tables from an Informix database; nor am I able to manually import from this DB. This is a DB created by Avaya and...
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]