Invalid object name 'MAPS.dbo.devices'

Feb 9, 2012 at 8:47 PM

Hey Buck,

You've got a great idea here and I really appreciate all the effort you've put into your documentation - enough that I feel guilty about asking what is probably a dumb question but here goes:  I've installed the latest version of MAPS and successfully run the discovery against my SQL server hosts.  In your entry http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=318, you essentially say:

> USE MDW;
> GO
> INSERT INTO [MDW].[servers].[system] (<stuff>)
> SELECT  <stuff> FROM MAPS.dbo.devices

but when I try that I get an error as I am not able to select against the MAPS database.

> SELECT * FROM MAPS.dbo.devices
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'MAPS.dbo.devices'.

What do I need to do to configure my SQL 2008 instance to query the MAPS tables in the SQL Express instance?

Ken

Coordinator
Feb 9, 2012 at 9:03 PM

Hello there – the MAPS tool has been through probably three revs since that article, so you may have to spelunk around in there to locate that now. J

Buck Woody

Instructor, Academic Programs

woodyb@hotmail.com | http://moodle.extn.washington.edu/course/view.php?id=609

http://buckwoody.com |http://blogs.msdn.com/buckwoody|facebook, linkedin, twitter, Google+: BuckWoody

Description: Description: cid:3318414110_1508829

From: khemmerl [email removed]
Sent: Thursday, February 09, 2012 1:48 PM
To: woodyb@hotmail.com
Subject: Invalid object name 'MAPS.dbo.devices' [SQLCMS:300921]

From: khemmerl

Hey Buck,

You've got a great idea here and I really appreciate all the effort you've put into your documentation - enough that I feel guilty about asking what is probably a dumb question but here goes: I've installed the latest version of MAPS and successfully run the discovery against my SQL server hosts. In your entry http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=318, you essentially say:

> USE MDW;
> GO
> INSERT INTO [MDW].[servers].[system] (<stuff>)
> SELECT <stuff> FROM MAPS.dbo.devices

but when I try that I get an error as I am not able to select against the MAPS database.

> SELECT * FROM MAPS.dbo.devices
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'MAPS.dbo.devices'.

What do I need to do to configure my SQL 2008 instance to query the MAPS tables in the SQL Express instance?

Ken

Feb 9, 2012 at 9:07 PM

I got things working by creating a linked server (in SSMS under Server Objects > Linked Servers) called "VMDEV-APP2\MAPS" where VMDEV-APP2 is my server name and MAPS is the SQL Express instance name.  The following query now works:

> SELECT * FROM [VMDEV-APP2\MAPS].MAPS.dbo.devices

Using this, I should be able to get your code to work.

Ken

Coordinator
Feb 9, 2012 at 9:08 PM

Nice – post whatever you learn as a comment back on that project.

Buck Woody

Instructor, Academic Programs

woodyb@hotmail.com | http://moodle.extn.washington.edu/course/view.php?id=609

http://buckwoody.com |http://blogs.msdn.com/buckwoody|facebook, linkedin, twitter, Google+: BuckWoody

Description: Description: cid:3318414110_1508829

From: khemmerl [email removed]
Sent: Thursday, February 09, 2012 2:07 PM
To: woodyb@hotmail.com
Subject: Re: Invalid object name 'MAPS.dbo.devices' [SQLCMS:300921]

From: khemmerl

I got things working by creating a linked server (in SSMS under Server Objects > Linked Servers) called "VMDEV-APP2\MAPS" where VMDEV-APP2 is my server name and MAPS is the SQL Express instance name. The following query now works:

> SELECT * FROM [VMDEV-APP2\MAPS].MAPS.dbo.devices

Using this, I should be able to get your code to work.

Ken