Can't Connect To External SQL Server (Please Help)
Jan 24, 2007
Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem...
I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy!? Well not for me ..
This is the error
Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight off no changes...
After some investigating I have found a few threads about advice but still cannot get it to connect to the external SQL DB (BTW I can connect to a SQL DB on my server its just externally)... This is what I have done / Checked so far..
1. I have changed the connection string to include the port number 1433
(Provider=sqloledb;Data Source=THEIPADDRESS,1433;Initial Catalog=DB;User ID=xxxxx;Password=xxxx;)
2. I can ping the IP address of the external SQL Server with no problems
3. On my server I have enabled TCP/IP in SQLExpress & added sqlservr.exe as an exception in the Firewall
4. I have even tried turning the Firewall off completely while I tried to connect - But still nothing.
If anyone can help me I would be very appreciated.... I am starting to tear my hair out as I can't think what else I need to do???
Thanks
View 1 Replies
ADVERTISEMENT
Apr 9, 2007
ok so this is my code:
private void iDListBox_SelectedIndexChanged(object sender, EventArgs e)
{
string connectionString = GetConnectionString();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Table1 WHERE Naam=@Naam", connection);
cmd.Parameters.AddWithValue("@Naam", iDListBox.SelectedValue);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
naamTextBox.Text = reader.GetString(1);
}
reader.Dispose();
connection.Dispose();
}
}
static private string GetConnectionString()
{
return "Data Source=(local);Initial Catalog=AdventureWorks;"
+ "Integrated Security=SSPI;";
}
but when I change the selected index of the listbox, then this error comes up:
System.Data.SqlClient.SqlException was unhandled
Message="An error occured while setting up a connection with the server. At making a connection with SQL server 2005, this jamming is possibly caused by the fact that at the standardinstitutions of SQL server no external connections have been permitted (provider: Provider of named pipes, error: 40 - no connection with SQL could open server)"
If the error sounds a bit weird, sry I tried to translate as most of my errors come in my language
someone knows what the problem is and a solution to it?
(btw sry if this is in the wrong part of the sql forum, but there are so much parts, I didn't know which to choose lol )
thx in advance
View 1 Replies
View Related
Feb 20, 2007
have setup SQL 6.5 on a machine. I have verified that port 1433 is opened for SQL. I am also using a router dell 2300. I am running Windows XP.
I have set up my machine to port forward and have setup a static ip 192.168.2.136 nothing I do seems to work.
I can connect to the server by name
ex:
MyStr = "Provider=sqloledb;Data Source=MYSQLPC,1433;Network Library=DBMSSOCN;Initial Catalog=master;User ID=myusername;Password=password;"
Conn.open MyStr
I can also connect using internal IP address
ex:
MyStr = "Provider=sqloledb;Data Source=192.168.2.136,1433;Network Library=DBMSSOCN;Initial Catalog=master;User ID=username;Password=password;"
Conn.open MyStr
but when I try to connect to the external IP 12.xxx.xxx.xxx
I get the dreaded sql does not exist error.
I can register the server by external ip. When I try to start the server I get an (RPC server unavailable) error.
I can ping the external ip.
I can telnet 192.168.2.136 1433 without error
I can connect though security manager using 12.xxx.xx.xx
I can't telnet 12.xxx.xx.xx.
I think its router but I do not know what I'm missing. I have static ip 192.68.136 set up.
Router Port Forward Settings
Service Enabled In Port Dest Addy Dest Port Type
MSSQLSER Y 1433-1434 192.168.2.136 1433-1433 TCP
MSSQLSER Y 1434-1434 192.168.2.136 1434-1434 UDP
I have also read that some ISP's block port 1433 due to the worm problem. So I changed the listining port from 1433 to 1971. I am still able to connect using this new port with local ip or local name. I still cannot connect to external IP. (I did change router setting to reflect new port forward to 1971)
I am not sure what I missing.
Thanks in advance for any help
Chris
View 1 Replies
View Related
Jul 20, 2005
Hi all,I am having real problems allowing a client to connect to sql 2000through enterprise manager.. I have tried all sorts but to no avail:From our local network all works fine.. Using the adsl line.. Even ifi try and connect to the external IP and use login details..(Asopposed to connecting local and using windows accounts) I can ping andtelnet the server and port.The server is behind a firewall so i opened up port 1433 and port1434(? is it needed).. To replicate the client i took the same laptophome that i use to connect in the office.. However using the exactsame config on my dial up at home i can ping the server but cannottelnet onto port 1433.. I think that this is the vital missing stepbut do not know hpw to resolve it..Any ideas anyoneCheersAnt
View 1 Replies
View Related
Jan 28, 2007
Hi again... I guess this is yet another newbie question (Sorry if its been asked before!)
If I have an IP address for an external SQL DB with valid User & Pass... Can I connect to it using SQLExpress on my machine??
If so can anyone point me towards how to do it, or run through it below (In easy steps as I'm dumb )
View 6 Replies
View Related
Jun 9, 2004
Hi,
I have been developing an app using SQL Server 2000 and am ready to transfer to a server located offsite. How can I connect to this server through enterprise manager or anything else so that I can use the copydatabase wizard to move it to the live server?
Thanks
Wheelz
View 4 Replies
View Related
Jul 3, 2006
Hello,
I'm not sure whether this is right section to post this. It seems the most relevant one to me. (Please point me in the right direction if it is not).
I am a programmer/web developer for a medium sized organisation in the financial industry (in Australia). Obviously being in the finance industry, we have very strict guidelines and access when it comes to security. We are currently in the process of converting our website to use a SQL Server database (instead of MS Access which we have been using for years). In the past, we have accessed our web database via SFTP as it was only an Access file. Now that we are converting to SQL Server, we will still need access to our database (which is on a server hosted externally). It seems a bit silly (and even bizarre) to me to consider trying to access a SQL Server database via SFTP (as that, to me, defeats the purpose of some of its security features), but is it even possible?
My security guys here will only allow me to access the external server that hosts our website/database via SFTP (on a machine that is outside our network, so any files that I wish to update on our website I need to copy over via USB or whatever). If I am not able to get into the SQL Server administrator program to change our database via SFTP, is there someway that I can "drop" a changed copy of our database into a directory somewhere that SQL Server can "pick up"?
Am I making sense?
Many thanks,
Bronwyn
View 5 Replies
View Related
Jul 5, 2007
I have seen the
Tools------>External tools
in sql server 2005 window
What external tools are used ? How they are used?
Plz give me the link to study this
Thanks,
Swati
View 3 Replies
View Related
Mar 21, 2007
Hi,I have a Sybase dataserver containing lots of (huge) tables that Iwould like to access from SQL Server (two different applications,using two different datasources, now want to talk to each other). MSAccess has a feature for 'linking' external data. Can I do similarstuff in SQL Server?Basically, I am trying to avoid having to duplicate the data in boththe dataservers and worry about keeping them in sync.Regards,Tanveer
View 3 Replies
View Related
May 11, 2006
Hi All,
Quick question ...
Is it possible to add an external server registration using SQL Server Management Studio Express CTP?
Reason being I have been doing some work from home and need to port the data back to the office who are on SQL 2000. I have a database with my web hosting company and wanted to export the data to the 'live' database so I could import to the office database - any ideas?
I've tried to connect using my login details and I know the live DB is operational as I can connect through my work system. I just can't seem to be able to do it on my system at home.
Any help would be greatly appreciated as it's been a real pain to get stuff transferred. I've so far had to generate SQL script to create the procs and tables for when I get to work - the proper down side is that I lose the content of the tables which not much right now but will be loads soon!
Many Thanks
--
I have just dicovered that the CTP management studio will not connect to SQL 7 - is there any alternative or does the new version compensate for this?
View 3 Replies
View Related
Aug 24, 2007
The reason that I would like to install SQL Server Express on an external hard drive is for portability. I am developing a database that I will be working on in the office and at home. At the current time, I do not have a laptop at the office (and I don't want to use my personal laptop for this project). I need a way to develop and test the database both at home and at the office.
I was wondering if anyone knows if this crazy idea would work. I am also thinking of doing the same with Visual Studio Express. Since there are no licensing violations to speak of for these software packages, it would seem like this could work.
Any thoughts?
View 6 Replies
View Related
Jan 24, 2007
Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem...
I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy!? Well not for me ..
This is the error
Microsoft OLE DB Provider for SQL Server[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight off no changes...
After some investigating I have found a few threads about advice but still cannot get it to connect to the external SQL DB (BTW I can connect to a SQL DB on my server its just externally)... This is what I have done / Checked so far..
I have changed the connection string to include the port number 1433
(Provider=sqloledb;Data Source=THEIPADDRESS,1433;Initial Catalog=DB;User ID=xxxxx;Password=xxxx;)
I can ping the IP address of the external SQL Server with no problems
On my server I have enabled TCP/IP in SQLExpress & added sqlservr.exe as an exception in the Firewall
I have even tried turning the Firewall off completely while I tried to connect - But still nothing.
If anyone can help me I would be very appreciated.... I am starting to tear my hair out as I can't think what else I need to do???
Thanks
View 5 Replies
View Related
Mar 26, 2008
Hi,
I am trying to invoke a webservice method when a specific record gets updated in my sql db table. I am planning on writing a trigger on the table, that would invoke the webservice when the event occurs. But I am not sure how to accomplish this. Any ideas/suggestion would be very helpful.
ThanksDabi
View 4 Replies
View Related
Dec 9, 1999
How can I move data from an external source to SQL-server 6.5.
If you for example has an oracle database on a UNIX or VMS-system and want
to move table data from a table in the oracle database to the SQL-server database.
There must be plenty of tools to do that via ODBC.
Any suggestions ?
View 1 Replies
View Related
Aug 9, 2006
I have generated a DLL file in VC++ 2005 by a 'C' file. It works fine when I put in a 32bits machine(32bits Windows Server 2003 + 32 bits SQL Server 2005).
However, when I build it into 64 bits, it doesn't work in a 64 bits machine. I have checked by Dependenct Walker, the DLL generated is linked with KERNEL32.DLL / OPENDS60.DLL / MSVCR80D.DLL, all of these DLL files are on the 64 bits machines and linked correctly.
I used the command
sp_addextendedproc 'abc', 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnabc.dll'
to create a ext. stored procedure. When I run it, the error message shows that
Could not load the DLL C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnabc.dll, or one of the DLLs it references. Reason: 126(error not found).
I would like to ask what is cause of the problem? Do I need to use CLR instead?
Thank you very much!!~
View 2 Replies
View Related
Dec 12, 2006
I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).
The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.
SQL Server Express 2005 is installed in mixed mode.
Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.
These are my values in my Java app web.xml -
<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.
And yes, the port is 1055 - I checked to find it.
I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).
Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?
View 7 Replies
View Related
Sep 24, 2007
Hi
I'm a newbie at SQL 2005 and I'm trying to create linked tables to our ERP system through ODBC. I can do this in MS Access or vb.net by using the ERP system's ODBC driver, but I am lost when it comes to SQL Server 2005.
Thanks for any help
View 1 Replies
View Related
Nov 26, 2006
hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution.
Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also installed the SQL Server 2005 Service pack as instructed via the MSDN site. However, when attempting to test my .net projects on my desktop pc (ie visit http://localhost), I encounter the error:
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)
note that the server I am attempting to connect TO is the old SQL 2000 server - NOT 2005. I specify my connection info in the web.config - and it points to an external ip address on the web.
Can anyone shed some light on this? I've tried enabling remote access on my local SQL 2005 install, but I'm fairly sure thats for servers that want to connect to my desktop, rather than my desktop attempting to connect to external servers. Any help is greatly appreciated - I'm pulling my hair out over trying to figure this out! :)
To summarize my setup (if it helps)
Desktop PC:Windows Vista (Ultimate)SQL Server 2005Visual Studio 2005II 7.0.Net 2.0 (ASP.Net Application)
External Server (co-located at a datacenter)Windows Server 2003SQL Server 2000IIS 6.0.Net 2.0 (ASP.Net Application)
Much appreciated,
Ted
View 5 Replies
View Related
Apr 9, 2007
I need to create a SQL server database and add some tables to it. Then access it with a C# application. The problem is that the new SQL server database and it's tables must reside on an external hard drive. How do I point SQL server to this external drive, so that I can create a database on this drive and then create tables and access data on it?
View 7 Replies
View Related
Jun 10, 2007
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
Any insights?
View 1 Replies
View Related
Oct 20, 2007
I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist
View 6 Replies
View Related
Apr 3, 2008
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
View 4 Replies
View Related
Apr 18, 2007
Can I connect from a SQL Server 2005 database to a SQL Server 2000 database, without establishing a linked server connection.
I need to fire a SELECT query on a SQL Server 2000 database, but don't want to add it as a linked server. Is there any way I can do this or its not possible??
View 1 Replies
View Related
Jan 10, 2008
I'm trying to develop an application for a friend, who has his own server and SQL 2005 setup on it Is it possible to add a connection to an externally hosted SQL Database using VWD2008? I have a login and password for it, I just don't know where I set the IP address to connect to and the name of the DB etc...?Any help greatly appreciated.
View 3 Replies
View Related
Oct 17, 2005
hi,am working with my friend so we need to use the same DB ..how can i get him DB and insert it in mine to use it.i 've try to copy it and paste in C:Program FilesMicrosoft SQL ServerMSSQLData then try to connect it by New connection bt it doesn't workNote:am working n Web Matrix ProjectRegards,
View 3 Replies
View Related
Mar 25, 2001
For every one
Visual basic permit use shell command to execute any file
shell "c:programs Filesword.exe
How could I make it in SQLServer 7.0
Sincerely.
Fain Boris.
View 2 Replies
View Related
Jul 23, 2005
Hello,I want to access my database server from the internet. I've created a ruleon my router to redirect port 1433 to the desired machine, but still get aServer does not exist, or access denied message. When I change the(external) ip to the local IP address, connection succeeds. Is thereanything i need to change within SQL Server to allow external (internet)access?
View 2 Replies
View Related
Jan 15, 2008
Can I include an external file (html) in report's definition? Like a subreport, and expecting show the file content...
thanks
View 5 Replies
View Related
Oct 15, 2007
Hi Experts,
I am looking for some guidance on the following CE based project. The project would mean placing a program on multiple appliances (either PDA mrtphone) which would then periodically connect onto a SQL 2005 server and both read and right to a table on the server. This would mean multiple connections to the server.
I have read various articles which discuss the use of SQL_ce to achieve this but SQL_ce is a single user application. Is it possible to achieve this objective by publishing a share of the SQL 2005 database tables to an internet share folder to allow multiple external connections? Also if it is possible can I test the application on a windows XP platform?
Thanks in advance,
Joe
View 1 Replies
View Related
Sep 12, 2005
I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?
View 15 Replies
View Related
Oct 17, 2014
I designed the AlwaysOn wrong, but every time we fail over from primary server to another server, my applications cannot connect because the sql logins cannot connect to their default databases. Once I run the command to link the login with the user in the default database then the users are able to connect. Did I do something wrong when designing AlwaysOn?
View 9 Replies
View Related
Jul 13, 2007
Hello,First, I tried to find the answet to this question, but no luck - so I decided to post it.
When I was creating my applications in asp.net - for the first time I decided to start using external DataSets. I think they are great and work very nice!But once I pushed the application to GoDaddy, I got an error of this nature:I was trying to access the exterbal dataSet like this:Dim productsAdapter As New NorthwindTableAdapters.ProductsTableAdapter()
Dim products as Northwind.ProductsDataTable...And got an error saying that it couldn't find this type (but it worked fine on my local machine in visual studio).So did I miss something that prevented this application working on GoDaddy? or there are some limitations on GoDaddy? ...or something else.Thank you for looking into this for me.Valera
View 7 Replies
View Related
