Thx for the reply ... but the same application is running on another Server w/SQL Server 2005 without an issue.

It may be a Windows Server 2003 issue ......

Thank you Jeffrey I appreciate the reply ... there are three tables though, and probably about 100 or so columns between them, so I didn't want to go that route....

Usually when I restore and check the DB Owner it's blank, not the ID of the user who performed the Restore. The problem occurs when I check the properties...

Named Pipes

Named Pipes is an authenticated protocol. This means that any time a user attempts to open a connection to the SQL Server via Named Pipes, the Windows NT authentication...

SQL Server Authentication, using SA and the SA Password, on the remote computer. The SQL Server Instance is setup with Mixed Mode Security.

I'm going to keep throwing out more information in the hope that somehow a light will come on ...

When a successfully tested ODBC link is set to TCP/IP, the...

BTW, the Named Pipes ODBC connection works remotely on my Server (SQL 2005 Workgroups) but doesn't on another Client's Server using 2005/WG Edition ... my test environment is Express ...

Thank you for your response. I ran the query and here are the results; the config_value and run_value are both 1.

remote access0111

Please keep in mind that I can connect...

I need some help with this topic. The SQL/Server 2005 computer communicates with the DB through ODBC using Named Pipes without a problem. A remote computer connects to...

Thank you ... the script seems to work for the database written for SQL/2000, but for the database converted from Access to SQL/2005 it returns "The login already has an...