I am using two windows 2000(SP4) server box for Sql server 2000(SP3a) replication wit following methods-
1.ISDN Dialup line with NT1 terminator at both end.
2.Create Dialup from one computer.
3.Create RAS with static IP Address at second computer (Dial in) for acceptance of dialing.
4.Dialing from one place to another computer and get connection by dialup.
5.I can ping only Remote IP (RAS STATIC) Address at both end.
Try to registered SQL Server 2000 from dial place or dial in place got following errors-
Specify Sql server not found, Connection Open Connected()
What I am missing in setup of windows or Sql server 2000 or any hard component, let me help. Is the any need of physical router.
I am using two windows 2000(SP4) server box for Sql server 2000(SP3a) replication wit following methods-
1. ISDN Dialup line with NT1 terminator at both end. 2. Create Dialup from one computer. 3. Create RAS with static IP Address at second computer (Dial in) for acceptance of dialing. 4. Dialing from one place to another computer and get connection by dialup. 5. I can ping only Remote IP (RAS STATIC) Address at both end.
Try to registered SQL Server 2000 from dial place or dial in place got following errors- Specify Sql server not found, Connection Open Connected()
What I am missing in setup of windows or Sql server 2000 or any hard component, let me help. Is the any need of physical router.
Dear Pat Phelan Sir Resident Curmudgeon
Lot of thanks to you for your valuable suggesion, I did do whatever you suggested prior to his emal but not yet got solution
I am using port 1430 for a server and 1440 for b server.
How I can open my case with MS-PSS (Microsoft Professional Support Services), I didn't find any rool for unregistered users.
My application is working fine when i use broadband. but when i change my settings to dialup the application won't connect to sql server.
Details about project:
Connection string is IP based. Sql Server 2000. Framework 2.0 Sql Server is on hosting Servers. Application will be running on any system that has internet connection. The records that the application will fetch are not much, max 6 records in every 15 Secs.
Application is working fine on cable internet but when i switch to dialup it won't connect not even once.
dialup speed is good enough.
If you need any other detail please tell me...
Thanks in Advance. Erphan Rajput.
Errors:
9/6/2006 9:22:00 PM BackgroundWorker1_DoWork An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at SMSChat.Shared.DataSource.GetMessages(String ChannelName, DateTime DT) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppSharedDataSource.cs:line 47 at SMSChat.Form1.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppForm1.cs:line 132
9/6/2006 9:22:05 PM BackgroundWorker1_DoWork An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at SMSChat.Shared.DataSource.GetMessages(String ChannelName, DateTime DT) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppSharedDataSource.cs:line 47 at SMSChat.Form1.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppForm1.cs:line 132
9/6/2006 9:22:10 PM BackgroundWorker1_DoWork An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at SMSChat.Shared.DataSource.GetMessages(String ChannelName, DateTime DT) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppSharedDataSource.cs:line 47 at SMSChat.Form1.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppForm1.cs:line 132
9/6/2006 9:22:15 PM BackgroundWorker1_DoWork An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at SMSChat.Shared.DataSource.GetMessages(String ChannelName, DateTime DT) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppSharedDataSource.cs:line 47 at SMSChat.Form1.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppForm1.cs:line 132
9/6/2006 9:22:20 PM BackgroundWorker1_DoWork An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at SMSChat.Shared.DataSource.GetMessages(String ChannelName, DateTime DT) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppSharedDataSource.cs:line 47 at SMSChat.Form1.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e) in C:Documents and SettingsErphan RajputMy DocumentsVisual Studio 2005ProjectsSMSChat AppSMSChat AppForm1.cs:line 132
We have a setup with one Publisher Server and 15 Subscribers with merge replication configured for all subscribers. The current Database size is approximately 3 GB expected to grow to 10 GB in next 1 year. We wanted to know what benefits would we incur if we add an additional seperate distributor server (hardware box). Also, what is the approx. size of a database where a seperate distributor server (hardware box) is recommended.
Not sure if this is the right place, but ill give it a try.. Everytime i try to make a websync for my replications i get this error and then it rolls back everything:
===================================
The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)
I have a setup of transaction replication between one publisher and subscriber in the Same server.Now, I need to add a new subscriber to the existing publisher. So publisher database name is DB_A and Subscriber 1 name is DB_B. So the new subscriber will be DB_C. Is this kind of setup possible on one server?
If yes then at the time of reinitialization is it going to apply the snapshot on DB_B as well as DB_C?Also let say if due to disk error DB_B gets corrupted then will data be still replicated between DB_A and DB_C? (Assuming publisher, subscriber 1 and 2 are sitting on individual disks).
Below is a script I found that will help me turn on C2 auditing. The problem is that I am generating trace files that take up way too much space.
I need to know what column id and event id, so I am only turning on "failed login" and nothing else.
exec sp_trace_setevent @TraceID, x, x, @on
Code Snippet
CREATE PROC AuditTrcProc AS -- Create a Queue declare @rc int declare @TraceID int declare @maxfilesize bigint set @maxfilesize = 1
-- Please replace the test InsertFileNameHere with an appropriate -- filename prefixed by a path, eg.. c:MyFolderMyTrace. The .trc extention -- will be appended to the filename automatically. If you are writing from -- remote server to local crive, please use UNC path and make sure server has -- write access to your network share
declare @cmd sysname
set @cmd = 'copy c: empsessiontrace.trc c: empsession' + cast(cast(rand() * 1000000 as int) as varchar) print @cmd exec master..xp_cmdshell @cmd
Ain't sure if this is the right place. but anyway, here is the situation. I have 2 PCs and both are running Windows XP (A is using SP 2 and B is using SP 1) which are connected via a router and A can ping B and vice versa. I have SQL 2000 installed on A, so how do i go about setting up B so that B can access the database and tables of SQK 2000?Thanks.
Does anyone know if its possible to configure sql server 2000 so it reads in the date in a different format. Right now, it takes the date in the following format month day year. I want it to take in day month year instead.
I am using asp.net and that is properly configured to give day month year, but then this date is sent to sql server, i get into problems
I've installed SQL Server 2000 trial on a standalone XP Pro machine as a local server, however the debugger does not work correctly. I will not allow me to step into the code of stored procedures. Can anyone provide me assistance in resolving this.
I am new to the creation of SQL Servers and databases, I have only use SQL statements in code in the past, and I have encountered a problem in my first SQL Server 2000 setup...
I am trying to setup a database in SQL Server 2000 called Equipment, which will contain multiple tables corresponding to the names of different equipment being used. I am able to create that just fine, but my problem occurs when I try to create login names for that database. For the database to correctly interface with another program already in use I need two login names, "Equip" that has full access and "Equip_ReadOnly" that is unable to delete, insert, or update. The problem is that I wish for those two login names to be accessing the same tables within the database, so that any changes made by Equip will be seen by Equip_ReadOnly. However, when I try to do this I end up with two sets of tables, one owned by Equip and the other owned by Equip_ReadOnly.
I am able to accomplish what I want in SQL Server 2005 by using the dbo schema to contain the tables and then have Equip and Equip_ReadOnly as users of the dbo schema, but for this project I am unable to use SQL Server 2005. So far I have been unable to figure out how to accomplish this task using SQL Server Enterprise Manager. So, does anyone have any ideas or insight into this particular problem? I am stuck at the moment and any help would be appreciated.
Thanks
P.S. If this was the wrong forum to post this question in, please point me to the correct forum. Thanks Again.
My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Hi, i tried to install MS SQL server 2000 in my XP system but during the setup service account installation, i tried to use a domain user account but it cannot validate my user name and password. I used my windows administrator logon account and password. Please help..thank you.
I am trying to install Service Pack 4 to set up the SQL Server 2000 but I am having problem. When I clicked the setup.bat, the screen just "froze" with the message " validating user. Please wait..."
Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End upgraded with service pack 3 and analysis service. Now I am trying to install sql server 2000 report services. But I run SQL2KRSSP1-ENG.EXE setup Then following error occurs The upgrade patch can not be installed by window installer because the program to be upgraded may be missing , or the upgrade patch may update a different version of the program Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch. I redownload the same exe to other location. And again run but getting same error Please Guide me or atleast give some help full link. thanks
In DTS 2000 there was situation where I had to connect source and destination through a dialup connection (56k), where the transferring of data took me ages to finish, so it was not successful.
I need to replicate a database which will be updated both sides.Table doesn't have the primary key,and already has data.Please advice which replication will suit and what are the limitations.URGENT!! Thanks!
I did setup to have a Desktop SQL Server running on Windows NT workstation in a different domain across the internet create a pull subscription to a transaction publication that is immediate updating that I have published on my NT SERVER in my domain. It never got any further than creating the subscription -- I got the following error on the pull:shared agent job history:
The job failed unable to determine if the owner (domainusername) of job SQLServername-databasename-pubname-SQLServername2-databasename2 - 0 has server access (reason: Could not obtain information about Windows NT group/user 'othernameIdon'tunderstand'(SQLState 4200000) (Error 8198)
I want to be able to do bi-directional transaction based replication between a 7.0 SQL server running on Windows NT 4.0 server SP5 and an NT Workstation 4.0 SP5. Can this be done or would it require that both machines to be NT Server based? The reason I asked is because previously under 6.5 I was able to install the SQL operating system on Windows NT Workstation and now it looks like I can only install the Desktop version under 7.0. Will this give me the type of replication I am looking for?
Hello, I'm newbie in replication field. At the moment, I am able to setup replication on LAN (1 distributor to few subcribers). However, I found some difficulties on setting-up the replication on WAN. Is there any guidelines, setup documents or examples (like print screen) for me to refer to ? Hope able to get any assistance at here.
I am using MSDE 2000 for replication of my Data. I have one publisher and two subscribers. but i need t filter rows for publications. Problem is that for filtering, i need host_name and in push replication host_name is name of system in which Agents are running but in MSDE all agents are running in publisher system ( distributor System). so everytime for any publication i get only id of server. i am facing same problem in pull replication also.
Any suggestions on how to replicate from AS/400 to SQL Server 2000?
Data is stored on a AS/400, but applications use a SQL Server 2000 DB. Currently, DTS packages drop the SQL DB, rebuild the tables from a script, copy the data, and then rebuild the indexes as a nightly batch job. Is there a better way to do this? Also is there a clean way to replicate daily transactions as well?
I'm trying to determine if it is possible to do many to many replication in sql server 2000.
What i basically want is to have n databases share the same basedate (share a common database) and allow updates in any database to be replicated to all the other databases (with a simple conflict resolution, like last update wins).
My goal is total autonomy, without a single point of failure. If any node goes down, the other nodes will continue to work and continue to replicate their data to the remaining nodes. When a node comes back up it will catch up with the over nodes (or get reinitialized if it was a serious crash).
The amount of data i want to replicate is not that big (less than 100MB) and does not change that often. All servers are sql server 2000 instances connected by a gigabit network and the number of nodes involved is less than 10. Some latency is also acceptable.
the question is: is this at all possible? I have read i bit in 'SQL Server High Availability By Paul Bertucci' and some other resources and it looks like a multiple publishers or multiple subscribers with merge replication setup should work, but i'm not too sure if it will work for n > 2 nodes (where all nodes publish and subscribe to each other) and it also mentions constraints on which data a given node is allowed to update (i hope this could be handled by simple conflict resolution).
And if it is not possible in 2000, could it be accomplished en 2005?
