Error: 18456, Severity: 14, State: 16.
Login failed for user 'XXXXXX.COMusername'.
On the remote servers I enabled Named Pipes and TCP/IP and activated the Browser.
Here's what's strange: I can connect to one server but not any other.
I know this is an easy one for most of you but this is new territory for me.
I am trying to link a production application database to an existing SMS database.
Both of these databases are SQL 2000. I have sa access to both of them.
I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases.
For simplicity I will define them both.
Application Database we will call €œA-Database€?
SMS Database we will call €œB-Database€?
I have gone into the A-Database and gone to linked Servers under the security node in enterprise manager. I created a new linked database and selected the SQL Server option in the general Tab.
In the Security Tab I selected the €œBe made using the security context€? and used €œsa€? for the Remote login and the CORRECT sa password for the With password option.
The server options tab remain the same with €?RPC, RPC Out, & Use Remote Collation€? selected.
It appears to connect but there is not any Table or Views showing up. What am I doing wrong here and what do I need to do to link these 2 database engines so I can move forward?
Thanks,
Gene Godsey
I am working on a computer connected to a network. I am using SQL 2000/XP on my computer so I can manage other sql servers on our network (I'll call them S1 and S2, both running SQL 2000)
I recently received a new computer running SQL 2005 Standard/Vista. When I try to connect to S1 and S2, I can’t find them anywhere. Am I overlooking some settings in 2005/vista?
I am a little inexperienced at this, so please let me know if any additional information would be helpful.
Thanks in advance
Hi Everybody,
Can anybody help me on Remote Servers. I want to create a remote server
from 6.5 to 7.0. Is it possible to create a remote server from 6.5 to 7.0?.
From the Books online I saw remote server related commands. Like Linked servers in 7.0, tables of 7.0 can be extracted like "select * from <Remote_server>.<Database>.<Owner>.<Table_name>", in 6.5 Remote servers?. How do we execute a stored procedure of 7.0 Database from 6.5 server in remote server?.
Can anybody guide me on the above topics.
Tks in advance,
Sam
How do I add a remote SQL server to a local SQL server so that I can query it
using the normal T-SQL syntax. I have already tried using the following syntax:
sp_addlinkedserver @server = '233.56.152.112',
@srvproduct = N'SQL Server'
This caused the server to show up in the linked servers under Security folder in the Enterprise Manager GUI.
BUT WHEN RUNNING THE FOLLOWING QUERY:
(Select * from 233.56.152.112].remoteDATABASE.dbo.remoteTABLE)
I GET THE FOLLOWING ERROR:
[OLE/DB provider returned message: Client unable to establish connection]
[DBNMPNTW]ConnectionOpen (CreateFile()).
ANY GUIDANCE IS GREATLY APPRECIATED
THANKS
I am trying to get 1 SQL Server to update another SQL Server.
I have followed the examples in the books on-line and did have some success until I rebooted one of the servers.
I need a step by step process of how to set up the communication link to these servers.
am an authenticated user of a remote data base
I can log in using sql server management studio and add tables and
even I can back up the database .
Good.
But I want to get a copy of the
database to my local computer
Is there any way to do
this?The problem is that i don't have access to the directory of sql sever pleases tel me a way that is possible just by using sql server or any add on on it
Hello,This is my first post, and i am looking for help about Databases in remote servers.This is my problem:1) I have a free account in "HostBasket", with 50 mb of space, and 10 mb of SQL Server... with ASP.NET 2 support --> http://www.hostbasket.com/dotnet2.shtml?LinkFrom=100602) They gave me this info for the database:Your SQL Server: sql15.hostbasket.comYour database name: myDatabaseNameYour login for the database: myLoginYour password for the database: myPasswordConnection string for ASP.NET (using ADO.NET with System.Data.SqlClient namespace):Persist Security Info=True;User ID=myLogin;Password=myPassword;Initial Catalog=MyDatabaseName;Data Source=sql15.hostbasket.com 3) Actually, i don't know what to do with that info... I mean, i have read so much info, and all people saying "their way" to do things... oh, I am so confused...4) I read in a website, this: "the database can be uploaded as a FILE saved in the App_Data folder, under the .mdf extension"I read that from : http://dotnetjunkies.com/QuickStartv20/aspnet/doc/data/vwd.aspx5) In the url given above, there is a "step by step" example... i follow it, exactly (i start a asp.net website, i create the database and the table, i show the data with the grids, etc )6) All is OK until here, i mean, when i run the website with VWD, it shows me the info OK.7) But... ¿How can i do this works on the Remote Server i described in 1) and 2) ?I know how to upload my website, in fact i uploaded a very basic one, and all was OK, but when i work with databases starts my problem...So, i am almost sure, that i have an error in the "Conecction String"... connectionString="Data Source=.SQLExpress;AttachDbFilename=|DataDirectory|MiBaseDeDatos.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" ¿How should it be, to work with my free remote server?or,if you have done the "easy way" of uploading the .MDF file in the server (but a server different of mine) please, tell me the "how to..." (and the server you used :p )--------------------Ok guys, i am a Chilean young (i dont speak english very well) and i tried to write my ideas in an easy way, so I REALLY HOPE you can help me.I am a New (very new) on this (vwd , .net , asp.net ) in fact, i am using this just 3 days ago...THANK YOU SO MUCH,Carlos,La Serena, Chile.
View 7 Replies View RelatedPlease help me! We have a server that was renamed some time ago and, for some reason, the old name is now in SQL 6.5 in remote servers. I can't remove it because it keeps saying that it is "not defined as a remote server at the site."
This is a problem because when I try to set up the server for replication as a subscriber, it gives me the same message and won't let me go any further. It's kind of a catch-22; It's not a valid server so it should be removed, but when I try to remove it, it fails because it's not a valid server.
Hi, all -
I know you can execute stored procedures on remote servers in SQL Server 6.5, but can you run regular queries as well using the 4 part name qualification?
Example: select * from server1.database1.dbo.table1
If not, is there another way I can manipulate data on remoter servers?
Hi
I have two SQL Servers (6.5). One based in London (LDNINNTS9) and one in New York (NYINNTS2).
I had bidirectional replication set up on one table in a DB and everything is (WAS!!!) working fine. Came to work this morning (Monday typical!) and the following has happened.
When I select the remote servers option on the NY server from Enterprise manager I get the following error message
Unable to connect to site '0'because '' is not defined as a remote server.
Now it says that '' is not defined as a remote server. So I did a select of @@Servername and it has returned (null). It was set to NYINNTS2. I have tried executing some ISQL to change the name and started and stopped the SQL Services but the name remains (null). Does anyone have an idea of what I can do to set the name up as it was?
I know that the Server name gets set to null if it is invalid, but I am trying to set it to NYINNTS2, which should not be invalid? Does the domain name impact the validity of the name?
HELP!!!!
Regards
Steve Farmer
i am having 2 sql servers one is web sql server server and other server is my local sql server. i am making web application through which i want to connect both sql servers at a time and by selecting data from web server i want to insert it into my local sql server both having same database on which i want to work , i want to know how it can be done
my idea as follows in web.config i specify 2 connection string and by selecting data from websql server database table i going to store it in dataset and then i return dataset to another function which connects to local sqlserver database.but database records are much large. can any body guide me .
i am going to place my web application on local server (C# asp.net 2.0) .
thank you,
i tried this code
c# file
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Uupdatedata();
}
public void Uupdatedata()
{
string constr1=ConfigurationSettings.AppSettings["abccon1"];
string constr2 = ConfigurationSettings.AppSettings["abccon2"];
System.Data.SqlClient.SqlConnection dbcon1 = new System.Data.SqlClient.SqlConnection(constr1);
dbcon1.Open();
System.Data.SqlClient.SqlConnection dbcon2 = new System.Data.SqlClient.SqlConnection(constr2);
dbcon2.Open();
SqlDataReader dr;
SqlCommand cmd = new SqlCommand("select * from Unit_Master",dbcon1);
dr = cmd.ExecuteReader();
while (dr.Read())
{
string Sql = "insert into Table1(Unit_Id,Unit_Desc) values(" + dr.GetInt32(0).ToString() + "," + dr.GetString(1) + ")";
SqlCommand cmd1=new SqlCommand (Sql,dbcon2);
//cmd1.EndExecuteNonQuery ();
}
//dr.Close();
//dbcon2.Close();
}
web.config<configuration>
<appSettings>
<add key="abccon1" value="Data Source=comp01;Initial Catalog=abc;User Id=sa ; Password=sa"/>
<add key="abccon2" value="Data Source=comp01;Initial Catalog=abctest;User Id=sa ; Password=sa"/>
</appSettings>
<connectionStrings/>
this 2 databases are from single my loacl server
it wont work it gives exception
please healp me.
Hey, all. I've mainly worked with MySQL databases before. I'm working on an (old) ASP page that uses this connection string:strConnect = "Provider=SQLOLEDB; Data Source=SQL1.MYDBSERVER.NET; Initial Catalog=...; User ID=...; Password=..."
It works fine on the production server, but the local copy fails if I try to access the Products page (which uses the database), with this error: Microsoft OLE DB Provider for SQL Server (0x80004005)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied./html/products.asp, line 19Similarly, if I plug the connection info into Tools/Connect to Database in Visual Studio, I get: Connection failed:SQLState: '08001'
SQL Server Error: 17
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. Am I doing something wrong? Do I need more info from the hosting provider to connect remotely? Or is the database not accepting remote connections at all?Thanks in advance for your help!
Hi,
I've SQL 7 running on windows NT 4.0 server.
From my Sql server when I tried to register a remote server in the same office, I couldn't.
When I get the new registration wizard, I could see the server(s) I want to register. But when I finish all the steps in the wizard, it says: Unable to establish client connection.Connection Open(Create File).
I tried using both sql standard and win nt security (logins) but didn't work.
Help please.
Thanks,
Kiran
Hi
Is there a way (workaround) of running a remote stored
procedure as pass through query and without having to use
linked servers. Something similar OPENROWSET when
selecting form a remote object?
Many thanks
Tariq
Hi, I'm looking for an artical or Someone who can explain me what is the best way to transfer data between two remot database?
I'll Explane:
two business have local SqlServer in their office.
1 of business need to get Specific data from other. each database is protected. how can I read ake information of it?
Thanks.
I have a HA Listener which is visible and can be connected to, it has a read only secondary on a different subnet so when connecting to it we use the applicationintent = readonly and multisubnetfailover = true.
Trying to connect it as a linked server is giving me problems. I tried putting the extra info into the provider string but keep getting the failure to initialise error. I am trying to link SQL2012 to a 2012 HA group but will also need to connect from a sql2008 server as well
Hi all,
I have an application in asp.net 2.0 and iam trying to connect database which is in remote server(Sql server 2000).But iam getting error as follows:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
i know this is because asp.net 2.0 try to connect sql serverexpress by default.i have removed sql server express from my machine,Still iam getting the same error..any body have an idea how to solve this ...
regards
anitha
I am using SQL Server 2000 database in my VB.Net project.
My VB.net application is installed one two machines in different cities i.e. there are two separate databases.
First machine's IP address is say 202.33.44.55 and other machine IP address is say 203.33.55.66. Now I want to use each others databases i.e. I want to set their database group.
So that in my VB.Net's application which is installed on 202.33.44.55 I could see data of the 203.33.55.66 by just changing the connection string
I need to connect to a remote sql server. this is the information i have:
IP address: http://222.224.222
database name: db1
uid: exampleuser
pwd: examplepwd
what would be my connection string? here is my connection string that didn't work
"Server=http://222.224.222;Database=XyberToursSQL;Uid=exampleuser;Pwd=examplepwd;"
i get a invalid connection error
Do i need to do anything at the sql server end?
any help would be appreciated
thanks
john
Hi,
I have a web application installed on a server. I want to connect to a
remote database server. I have access to both the servers, I can assign
any user privileges or settings that are needed. How do I do this? I
tried it the usual way, specifying the conn string and opening the
conn, and expectedly it throwed an sql server does not exists error.
Thanks.
Hi to all:
I always had a problem connecting to SQL Server from home using EM.
I do add a new server registration, but i always get the following exception:
A Connection could not be established to IP ADDRESS
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())
At the same time, I do use a utility, found at http://sql.bhaidar.net to connect to the same database and works perfect.
Is there any configuration I should do to my pc, don't know maybe some port configuration or so, to allow EM to connect to those remote databases?
Thanks in advance.
Regards
Hi All
I have been configuring my website with the following:
I have my domain residing on a webserver with SQL Server 2005, and the database (an sql server 2000 db) which I am connecting to reside on another web.
Now when I try to connect to the to the remote database from SQL Server 2005, it gives me error, something like 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. or maybe 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Any suggestions will be welcomed :)
Thanks in Advance
Mykhan
Hi
I've got a desktop and a notebook and both are connected to the router. On both I've got Sql Server Express and Sql Server Management Studio Express installed. I need to connect to a remote Sql Server (using user ID and password) which works fine on my desktop, but fails on my notebook: Error:0 and Error: 10060.
I checked all router settings and notebook settings, but I don't know what I am doing wrong. I got myself another notebook and installed Sql Server Express plus Management Studio, which did not work either.
Hopefully someone can help.
Thank you.
I have recently taken over as webmaster at my company and need help connecting to our remotely hosted SQL server. The company who is hosting it will charge me "support time" to explain how to connect to it.
The database is used to store data and application information for our customer service center. So it is ALL database driven...
i have installed SQL Server Enterprise Manager on my machine, but have no ideas on where to even being trying to connect. I have the name of the server, password....etc. But do not know where to configure a connection.
ALSO, when i install my Enterprise Manager the first options askes me whether i want to create a new instance of SQL server on a local or remote machine....i am guessing my local machine right...??
any insight or direction is greatly appreciated.
tony.
Hi Everybody,
Can anyone tell me what is the difference between Remote Server and Linked Servers.
thks in advance,
Srinivasan.
i have sql server 2000 running on a windows server 2003 machine but have my web application on another windows xp machinei'm getting access denied from the client machine.... the 2 computers are connected by workgroup.. anyone can tell me how and what i need to do to connect to the sql server thanks
View 2 Replies View RelatedHello
I wrote a web app (vb.net) with mssql 2005 express edition DB.
I created a vs2005 setup project and added it to my app solution.
On my local computer it works fine (using IIS 5.1).
Now, I'm trying to deploy the app on a remote server (with mssql 2005 express edition installed) but when I try to run my app via the remote server's IIS, I get this Error message:
ERROR: Could not connect to database.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).
My app connectionstring looks like that:
<connectionStrings>
<add name="SiteSqlServer" connectionString="Data Source=localhost;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=False"
providerName="System.Data.SqlClient" />
<add name="MaxinetConnectionString" connectionString="Data Source=localhost;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=False"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="SiteSqlServer" value="Data Source=localhost;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=False"></add>
Can anybody tell me what I'm doing wrong and how to fix it
I am currently developing a 2.0 asp.net application from my home pc (Windows XP) and am trying to connect to a sql server on my host. This works fine at work but at home I just get the following error message:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Any ideas, i have even tried disabling my firewall to see if that made a difference.
Your help is much appreciated.
Hi guys ,I connect to internet using a proxy for example 122.158.190.5 : 8080 Most software read it from IE setting and in some cases I have to enter this proxy setting manually so that software can connect to the internet . I want to connect to a remote server using "SQL Server Management Studio" but it doesn't connect. And I couldn't find any proxy setting . How can I set this proxy setting ?And also I need to connect with may asp.net program to that remote server from my local computer how can I set this one ? Thank you in advance .
Hello everybody!
Can anyone tell me what steps i should follow in order to get my web site (which is hosted with a web host in ireland) to connect to yet another server (different country) where SQL Server 2005 will be running?
Thank you! - Callam
I was wondering if anyone knows how to connect with SQL Server over TCP/IP using ODBC
I tried using the IP address or domain name of the remote machine, but I get the following error:
Microsoft SQL Server ODBC Driver Version 03.70.0690
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
TESTS FAILED!
Thanks in advance
Mohamed
Hi everyone.
I need to know which are the best ways to connect to a remote SQL SERVER 2000 from inside a VB6 application. By remote I mean on a dedicated server outside my LAN that I can access by IP address.
Any opinion would be appreciated.