Enabling Service Broker In SQL Server 2008?
May 3, 2010
I am integrating SqlCacheDependency to use in my LinqToSQL datacontext.I am using an extension class for Linq querys found here - http://code.msdn.microsoft.com/linqtosqlcacheI have wired up the code and when I open the page I get this exception - "The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications."its coming from this event in the global.asax
protected void Application_Start()
{
RegisterRoutes(RouteTable.Routes);
//In Application Start Event
System.Data.SqlClient.SqlDependency.Start(new dataContextDataContext().Connection.ConnectionString);
}
my question is...how do i enable Service Broker in my SQL server 2008 database? I have tried to run this query.. ALTER DATABASE tablename SET ENABLE_BROKER but it never ends and runs for ever, I have to manually stop it.once I have this set in SQL server 2008, will it filter down to my DataContext, or do I need to configure something there too ?
View 2 Replies
Similar Messages:
Nov 8, 2010
I can't figure this out. I have a simple ASP.NET application that I am hosting on my computer which all local computers can hit. The next thing I want to do is setup the website for public access. No matter what I can't seem to get it to work.
- I have allowed incoming connections to port 80 through the firewall.
- I have setup my router to port forward all HTTP requests (80) to my locally assigned IP (192.168.1.XXX).
- I have setup my server to use anonymous authentication, which is set to "Application pool identity".
- I have even shut off my firewall to try and see if it would work.
Can't figure this out. Read a bunch of information, and in my head this should work, but it seems like I am missing something simple. I realize this thread's subject matter applies to IIS7 more-so than ASP.NET, however since I am relatively new to ASP I figured maybe I missed an ASP setting or something.
View 7 Replies
Jan 5, 2011
We have a web application that makes a call to a remotely hosted ASMX service that worked in Server 2003 under IIS6. We are now migrating it to a Server 2008/IIS 7 setup and it doesn't appear that the application makes the call to the remote web service anymore. We ran Wireshark and don't see any traffic to the service URL. It seems to throw a 404 error without trying to connect.
Is there some security policy or restriction in Server 2008 or IIS 7 we need to set to allow an ASP.NET application make a call to a remote web service? We are using Network Service as our application pool user, but also tried using Local System as a troubleshooting step. In addition, the same code works if run from a console application on the server instead of the web application.
Is there some setting under IIS7 or server 2008 that would be causing this?
View 3 Replies
Dec 1, 2010
I am trying to retrieve some values from a Database built in SQL Server Express 2008 using .net Web Service.
[Code]...
Whenever i click run in Visual Studio 2008, it shows the startup page in IE that has two Methods (HelloWorld and authorizePassenger). When i click my method authorizePassenger it gets invoked and it asks me for input but when i input and click invoke IE shows HTTP500 error. The code above working fine in Standalone VB.net Application, so i guess i m doing the coding of Database correctly.
View 6 Replies
Apr 5, 2010
I have an application where I want to send an email reminder for an appointment 24 hours prior to the event. Users would log in and insert appointments. I would think I would want a background thread running on the server that would regularly check the database (say every hour) and generate an email if there is an event is due within the next day. From what I have read it seems like a Web service might do this. I guess I have a few questions
1) am I on the right track - is this an application for web services
2) can anyone point me to a good resource which can help me create the web service I would need. I would prefer if it is in VB and not C#.
View 11 Replies
Sep 14, 2010
We have an issue with a .NET 2.0 web service application that is generating a module not found exception when we try to load on server 2008. A second server running the same 2008 version loads the service fine.As part of the investigation we have taken the default hello world .NET 2.0 web service and deployed to both servers and have exactly the same issue with it running fine on one but not the other. The issue is trying to track down the module in question. Running process explorer and dependency walker doesn't seem to give us a clue.
The full error is:-
[code].....
View 1 Replies
Dec 9, 2010
I create web service for Reading and writing the registry. It works fine in win-xp. But its not working when I published it in win-2008 server. It shows me http 500 error.
My Code is:
set Reg:
string key = @"SOFTWAREWow6432NodeMyCompanyMyProjectSettings";
string valuename = "Allow";
setRegistryValue(key, valuename, Value);
Get Reg:
string key = @"SOFTWAREWow6432NodeMyCompanyMyProjectSettings";
string valuename = "Allow";
return Convert.ToInt32(getRegistryValue(key, valuename));
View 2 Replies
May 4, 2010
In our project we need to restore the analysis service database back up(.abf) files.Now i can connect to analysis service and can create new database.May i know how i can restore the abf file .i saw i can do this by using sql server SMO dll .check the below link
[URl]
how to get the samples are located in <system_drive>:Program FilesMicrosoft SQL Server100Samples folder,if you alrady installed the documentation
View 1 Replies
Jul 14, 2010
I am trying to access a wcf service hosted on a server running on a virtual machine on a windows 2008 R2 hyperv. When i access this service when running my asp.net website through code everything works fine how ever when i deploy the application on the local IIS , in the deployed mode i am getting an securityaccessdeined exception. My Asp.net app is running on a IIS server on another virtual machine. The stack trace is as given below :
Environment Info: My asp.net app has built on .NET 4.0 framework using VS2010. My WCF services are based on .NET2.0 framework.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 14-07-2010 13:56:54
Event time (UTC): 14-07-2010 08:26:54
Event ID: dd1986e7e7dc4473beb908754c75a580
Event sequence: 4
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/StratosTest-1-129235696025728041
Trust level: Full
Application Virtual Path: /StratosTest
Application Path: C:inetpubwwwrootStratosTest
Machine name: MC-NEWCODE
Process information:
Process ID: 1752
Process name: w3wp.exe
Account name: IIS APPPOOLASP.NET v4.0 Classic
Exception information:
Exception type: SecurityAccessDeniedException
Exception message: Access is denied.
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()
at Default2.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Request information:
Request URL: http://localhost/StratosTest/Dashboard.aspx
Request path: /StratosTest/Dashboard.aspx
User host address: ::1
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOLASP.NET v4.0 Classic
Thread information:
Thread ID: 4
Thread account name: IIS APPPOOLASP.NET v4.0 Classic
Is impersonating: False
Stack trace: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()
at Default2.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
View 1 Replies
Mar 30, 2011
I am toying with the idea of enabling CLR on my SQL server, using EXEC sp_configure 'clr enabled', 1
However, I am sharing my database server with several other developers and their projects. I've heard vaguely that their might be security issues with enabling this.
Does anyone know what these issues might be? Is CLR safe to use on SQL Server?
View 1 Replies
Apr 15, 2010
Would something be missing, not working, or confusing if I do this? First, install SQL Server 2008 Standard, and SP1. Then, install Visual Studio 2010 Professional, unchecking SQL Server 2008 Express option. Or would I need to fix any configurations afterwards?
View 1 Replies
Jun 29, 2010
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 Replies
Feb 24, 2011
That is what I have to do: Send XML to a web service. I have preliminary requirements of what I have to generate in the XML. So, I just create this big, long XML stream and send it to the service? I would like to read a little bit about this to educate myself. Do you have a good link, or can you voice your opinion of this one,Additionally, I am coding in VB.NET so I will have to convert that code if it is a good example.
View 15 Replies
Jan 31, 2011
I have a webservice.
I would like to get the log on user id.
I am using the following code.
During runtime, it gives error saying "Request is not available in this context".
HttpApplication context = new HttpApplication();
string username = context.Request.ServerVariables["LOGON_USER"];
How do I get LOGON_USER in a webservice.
View 1 Replies
Nov 12, 2011
I've got a web app running with purely web services like these:
Code:
<WebMethod()> _
<ScriptMethod(ResponseFormat:=ResponseFormat.Json, UseHttpGet:=False)> _
Public Function EditService(ByVal toddtype As String _
, ByVal fromddtype As String _
[Code] ....
And I want to log each web service call. I don't want to bother my database with this log - I would prefer to have the web app log to a text file on the web server itself.
How would I open and access a log file like this from a bunch of web services? Does web app still have application startup like events???
View 1 Replies
Mar 28, 2010
I have looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it.was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go.
Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking!
View 4 Replies
Jun 7, 2010
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.
View 8 Replies
Oct 11, 2010
I am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
View 2 Replies
Jun 24, 2010
I have a web service that runs a query (from C#) to get a dataset from sql server. I get the following time out error. Googling on this error says, you can set the timeout on command object. But I am not using command object to set the timeout. This is the code I am using to get the dataset.
code:
[code]....
View 8 Replies
May 19, 2010
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 Replies
Aug 10, 2010
I want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 Replies
Mar 18, 2010
we can not add .mdf file to the project in vs2008 and sql server2008 when i am adding .mdf file its displaying an error message so it is not possible to add
View 2 Replies
Apr 29, 2010
When i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
View 2 Replies
Jan 6, 2011
I have two web services on two different servers communicating
WS1.asmx
Code:
<%@ WebService Language="VB" Class="WS1" %>
Imports System
Imports System.Web
Imports System.Web.Services
Imports System.Xml.Serialization
Imports System.Net
Imports System.IO
' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
' <System.Web.Script.Services.ScriptService()> _
<WebService(Namespace:="[URL]_
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
Public Class WS1
Inherits System.Web.Services.WebService
Dim IP as String = "192.168.0.174"
<WebMethod()> _
Public Function Function1(ByVal s1 As String) As String
Dim ReturnString As String = ""
Try.........................
View 11 Replies
Jan 16, 2010
I am having some trouble with my web service. I want to make a variable that will be the same for each thread running. To be specific, my program is that user 1 goes on my page and types something into the textbox and that user 2 can see what user 1 is typing into the box. its sorta like google wave. The problem is that when i run it, the variable's value does not go to user 2 and instead another instance of that variable is created.
View 18 Replies