Remotely installing DSN

Is there any way to install a System DSN to all the pcs on my 2003 network?
(clients running xp)
either by a GPO or something else?]
i dont want to have to go around every pc doing itSystem DSN's are stored in the registry. making it somewhat difficult to
distribute.
You could change ther registry on one computer, save the registry to .reg
file, distrubute to all computers, and execute a custom script to import the
value.
ODBC entries are located in the registry in two spots. Both are under the
HKEY_Local_Machine\Software\ODBC
The first is found in the ODBC Data Sources subkey
The second set of registry entries go in the ODBC.INI subkey.
there are applications to help you do this as well...
http://www.freevbcode.com/ShowCode.asp?ID=3369
If it was me I would try my hardest to change the Datasource on the
application level before changing alot of computers.
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
*/
"MatthewWilsonAPD" <MatthewWilsonAPD@.discussions.microsoft.com> wrote in
message news:2DF39EDF-40A9-4FAB-9E72-7BEB554A7FAA@.microsoft.com...
> Is there any way to install a System DSN to all the pcs on my 2003
> network?
> (clients running xp)
> either by a GPO or something else?]
> i dont want to have to go around every pc doing it|||DSNs are just registry entries so you could create a
VBScript to deploy or call from login scripts...whichever.
Take a look at the following example:
http://www.databasejournal.com/feat...cle.php/2238221
-Sue
On Fri, 8 Sep 2006 08:24:02 -0700, MatthewWilsonAPD
<MatthewWilsonAPD@.discussions.microsoft.com> wrote:

>Is there any way to install a System DSN to all the pcs on my 2003 network?
>(clients running xp)
>either by a GPO or something else?]
>i dont want to have to go around every pc doing it

Remotely Connect to Sql Server

