Solved

Get error #5 when using SQL Server SMO in Windows Forms project

Posted on 2015-02-11
9
107 Views
Last Modified: 2015-02-13
I am trying to get a list of server databases from within my visual studio windows forms project. I am using the following to the a list of available servers and everything works ok:  

Dim dataTable = SmoApplication.EnumAvailableSqlServers(False)
 datServers.ValueMember = "Name"
 datServers.DataSource = dataTable

I am using this code to list all of the databases for the past servers.  It works fine and returns all of the databases for some servers but others I get a connection error.    All of the severs are SQL server 2008 R2  

  Dim server As New Microsoft.SqlServer.Management.Smo.Server(xServer)
            For Each db As Microsoft.SqlServer.Management.Smo.Database In server.Databases
                datCombo.Items.Add(db.Name)
            Next


I can figure out why it works for one sever but not the other.

Any help would be appreciated.
0
Comment
Question by:Mike_Stevens
[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
  • 4
  • 4
9 Comments
 
LVL 34

Expert Comment

by:ste5an
ID: 40603498
Can you connect to the other server in SSMS? Do you have the appropriate permissions?
0
 

Author Comment

by:Mike_Stevens
ID: 40603517
permissions on both servers are the same.    

Also, when I an trying to list the databases for a particular server im not using a username or password and it works on one server.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40603529
Error #5 is Access Denied. Are you sure the user exists in all SQL Server instances? And has the right privileges?
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:Mike_Stevens
ID: 40604073
I understand that Error #5 is an access is denied error.      I am not passing a username or password and the machine that is making the call is part of the domain.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40605096
Sure. But not passing a SQL user credential should mean that's using current user domain credential and is that user credential that you need to check if exists in all SQL Server instances.
0
 

Author Comment

by:Mike_Stevens
ID: 40605616
I am developing this on a Windows 7 laptop using VS2010 that is logged into the same domain and the SQL servers.   Both  of the SQL servers have a login configured that is the same as what I use to log in to the domain with my laptop.
0
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40605622
The errors are always on the same SQL Server instances? If so, can you connect to that instances remotely?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40608056
You've found the issue?
0
 

Author Comment

by:Mike_Stevens
ID: 40608234
no.  no solution.  I will keep tinkering with it
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

623 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