Port Conflict And IPv6-Adress Resolution Errors When Creating Endpoint
Aug 24, 2006
Hello,
executing the first script listed below resulted in the error message (translation):
Message 7890, Level 16, Status 1, Line 1
Error when registrating Endpoint. Potential port conflict ...
use AdventureWorks;
go
CREATE ENDPOINT SQLEP_AWPersons
STATE = STARTED
AS HTTP
(
PATH = '/AWpersons',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'PersonInfo'
(NAME='AdventureWorks.dbo.uspGetPersonInfo'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'AdventureWorks',
NAMESPACE = 'http://Adventure-Works/Persons'
)
I changed the port in the script to 8084:
PORTS = (8084),
Error Message 102: Wrong Syntac near ')'.
I changed the port in the script to '8084':
Error Message 7888: The stated IPv6-Address is not supported. The server is potentially not configured for the IPv6 Connectivity or the address is not formated in an known IPv6-Format.
I'm running into problems with my replication where I get the following error: Violation of PRIMARY KEY constraint
I know what the error means, and I know what is causing it. In my case, a property is being added to an inventory item independently at the publisher and subscriber end. Each available property has a particular ID, each inventory item has its own unique ID, and of course the properties per inventory item are stored in a linking table. I am using UUIDs for the inventory items, to avoid collisions in that aspect, but the list of properties is fixed (currently only 15 - 20 available properties), so it doesn't make sense to me to have managed ranges, UUIDs, or other such things for the properties. Of course, I could apply a "source ID" to each added property to avoid these collisions, but I'd prefer not having to redesign the database, not to mention deal with the extraneous copies of properties.
My preference would be to simply have the server delete the copy on the server and take the subscriber row. I would have thought that using the "subscriber always wins" conflict resolver would have this effect, but it doesn't work for me. Is there a straightforward way of dealing with this problem? Am I missing something obvious? I've looked into a custom conflict resolver, but that seems like overkill for what must be a fairly common scenario.
For the record, the publisher in my case is SQL Server 2005, and the subscribers are SQL Server Mobile clients.
I have a couple of tables set up with column level tracking and using the "Subscriber Always Wins" conflict resolver.
I am still trying to work out why there is a conflict as the only updates to these rows happen at the subscriber.
What I am finding is that a conflict occurs and there appears to be a delay between the conflict being recognised and then resolved.
The reason I know there is a delay is because this is playing havoc with a data extract that relies on the updates from the subscriber.
For instance, I have a job on which the status is changed. That status change triggers an extract via BizTalk to another system. BizTalk, via an SQL adapter extracts the data from the server and I find that some of it is missing in the extract.
I go and look into the database at the raw data and find that the data is in fact there.
I have certain triggers running which set up export flags in the database to say this data should be exported. This works perfectly when there are no conflicts.
In each case where data has not been extracted, a conflict occurs.
Is there any way to guarantee that the conflict will be resolved at the same time as the synchronisation is complete - i.e. within the same transaction?
I thought replication was supposed to be a single transaction - you get it all or you get nothing.
I'm interested to hear from anyone who has experienced this behaviour.
I am doing a work were i have to syncronize data between a Publiser (PC, SQL SERVER 2005), and a subscriber (Pocket PC, SQL CE MOBILE). I studied lots of articles and i managed to put the syncronization to work, the problem is in conflict resolution!
The subscriber can´t insert or delet, only update!!
For exmple: I have a table that contais the quantity of a product X, for example 100 units, this goes to Pocket, but later arrive move 100 units that are increased in the PC, so we get 200 in the PC, (but 100 in Pocket), no problem if i syncronize now (Pocket will have 200 too), but if remove in Pocket for example 50 units, i've changed the same column in both Publisher and Subscriber database, if i syncronize now, i'll have a conflict, the final result should be 150 of product X in both databases (100 + 100 - 50), but the Publisher wins the conflict and the final result is 200!
I never worked with stored procedures and in microsoft theres and article called How to: Implement a Stored Procedure-Based Custom Conflict Resolver for a Merge Article (Replication Transact-SQL Programming), but they dont explain it very well and i dont know how to do my own stored procedure and implement it to the merge article.
in my own stored procedure i'll have to do some calculations to get the result i want, maybe using some table for the additions and subtractions. (Does the com based Addition resolver do this for me???)
Maybe you have experienced some problem like this, and could help me!
How should i do the stored procedure?
Oh, i tried to use de addiction resolver and the average resolver of com based but nothing happed, dont know why, i read some stuff and i think the addition could solve my problem, but it doesn´t work, i read above what you said and installed service pack 1 for sql 2005, but i instaled and nothing happened! When i change to the resolver that the subscriver wins, it works, why addition dont work?
I'm having some problems getting Interactive Conflict Resolution working under SQL Server 2000 SP4. I have set "Allow Subscribers to resolve conflicts interactively" under the Resolver tab for the article in the publication. I have set "Enable synchronization using Windows Synchronization Manager" and "Resolve conflicts interactively" under the Synchronization tab for the subscription. I have set "Resolve conflicts interactively" under the Other tab for the subscription properties in the Windows Synchronization Manager. However, when I generate conflicting data in the publishing and subscribed DBs and synchronize using the manager, the resolution is automatic and a warning pops up informing me that "conflicts occurred while syncronizing the data and were resolved according to defined rules." Am I missing anything here?
we have Reporting services and Office Sharepoint on the same server, but the reporting services website is on default website and won't start because MOSS is already using the port. can i just change SSRS website port ?
in merge replication using sql server 2005 and sql server compact, what happens when rows or columns cannot be inserted/updated/deleted because of some error other than a conflict? Are they handled differently tan change conflicts?
I have an Access front end to a MS SQL database. I use ODBC to connect the two and have linked the tables into access correctly.
I am having a problem with Write Conflicts. Access is showing an error box every time I try to change records that have links to them from other tables. I am not trying to change keys or any index fields. If I go to the SQL Enterprise manager I can change the records every time with no problems.
Anyone out there got any idea as to what is happening? I have been trying to solve this for over a month now and am completely stuck.
I try to implement mirroring using certificate authentication. When I do this query :
create certificate Principal_cert with subject = 'Principal certificate', start_date = '2007/11/01', expiry_date = '2020/11/01'; GO
Create endpoint endpoint_Princ state = started
as tcp(listener_port = 7024, listener_ip = all)
for database_mirroring (authentication=certificate Principal_cert, encryption = disabled, role = all);
GO
I have this error :
Msg 1088, Level 15, State 1, Line 1
Cannot find the object "Principal_cert" because it does not exist or you do not have permissions.
I have also noticed that the error does not occured when I try this in the master database.
So, I have two questions:
1. Why SQL server does not find a certificate that just been created ? 2. Should the certificate be in the master database or in the database being mirrored ?
Hi there, I am just trying to create an ENDPOINT to define a Web Service in Sql server 2005. Here is my code Create ENDPOINT AWService STATE = STARTED As HTTP ( PATH = '/ADVENTUREWORKS', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = 'DEVISQLDM2005' ) FOR SOAP ( WEBMETHOD 'GetProductList' (NAME = 'AdventureWorks.Dbo.GetProductList'), DATABASE = 'AdventureWorks', WSDL = DEFAULT ) and when i run this T-SQL its complaining about Msg 7807, Level 16, State 1, Line 1 An error ('0x80070057') occurred while attempting to register the endpoint 'AWService'. I am trying this code to run on Windows XP pro and Sql Server 2005. Any clue why its complaining about this ? Thanks -D
I see that MS has a conflict viewer that can be accessed by managment studio, however I would like to create one with some customized options. Is there a sample of code somewhere to start this? I could really find anything in BOL. Thanks in advance.
I can't map other sql servers without creating alias with proper port number on client network utility. Other users using same version of the client tools, MMC, SQL DMF etc. I need to map 70 sql servers on using my client tools. Any help is appreciated.
We have encountered a problem connecting from our client code to SQL Server 2005 using raw Ipv6 addresses. A small client application on Windows Server 2008 using SQL OLE DB interfaces WILL connect successfully to the raw Ipv6 address of the SQL 2005 Server (also on Windows Server 2008) but the same client will fail to connect if run from a Windows XP or Windows 2003 Server box.
I have seen another post to this forum entitled "IPv6 support for SQL Server ODBC Driver" which would seem to indicate that SQL Native Driver (SQLNCLI) should support IPv6 on 2k3 and XP but that was in the context of a ODBC driver and Vista.
Can we have confirmation from Microsoft that:
SQL OLE DB does NOT support IPv6 on 2k3 and XP? SQL OLE DB DOES support IPv6 on Vista and Longhorn? SQL Native Client DOES support IPv6 on 2k3 and XP and Vista and Longhorn?
I am unable to create the DSN using SQL Server ODBC driver(2000.86.1830.00)by specifying the server name as IPV6 Address. Here are the steps that I have used to create the DSN. 1. Opened the ODBC Data Source Administrator(Start->Control Panel->Administrative tools->Data Sources(ODBC)). 2. GoTo System DSN tab and clicked on ADD buton, selected the SQL Server driver from the list of ODBC Drivers. 3. Entered the Name and Description. 4. Provided the IPv6 Address of machine in the Server Field. click Next. 5. Entered the SQL Server authentication details. Clicked Next. 6. The wizard poped up following error: " Connection Failed: SQLstate:'01000' SQL Server Error:14 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection open(parseconnectionParams()) Connection Failed: SQLstate:'08001' SQL Server Error:14 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection."
By specifying the IPv6 address as server name I was able to create the DSN in Windows Vista but failed in other operating systems like 2k3 and XP. Could anyone of you please let me know the reason behind the failure of DSN creation? Does the SQL Server ODBC Driver supports IPv6?
I have VB2008 express edition and SQL server 2005. When i try to create a new local datasource in my project, the datasource seems to be created just fine however an error message comes up. If i try to create the datasource by selecting it on the 'add new item' menu, an error message says
"The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed Dataset associated with the project will not be created."
If I try to create the datasource by selecting 'add new datasource' from the datasources pane, i can create the connection to a new or existing database but when i click next to proceed to the page defining the dataset, an error message says
"An error occured while converting this connection: Data provided identified by guid ' 7c602b5b-accb-4acd-9dc0-ca66388c1533 ' could not be loaded"
I'm trying to migrate a MSDE based application into a SQL2005 Express SP2 DB Engine on Windows Vista Business but I'm facing several errors that are blocking me. Since the installation of SQL2005 Expr. must be done in a silent mode (the end user shouldn't set anything), I'm installing it using this syntax:
The installation proceeds without problems but when my program tries to create the database, a message error appears:
CREATE DATABASE denied on database 'master' (I translated directly from italian). What I would like is to install SQL 2005 with "Windows Authentication" access instead of "SQL Authentication".
If I install SQL2005 manually by setting a named instance (CSERV), Windows Authentication mode, activating the option "set the local account as SQL administrative account" (translated from italian and suggested with Vista) I get the following error (read from the LOG):
CREATE FILE encountered operating system error 5 (access denied) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerCSERVDataCGIDBDat.mdf'
CSERVData is the folder that the application creates and where the "mdf" and "ldf" files are stored.
So in the first case it seems that SQL2005 don't recognize the local account as administrator even if the user has administrative privileges (at least for Vista), in the second case is Vista that is blocking the action.
When I want to create a dimension i always end showing up errors below:
COPY <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> Â <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100"
[Code] ...
Errors and Warnings from Response    Internal error: The operation terminated unsuccessfully.    The following system error occurred:    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DB LAB2', Name of 'DB LAB2'.
In 7.0, an application development change has been made to defer name checking in stored procedures until exection time. This allows a clean store of the proc in the system catalog regardless of objects existing or not. At execution time, the proc is compiled, and object resolution is done. Problem - the procedure fails if object names, column names, etc are wrong or don't exist. So, during nightly cycle's the procedures bomb out.
Is there anyway to disable this 'deferred name resolution', or am I at the mercy of the developers? Can I make the resolution immediate?
Friends I have one SQL server2000 which have Mixed Mode authentication.It is working fine in PC which server instance is situating.But I have another PC which having connectvity tools of SQL Server.When I am trying to access SQL Server from the second PC through SQL authentication access getting denied.In the same time if I am accessing any of first PC's Folder using it's administrator password.Then if try with SQL authentication I am able to connect with SQL Server in the First PC from second PC .Please note SQL server instance is not in windows authentication mode .What may be the problem.Please suggest me a resolution
I am in the process of moving from a 32-bit SQL Server 2005 Enterprise (9.0.3054) to a 64-bit SQL Server 2005 Enterprise (9.0.3054 with 4 CPUs and 8GB of memory on Win 2003 SP2) and the process has been very frustrating to say the least. I am having a problem with packages that I created on my 64-bit SQL Server. I am importing a few tables from the 32-SQL Server into the 64-bit SQL Server using the Task --> Import to create the package.
Sometimes when I am creating a package I get the following error in a message box:
SQL Server Import and Export Wizard
The SSIS Runtime object could not be created. Verify that DTS.dll is available and registered. The wizard cannot continue and it will terminate.
Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (System.Windows.Forms)
Other times when I run a package that has run successfully before I get the following error:
Faulting application dtexecui.exe, version 9.0.3042.0, stamp 45cd726d, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x025d23f0.
The package appears to hang when running. By this I mean that the Package Execution Progress shows progress up to a point then it just stops. (The package takes about 17 seconds to run normally) CPU usage is at 1% and the package cannot be stopped.
I have deleted and re-created the package several times and I have also re-installed the service pack on the SQL Server (9.0.3054) but that did not help.
I am trying to add data to 2 columns CaseResolvDatetime and CaseResolvGroupName based on the criteria: 1. for a CallID, the last datetime where Resolution='Resolved' 2. where there is no 'Resolved', the 2nd last datetime & groupname for a particular CallID
INSERT @table(CallID, ResolvDatetime, GroupName, Resolution, CaseResolvDatetime, CaseResolvGroupName) SELECT '00458176','08/1/2005 1:41:54 PM','Field Sup CoOrd','Resolved',Null,Null UNION ALL SELECT '00458176','08/9/2005 3:35:24 PM','Service Desk','Reassigned',Null,Null UNION ALL SELECT '00458176','08/12/2005 9:54:37 AM','BSSAppSvcs-Club','Reassigned',Null,Null UNION ALL SELECT '00458176','08/16/2005 10:32:40 AM','CDR SysOps','Reassigned',Null,Null UNION ALL SELECT '00458176','08/24/2005 11:18:30 AM','CDR Server','Reassigned',Null,Null UNION ALL SELECT '00458176','08/24/2005 2:13:15 PM','Field Sup CoOrd','Reassigned',Null,Null UNION ALL SELECT '00458176','08/24/2005 4:01:24 PM','CDR Server','Resolved',Null,Null UNION ALL SELECT '00458176','08/25/2005 4:29:44 PM','Field Sup CoOrd','Reassigned',Null,Null UNION ALL SELECT '00458176','08/26/2005 2:59:19 PM','Service Desk','Reassigned',Null,Null UNION ALL SELECT '00458176','09/9/2005 10:42:44 AM','Field Sup - Vic','Completed',Null,Null UNION ALL SELECT '00461166','09/7/2005 9:49:02 AM','BSSAppSvcs-Apps','Resolved',Null,Null UNION ALL SELECT '00461166','09/7/2005 10:26:42 AM','Service Desk','Completed',Null,Null UNION ALL SELECT '00461166','09/9/2005 10:19:13 AM','BSSAppSvcs-Apps','Reassigned',Null,Null UNION ALL SELECT '00461166','09/15/2005 1:15:00 PM','Service Desk','Reassigned',Null,Null UNION ALL SELECT '00461166','09/15/2005 1:15:11 PM','Service Desk','Resolved',Null,Null UNION ALL SELECT '00456633','08/08/2005 1:18:32 PM','BSSAppSvcs-Club','Completed',Null,Null UNION ALL SELECT '00456633','08/26/2005 2:02:07 PM','Service Desk','Completed',Null,Null UNION ALL SELECT '00456633','08/26/2005 3:31:36 PM','Service Desk','Completed',Null,Null
SELECT CallID, ResolvDatetime, GroupName, Resolution, CaseResolvDatetime, CaseResolvGroupName FROM @table
UPDATE @table
SET CaseResolvDatetime = CASE WHEN Resolution = 'Completed' AND CallId = (select CallId from @table where GroupName like 'Ser%' AND Resolution = 'Completed') then ResolvDatetime ELSE NULL END
SELECT CallID, ResolvDatetime, GroupName, Resolution, CaseResolvDatetime, CaseResolvGroupName FROM @table -------------------------------------------------
At the moment I get the error:
Server: Msg 512, Level 16, State 1, Line 25 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.
Yet when I change the line:
"where GroupName like 'Ser%'" to "where GroupName like 'CDR%'" ... I get no error.
I am merging two databases and created two different schemas to contain the objects in the new DB. I would like the objects in both schemas to be visible to one user but I can't figure out how to make this happen. I thought I could just set the Owner of the schemas to the same User but that didn't work. At the moment, the User default schema is set to dbo. I would like the default to be both schemas but this isn't an option.
Is there any way to have multiple schema objects visible to a single user? Thanks!
I am using Allwayson to replicate a FCI to a remote site. (windows 2012R2) Although all is implemented, iam getting a strange error with the listener resources after ive made a failover test.
It keeps saying "Name resolution not yet available"from my understanding this is trying to update an entry that doesn't exist (since the user has permissions to do it).
Is there any way to set up name resolution for DTC when there are two servers with the same name? I have three servers - two production systems named "SQL" and an archive system "DMART". I want to run DTC procedures to archive data from both SQL's to the DMART. Is there any way to set up the DMART so it can properly resolve the names from each of the SQL's? They are on separate networks, but unfortunately have the same NetBIOS name.
I'm just wondering what is the resolution or execution order for a query like this (simplified version):
CREATE VIEW ClosedSales AS SELECT * from NatSales where CurrentFlag = 1 and ValidTo <> '9999-99-99' Select * from ClosedSales where CustomerId = 10
The thing I want to know is:
- If first the complete dataset from the view is calculated and the the CustomerId=10 filter is applied - Or the CustomerId=10 condition is added to the where clause in the view definition
My real case is much more complex but that is an interesting point in my performance analysis.
DropDB.sql IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Caching') DROP DATABASE [Caching]
I have gotten some great answers. Now I like to ask a deeper question. This command was created for SQL Server Express, for an internal software package at my company, by an outside vendor. However, sometimes this command doesn't work 100% on all user computers. So I have two questions. 1. Is there any way to either enhance the command, or the database command, to provide error diagnostics, to find out the issue for an individual user computer, why it doesn't always work? 2. Can anyone think of any scenarios that would prevent this from working? The key element here is that this caching database is supposed to allow individuals to use a particular piece of software, when they aren't connected to the network at work. But it doesn't always work on each computer - 100% of the time - even when the computer has SQL Server Express installed, and is running Windows XP. Randy
I created a report in SSRS which incorporates an image.And I have written a code using C# to export the report to PDF. While I am exporting this report to PDF from the SSRS, the resolution of the image got decreased.
Can anyone give me a solution to configure the resolution of the image in the PDF.
An outside vendor created this command and SQL files for internal software, using SQL Server Express, which is installed on every user machine
osql -S (local)SQLEXPRESS -E -i DropDB.sql The SQL file has this: IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Caching') DROP DATABASE [Caching]
This command was created for SQL Server Express, for an internal software package at my company, by an outside vendor. However, sometimes this command doesn't work 100% on all user computers. So I have two questions. 1. Is there any way to either enhance the command, or the database command, to provide error diagnostics, to find out the issue for an individual user computer, why it doesn't always work? 2. Can anyone think of any scenarios that would prevent this from working? The key element here is that this caching database is supposed to allow individuals to use a particular piece of software, when they aren't connected to the network at work. But it doesn't always work on each computer - 100% of the time - even when the computer has SQL Server Express installed, and is running Windows XP. Randy
i created a query and when i run it like this i get data but when i add a value in the 2ed case for '2%' i get error. Select a.email, case when a.reportnumber like '1%' then (select b.Reportnumber from ijasSummaryNo b where a.Reportnumber = b.Reportnumber) end as Reportnumber, case when a.Reportnumber like '1%' then (select b.stonebreakdown from ijasSummaryNo b where a.Reportnumber = b.Reportnumber) end as Measurement, case when a.Reportnumber like '1%' then (select b.reportcarddate from ijasSummaryNo b where a.Reportnumber = b.Reportnumber) end as ijasDate, case when a.reportnumber like '2%' then (select c.Reportnumber from appraisalsummaryblue c where a.reportnumber = c.reportnumber) end as imacsRepNo from t_RegisterInfoTemp a Query works fine like this but when i add this (the one marked bold i get error) case when a.reportnumber like '2%' then (select c.Reportnumber from appraisalsummaryblue c where a.reportnumber = c.reportnumber) end as imacsRepNo,case when a.reportnumber like '2%' then (select c.Measurement from appraisalsummaryblue c where a.reportnumber = c.reportnumber) end as Measurement2
This is the error. Server: Msg 4414, Level 16, State 1, Line 1Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (260) was exceeded.
