Solved

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

Posted on 2007-04-03
7
180 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
  • 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

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:…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now