Web service uses SQL Server based authentication how to change to windows based authentication both web server & Database service resides in different domain .
View 1 RepliesI'm trying to setup a connection to a webservice from VB.NET I'm totally clueless on how to perform this. I receive an overview of what their Soap can do and i also received a securitykey. I'm however not sure how to call this webservice using the securitykey in VB.NET. bit further using the layout of the service underneath.This is the soap layout:
[Code]....
I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "...""[code]
View 7 RepliesThis emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
I did a search first - so if I missed it just let me know. I want to run an application using windows scheduler and use a certain username and password. The application will then call a web service. I need the wed service to run as the username and password used to run the application. Then I need to perfrom a DB connection with the same username and password.
I have looked at impersonation but not getting it all the way.
I need to connect to a sql server as a specific user regardless of who is logged in on the pc where the program is running.
[Code]...
gives me "Login failed for user ACMEinvoicing" which is who I want to log in as. I'd think that the problem is the login except that I can right click SQL Server Management Studio and select Run As/The following user and enter ACMEinvoicing and password and it opens up allows me to connect to report server and shows me connect as ACMEinvoicing and allows me to run everything I need to. From within code how do I connect to the sql server reportserver as someone other than who is logged in?
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
Exception: ASP .NET VB .NET Code connect to sql server using sql authentication sql onnection stringHere is the solution for the problem
View 1 RepliesI am creating a simple program. (soon to be vastly complex) that is connecting to a server, and sending an authentication code to connect. I got the connection part, but what keeps breaking up is the method of authenticating. I have the entire authentication process in a while loop, so that it will keep going until it receives the authentication reply from the server (an OK-002938, or what ever client number the server decides.
This is my client code for the event:
Private Sub CONNECTSERVER_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles CONNECTSERVER.DoWork
Try
If network_client.Connected = False Then
network_client.Client.Connect(My.Settings.service_address.ToString, My.Settings.service_port.ToString)
[Code] .....
The client side is flawless. But the server side, works, but it doesn't continue past storing the bytes into a container...
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 Repliesi am trying to add webreference by right clicking on project in visual studio 2008 it gives me error message below The document at the url [URL] was not recognized as a known document type.how to sort out error above or is there any other method to add webservice
View 5 RepliesSo we've set up a sp_linkedserver on SQL Server to connect to a remote Access database.Assume the path to this database is W:/breakfast/pancakes/secretPancakes/pancakeDB.accdb
We know the username and password to the actual database Password: allY0urPancakeAreBelongToUs!
The problem is, there is also authentication to get into the "secretPancakes" directory.
This authentication is Username: SuperChef Password: ilovesf00d
[Code]...
Also, is this where I would change these credentials to the credentials used to get into that folder right?
I am new to web services in VB.net. I have imported the WSDL into the Visual Studio 2010, but using the .net 2.0 "Web References" framework instead of the new "Service References".I simply need to learn how to pass my API key and one other piece of information through the API to the server. This is all that I have. What code to I need to add to a) Send the API Keyb) Send the Database Mode String
Public Sub Call_Web_Service_Method()
Dim CallWebService As New PersonService.Header()
Dim sPostAPIKEY As String = CallWebService.APIKey()
[code].....
I have started to Build my Server Monitoring/Alarm system and I have built all the components that check network connectivity and internet connectivity etc and alarm if anythingis bad.However I am now struggling to find a way that I can check the following local services are running ok:
[code]
I have an application, I want to connect my database in SOL Server Authentication mode(mixed mode), Hence When I connecting my database through connection string. then what parameter to be passed or what to be checked.
View 1 RepliesJust wondering if anyone knows why does my authentication server fail at comparing strings? Also is there a better method of comparing strings than what im using below? User types in a textbox then sends text to server, server then checks it
[Code]...
I'm looking for a way to get details of the name and status of all services running on a service. I did use the following code:
Public Sub GetServices()
Dim localServices As ServiceController() = ServiceController.GetServices()
For Each service As ServiceController In localServices
If Not String.IsNullOrEmpty(service.DisplayName) Then
dictservice(service.DisplayName) = New Service(service.DisplayName, service.ServiceName, service.Status.ToString)
End If
Next
End Sub
However, since I have packaged up my project as a WCF service, the System.ServiceProcess namespace I used cannot be used: Is there any other way I can retrieve the same details? Possibly through WMI?
We are planning on creating reports to be run on the same computer that the database application is running on. which of these is the best approach? (SQL Server Reporting Services or creating a rdlc ReportViewer report) Also I tried to locate detailed rdlc ReportViewer report tutorials both in books and online and found none. It's probably because I'm looking in the wrong places.
View 1 RepliesI have a situation where I need to create a session in a Windows server using a specific Username and Password.
View 1 RepliesWe recently upgraded our job server to Windows Server 2008. We have jobs we run manually in a folder (c:Custom Programs). Some programs are console programs others are have a gui. This one program has a gui.It also has a progress bar that shows the progress of the job when you click the go button. Of course it spawns a thread to do the processing. This thread creates a log file to write errors and other things too.
The problem is when the program goes to create the log file an access not authorized error is thrown. I checked the permission on the folder. All users are allowed to create/edit/append/execute. Pretty much everything except take ownership. Also, there's nothing that denies anything. So I see no reason why this isn't working. We can get this to work by using the run as administrator option when we first run the program. However, we don't view this as unacceptable solution. My only thought is the spawned thread isn't getting the same permission set as the program. Am I correct or does something think it's something else.
[Code]...
I have a console application created in VS2005, with a web reference created via WSDL.When I run on my local machine (and I have a browser up) I can access the web service fine (if a browser is not up I get the 407 error).I understand this,since my local client machine MUST go through the company proxy (I assume the proxy is resolved when I sign start the browser).When I copy the application to our server, the 407 proxy authentication required error ALWAYS comes up.The thing is, on the server all check boxes in internet options/connections/lan settings are NOT checked. i.e. the server DOES NOT go through a proxy.I installed wireshark to help track down the problem and it shows that when i access the web service wpad is being called and our proxy server is being called.is there a .net configuration that allows me to say "ignore the proxy".I have already tried variations on the system.net section of the app.config file: [code]It seems that no matter what we do (including changing registry settings) this application ALWAYS tries to go through a proxy.
View 1 RepliesI have built an application in VB 2010 on my Windows 7 Pro desktop. I have a particular combo box with a datasource that is dynamically populated, depending on certain values entered by the user; it may or may not have any records in the datasource. When I run/install the application on my desktop, the combo box acts normal, if I click the dropdown button and the datasource contains no records, the combobox will show a single blank beneath the combobox (to indicate no records). When I perform the same action on server 2003, the combobox DOES NOT show a blank row, it does nothing! It act's like it's broken.
View 3 RepliesQuestion: How to pass the current user on the web page from the IIS server to the Reporting Services Server.I have seen this topic throughout the forums. However, the answers are always hard code the user in web.config - use a login window and pass those fields to the IReportServercredentials or create one user for everyone.
When the person who asks the question comes back and says that doesn't work there is not answer.Does anyone know how to do this? I have VS 2008 ( and 2010 ) I am sending the info to SSRS 2005 server.As anyone using SSRS knows that if the reports have parameters and udf behind the report to inspect who the user is, then you have to pass that user to the report.
[Code]...
I have been programming steady with vb.net for a year now and was all happy about using the List view and email etc from web sites. I even used a reportviewer to pdf to email attach, cool. Now I feel quite lost and realize I have not been using properties, etc. That is my background.
i'm doing everything by the book, but the .NET client is simply not sending an authentication header when making requests to my (PHP) SOAP Web Service. I have verified this by logging the raw post data at the PHP end of things and .NET never sends any auth headers.This is the code I am running before making calls on my ExampleWebService Web Service:
ExampleWebService.PreAuthenticate = true;
NetworkCredential myCred = new NetworkCredential("myusername","mypassword");
CredentialCache myCache = new CredentialCache();
[code]....
As I understand it, PreAuthenticate should force the sending of my HTTP Basic Auth Credentials on every request regardless of challenge. Does this only work with IIS hosted services?
I am trying to call this webservice asynchrounously in vb.net. So on the aspx side i added this property async="true". Now on the vb.net code side i have this function inside my webservice that i am calling.So -
dim as as webservice.webstring
as.functionasync(param1, param2)
I am building a client in VB.net for calling webservices methods from a partner organisation.[URL]../system.web.services.protocols.soaphttpclientprotocol%28v=VS.71%29.aspx because I can't get it to work using the Web References feature of Visual Studio 2010 (when I try to do that it turns the methods from the WSDL into classes).I have created a proxy class and can instantiate an object of that class no problem.
However, when I try to call a method which requires arguments I get this error:
Unmarshalling Error: unexpected element (uri:"http://api.service.apimember.emailvision.com/", local:"key"). Expected elements are <{}key>,<{}login>,<{}pwd> Does anyone have any idea why this might be? (If it's helpful I can post my code and the location of the WSDL.) (P.S. I can get the whole thing to work fine in PHP using ZF Soap classes, but for various reasons I need to get it to work using .Net)
Edit to add: I have used Wireshark to examine the outgoing and incoming SOAP message to compare them with the messages being sent via SoapUI, where it all works fine.What this has shown is that my VB client is sending a message where the namespace of the web service I am trying to access is declared as an attribute of the method, and not in the soap:envelope attributes.
[Code]...
I'm getting familiar now with using the Dataset Designer and how it makes for quick and easy updates and query of tables. I use to use the OleDB commands and leave the Connection String as a Global Constant so I can easily change it if the server name changes, or if we have to re-direct the .NET to another instance of the database.
But now that I use the Dataset designer I'm concerned that I maintain flexibility and support in the long run. how the Dataset designer works and where it stores it's connection string info? And how difficult that would be to update. It looks like I modify the App.config file, but I'm unfamiliar with this.
What am I getting myself into? It looks like a standard XML file. Is that it?
I am working on moving applications from Windows 2000 to new server Windows 2003 R2(64 Bit). I noticed that there are some VB programs and config files for those programs have been placed in Windows 2000 Registry. Some other applications are using them from different servers.Why do we use registry here? How can i move these to registry in windows 2003? Can I just move these or do I have to write VB programs to place them in 2003 registry?
View 1 RepliesI have a .net Windows Service developed in VB.net. I have a settings file in the root directory called Connections.XML and I am setting the basedirectory [code]...
When I schedule the service this is working absolutely fine in my Windows XP machine. But when I installed the same service in our development server (Windows 2003 64 bit Server) for some reason it is not able to locate this file.
I am building a Setup project for a Web system using Visual Studio 2008. I upgraded my development machine from Windows Xp to Windows 7. The problem started with Windows 7. Whenever I try to build I get the above error. I ve tried several solutions given online but I ve failed to get a solution. When I transfer the system to a machine running Windows Xp or Windows 2003 Server it builds successfuly.
View 4 Replies