Solved

Can't reference new databases in Visual Studio (CLR-integration)

Posted on 2007-04-03
7
191 Views
Last Modified: 2013-11-26
I'm following the examples of CLR-integration in a book (Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL &  .NET by Dejan Sunderic)
When I create a new visual basic database project in VS2005, only some of the databases will show up as available connections (not the one I want). Subsequently, you'll then push the button Add New Reference. But... then I can't connect at all. The dialogue finds the server (local machine), but no schemas (databases).

-I use sql server authentication with the same user/pwd for all databases.
-One database (B) that won't show up is restored from a backup of A, that will show up. (i was allways logged in as the same user)

I'd be very pleased with a solution for this, it consumes a lot of time!

Also, if anyone has a suggestions of good links/books that explains sql2005 security in general, it'd also be very helpful.

Secure by default...I love it ;-)
0
Comment
Question by:davidsperling
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 28

Accepted Solution

by:
imran_fast earned 250 total points
ID: 18842093
The user you are using does it has access on all the databases. It can see only those  database on which this user have access
You need to give this user access on the other databases.
0
 
LVL 28

Assisted Solution

by:imran_fast
imran_fast earned 250 total points
ID: 18842098
0
 
LVL 4

Author Comment

by:davidsperling
ID: 18842100
Yes, in Management Studio. Btw, it's sql2k5 express and full version of vs2k5.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 4

Author Comment

by:davidsperling
ID: 18842108
And yes, I've configured the surfice area ;-)
0
 
LVL 4

Author Comment

by:davidsperling
ID: 18842132
Hmm, I actually can't se NONE of the databases in the "add new reference"-dialouge. Haven't even got the chance to log in.
0
 
LVL 4

Author Comment

by:davidsperling
ID: 18842144
With good links I meant info how to turn the friggin'n security off! :-) It's god damned test environment! I can't be the only one who's p-d about this, can I ?
0
 
LVL 4

Author Comment

by:davidsperling
ID: 18856265
Think I solved the problem. Embarasing enogh, I forgot to type in MYSERVER\SQLEXPRESS instead of just MYSERVER... :-)
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question