Remote connection failed: tcp

Showing posts with label tcp. Show all posts

Friday, March 23, 2012

Remotely connecting

I am kinda new to this.

Question:
I am trying to set up server.
I have installed SQL 2005 standard.

And now I am trying to log in through TCP/IP..
I went to SQL Server Config Mgmt and Enabled TCP/IP
Double checked IP address and made it Active and enabled it.

Now I tried to connect Management Studio using that IP and it doesnt log in.

Does anyone knows good links to guidelines on how to set up server, login etc.

Thank you very muchDid you restart the service ? See my screencast on www.sqlserver2005.de . You have to restart to make changes effective.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

check your surface area configuration for connection. check the ooption that says you want to accept connection from a remote connection. The only connection allowed by default is local

start>programs>micrsoft sql server 2005>configuration tools>surface area configuration>configuration for services and connection>remote connection>local and remote connection

from there you'll know what to do

Monday, March 12, 2012

Remote Scripting and Firewall Ports

I need to configure my firewall to allow remote scripting on my SQL 2000 DB.
Which udp and tcp ports do I need to open?Scott (Scott@.discussions.microsoft.com) writes:
> I need to configure my firewall to allow remote scripting on my SQL 2000
> DB. Which udp and tcp ports do I need to open?
Would scripting being any different from running queries?
If SQL Server listens on port 1433, that is your guy.
How remote are these connections? From the Internet? Or just in the
local network? If you expose the server on the Internet, make sure
that you have a really strong password for sa and all other SQL logins for
that matter. And make absolutely sure that you are running at least SP3.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Wednesday, March 7, 2012

Remote Database backup/restore

Anyone know if this can be done over TCP/IP connection?
Thanks in advance..
-BBHi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > Anyone know if this can be done over TCP/IP connection?
> >
> > Thanks in advance..
> >
> > -BB
> >
> >
>|||Correct. SQL Server does the backup, not the client from where you run the client app to send the BACKUP
commend to SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be seen
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Yes, You can do that. All you have to do is , create a Alias for the SQL
> > server using TCP/IP protocol, Ip address and Port number.
> > Using that Alias name register the SQL server in enterprise manager or use
> > Query Analyzer to connect.
> >
> > After that you could run the BACKUP DATABASE command to backup and RESTORE
> > DATABASE command to restore the database.
> >
> > To backup the file remotely or restore the file from remote locaton you
> have
> > to start the SQL Server service
> > using an Domain OS user which got write access to the remote share.
> >
> > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> sercice--
> > Double click and select the "Log on" option.
> > There you give a Valid Domain OS user and password to start the service.
> Now
> > stop and start the MSSQL Serevr service.
> >
> > Note: That domain user should have previlages in the remote share to write
> > the file as well as prev. to start the SQL server.
> >
> > After this you try to execute the Backup database command in Query
> > Analyzer:-
> >
> >
> > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> > init ( With init will overwrite the backup file every time)
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > Anyone know if this can be done over TCP/IP connection?
> > >
> > > Thanks in advance..
> > >
> > > -BB
> > >
> > >
> >
> >
>|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > Hi Hari,
> >
> > I had gotten this already. So the only file systems that can EVER be
seen
> > are the ones available to the Server .. no matter where you execute the
> > BACKUP from? For example if I want to execute the backup from a
remote
> > site, and put the dump file on client that is executing the BACKUP, then
I
> > MUST have a network share enabled on the remote client computer?
> >
> > Many thnx again,
> >
> > -BB
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > Yes, You can do that. All you have to do is , create a Alias for the
SQL
> > > server using TCP/IP protocol, Ip address and Port number.
> > > Using that Alias name register the SQL server in enterprise manager or
use
> > > Query Analyzer to connect.
> > >
> > > After that you could run the BACKUP DATABASE command to backup and
RESTORE
> > > DATABASE command to restore the database.
> > >
> > > To backup the file remotely or restore the file from remote locaton
you
> > have
> > > to start the SQL Server service
> > > using an Domain OS user which got write access to the remote share.
> > >
> > > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> > sercice--
> > > Double click and select the "Log on" option.
> > > There you give a Valid Domain OS user and password to start the
service.
> > Now
> > > stop and start the MSSQL Serevr service.
> > >
> > > Note: That domain user should have previlages in the remote share to
write
> > > the file as well as prev. to start the SQL server.
> > >
> > > After this you try to execute the Backup database command in Query
> > > Analyzer:-
> > >
> > >
> > > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat'
with
> > > init ( With init will overwrite the backup file every time)
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > > Anyone know if this can be done over TCP/IP connection?
> > > >
> > > > Thanks in advance..
> > > >
> > > > -BB
> > > >
> > > >
> > >
> > >
> >
> >
>

