Solved

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

Posted on 2007-04-03
7
178 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
Comment Utility
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
Comment Utility
0
 
LVL 4

Author Comment

by:davidsperling
Comment Utility
Yes, in Management Studio. Btw, it's sql2k5 express and full version of vs2k5.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 4

Author Comment

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

Author Comment

by:davidsperling
Comment Utility
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
Comment Utility
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
Comment Utility
Think I solved the problem. Embarasing enogh, I forgot to type in MYSERVER\SQLEXPRESS instead of just MYSERVER... :-)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

771 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

14 Experts available now in Live!

Get 1:1 Help Now