?
Solved

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

Posted on 2007-04-03
7
Medium Priority
?
192 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 750 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 750 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

764 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