Remote Database backup/restore

Saturday, February 25, 2012

Remote Connections Enabled, but I still get error that Remote is not configured - Sql 2005

Fellow Devs,

I have an instance of SQL Server Express 2005 running on another box and I have Remote Connections enabled over both TCP/IP and Named Pipes, but on my other box I keep getting the error that the server does not accept Remote Connections.

Any ideas why this might be happening? Is there some other configuration?

start server configuration manager

click on protocols > TCP/IP and properties

go to IP addresses and under IPALL remove everythink from TCP dynamic port , under TCP Port enter port you want to use like 1433

save all changes restart service and should work

|||and if you have windows firewall on you have to allow to accept connection on this port|||

I don't see that option in my server configuration manager. I just see "File Server", "Application Server" and "Remote Access/VPN Server". Where do I modify thse settings?

Thanks!

|||

1) open SQL Server configuration manager
2) on the left under "Sql server 2005 network configuration" click on protocols for SQL
3) on right side right click TCP/IP > properties and tab IP addresses

|||

I was having the same problem and I followed your instructions, but now VS doesn't even detect the sql server. Any solutions?

Thanks.

|||

Swackhammer1:
I was having the same problem and I followed your instructions, but now VS doesn't even detect the sql server. Any solutions?
Thanks.

If VS is not detecting the SQL Server it may mean your SQL Server service maybe off. You may want to download the advanced version from the link below if not first get the eval and then spend $33 to get the developer edition. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

|||

looool what kind of solution is that ? doesn't work pay $33.

here is an article explaining step by step what you can do to enable remote connections - pretty much same idea i gave you , but when you will follow it must work

|||You have given the original poster very low level usually not adviced connection to SQL Server and it is not working, Express is best used for small company intranet hosted application nothing more. I have used SQL Server since 1998 and I have not got the need to connect to SQL Server on those layers. So mine will cost after 180 days but it is pain free.|||

i saw many of your posts and i KNOW that you work with SQL for long time and you know about it much more than i do.
I agree that SQL express is perfect for small project, intranet & for development and i believe that is what this person needs - when someone ask how to enable remote connections in SQL express- my guess would be that he/she doesn't work for BIG corporation that has billions of transaction / day

My point is that there is no reason to buy anything cos EXPRESS edition can work perfectly all you need is to spend few minutes with it and make the setup + maybe change firewall settings.

|||Yes but connecting to SQL Server through TCP port is not good advice because there is also the known UDP port and two others Microsoft admit to have reserved but only give to customers as needed which opens you up to known security issues. Microsoft was like Oracle selling the developer edition for hundreds we asked for the lower price for access and got it. Fighting with Express eats into development time.|||Ok. Here's the thing. I'm using SQL EXPRESS and VS 2005 on my machine, but the company I'm developing for has the full SQL SERVER 2005. Before I changed the tcp/ip setting, I could see my server in VS. After changing the settings though, it no longer shows up. I do have the service running. I double checked.|||OK. I decided to get the trial version of SQL SERVER 2005 for now. Let's see how that works out.|||

The links below from Microsoft covers most of what you need and some of what I have been trying to explain in details. Hope this helps.

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||

Caddre - very good links :)

BTWSwackhammer1 where in VS you can not see your SQL server ? in databse explorer when you click "add connection" ? if that is the problem just enter ".\SQLEXPRESS" in server name field or IP address of you server or "YOUR_COMPUTER_NEME\SQLEXPRESS"

Remote Connection to SQl Server Express Via ADO

