I don't know.

When I try to connect I get this error.

Server: Msg 17, Level 16, State 1, Line 1

SQL Server does not exist or access denied.

That is using for

@server='ServerName, i.e. computername ',

and

@datasrc='default instance name i.e. MSSQLSERVER'

-------------------------------------------

If I change

@datasrc='computername'

I get a different error.

Server: Msg 18456, Level 14, State 1, Line 1

Login failed for user 'domain\useraccount'.

If I change

@datasrc='computername\MSSQLSERVER'

I get a different error.

Server: Msg 14, Level 16, State 1, Line 1

Invalid connection.

-------------------------------------------

Named pipes is not enabled on SQL 2005 machine, only TCP/IP is enabled. Does named pipes have to be enabled?

------------------------------------------

Also I am using a windows account that is a sqldomainadmin account and DOES have

owner rights to the database on 2005.

Any help is appreciated.