October 21, 2013 at 3:29 pm
Hi,
I have recently started to learn a bit about SSRS using Visual Studio 2010.
I have been using SSMS for a few months now and most of what I have learnt so far has been DML. Because of this, when I have downloaded sample databases to use in SSMS, I do not think I have set these up properly.
Basically, I am able to query AdventureWorks2008R2 in SSMS but I am unable to use this DB as a data source in Visual Studio. I have three sample databases that I can query in SSMS however, the only one that I can use as a data source in Visual Studio is one that was set up by someone who knew what they were doing!
I have tried a few things in Visual Studio in order to get it so that I can use Adventure Works as a data source (much better for experimenting with queries/reports) however, I have had no luck so far.
Any help would be greatly appreciated. If you require further information, please let me know.
Many thanks,
Ben B
October 21, 2013 at 4:44 pm
It sounds like a permissions issue. Do you connect to the SQL Server instance with a different login than the one that is running Visual Studio?
You may need to create a user on your database. Here's the introduction to that in the Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 3:32 am
Thanks for the reply. I am now able to use the Database I wanted.
Many thanks,
Ben B
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply