• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

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

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
davidsperling
Asked:
davidsperling
  • 5
  • 2
2 Solutions
 
imran_fastCommented:
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
 
davidsperlingAuthor Commented:
Yes, in Management Studio. Btw, it's sql2k5 express and full version of vs2k5.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
davidsperlingAuthor Commented:
And yes, I've configured the surfice area ;-)
0
 
davidsperlingAuthor Commented:
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
 
davidsperlingAuthor Commented:
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
 
davidsperlingAuthor Commented:
Think I solved the problem. Embarasing enogh, I forgot to type in MYSERVER\SQLEXPRESS instead of just MYSERVER... :-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now