Dear All,

I have TWO PCs, one of them having SQL Server 2005 Express

i get sure the TCP is enables , Active, Remote conneciton is enabled via TCP only

from VS2005 (C#) i can add new sqlconnection contorl and configure it with any of the installed DBs

but when i got to the Other PC with VS2005 as well, i can't configure it

all i can do is to see the server inthe server list.. but NO databases are retieved at all in the Select database drop down menu

any solution or suggestion

Do you use window authentication? Maybe there is a problem with that. Why don't you try creating a database user and try logging in with it?

Monday, February 20, 2012

Remote connection problems

I have a Windows 2003 server running SQL Server 2005. I can connect locally via TCP/IP and I've followed all the recommended steps to enable TCP/IP and remote connections.

However, I cannot connect remotely from my desktop machine (different LAN) using the SQL Management Studio, not will the same connection string work on a webserver that's on a different machine.

My connection string is:

Dim objConn, objRS, strConn, strSQL, Email_Number, Template
strConn = "Driver={SQL Server};Server=88.208.229.121;Database=test;Uid=XXX;Pwd=YYY;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConn

The error that I'm getting on the client with management studio is that the remote database is not available and most probably because TCP/IP was not enabled!

The error that I'm getting through classic ASP on the remote web is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Keep in mind I can use the exact same connection string and ASP and connect on the local machine, no problems.

Any help in this matter will be greatly appreciated.

Thanks
Riaan
London

Is there a firewall (esp. Windows firewall) between your computer and the server?

Have you enabled remote connections (using the Surface Configuration tool)?

Have you enabled TCP/IP?

Check these resources:

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||Hi

There is no firewall on the server, and from this location I connect through a broadband router that has the standard type of protection.

Yes, remote connections and TCP/IP are enabled.

I actually followed the steps from the first article.

Riaan|||I've done every step in the mentioned articles as above and neither of my two web servers at my ISP are running Windows Firewall. They are both at the same ISP and as I said, with the connection string I use I can browse the DB from classic ASP on the server that runs SQL, but not from another server that just runs IIS.

Is there anywhere else I should look?

Riaan
London|||

I noticed that your server bridges two networks.

It is possible that the problem lies there due to the added complexity involved in dealing with two networks simultaneously.

It will have two ip addresses, one for network 1 and another for network 2. You cannot connect to the network 1 ip from network 2. From your local machine you can "see" both networks and both network cards, so it will be able to connect to either ip address. Only remotely does it matter which identifier you use for your server (assuming that the configuration of your server is absolutely perfect) because again the server bridges two networks. So have you tried the other ip address to make sure you aren't using network 1's ip address to try to access the server from network 2?

Additionally, you will have to make sure that you have enabled it for both network interfaces -- this requirement is there to allow differentiation between trusted and untrusted networks but of course adds to the complexity of configuring the system to service two different networks.

I hope this helps,

John Gordon (MSFT)

Remote connection of SQL Express

Good day! I'm trying to make remote connections to SQL Express and it seems that it is not working.

Below are the steps that I did

- TCP/IP enable in the "Protocols for SQLExpress" node

- Since I'm not going to use SQL browser, I clear out the value for "TCP Dynamic Ports" and instead create my own TCP Port number

- I add my windows authentication to the dbase that I want to try to connect remotely

- Add the sqlsrver.exe to the exceptions of the firewall but even I turned-off the firewall already it still not connecting.

My error message is

"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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "

Is there any step that fail to apply?

Thanks in advance.

It already worked. I just included the port number to my connection. (Bummer! How come I forgot to include it... :))

Friday, March 23, 2012

Remotely connecting

Monday, March 12, 2012

Remote Scripting and Firewall Ports

Wednesday, March 7, 2012

Remote Database backup/restore

Remote Database backup/restore

Remote Database backup/restore

Saturday, February 25, 2012

Remote Connections Enabled, but I still get error that Remote is not configured - Sql 2005

Remote Connection to SQl Server Express Via ADO

Monday, February 20, 2012

Remote connection problems

Remote connection of SQL Express

Remote connection failed

Blog Archive

About Me