I've successfully created a Linked server within SQL Server 2005 Management
Studio to a DB2 database (DB2 is hosted on Windows Server 2003). If I right
click the linked server and select 'Test Connection' and get a message 'The
test connection to linked server succeeded'.

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 connect front uses Winows XP ...

I think I cannot install Office Accounting 2008 (Professional Edition) and
use my existing SQL Server 2008 (Standard Edition).
How can I do this?
Thanks!

New installation on windows 2003 sp2. I installed sql 2005 developer edition
with sp1 and sp2, including reporting service, integration service.....
I enabled remote connections using tcp/ip and name pipe, when I tried to
connect it using SMO remotely, it gives me this error ...

OK, pardon my lack of technical know how but I am hoping someone can assist
me in troubleshooting an appliaction connectivity issue.
SQL 2005
Two named instances of SQL server:

i am facing a problem in calling a sp using sql native client
provider for SQL Server 2005. I have a stored procedure which return
some rows as output. I am calling this sp through my vb application
using "DSN=MyDSN; UID=MyUID; PWD=MyPWD" as connection string, in this

Hello
I have Pass through queries that I can run successfully when opened directly
in the Access Queries window, but when I try to run the queries from VBA code
module I end up with ODBC -- Call Failed. I have increased the timeout

What are the needed files/settings needed in order to a client computer
under Win95 or 98 can connect to SQL Server 2005 on the serve machine (with
or without SQL Native Client drivers)?
Our [installed] exe runs smoothly on a XP machine but the same exe installed

ResultSet.getTimestamp() seems to be truncating trailing zeros in the
milliseconds field.
I have a timestamp value in the database that shows as 2008-07-07
11:23:17.220 when I query it directly using MSSQL Management Studio. Note

I have a linked server setup so that I can query Active Directory and ADAM. I
have veiws for Users and Groups, and have even written a query to return the
members of a given group. The problem is, I need to write the reverse, a sp
to return the groups a given user is a member of. ...

I have SQL 2005 Express running on XP SP2 in a workgroup environment. When I
attempt to connect to the database, via ODBC, from another workstation in the
workgroup with our report viewer I get an error of Incorrect password.  I
tested the OCBC connection when I created it and it ...

I have a access db version 2000 running on ms access 2003.  There are bunch
of
tables linked to sql server 2005 db.  Based on what I have read so far,
odbc doesn't do codepage translation.  Hence, I better make sure that ms

I have an Access 2007 (accdb) file that is linked to a SharePoint 2007 site.
It is a standart feature of SharePoint that allows to create Access file that
is linked to SharePoint lists.
I need to create a linked server in SQL 2005 that connects to the Access

I'm trying to troubleshoot sporadic connectivity errors to our SQL server.
Every now and then we have been receieving connectivity errors. When I go to
investigate I see nothing in any logs on our sql server that says its having
problems. On the clients i can ping the serer by ...

I have 2 XP boxes in a peer to peer network.  I have SQL Server Developer
edition running on one of the two boxes and I am trying to get an application
to connect to it from the other one.
I am used to setting up SQL databases on Windows Server running as a domain