ENDPOINTs In SQL Server 2005 April CTP
May 3, 2005Hi
View 7 Replies
ADVERTISEMENT
SQL Server 2005 Express Edition April CTP
Nov 1, 2005Ferhat writes "TITLE: Microsoft SQL Server 2005 CTP Setup (April)
----------------------------------------
Can't disable the network protocols for server SuperSocketNetLib registry key. The returned error code is -2147024770
How can I fix this?
Thanks everyone! Happy coding"
Cannot Connect To SQL Server 2005 April CTP From Remote Computer
Jun 17, 2005Hi,
View 18 Replies View RelatedDHCP Service Fails To Start After Installing SQL Server 2005 April CTP
Jul 18, 2005I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.
View 20 Replies View RelatedHttp Endpoints For SOAP In SQL Server 2005 - Can The Stored Proc Referenced Do More Than Select?
Feb 17, 2008I am new to web services and as a DBA I only have limited .net experience. Our development team is creating a web services interface for our new IVR phone system, and we've decided on a solution that will send each of the phone call parameters from our database to the phone system in an XML based on line number and extension. I've found that Http Endpoints in sql server will be a perfect solution for exactly that and I won't need any .net to develop it. Thats the good news. There are, however, other requirements for our phone system to communicate back to our database. All of the examples I've seen for endpoints use a stored procedure performing a select statement.
Is it possible to create an endpoint that references a stored procedure performing an insert or update? To be more specific, can I create an endpoint that references a stored procedure that has parameters? If so, how do I pass those parameters through a web service request? Is it as simple as adding &variable="value" to the url?
If so I could develop this entire solution from the database side and not involve our .net programmer!
Another alternative: the phone system does have it own database in sql server. I'm not sure if our phone system provided can or will do this, but if they are willing to work with this, maybe a service broker can fit into this solution.
I look forward to any response. Thanks!
SQL 2005 April CTP Setup WMI Error
Aug 20, 2005
Hello, I am trying to install SQL 2005 April CTP on a laptop running XP SP2. (Using the MSDN DVD Pack - VSTS etc). The pre-requisites get installed but then i get this error message below. The link it points to just says that there is no info available on that topic. Can someone help?
Restore Database April CTP 2005 Failed?
Jul 23, 2005The following failed in EM (or whatever it is called now managementstudio I think) and I scripted it out and ran it in a query window toget more info. This works fine in SQL 2000 but not in 2005. I also triedto 'create' the database first then ran this command below but with the'force restore over existing database' checked on but this failed alsowhich is odd as well. Any ideas. This is my very first play with 2005 soit is not off to a great start although to be fair, i seem to have gorlucky on the install as it all went OK. BTW, is there a more approriatenewsgroup for this query?ThanksRESTORE DATABASE [bob] FROM DISK = N'C:BigFujiCopiesBob.bak' WITHFILE = 1,MOVE N'bob_Data' TO N'c:Program FilesMicrosoft SQLServerMSSQLDataob_Data.MDF',MOVE N'bob_Log' TO N'c:Program FilesMicrosoft SQLServerMSSQLDataob_Log.LDF',NOUNLOAD, STATS = 10GOMsg 5122, Level 16, State 1, Line 1Directory lookup for the file "c:Program FilesMicrosoft SQLServerMSSQLDataob_Data.MDF"failed with the operating system error 3(error not found).Msg 3156, Level 16, State 3, Line 1File 'bob_Data' cannot be restored to 'c:Program FilesMicrosoft SQLServerMSSQLDataob_Data.MDF'.Use WITH MOVE to identify a valid location for the file.Msg 5122, Level 16, State 1, Line 1Directory lookup for the file "c:Program FilesMicrosoft SQLServerMSSQLDataob_Log.LDF" failed with the operating system error3(error not found).Msg 3156, Level 16, State 3, Line 1File 'bob_Log' cannot be restored to 'c:Program FilesMicrosoft SQLServerMSSQLDataob_Log.LDF'. Use WITH MOVE to identify a validlocation for the file.Msg 3119, Level 16, State 1, Line 1Problems were identified while planning for the RESTORE statement.Previous messages provide details.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.*** Sent via Developersdex http://www.developersdex.com ***
View 2 Replies View RelatedTyped Endpoints In SQL 2005?
May 18, 2007Is it possible to return typed data in an Endpoint for an ASP.Net Web Reference to Proxy? If so, is there any specific terminology I should be aware of to target my search?
I realize there is a choice between Object (returns a dataset or error) or dataset, but the automatically generated WebReference Proxy in ASP.Net (2.0) is untyped and we can't change the typing there as you have to remove the entire WebReference to pick up new WebMethods (or changes to signitures I'd assume).
I'm able to create my own typed proxy as a psuedo-DAL assembly which takes the WebReference and cast rows/objects into typed rows/objects one at a time, but this seems like a lot of work and probobly not the best practice.
Any help would be greatly appreciated
Cannot Start SQL Server Database Services - SQL Server Express April CTP
May 22, 2005I am new to SQL Server. I tried to read as much as possible in newsgroups prior to this post. I have tried several different ways to install this without success. The last time I attempted to install as a local service and I unchecked hide advance configuration. I am running Windows XP SP2 with all the latest updates. Is there a solution to install this properly? Any help would be greatly appreciated!
View 13 Replies View RelatedI Can Not Install MSQL Server 20005 TCP Express April Edition
Aug 10, 2005hello all during the instaletion i get an error message that SQL server can not start the service, after that the programm rolls instalation back.do someone knows what's going on?i use win xp pro.thank u for ur help.
View 2 Replies View RelatedAre Calls To SQL Server EndPoints Automatically Enlisted In A Transaction?
Mar 8, 2008All -
I have a SQL Server 2005 HTTP endpoint. I create a transaction scope in a client application and call two methods on that endpoint. Will the operations performed in the two methods, really, be in a transaction?
In other words, will SQL Server enlist in the ambient transaction even when I am accessing it through a HTTP endpoint?
Thanks.
How To Completly Stop Mirroring, Eg Disable The Endpoints On The Server
Aug 23, 2006We have tested mirroring with success.
Now we want to completly disable mirroring, and have done this on all mirrored database.
It seems though that the server stille maintains the mirror endpoints, hence you can do a "telnet localhost 5022".
How can we disable the mirroring endpoints ?
Martin Tan
SQL DBA
SQL Server Admin 2014 :: How To Delete A Login Linked With Endpoints
Sep 1, 2015I am planning to delete a login from SQL logins because he moved out from project .when i try to delete the login , it throws an error saying " The server principal owns an endpoint and cannot be dropped , error 15141 "
Same problem facing on different servers.
Note : Environment is SQL 2012,SQL 2008 including cluster servers .
SQL April CTP And SQL 2000
Apr 20, 2005Can SQL April CTP and SQL 2000 coexist on the same machine without any problems?
View 9 Replies View RelatedUsing TransactionOption In April CTP
Jul 21, 2005Hello.
View 9 Replies View RelatedApril CTP Installation Failed
May 17, 2005I've already installed VSTS 2005 Beta2 and I try to install workstation components of April CTP. What should I try to pass th error?
View 6 Replies View RelatedAbout Endpoints
Mar 2, 2007When I constructed my endpoint:
CREATE ENDPOINT MyNewEndPoint
STATE = STARTED
AS HTTP
(
PATH = '/MyEndpoint',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'arkansas'
)
FOR SOAP
(
WEBMETHOD 'GetSession'
(NAME='MyDB.dbo.spGetSession'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'MyDB',
NAMESPACE = 'http://MyDB/MyEndpoint'
)
the site is hardcoded. But, when I'm getting ready to deploy I'll need the site to be my production site. Is there an easier way to accomplish this then to edit the script each time before delpoyment?
TIA,
Dave C.
Installion Problem With SQL Express April CTP
Sep 24, 2005When intalling SQL Server 2005 Express this gives me the message:
SQL Server Setup could not connect to the database service for
server configuration. The error was: {Microsoft}{ODBC Driver Manager}
Data source name not found and no default driver specified Refer to
server error logs and setup logs for more information. For details on
how to view setup logs, see "How to View Setup Log Files" in SQL Server
Books Online. Error No:29545
which I don't get since I have SQL Server 2000 Dev Edtion running,
Win 2K sp4. I couldn't find anything in the MS KB to explain why it's
doing so.. anything I missed perhaps?
Accessing The Current Transaction In BOL (April 05')
Jul 23, 2006Here is the text I do not believe is correct or at the least misleading...
"If you want to terminate the external transaction from within your stored procedure or function. In this case, you call the Transaction.Current.Rollback method. "
You cannot terminate transactions declared in TSQL in SQLCLR routines.
HTTP Endpoints
Jun 9, 2006Are HTTP Endpoints able to be reached by another application that does not run on the same network?
For example, we have a partner that has a Web Application that would like to retrieve data from our database. We would like them to call a SOAP method through the Endpoint and in essence let their Web Application consume the Web Service. Is this possible?
Endpoints And Authentication
Mar 5, 2007I tried asking a similar question over at the asp.net, but I'm not getting any replies.
I created an endpoint in SS 2005 using DIGEST authentication, and I was successful in adding the web service to my project and getting results from a call to it.
However, the production environment does not exist in a domain environment, which eliminates even DIGEST (which requires a valid windows domain logon).
But, when I create the endpoint using BASIC authentication, I can no longer "find" the service. SS says the command(s) completed successfully after the Create Endpoint command. As a test, the documentation says that you can enter the http site into IE and the WSDL will display. And that works in digest mode. However, I've tried both:
http://<server>/path?WSDL and
https://<server>/path?WSDL
And neither returns the WSDL in IE (nor can it be added to my project as a web service).
I'm hoping someone has some ideas on how I can resolve this problem.
TIA,
Dave
How Are Endpoints Encrypted?
Dec 13, 2007Hi All,
I have mirroring set up in a test environment and it works great however I need to know/understand how the endpoints are encrypted. I have them set to use the AES algorithm; however I can not tell from BOL what keys they are using. I know the service master key is the root encryption key and endpoints sit at the server level (same level as service masterkey) but I am not sure if the endpoints use it to perform the encryption or not; do they and if not what do they use?
Thanks in advance,
Coleman
How To Use Http Endpoints?
Mar 18, 2008hi,
I am new to sql so i created this http endpoint int sql 2005.
now how to use it?
for example i create stored procedure and i can use it by "execute procedurename"
how it works on endpoint side?
UnmappedSoapMethod Using SQL Endpoints
Jul 3, 2007Hi,
I am trying to use a SQL Endpoint in my SQL 2005 DB to retrieve information from my C#.Net program. It works fine for me when I run it, but I am set as an administrator in SQL Server. When I try to run it as a normal/test user, I get the error message: "There was an error in the incoming SOAP request packet: Client, Endpoint, UnmappedSoapMethod."
Now, I have set up the endpoint in SQL and I can see the method I am trying to call when I do a select on the sys.endpoint_webmethods table. I have also allowed the domain group which the test user is a member of execute permission to the stored procedures and Access permissions to the endpoint.
What have I missed in the set up for me to be receiving this error message?
Cheers and thanks in advance.
Sam.
Database Mirroring Webcast On Friday April 28.
Apr 27, 2006Attendee Registration URL: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032290575&Culture=en-US
I'll be talking about database mirroring starting @ 9:30 AM Pacific Daylight Time.
Thanks,
Mark
Service EndPoints Not Accessible
Dec 20, 2006I am trying to expose a stored procedure on SQL Server 2005 as a web service. So I just have an end point created with the procedure as my web method. Now when I try to reference this web service in my C# windows application, I am only able to see the procedure definition by requesting for the WSDL http://servername/path?wsdl. But when I try to reference it, I get the error 501/505 - Not Implemented or not supported. Any ideas what the issue here could be? Would really appreciate the help here as I am kinda stuck! - Thanks, Manmeet
View 2 Replies View RelatedHTTP Endpoints On Vista
Mar 20, 2007Hi,
I'm looking into hosting SQL Server endpoints on Vista. Unfortunately they don't work nicely because, as far as I know, they require http.sys which is part of Windows Server 2003. Hence, I can create my endpoint but i can't browse to it over http.
So, siple question (not so simple answer) how can I access SQL Server endpoints on Vista?
Thanks
Jamie
How Do You Set Up And Use Endpoints? Examples Required
Jun 20, 2007i have posted here a few times on my endpoint issues but i cant find a resolution so im approaching the issue from a different angle. can you guys tell me how you create and consume endpoints, preferably with the endpoint code, the url you use to see the wsdl, and any network/pc settings you may have altered to get endpoints to work. im looking for tips or steps that may not be included in basic endpoint tutorials. I really am stuck and have no idea what else to try. thanks all
View 3 Replies View RelatedHTTP Endpoints How To Performance Measure?
Mar 11, 2008I have application who like to use HTTP Endpoints in our cosolidate enviornment. How I can measure the performance on HTTP Endpoints? I would like to know how much CPU, Memory and IO used by HTTP Endpoints?
Any suggestion? Thanks in advance.
Tracing HTTP/SOAP Endpoints
Mar 23, 2008Has anyone worked out how to trace SOAP/HTTP Endpoints in SQL 2005 SP 2?
I'm not having a particular problem, just want to know how things work, such as which layer is responsible for the HTTP Authentication. I've traced the HTTP.sys stack using logman.exe (see http://www.thelastpickle.com/2008/03/22/tracing-sql-soap-endpoints-through-httpsys/) .
I cannot see any SQL Profiler events, and I've tried setting trace 7801 and 7803 as described in http://www.sqljunkies.com/Article/5CCAC423-1407-4A36-AF71-ED6A67D9646A.scuk#_Toc52964195 but they do not result in any logging.
thanks
Aaron
Closed Conversation Endpoints Not Being Purged
Sep 25, 2006We have been having a problem with service broker for quite a while now and searching on these forums and more generally on the web has not yielded any kind of answer...
Our application utilises service broker within a single database (there is no cross database, cross instance or cross server communication). There are approximately 12 queues which are used to varying degrees. A few of the queues have a throughput rate in the order of up to 100s per minute at peak periods.
In some scenarios we are able to make use of persistent conversations but the majority of messages are sent on their own conversation or in small batches on their own conversation.
Some time ago we found that the database was growing in size more than expected due to a build up of data in the service broker meta data internal tables, exposed via the sys.conversation_endpoints system view.
We identified a problem in the application that was preventing some conversations from being closed and have now fixed this.
However, we are still experiencing a build up in the service broker tables and sys.conversation_endpoints shows this is now due to a very large number of conversations in the "CLOSED" state.
I know that conversations are kept around to prevent replay attacks but thought they were supposed to be cleared after about 30 minutes. This is certainly not happening as we currently have conversations that were opened on the 18th September, a full week ago. We currently have about 350,000 closed conversations and this figure is increasing!
We have tried restarting the SQL Server instance with no effect.
I have been using a script to loop through all closed conversations and get rid of them using the "WITH CLEANUP" clause but I'm loath to create a scheduled task that does this in the background when service broker should be doing the job itself.
Has anybody experience this problem and, even better, have any idea how to solve it?
Daniel
Closed Conversations Are Not Purged From The Receiver Endpoints Table
Nov 30, 2007
Hi,
I implemented the pattern suggested in the 'Recycling Conversations' article that Remus Resanu presented. Everything works great except ended conversations on the receiver remain in the sys.conversation_endpoints table forever in the 'CLOSED' state.
Is there some setting I am missing to have those conversations purged from the endpoints table. I am concerned that in the production environment this table will grow very large.
Thanks
How To Call Via CLR One Dll Which Calls Two Webservices (endpoints) With Dynamic Parameter
May 23, 2007I developed one DLL in vb .Net which call two web services (sql endpoints) I wish to use this solution but for hundreds of servers (endpoints) I want to ask if I could do that with dynamic parameters passed to de DLL CALL in sql server clr.
Actually when I compile de DLL I need to have referenced (hardcoded) the webservices (endpoints) and when I need a brand new endpoint I need to reference it, compile the dll and release.
I cannot find how to invoke the service within the DLL with the namespace or webservice name as parameter.
Mi code to invoke now my referenced end point is: (note that my endpoint name is rperez)
Dim CallWebService As New rperez.IntelisisServiceEndPoint
CallWebService.Credentials = System.Net.CredentialCache.DefaultCredentials
Call CallWebService.IntelisisService(ArchivoOriginal)
My class rperez.IntelisisServiceEndPoint is referenced (hardcoded) in the dll project I need it dynamic
Do I need to change my code to PROXY object ?