Can't reference new databases in Visual Studio (CLR-integration)
Posted on 2007-04-03
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 ;-)