Hi
i am trying to registering the remote sql server (MMC Sql EnterPrise
Manager) which is outside our Network . i.e the machine is located at ISP.
it is giving me error SQL server does not exist or access denied.
i am specifying the IP address of remote machine to whom i want to access
remotely,
(SQL Server Properties ) under connection tab - (configuration done to
remote sql server)
i had selected the option of allowing other sql server to connect remotely
to this sql server using RPC
even i am not able register remote sql server in my local sql server.
Can anyone help me out what exactly we have to do for remote access of sql
server.
Thanks
MiteshCan you ping the SQL server?
Can you telnet to port 1433 from your side ?
Is there a firewall in between ?
Make sure you can connect on port 1433 otherwise it will not work , you
would then need to check whats blocking that port somewhere!
HTH
Dylan
"Mitesh Patel" <mitesh@.viraat.com> wrote in message
news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi
> i am trying to registering the remote sql server (MMC Sql EnterPrise
> Manager) which is outside our Network . i.e the machine is located at ISP.
> it is giving me error SQL server does not exist or access denied.
> i am specifying the IP address of remote machine to whom i want to access
> remotely,
> (SQL Server Properties ) under connection tab - (configuration done to
> remote sql server)
> i had selected the option of allowing other sql server to connect remotely
> to this sql server using RPC
> even i am not able register remote sql server in my local sql server.
> Can anyone help me out what exactly we have to do for remote access of sql
> server.
> Thanks
> Mitesh
>
>|||when i ping to ip address it is showing destination host unreachable (this
is due to internet provider had stopped ping )
yes i am able to do telnet to port 1433 after passing the telnet command at
port 1433. the telnet window shows connecting... and then telnet screen
becomes blank (might it been connected and waiting for commands )
remote server is located in data center then firewall will be there
............
Thanks
Mitesh
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:uaq5Y8U0EHA.1396@.tk2msftngp13.phx.gbl...
> Can you ping the SQL server?
> Can you telnet to port 1433 from your side ?
> Is there a firewall in between ?
> Make sure you can connect on port 1433 otherwise it will not work , you
> would then need to check whats blocking that port somewhere!
> HTH
> Dylan
>
> "Mitesh Patel" <mitesh@.viraat.com> wrote in message
> news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
ISP.[vbcol=seagreen]
access[vbcol=seagreen]
remotely[vbcol=seagreen]
sql[vbcol=seagreen]
>|||You should also make sure that it's the public IP you try to access or you
have the proper NAT settings in the Firewall in both ends. It could also be
the settings for your VPN connection (if that's what your using ) that needs
to be checked.
Regards
Steen
Dylan Kruger wrote:[vbcol=seagreen]
> Can you ping the SQL server?
> Can you telnet to port 1433 from your side ?
> Is there a firewall in between ?
> Make sure you can connect on port 1433 otherwise it will not work ,
> you would then need to check whats blocking that port somewhere!
> HTH
> Dylan
>
> "Mitesh Patel" <mitesh@.viraat.com> wrote in message
> news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...sql

Remotely Connect to Sql Server

Hi
i am trying to registering the remote sql server (MMC Sql EnterPrise
Manager) which is outside our Network . i.e the machine is located at ISP.
it is giving me error SQL server does not exist or access denied.
i am specifying the IP address of remote machine to whom i want to access
remotely,
(SQL Server Properties ) under connection tab - (configuration done to
remote sql server)
i had selected the option of allowing other sql server to connect remotely
to this sql server using RPC
even i am not able register remote sql server in my local sql server.
Can anyone help me out what exactly we have to do for remote access of sql
server.
Thanks
Mitesh
Can you ping the SQL server?
Can you telnet to port 1433 from your side ?
Is there a firewall in between ?
Make sure you can connect on port 1433 otherwise it will not work , you
would then need to check whats blocking that port somewhere!
HTH
Dylan
"Mitesh Patel" <mitesh@.viraat.com> wrote in message
news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi
> i am trying to registering the remote sql server (MMC Sql EnterPrise
> Manager) which is outside our Network . i.e the machine is located at ISP.
> it is giving me error SQL server does not exist or access denied.
> i am specifying the IP address of remote machine to whom i want to access
> remotely,
> (SQL Server Properties ) under connection tab - (configuration done to
> remote sql server)
> i had selected the option of allowing other sql server to connect remotely
> to this sql server using RPC
> even i am not able register remote sql server in my local sql server.
> Can anyone help me out what exactly we have to do for remote access of sql
> server.
> Thanks
> Mitesh
>
>
|||when i ping to ip address it is showing destination host unreachable (this
is due to internet provider had stopped ping )
yes i am able to do telnet to port 1433 after passing the telnet command at
port 1433. the telnet window shows connecting... and then telnet screen
becomes blank (might it been connected and waiting for commands )
remote server is located in data center then firewall will be there
............
Thanks
Mitesh
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:uaq5Y8U0EHA.1396@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Can you ping the SQL server?
> Can you telnet to port 1433 from your side ?
> Is there a firewall in between ?
> Make sure you can connect on port 1433 otherwise it will not work , you
> would then need to check whats blocking that port somewhere!
> HTH
> Dylan
>
> "Mitesh Patel" <mitesh@.viraat.com> wrote in message
> news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
ISP.[vbcol=seagreen]
access[vbcol=seagreen]
remotely[vbcol=seagreen]
sql
>
|||You should also make sure that it's the public IP you try to access or you
have the proper NAT settings in the Firewall in both ends. It could also be
the settings for your VPN connection (if that's what your using ) that needs
to be checked.
Regards
Steen
Dylan Kruger wrote:[vbcol=seagreen]
> Can you ping the SQL server?
> Can you telnet to port 1433 from your side ?
> Is there a firewall in between ?
> Make sure you can connect on port 1433 otherwise it will not work ,
> you would then need to check whats blocking that port somewhere!
> HTH
> Dylan
>
> "Mitesh Patel" <mitesh@.viraat.com> wrote in message
> news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...

Remotely Connect to Sql Server

Hi
i am trying to registering the remote sql server (MMC Sql EnterPrise
Manager) which is outside our Network . i.e the machine is located at ISP.
it is giving me error SQL server does not exist or access denied.
i am specifying the IP address of remote machine to whom i want to access
remotely,
(SQL Server Properties ) under connection tab - (configuration done to
remote sql server)
i had selected the option of allowing other sql server to connect remotely
to this sql server using RPC
even i am not able register remote sql server in my local sql server.
Can anyone help me out what exactly we have to do for remote access of sql
server.
Thanks
MiteshCan you ping the SQL server?
Can you telnet to port 1433 from your side ?
Is there a firewall in between ?
Make sure you can connect on port 1433 otherwise it will not work , you
would then need to check whats blocking that port somewhere!
HTH
Dylan
"Mitesh Patel" <mitesh@.viraat.com> wrote in message
news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi
> i am trying to registering the remote sql server (MMC Sql EnterPrise
> Manager) which is outside our Network . i.e the machine is located at ISP.
> it is giving me error SQL server does not exist or access denied.
> i am specifying the IP address of remote machine to whom i want to access
> remotely,
> (SQL Server Properties ) under connection tab - (configuration done to
> remote sql server)
> i had selected the option of allowing other sql server to connect remotely
> to this sql server using RPC
> even i am not able register remote sql server in my local sql server.
> Can anyone help me out what exactly we have to do for remote access of sql
> server.
> Thanks
> Mitesh
>
>|||when i ping to ip address it is showing destination host unreachable (this
is due to internet provider had stopped ping )
yes i am able to do telnet to port 1433 after passing the telnet command at
port 1433. the telnet window shows connecting... and then telnet screen
becomes blank (might it been connected and waiting for commands )
remote server is located in data center then firewall will be there
............
Thanks
Mitesh
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:uaq5Y8U0EHA.1396@.tk2msftngp13.phx.gbl...
> Can you ping the SQL server?
> Can you telnet to port 1433 from your side ?
> Is there a firewall in between ?
> Make sure you can connect on port 1433 otherwise it will not work , you
> would then need to check whats blocking that port somewhere!
> HTH
> Dylan
>
> "Mitesh Patel" <mitesh@.viraat.com> wrote in message
> news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > i am trying to registering the remote sql server (MMC Sql EnterPrise
> > Manager) which is outside our Network . i.e the machine is located at
ISP.
> > it is giving me error SQL server does not exist or access denied.
> >
> > i am specifying the IP address of remote machine to whom i want to
access
> > remotely,
> >
> > (SQL Server Properties ) under connection tab - (configuration done to
> > remote sql server)
> > i had selected the option of allowing other sql server to connect
remotely
> > to this sql server using RPC
> >
> > even i am not able register remote sql server in my local sql server.
> >
> > Can anyone help me out what exactly we have to do for remote access of
sql
> > server.
> >
> > Thanks
> > Mitesh
> >
> >
> >
>|||You should also make sure that it's the public IP you try to access or you
have the proper NAT settings in the Firewall in both ends. It could also be
the settings for your VPN connection (if that's what your using ) that needs
to be checked.
Regards
Steen
Dylan Kruger wrote:
> Can you ping the SQL server?
> Can you telnet to port 1433 from your side ?
> Is there a firewall in between ?
> Make sure you can connect on port 1433 otherwise it will not work ,
> you would then need to check whats blocking that port somewhere!
> HTH
> Dylan
>
> "Mitesh Patel" <mitesh@.viraat.com> wrote in message
> news:OJExAfU0EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> Hi
>> i am trying to registering the remote sql server (MMC Sql EnterPrise
>> Manager) which is outside our Network . i.e the machine is located
>> at ISP. it is giving me error SQL server does not exist or access
>> denied.
>> i am specifying the IP address of remote machine to whom i want to
>> access remotely,
>> (SQL Server Properties ) under connection tab - (configuration
>> done to remote sql server)
>> i had selected the option of allowing other sql server to connect
>> remotely to this sql server using RPC
>> even i am not able register remote sql server in my local sql
>> server.
>> Can anyone help me out what exactly we have to do for remote access
>> of sql server.
>> Thanks
>> Mitesh

Remote(over a network) Database Connection Issue

This has to be an easy question.

WORK2 - My workstation (xp pro)
WORK3 - Location of SQL Express 2005

WORK3\COMPANY
sa,password

WORK3 is a XPPro, both WORK2 and 3 have full admin rights to their machines and the network, I am using SQL Authentication (sa, password)
I have used the SQL Server Config app to enable the 4 Protocols, then restarted service. I can connect locally to my database via "SQL Server Management Studio Express", and through my VB application. I have checked "allow remote connections" in the database properties.
I do not know what i am missing? any thoughts?

Thanks in Advance

Are

you using a connection string? which is?|||

Are you using a connection string? which is?

|||

My VB6 connectionstring is:

This works PERFECT when the data souce is a local SQL Express Database

mstrProvider = "SQLNCLI.1" 'SQL Server 2005 Express

mstrPassword ="password"

mstrDataSource =<my database name>

goSQLDataSource= "WORK/SQLSERVER"

ConnectString = "Provider=" & mstrProvider & ";" & _
"Persist Security Info= False" & ";" & _
"Integrated Security=SSPI" & ";" & _
"User ID=sa" & ";" & _
"Password=" & mstrPassword & ";" & _
"Initial Catalog=" & mstrDataSource & ";" & _
"Data Source=" & goSQLDataSource

When i use the SS Management Studio i cant connect to a remote SQL Server even though the allow remote connection is enbled.

|||

How is your authentication mode? if you are using a sql logins like a "sa", the authentication mode must be "sql server and windows authen....."

|||

are you refering to this?

"Integrated Security=SSPI" & ";" & _

I am always going to use SQL Authentication...Local or remote.

When I use SSMS i have to change it from Windows Auth to SQL b/c it doesnt let you enter a password if you are using Windows.

Does that answer your question?

|||

Sorry, when I told verify the authentication mode I mean on the SQLserver configuration properties.

|||

Verify the authentication mode on <INSTANCE>\properties\security\server authentication...

|||

The option button is select for "SQL Server and Windows Authentication mode" under the Server Properties/security

|||Why does Microsoft have to be so difficult? lol...sorry just venting|||

Verify this other one option <INSTANCE>\properties\connections\"alow remote connection s to this server"

|||

Maximum number of concurrent connections=0

Use query gov. = unchecked

default connection options= all unchecked

allow remote connections to this server=checked

remote query timeout=0

require distrubited transactions=unchecked

Configured values=selected

sql

Remote User Connection to SQL Server 7 Standard Edition

Is it possible to connect a remote user (in a wide area network) to a
database running on SQL Server 7 Standard Edition.
Do I need the Enterprise Edition to accomplish this?
Yes (to the first)
and
No (to the second)
Mike John
"guez" <guez@.discussions.microsoft.com> wrote in message
news:C4A2552E-74CA-4DDF-A1D1-4A1E05FB773C@.microsoft.com...
> Is it possible to connect a remote user (in a wide area network) to a
> database running on SQL Server 7 Standard Edition.
> Do I need the Enterprise Edition to accomplish this?

Remote User Connection to SQL Server 7 Standard Edition

Is it possible to connect a remote user (in a wide area network) to a
database running on SQL Server 7 Standard Edition.
Do I need the Enterprise Edition to accomplish this?Yes (to the first)
and
No (to the second)
Mike John
"guez" <guez@.discussions.microsoft.com> wrote in message
news:C4A2552E-74CA-4DDF-A1D1-4A1E05FB773C@.microsoft.com...
> Is it possible to connect a remote user (in a wide area network) to a
> database running on SQL Server 7 Standard Edition.
> Do I need the Enterprise Edition to accomplish this?

Remote User Connection to SQL Server 7 Standard Edition

Is it possible to connect a remote user (in a wide area network) to a
database running on SQL Server 7 Standard Edition.
Do I need the Enterprise Edition to accomplish this?Yes (to the first)
and
No (to the second)
Mike John
"guez" <guez@.discussions.microsoft.com> wrote in message
news:C4A2552E-74CA-4DDF-A1D1-4A1E05FB773C@.microsoft.com...
> Is it possible to connect a remote user (in a wide area network) to a
> database running on SQL Server 7 Standard Edition.
> Do I need the Enterprise Edition to accomplish this?sql

Remote SQL with proxy on server

Hello
I'm connecting to DB SQL server from my Access XP using
DSN User, but on my network I have a proxy, so it's block
my connection and I'm enable de connect,
How can I depass a proxy to connect from Access to a
remote DB SQL
ThanksDoes this article help
http://support.microsoft.com/default.aspx?scid=kb;en-us;216415
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.orgsql

Remote SQL Trace causing network slowness

Hello!
I was running SQL Trace from my computer (remotely) and noticed that all
activities against this server are slowing down. Queries that normally takes
a sec to execute are taking much longer. Once I stop trace, everything is
back to normal. Local Area Connection graph show network activity under
0.5%.
I have no problems when I start trace locally on the second node of the
cluster (server in question is SQL Server 2005 64-bit /Windows 2003 SP1
Active/Passive cluster). Did someone experience similar problem? What is the
best practices in regards to executing SQL Trace to minimize impact on SQL
server?
Thanks,
IgorNever run profiler on a busy system if you are concerned with performance,
especially remotely. Instead use Trace and send the results to a local
disk. Copy those files to your local server and load them into profiler if
you want to look at them.
http://support.microsoft.com/?id=283790
--
Andrew J. Kelly SQL MVP
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:uq%23PELbkGHA.4284@.TK2MSFTNGP05.phx.gbl...
> Hello!
> I was running SQL Trace from my computer (remotely) and noticed that
> all activities against this server are slowing down. Queries that normally
> takes a sec to execute are taking much longer. Once I stop trace,
> everything is back to normal. Local Area Connection graph show network
> activity under 0.5%.
> I have no problems when I start trace locally on the second node of the
> cluster (server in question is SQL Server 2005 64-bit /Windows 2003 SP1
> Active/Passive cluster). Did someone experience similar problem? What is
> the best practices in regards to executing SQL Trace to minimize impact on
> SQL server?
> Thanks,
> Igor
>|||Thank you, Andrew!
Igor
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%234eaCcbkGHA.5036@.TK2MSFTNGP04.phx.gbl...
> Never run profiler on a busy system if you are concerned with performance,
> especially remotely. Instead use Trace and send the results to a local
> disk. Copy those files to your local server and load them into profiler if
> you want to look at them.
> http://support.microsoft.com/?id=283790
> --
> Andrew J. Kelly SQL MVP
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:uq%23PELbkGHA.4284@.TK2MSFTNGP05.phx.gbl...
>> Hello!
>> I was running SQL Trace from my computer (remotely) and noticed that
>> all activities against this server are slowing down. Queries that
>> normally takes a sec to execute are taking much longer. Once I stop
>> trace, everything is back to normal. Local Area Connection graph show
>> network activity under 0.5%.
>> I have no problems when I start trace locally on the second node of the
>> cluster (server in question is SQL Server 2005 64-bit /Windows 2003 SP1
>> Active/Passive cluster). Did someone experience similar problem? What is
>> the best practices in regards to executing SQL Trace to minimize impact
>> on SQL server?
>> Thanks,
>> Igor
>

Remote SQL Server Access

I'm using SQL Server to store session state. The Sql Server is on the local network but not on the web server. I use impersonation and use account credentials for the ASPNET worker process:

<identity impersonate="true" userName="domain\user" password="pass"/
I'm able to access all resources and execute all pages without any problem.

When an object is added to session state I recieve the following error:

"Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'domain\username. "

Here is my web.config entry for using sql server (with modified connection string of course):

<sessionState mode="SQLServer" cookieless="false" timeout="30" stateConnectionString="Data Source=xxx.xxx.x.xx,1433;Network Library=DBMSSOCN;Initial Catalog=ASPState;Integrated Security=SSPI" /
I've checked and given the user i'm impersonating the ability to do everything. I've granted access on all necessary files, added them to the DB and made the user a db_owner of the ASPState table. I can log in to a machine as the user, then access sql server using the windows authentication. I granted 'act as part of the operating system', 'access this computer from a network', 'log on as a service', 'log on as a batch job' on both the remote computer hosting sql server and the web server.

The strange thing is i installed the asp session state tables on my development machine, using the same configuration file to run everything, and was able to add an object to session state without any problem. But when i specify the remote server, i'm denied.

Anybody have an idea?Have you tried switched back from integrated and supplying the said user details in the connection string? Not suggesting that as a solution but just wondering if that works.

Remote Process of Report

Hi,

We have a reports running in a system in our internal network. Now our requirement is we have to publish the same report into web for the public. How can I do that..?

Note :

I can not install reporting service in my Web server system.

There should be a way to put the report from the reporting server to the web server and display in the webpage to the public.

This is really an urgent requirement.

Are you using RS2005? If so, you can embed the report viewer control into your ASP.Net application.|||

I'm using 2003, Is there any way to do this. My problem is I have to show a report to a website which is running in diffrent system in the same network.

the user will be provided by a hyperlink in the asp.net webpage by clicking the link the user should see the report.

Thanks

Mohan

|||

It is tricky in 2003 without the viewer control.

Your user's won't be authenticated against your RS backend, so you will have to get the contents of the report from within your ASP.Net application. You will want to use the HTMLFragment deviceinfo setting. The trickier part is resolving the secondary streams (like images and charts). You will have to use the StreamRoot deviceinfo to redirect image requests back to your ASP.Net application, so you can make them on behalf of your users.

Remote Connections in 2005

This has probably been answered before, but...
I have a local SQL Server 2005 instance running, and I would like to
have another user on my network connect to this instance. However,
when he tries to connect, he always receives the same error message:
"An error has occured 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 28: - Server
doesnt' support requested protocol)"
So, I checked the properties for the server, and under the connections
tab the allow remote connection box is checked.
Any clue where to look next?
Thanks In Advancechris.teter@.gmail.com wrote:
> This has probably been answered before, but...
> I have a local SQL Server 2005 instance running, and I would like to
> have another user on my network connect to this instance. However,
> when he tries to connect, he always receives the same error message:
> "An error has occured 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 28: - Server
> doesnt' support requested protocol)"
> So, I checked the properties for the server, and under the connections
> tab the allow remote connection box is checked.
> Any clue where to look next?
> Thanks In Advance
>
is tcp and/or named pipes enabled - they are disabled by default

Remote Connections in 2005

This has probably been answered before, but...
I have a local SQL Server 2005 instance running, and I would like to
have another user on my network connect to this instance. However,
when he tries to connect, he always receives the same error message:
"An error has occured 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 28: - Server
doesnt' support requested protocol)"
So, I checked the properties for the server, and under the connections
tab the allow remote connection box is checked.
Any clue where to look next?
Thanks In Advancechris.teter@.gmail.com wrote:
> This has probably been answered before, but...
> I have a local SQL Server 2005 instance running, and I would like to
> have another user on my network connect to this instance. However,
> when he tries to connect, he always receives the same error message:
> "An error has occured 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 28: - Server
> doesnt' support requested protocol)"
> So, I checked the properties for the server, and under the connections
> tab the allow remote connection box is checked.
> Any clue where to look next?
> Thanks In Advance
>
is tcp and/or named pipes enabled - they are disabled by default

Remote Connections in 2005

This has probably been answered before, but...
I have a local SQL Server 2005 instance running, and I would like to
have another user on my network connect to this instance. However,
when he tries to connect, he always receives the same error message:
"An error has occured 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 28: - Server
doesnt' support requested protocol)"
So, I checked the properties for the server, and under the connections
tab the allow remote connection box is checked.
Any clue where to look next?
Thanks In Advance
chris.teter@.gmail.com wrote:
> This has probably been answered before, but...
> I have a local SQL Server 2005 instance running, and I would like to
> have another user on my network connect to this instance. However,
> when he tries to connect, he always receives the same error message:
> "An error has occured 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 28: - Server
> doesnt' support requested protocol)"
> So, I checked the properties for the server, and under the connections
> tab the allow remote connection box is checked.
> Any clue where to look next?
> Thanks In Advance
>
is tcp and/or named pipes enabled - they are disabled by default

Remote Connection Problems

I am not able to register a remote server and connect to
it currently without going through this process:
1. Open "My Network" and click on "Entire Network"
2. Search for the SQL Server by host and domain name (i.e.
host.domain.com)
3. Sign in with a valid username and password
4. Connect to the SQL Server through MMC
Does anyone know why I need to establish the Windows
Authentication first? Shouldn't I be able to connect with
just SQL Authentication?Hi Shannon,
For Windows Authentication, SQL Server takes your current Windows user
details. That's useful if you are in the same domain. Sounds like you aren't
in the same domain and Windows is establishing a new set of credentials when
you navigate to the system. Those credentials are then being used by SQL
Server.
SQL Server authentication requires separate users to be set up inside SQL
Server (ie not Windows users).
HTH,
--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Shannon Burns" <sburns875@.hotmail.com> wrote in message
news:068101c364c2$b38e3420$a301280a@.phx.gbl...
> I am not able to register a remote server and connect to
> it currently without going through this process:
> 1. Open "My Network" and click on "Entire Network"
> 2. Search for the SQL Server by host and domain name (i.e.
> host.domain.com)
> 3. Sign in with a valid username and password
> 4. Connect to the SQL Server through MMC
> Does anyone know why I need to establish the Windows
> Authentication first? Shouldn't I be able to connect with
> just SQL Authentication?

Remote connection problem

I have SQL Server 2005. My system is in a local network. In the network others are able to access my database. I have the permission to access the database of others but still I am not able to access the others database.

Can any body tell me that what can be the reason?

Best Regards,

Kanhaiya Lal

Which error do you get during connecting?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Please provide more detail info here, such as what error message you came across? Did you see any clue in Server ERRORLOG? Is it connection failure or data operation failure? or others? What is you configuration? such as client connection string, server sku? Remote/local? client and server OS?

Thanks!

Ming

|||What authentication mode was the server installed with ?|||

The error was timeout expired and I have solve it.

Thanks

Kanhaiya

Remote connection failed, even with proper configuration

I am unable to connect to a SQL instance on the server from a workstation on the same network.

SQL Express SP1 is installed on the server, and allows mixed authentication. The instance name is <SERVERNAME>\SQLEXPRESS.

Both the Database and Browser services are running.

Local and remote connections are enabled under SAC. I also used sp_configure to make the same changes.

All Protocols for SQLEXPRESS have been Enabled using the Configuration Manager.

The firewalls on both machines have been disabled.

Rebooting the server or restarting services after various changes hasn't affected the outcome.

Local connections made directly on the server are always successful using either authentication mode.

SQL Native Client Driver is installed on the workstation.

The workstation user is trusted. However, neither authentication mode is successful.

The connection string from the workstation uses the named instance above and the SQL Native Client driver.

Other services on the server are working and avaialble to the workstation, such as shared folders.

When I attempt a connection from the workstation I receive the following errors:

Connection failed:

SQLState: '08001'

SQL Server Error: -1

[Microsoft][SQL Native Client]SQL Networtk Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Connection failed:

SQLState: 'HYT00'

SQL Server Error: 0

[Microsoft][SQL Native Client]Login timeout expired

Connection failed:

SQLState: '08001'

SQL Server Error: -1

[Microsoft][SQL Native Client]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 setting SQL Server does not allow remote connections.

I have tried all of the recommendations I can find here without any luck. What am I missing?

Hi,

can you post full connection string used to connection machines!!?

Are you able to get connected each other servers from SSMS?

Hemantgiri S. Goswami

|||

Try to connect to the Server directly using the appropiate port rather than just using the instance name (to see if the SQL Browser is causing the problem) Use the format Servername,portnumber for this. If this does not work, you might have not enabled TCP/IP for connections.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||THank you for the suggestions. The problem was caused by an unrelated program on the same server. Uninstalling the offending program, and reinstalling SQL Express, did the trick.|||

Would you mind posting what the offending program was? I'm getting the same reaction from SQL Server 2005 Express in my LAN with an application that was running just a couple of weeks ago.

TIA

Mike Baker
Adobe Community Expert

remote connection error SQL2005

I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration.

I am using \\xxx.xxx.xxx.xxx\sqlservername and user sa to connect. I get the following error: “An error has occurred while establishing a connection to the server. When connecting to the 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: 5 – Invalid parameter(s) found) (Microsoft SQL Server, Error:87)”

If I take out the \\ from the server path I get an error that the server not found. So I think I am getting to the server.

I have run SQL profiler and there is no event or failed login on the remote server when I try to connect to SQL server A. SQL Server A is on Windows2003 with all current patches. I have tried connecting from Windows XP pro and Windows2003 server.

Is this a network issue, Windows2003 issue, or a SQL issue?

If the server path starts with \\ the client stack assumes the connection is intended over Named Pipes, which requires the full pipe name specification, which is not the case in the above example, hence, the error "Invalid parameter(s) found".

The solution depends on whether the SQL Server is installed as a "default" or a "named" instance:

(1) For a default instance: specify the server by either (a) the server's machine name only (no \\ or \), or (b) the server machine's IP address only (again, no \\ or \).

(2) For a "named" instance:

- specify the server as either (a) machineName\instanceName, or (b) ipAddress\instanceName. Note that if you installed the Express edition it is installed as named instance with name SQLEXPRESS by default.

- grant firewall expection for the sqlservr.exe processes.

- start SQL Browser service on the server's machine.

- grant firewall expection for the sqlbrowser.exe processes.

|||This worked! Thank you!|||

I also can't connect to my SQL Server Express, running on xxx.xxx.xxx.xxx. I tryed out everything! F***

Could you write out a complete connection string, pls? I tryed:

string strConn = "Data Source=xxx.xxx.xxx.xxx; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

string strConn = "Data Source=servername; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

|||

I am facing a similar problem.

I have Microsoft SQL Server 2005 Express (Named Instance:=01HW050876\SQLEXPRESS) in my machine (OS : Windows XP). I am using ADO in Visual Basic 6 to connect to the database. I use SQL Server Authentication to connect to ther server. It works fine if I connect from my machine. However, if i try to connect from a different machine I get the following error:

Unhandled Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Here is my connection string:

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=01HW050876\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

I have also used the Ip address

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=xxx.xxx.xxx.xxx\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

The other computer is also in the same network and I was able to ping my machine from there. I have also set the login mode of the SQLServer to Mixed mode in the registry and have added the user from the other machine to the database and have given access rights.

Could you help me to track down the problem

|||

Shasur

This blog can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

remote connection error SQL2005

I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration.

I am using \\xxx.xxx.xxx.xxx\sqlservername and user sa to connect. I get the following error: “An error has occurred while establishing a connection to the server. When connecting to the 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: 5 – Invalid parameter(s) found) (Microsoft SQL Server, Error:87)”

If I take out the \\ from the server path I get an error that the server not found. So I think I am getting to the server.

I have run SQL profiler and there is no event or failed login on the remote server when I try to connect to SQL server A. SQL Server A is on Windows2003 with all current patches. I have tried connecting from Windows XP pro and Windows2003 server.

Is this a network issue, Windows2003 issue, or a SQL issue?

If the server path starts with \\ the client stack assumes the connection is intended over Named Pipes, which requires the full pipe name specification, which is not the case in the above example, hence, the error "Invalid parameter(s) found".

The solution depends on whether the SQL Server is installed as a "default" or a "named" instance:

(1) For a default instance: specify the server by either (a) the server's machine name only (no \\ or \), or (b) the server machine's IP address only (again, no \\ or \).

(2) For a "named" instance:

- specify the server as either (a) machineName\instanceName, or (b) ipAddress\instanceName. Note that if you installed the Express edition it is installed as named instance with name SQLEXPRESS by default.

- grant firewall expection for the sqlservr.exe processes.

- start SQL Browser service on the server's machine.

- grant firewall expection for the sqlbrowser.exe processes.

|||This worked! Thank you!|||

I also can't connect to my SQL Server Express, running on xxx.xxx.xxx.xxx. I tryed out everything! F***

Could you write out a complete connection string, pls? I tryed:

string strConn = "Data Source=xxx.xxx.xxx.xxx; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

string strConn = "Data Source=servername; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

|||

I am facing a similar problem.

I have Microsoft SQL Server 2005 Express (Named Instance:=01HW050876\SQLEXPRESS) in my machine (OS : Windows XP). I am using ADO in Visual Basic 6 to connect to the database. I use SQL Server Authentication to connect to ther server. It works fine if I connect from my machine. However, if i try to connect from a different machine I get the following error:

Unhandled Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Here is my connection string:

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=01HW050876\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

I have also used the Ip address

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=xxx.xxx.xxx.xxx\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

The other computer is also in the same network and I was able to ping my machine from there. I have also set the login mode of the SQLServer to Mixed mode in the registry and have added the user from the other machine to the database and have given access rights.

Could you help me to track down the problem

|||

Shasur

This blog can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx