SQL QUERY - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL QUERY

Author

Topic

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2007-12-03 : 06:58:10

Hi Guys

Can someone please assist me in writing a SQL QUERY.

What i have is the following

A Server Called THOR
SQL Instance. @ localhost
SQL Instance. @ THOR\OfficeServers

Now SAP B1 Is installed in the 1st and Projects and Sharepoint in the 2nd

Now in SAP im trying to execute the following

select PROJ_NAME from [THOR\OfficeServers].[PWA_Published_96A2FDAC_0A9D_4B90_902D_AF0B5FB541BB].[dbo].MSP_PROJECTS

This works 100% in SQL Management Studio...
But in SAP B1 i get the following error.
login failed for user sa the user is not Associated with a trusted SQL Server Connection

Can someone please assist me with this.

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-03 : 07:05:47

You do not have sa rights to the SAP instance. If you are the DBA grant yourself rights(assuming this table exists on the instance. If you are trying to access the second instance from the first instance, you will need to create a linked server, look up sp_addlinkedserver in BOL (Books Online).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources