Connecting to SQL Server 2005 - Not Allow Remote Connections

I use ASP.NET 2.0 and VS.NET 2005.

I have the following expression in my code:

string connectionString = "server=\'localhost\'; user id=\'sa\'; password=\'\'; Database=\'Northwind\'";

When I executed the code I have 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)."

The Microsoft Access was successfully connected in the Server Explorer window.

How do I solve this problem?

Thanks,

Andy.

Try this thread for the two links you need to get it going. Hope this helps.

http://forums.asp.net/thread/1381596.aspx

|||

From your link, I found the following link http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b914277. I have followed all the instructions from that page, but I still receive the same error message.

I am not sure which version of SQL I am using. From the "start" -> "All Programs", I can only see "Microsoft SQL Server". It was installed, when I installed Microsoft Visual Studio 2005 Professional.

Andy.

|||If you have the professional you should have the Developer edition CD separately, copy the content to your hard drive and install it as a named instance and then use the instructions for the developer edition. Hope this helps.

Connecting to sql server 2000 on Godaddy error: (provider: Named Pipes Provider, error: 40

Facts:

1. I am using my account on Godaddy trying to connect to my sql server db.

2. I can get into my db using user id and password.

3. Godaddy's help file shows this for a connection string:

connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" &
db_name & ";UID=" & db_username & ";PWD=" & db_userpassword

4. My connection string: "Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=***;database=DB_87972;" & _
"Trusted_Connection=False providerName=System.Data.SqlClient"

{password **** out}

5. Get 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)

I tried to email Godaddy's help desk with this information.

There first response: We do not allow remote connections to our sql server database.

There second response was to read the help file!

Does anybody have any suggestions?

Thanks in advance,

bswanson

Finally, I did get a tech support who would give me an ear. He got this script from his tech support to test my connection:

mssqltest.aspx

<%@. Import Namespace="System.Data.SqlClient" %>
<%
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString ="Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=*****;database=DB_87972;"
try
oSQLConn.Open()
catch dag as exception
response.write(dag.message)
End try
Response.write("Connection Open!")
%>

Now we know we are connecting to sql server!

The next issue I realized that I was facing is that the code on the server was not recompiling. It was on the 1.1 framework running on asp.net 2.0.

The code was upgraded to asp.net 2.0 and uploaded again. Still it bombed. In an effort to get it working the debugger was turned on.

The next problem turned out to be in the <compilers> . The compiler option is not allowed. After deleting this code:

compilerOptions="/define:Debug=True /define:Trace=True /imports:Microsoft.VisualBasic,System,System.Collections,System.Configuration,System.Data,System.Drawing,System.Web,System.Web.UI,System.Web.UI.HtmlControls,System.Web.UI.WebControls"

out of the compilers, it worked!

On my local machines, I have not had trouble with recompiling. But on Godaddy, it did not recompile.

Hope this can help someone. I am open to suggestions.

Thanks,

Bswanson

Connecting to external data source

I have found several pages demonstrating this but I still cannot make it
work. I need to connect to an external data source. I have a user DSN named
"OMD" which does not require a username or password. My connection will be
read-only. My intent is to use SQLConnect, although I am open to any
suggestions. I have tried various methods of connecting to Access databases,
figuring that would be easier and then I could connect to my OMD source, but
I have not been able to connect to any other data source. Any words of
encouragement would be appreciated.
How exactly are you trying to connect to external data sources? Linked
servers? Openrowset? Opendatasource? Openquery?
What steps did you take to set this up with SQL Server?
What errors are you getting? What specific types of data sources are
you trying to connect to - e.g. Access, FoxPro, Oracle, Sybase, etc?
I'm not real clear on what it is you are trying to connect to from
where and what the errors are.
-Sue
On Tue, 19 Oct 2004 09:29:12 -0700, Phil T
<PhilT@.discussions.microsoft.com> wrote:

>I have found several pages demonstrating this but I still cannot make it
>work. I need to connect to an external data source. I have a user DSN named
>"OMD" which does not require a username or password. My connection will be
>read-only. My intent is to use SQLConnect, although I am open to any
>suggestions. I have tried various methods of connecting to Access databases,
>figuring that would be easier and then I could connect to my OMD source, but
>I have not been able to connect to any other data source. Any words of
>encouragement would be appreciated.
|||I am trying to connect the the source any way I can.
I have tried Openrowset, openquery, sp_addlinkedserver, sqlconnect,
sqldriverconnect.
I have an ODBC connection named OMD that connects using the Transoft OMD
driver. (Although I have not successfully connected to any type of dtabase;
not even other SQL servers)
It seems to me that sqlconnect is the easiest way to connect. Since there
is no username or password required by the ODBC driver, I thought simply using
declare @.mycode int
@.mycode=sqlconnect(dsn='OMD')
should work. It does not. I would like the proper syntax required.
Somehow I am misinterpreting the examples in the Help files. Please excuse
my ignorance.
Since the code will not compile, I am not getting to the point of errors.
Thanks for replying.
Phil
"Sue Hoegemeier" wrote:

> How exactly are you trying to connect to external data sources? Linked
> servers? Openrowset? Opendatasource? Openquery?
> What steps did you take to set this up with SQL Server?
> What errors are you getting? What specific types of data sources are
> you trying to connect to - e.g. Access, FoxPro, Oracle, Sybase, etc?
> I'm not real clear on what it is you are trying to connect to from
> where and what the errors are.
> -Sue
> On Tue, 19 Oct 2004 09:29:12 -0700, Phil T
> <PhilT@.discussions.microsoft.com> wrote:
>
>
|||If your code won't compile then your first issue is more of
an issue with whatever language you are using and how to
code data access routines. There is no one generic response
on how to do this with any data source and in any language.
In any case, are you trying to code this using the ODBC
APIs? If so, you need to use SQLConnect("DSN-Name") .
It would probably be easier to help you out if you could
post what language you are trying to do this in, what syntax
errors you receive, what the code is that is failing and
what examples you are trying to follow.
-Sue
On Mon, 1 Nov 2004 09:44:05 -0800, Phil T
<PhilT@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I am trying to connect the the source any way I can.
>I have tried Openrowset, openquery, sp_addlinkedserver, sqlconnect,
>sqldriverconnect.
>I have an ODBC connection named OMD that connects using the Transoft OMD
>driver. (Although I have not successfully connected to any type of dtabase;
>not even other SQL servers)
>It seems to me that sqlconnect is the easiest way to connect. Since there
>is no username or password required by the ODBC driver, I thought simply using
>declare @.mycode int
>@.mycode=sqlconnect(dsn='OMD')
>should work. It does not. I would like the proper syntax required.
>Somehow I am misinterpreting the examples in the Help files. Please excuse
>my ignorance.
>Since the code will not compile, I am not getting to the point of errors.
>Thanks for replying.
>Phil
>"Sue Hoegemeier" wrote:

Connecting to external data source

I have found several pages demonstrating this but I still cannot make it
work. I need to connect to an external data source. I have a user DSN name
d
"OMD" which does not require a username or password. My connection will be
read-only. My intent is to use SQLConnect, although I am open to any
suggestions. I have tried various methods of connecting to Access databases
,
figuring that would be easier and then I could connect to my OMD source, but
I have not been able to connect to any other data source. Any words of
encouragement would be appreciated.How exactly are you trying to connect to external data sources? Linked
servers? Openrowset? Opendatasource? Openquery?
What steps did you take to set this up with SQL Server?
What errors are you getting? What specific types of data sources are
you trying to connect to - e.g. Access, FoxPro, Oracle, Sybase, etc?
I'm not real clear on what it is you are trying to connect to from
where and what the errors are.
-Sue
On Tue, 19 Oct 2004 09:29:12 -0700, Phil T
<PhilT@.discussions.microsoft.com> wrote:

>I have found several pages demonstrating this but I still cannot make it
>work. I need to connect to an external data source. I have a user DSN nam
ed
>"OMD" which does not require a username or password. My connection will be
>read-only. My intent is to use SQLConnect, although I am open to any
>suggestions. I have tried various methods of connecting to Access database
s,
>figuring that would be easier and then I could connect to my OMD source, bu
t
>I have not been able to connect to any other data source. Any words of
>encouragement would be appreciated.|||I am trying to connect the the source any way I can.
I have tried Openrowset, openquery, sp_addlinkedserver, sqlconnect,
sqldriverconnect.
I have an ODBC connection named OMD that connects using the Transoft OMD
driver. (Although I have not successfully connected to any type of dtabase;
not even other SQL servers)
It seems to me that sqlconnect is the easiest way to connect. Since there
is no username or password required by the ODBC driver, I thought simply usi
ng
declare @.mycode int
@.mycode=sqlconnect(dsn='OMD')
should work. It does not. I would like the proper syntax required.
Somehow I am misinterpreting the examples in the Help files. Please excuse
my ignorance.
Since the code will not compile, I am not getting to the point of errors.
Thanks for replying.
Phil
"Sue Hoegemeier" wrote:

> How exactly are you trying to connect to external data sources? Linked
> servers? Openrowset? Opendatasource? Openquery?
> What steps did you take to set this up with SQL Server?
> What errors are you getting? What specific types of data sources are
> you trying to connect to - e.g. Access, FoxPro, Oracle, Sybase, etc?
> I'm not real clear on what it is you are trying to connect to from
> where and what the errors are.
> -Sue
> On Tue, 19 Oct 2004 09:29:12 -0700, Phil T
> <PhilT@.discussions.microsoft.com> wrote:
>
>|||If your code won't compile then your first issue is more of
an issue with whatever language you are using and how to
code data access routines. There is no one generic response
on how to do this with any data source and in any language.
In any case, are you trying to code this using the ODBC
APIs? If so, you need to use SQLConnect("DSN-Name") .
It would probably be easier to help you out if you could
post what language you are trying to do this in, what syntax
errors you receive, what the code is that is failing and
what examples you are trying to follow.
-Sue
On Mon, 1 Nov 2004 09:44:05 -0800, Phil T
<PhilT@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I am trying to connect the the source any way I can.
>I have tried Openrowset, openquery, sp_addlinkedserver, sqlconnect,
>sqldriverconnect.
>I have an ODBC connection named OMD that connects using the Transoft OMD
>driver. (Although I have not successfully connected to any type of dtabase
;
>not even other SQL servers)
>It seems to me that sqlconnect is the easiest way to connect. Since there
>is no username or password required by the ODBC driver, I thought simply us
ing
>declare @.mycode int
>@.mycode=sqlconnect(dsn='OMD')
>should work. It does not. I would like the proper syntax required.
>Somehow I am misinterpreting the examples in the Help files. Please excuse
>my ignorance.
>Since the code will not compile, I am not getting to the point of errors.
>Thanks for replying.
>Phil
>"Sue Hoegemeier" wrote:
>

Connecting RS to another server

When I run an RS report on server1 that connects to a sql database on server2
I get the error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "
Suggestions?On Jun 7, 1:50 pm, Jimbo <J...@.discussions.microsoft.com> wrote:
> When I run an RS report on server1 that connects to a sql database on server2
> I get the error:
> "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "
> Suggestions?
Refer to Reeves Smith's response to your other posting. That would be
my suggestion as well.
Regards,
Enrique Martinez
Sr. Software Consultant

Connecting as a different user in a script

Is there a way to connect as a different user inside of a
script or SP? If so, could someone tell me the syntax (T-
SQL)? With that, I'd need to know how to disconnect or
close that connection and go back to the original
connection that ran the script.
Thanks,
VanUsername or login?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:070c01c3c320$b7479f40$a501280a@.phx.gbl...
> Is there a way to connect as a different user inside of a
> script or SP? If so, could someone tell me the syntax (T-
> SQL)? With that, I'd need to know how to disconnect or
> close that connection and go back to the original
> connection that ran the script.
> Thanks,
> Van|||SQL Login. Connect as a different sql login from a script
or sp....
>--Original Message--
>Username or login?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Van Jones" <anonymous@.discussions.microsoft.com> wrote
in message
>news:070c01c3c320$b7479f40$a501280a@.phx.gbl...
>> Is there a way to connect as a different user inside of
a
>> script or SP? If so, could someone tell me the syntax
(T-
>> SQL)? With that, I'd need to know how to disconnect or
>> close that connection and go back to the original
>> connection that ran the script.
>> Thanks,
>> Van
>
>.
>|||For SQL Login, you can use xp_cmdshell which kicks off OSQL and use the appropriate user in the /U
script.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:1436a01c3c327$010a50e0$a601280a@.phx.gbl...
> SQL Login. Connect as a different sql login from a script
> or sp....
> >--Original Message--
> >Username or login?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Van Jones" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:070c01c3c320$b7479f40$a501280a@.phx.gbl...
> >> Is there a way to connect as a different user inside of
> a
> >> script or SP? If so, could someone tell me the syntax
> (T-
> >> SQL)? With that, I'd need to know how to disconnect or
> >> close that connection and go back to the original
> >> connection that ran the script.
> >>
> >> Thanks,
> >>
> >> Van
> >
> >
> >.
> >

Connecting a user from a backup database to a new login

All,
In SQL Server 2000, I loaded a backup file into a new local database.
The database has an existing user which owns several stored procedures,
tables, etc.
Using SQL Server authentication, I want to create a login of the same
name as the user, so that when I login, I have access to the objects
owned by that user without having to prefix the objects with the owner
name.
For instance exec sp_mystoredproc instead of exec
ownername.sp_mystoredproc. (In fact, several of the stored procedures
exec other procedures without the owner name prefix and to go add the
owner will be a tedious process)
When I try to add login and grant the login name to the existing user
it tells me it already exists.
I cannot drop the existing user because it owns a whole bunch of
objects.
What can I do to work around this? How do I connect a login to an
existing database user? Is there a system table where I can just map
the two?
Brad> What can I do to work around this? How do I connect a login to an
> existing database user? Is there a system table where I can just map
> the two?
See the sp_change_users_login stored procedure in the Books Online. Also,
the Best Practice is to always schema-qualify objects.
Hope this helps.
Dan Guzman
SQL Server MVP
"brad" <brad.eckrose@.gmail.com> wrote in message
news:1168719405.103237.233140@.38g2000cwa.googlegroups.com...
> All,
> In SQL Server 2000, I loaded a backup file into a new local database.
> The database has an existing user which owns several stored procedures,
> tables, etc.
> Using SQL Server authentication, I want to create a login of the same
> name as the user, so that when I login, I have access to the objects
> owned by that user without having to prefix the objects with the owner
> name.
> For instance exec sp_mystoredproc instead of exec
> ownername.sp_mystoredproc. (In fact, several of the stored procedures
> exec other procedures without the owner name prefix and to go add the
> owner will be a tedious process)
> When I try to add login and grant the login name to the existing user
> it tells me it already exists.
> I cannot drop the existing user because it owns a whole bunch of
> objects.
> What can I do to work around this? How do I connect a login to an
> existing database user? Is there a system table where I can just map
> the two?
> Brad
>

Connected user list to a sql server database

Hi,
Is there any way to get the list of user names connected to a particular
database? Can any one give me the T-sql statement to get the list of users.
Venkat
Hi
Here is the query
Select Loginame,spid,db_name(dbid) from master..sysprocesses where
db_name(dbid)='dbname'
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
"Venkat" wrote:

> Hi,
> Is there any way to get the list of user names connected to a particular
> database? Can any one give me the T-sql statement to get the list of users.
> --
> Venkat
>
>

Connected user list to a sql server database

Hi,
Is there any way to get the list of user names connected to a particular
database? Can any one give me the T-sql statement to get the list of users.
--
VenkatHi
Here is the query
Select Loginame,spid,db_name(dbid) from master..sysprocesses where
db_name(dbid)='dbname'
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Venkat" wrote:
> Hi,
> Is there any way to get the list of user names connected to a particular
> database? Can any one give me the T-sql statement to get the list of users.
> --
> Venkat
>
>

Connected user list to a sql server database

Hi,
Is there any way to get the list of user names connected to a particular
database? Can any one give me the T-sql statement to get the list of users.
VenkatHi
Here is the query
Select Loginame,spid,db_name(dbid) from master..sysprocesses where
db_name(dbid)='dbname'
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Venkat" wrote:

> Hi,
> Is there any way to get the list of user names connected to a particul
ar
> database? Can any one give me the T-sql statement to get the list of users
.
> --
> Venkat
>
>

Connect using different Windows user name...?!?!

I've scoured Google searching for an answer that seems like it should be
easy but apparently isn't...when I open SSMS to connect to a SQL 2005
database and choose Windows authentication, it greys out the User Name
box...problem is, the server I need to connect to is in another domain...how
on earth are you supposed to specify a different Windows user name to
connect with other than the one currently logged into the machine?

-Ben

--
Posted via a free Usenet account from http://www.teranews.comOn Jul 6, 3:12 am, "Ben Hanson" <transparency...@.hotmail.comwrote:

Quote:

Originally Posted by

I've scoured Google searching for an answer that seems like it should be
easy but apparently isn't...when I open SSMS to connect to a SQL 2005
database and choose Windows authentication, it greys out the User Name
box...problem is, the server I need to connect to is in another domain...how
on earth are you supposed to specify a different Windows user name to
connect with other than the one currently logged into the machine?
>
-Ben
>
--
Posted via a free Usenet account fromhttp://www.teranews.com

Hi Ben,

If you need to connect to another machine within your own domain, or
in a domain with the appropriate trust relationship to your own
domain, then you can use the Run As feature when right clicking on the
shortcut that you're using to launch SSMS.

If, OTOH, it isn't possible for users from the target domain to log
onto machines on your local domain, then you need to find some other
way to do it - normal route to take in that case would be to get a
Terminal Services connection to a machine within the target domain and
then start SSMS normally (Or at least, that's what I've normally done
in the past).

The point behind this is - when SSMS offers to connect using Windows
Authentication, it's using Authentication that has already been
established. There's nothing built in to SSMS/SQL Server to perform
the authentication itself.

Damien

connect using a non-interactive user

Hi,
I've been searching the web for some time, without any luck ...
Is it possible to connect to a SQL Server using a domain account that is
marked as a non-interactive user ?
Thanks,
Marc
"Marc Nemegeer" <nemegeermATdelaware.be.NOSPAM> wrote in message
news:eOPNDNg$EHA.4028@.TK2MSFTNGP15.phx.gbl...
> I've been searching the web for some time, without any luck ...
> Is it possible to connect to a SQL Server using a domain account that is
> marked as a non-interactive user ?
Where are you setting that option, on the server local security option, or
through group policy? Seems like it should be easy to test...
Steve

connect using a non-interactive user

Hi,
I've been searching the web for some time, without any luck ...
Is it possible to connect to a SQL Server using a domain account that is
marked as a non-interactive user '
Thanks,
Marc"Marc Nemegeer" <nemegeermATdelaware.be.NOSPAM> wrote in message
news:eOPNDNg$EHA.4028@.TK2MSFTNGP15.phx.gbl...
> I've been searching the web for some time, without any luck ...
> Is it possible to connect to a SQL Server using a domain account that is
> marked as a non-interactive user '
Where are you setting that option, on the server local security option, or
through group policy? Seems like it should be easy to test...
Steve

connect user developed interface using WVD to DB SQLEE 2005

Dear Friends

I am a bigginer. I need to save input from textBox (User interface that I have made using VWD) to a database in SQLSEE 2005 using C#. please help me. I now how to connect to DB using Visual Items like gride view and form view. but i want to conect to DB using my developed UI lke in below. any help greatly appreciated

Name input area

address input area

Thanks

Amila

This article might help:

http://www.c-sharpcorner.com/Database/PlayingWithDataGridTA.asp

Buck Woody

connect user developed interface using WVD to DB SQLEE 2005

Dear Friends

I am a bigginer. I need to save input from textBox (User interface that I have made using VWD) to a database in SQLSEE 2005 using C#. please help me. I now how to connect to DB using Visual Items like gride view and form view. but i want to conect to DB using my developed UI lke in below. any help greatly appreciated

Name input area

address input area

Thanks

Amila

This article might help:

http://www.c-sharpcorner.com/Database/PlayingWithDataGridTA.asp

Buck Woody

Connect to sqlexpress from network computer

Hi

Please if any one can answer.I am developing .net vb app sqlexpress database.

In single user work ok.In multiuser from other computer on network I cannot get data.Any form without data workok fine . The error I am getting is as follows.

Application attempted to perform operation not allowed by the security policy.

request for permission of type

'System.data.sqlclientpermission,system.data,

version=2.0.0.0.,culture=Normal, publickeytoken=b77a5c561934e089'

Zaabdullah

Hi Zaabdullah,

You will most likely get a better response by posting on one of the VB.NET forums. It seems that the security policy for the Assembly needs to be corrected to allow accessing resources across the network.

Connect to SQL with NT authentication from form...

I have a login page that checks the given userid/password against ADSI and redirects the user if successful. My problem seems to come when I try to connect to the SQL database with the user's NT credentials. I have the user's NT account setup in SQL, have anony. disabled in IIS, using Integrated Windows Security in IIS, and am using the following connection string:

connectionString = "data source=SqlServer;initial catalog=pubs;Trusted_Connection=Yes"

I also have this entry in my Web.Config file: <identity impersonate="true" /
Actually, it seems to connect OK, but I can not select any data. I just receive "Select permission denied..." errors even though the user has been given these permissions in SQL.

Any advice would be greatly appreciated.

Thanks,
-BenYou need to set the proper access rights in for the User in SQL Server itself.|||The user has all the proper permissions on the SQL server.

Connect to SQL Server from machine not in domain

I am attempting to connect to a SQL Server that is in a domain that I
have a VPN connection to. I am receiving the Error: "Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server
connection. (Microsoft SQL Server, Error: 18452)
I errantly had expected that by mapping a drive to one of the shares
on the SQL Server that I am attempting to connect to, that I would be
able to connect ok using Integrated Windows Authentication. I have
even renamed my local UID/pwd to match that on the domain that owns
the SQL Server I am attempting to connect to.
Thoughts?Hi
If you have granted login to that user or a domain group on the domain where
the sql server is (where the user is a member) , then you should be able to
log in even though the user is in a different domain. If you can't grant the
login and if you can't change the way the domains trust each other, then you
will need to ue SQL Authentication.
John
"brandor" wrote:
> I am attempting to connect to a SQL Server that is in a domain that I
> have a VPN connection to. I am receiving the Error: "Login failed for
> user '(null)'. Reason: Not associated with a trusted SQL Server
> connection. (Microsoft SQL Server, Error: 18452)
> I errantly had expected that by mapping a drive to one of the shares
> on the SQL Server that I am attempting to connect to, that I would be
> able to connect ok using Integrated Windows Authentication. I have
> even renamed my local UID/pwd to match that on the domain that owns
> the SQL Server I am attempting to connect to.
> Thoughts?
>

Connect to SQL Server dialog box

I am studying the MCP book, and in Ch 10 (regarding SQL
authorization) it says:
The user name and password are submitted to SQL Server
2000 in clear text unless both the client and the server
Net-Libraries are using SSL encryption for the
entire session.

>--Original Message--
>Does anyone know if the SQL Server connection dialog box
transmit the password in clear text? I know it's hidden
from display but I'm wondering what it does behind the
scenes.
>Thanks,
>Ray Kurpiel
>.
>
Thanks for the response, Meryl.

Connect to SQL Server dialog box

I am studying the MCP book, and in Ch 10 (regarding SQL
authorization) it says:
The user name and password are submitted to SQL Server
2000 in clear text unless both the client and the server
Net-Libraries are using SSL encryption for the
entire session.

>--Original Message--
>Does anyone know if the SQL Server connection dialog box
transmit the password in clear text? I know it's hidden
from display but I'm wondering what it does behind the
scenes.
>Thanks,
>Ray Kurpiel
>.
>Thanks for the response, Meryl.