We have Windows XP pro running on a laptop. I can connect
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanksNormally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/defaul...kb;en-us;169470 or
_connection_pooling.asp." target="_blank">http://msdn.microsoft.com/library/d...on_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have Windows XP pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded[vbcol=seagreen]
>the
>.
>
Showing posts with label laptop. Show all posts
Showing posts with label laptop. Show all posts
Thursday, March 22, 2012
connection pooling
We have windows xp pro running on a laptop. I can connect
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanks
Normally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/default...b;en-us;169470 or
http://msdn.microsoft.com/library/de...n_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have windows xp pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>
|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect[vbcol=seagreen]
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the
>
>.
>
|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it[vbcol=seagreen]
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded
>the
>.
>
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanks
Normally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/default...b;en-us;169470 or
http://msdn.microsoft.com/library/de...n_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have windows xp pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>
|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect[vbcol=seagreen]
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the
>
>.
>
|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it[vbcol=seagreen]
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded
>the
>.
>
Saturday, February 25, 2012
connection error
Hi guys, my asp.net web page was working fine on my laptop. Until i transferred it into my friend's.. an error msg popped out. My SQL Northwind database was been copied over but still there seems to be a problem with the connection, can any one help me?
Personal guess: You are using an sa username/password in the connection string, and the other server you are connecting to is not set up for SQL security, only Windows security.
Show the connection string you are using (with any passwords obscured, of course).
|||
Personal guess: You are using an sa username/password in the connection string, and the other server you are connecting to is not set up for SQL security, only Windows security.Show the connection string you are using (with any passwords obscured, of course).
|||
SqlConnection conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=Northwind");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM tblDoor";
conn.Open();
//how to find out what user id to use?
Friday, February 24, 2012
Connection Broken
I have developed on application that connects to a sql database using tcp/ip
Sometimes the connection may get broken, for example with laptop users.
What is the most efficient way of detecting when this happens, instead of
the string of sql errors that we get.You either implement this through your own "sanity db class" with
sending a trivial command like "Select 'Sanity Check'" to SQL Server
and doing this in a try catch block, or you wrap the command you are
trying to send in a try catch block and retry upon the specific error
class for a lost connection.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Hello,
Mostly this should be because of some network issues. See if your network is
persistent..Run a ping from one of the laptop to sql server and redirect to
text file
and see if there is any request time-out..
Thanks
Hari
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.|||There are several Framework classes that can be called to see if the Network
changes state (which kills a connection) or you can use others to see if the
SQL Server instance is still responding. Yes, it sounds like there are
network hardware (or throughput/capacity) issues.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.
Sometimes the connection may get broken, for example with laptop users.
What is the most efficient way of detecting when this happens, instead of
the string of sql errors that we get.You either implement this through your own "sanity db class" with
sending a trivial command like "Select 'Sanity Check'" to SQL Server
and doing this in a try catch block, or you wrap the command you are
trying to send in a try catch block and retry upon the specific error
class for a lost connection.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Hello,
Mostly this should be because of some network issues. See if your network is
persistent..Run a ping from one of the laptop to sql server and redirect to
text file
and see if there is any request time-out..
Thanks
Hari
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.|||There are several Framework classes that can be called to see if the Network
changes state (which kills a connection) or you can use others to see if the
SQL Server instance is still responding. Yes, it sounds like there are
network hardware (or throughput/capacity) issues.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.
Connection Broken
I have developed on application that connects to a sql database using tcp/ip
Sometimes the connection may get broken, for example with laptop users.
What is the most efficient way of detecting when this happens, instead of
the string of sql errors that we get.
Hello,
Mostly this should be because of some network issues. See if your network is
persistent..Run a ping from one of the laptop to sql server and redirect to
text file
and see if there is any request time-out..
Thanks
Hari
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.
|||There are several Framework classes that can be called to see if the Network
changes state (which kills a connection) or you can use others to see if the
SQL Server instance is still responding. Yes, it sounds like there are
network hardware (or throughput/capacity) issues.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.
Sometimes the connection may get broken, for example with laptop users.
What is the most efficient way of detecting when this happens, instead of
the string of sql errors that we get.
Hello,
Mostly this should be because of some network issues. See if your network is
persistent..Run a ping from one of the laptop to sql server and redirect to
text file
and see if there is any request time-out..
Thanks
Hari
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.
|||There are several Framework classes that can be called to see if the Network
changes state (which kills a connection) or you can use others to see if the
SQL Server instance is still responding. Yes, it sounds like there are
network hardware (or throughput/capacity) issues.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Michael Tissington" <mtissington@.newsgroups.nospam> wrote in message
news:%231OsvqFoHHA.208@.TK2MSFTNGP05.phx.gbl...
>I have developed on application that connects to a sql database using
>tcp/ip
> Sometimes the connection may get broken, for example with laptop users.
> What is the most efficient way of detecting when this happens, instead of
> the string of sql errors that we get.
Sunday, February 12, 2012
Connecting to SQL Server over a VPN & through a router...
Hi All,
I have a NetGear combined wireless router / ADSL modem, and am
attempting to connect to SQL Server from my (wifi enabled) laptop, but
am getting a 'failed to create SSPI context' message (note that I'm
using Windows Authentication). I'm connected to my work LAN through a
SonicWall VPN. If I take the router out of the equation, I can connect
fine - even through the VPN.
Outlook also has no luck connecting - it appears that some aspect of
Windows Authentication is broken by the router being included in the
setup.
I can ping machines on my company LAN when connected through the
router, and can also connect to SQL server using the SS authentication
- so I'm not far away from being able to authenticate.
Any thoughts/help would be much appreciated.
Thanks,
Will (LemonSmasher)
Mmm... looks like I've 'solved' this. Having established the VPN
connection for the first time, I logged off of Windows, then logged
back on, reestablished the VPN connection and then authentication
worked. Must've been down to something being cached in my original
session - if anyone can shed light on this (or if its just a lucky
coincidence!), I'd be interested in hearing from you!
Will.
LemonSmas...@.hotmail.com wrote:
> Hi All,
> I have a NetGear combined wireless router / ADSL modem, and am
> attempting to connect to SQL Server from my (wifi enabled) laptop, but
> am getting a 'failed to create SSPI context' message (note that I'm
> using Windows Authentication). I'm connected to my work LAN through a
> SonicWall VPN. If I take the router out of the equation, I can connect
> fine - even through the VPN.
> Outlook also has no luck connecting - it appears that some aspect of
> Windows Authentication is broken by the router being included in the
> setup.
> I can ping machines on my company LAN when connected through the
> router, and can also connect to SQL server using the SS authentication
> - so I'm not far away from being able to authenticate.
> Any thoughts/help would be much appreciated.
> Thanks,
> Will (LemonSmasher)
I have a NetGear combined wireless router / ADSL modem, and am
attempting to connect to SQL Server from my (wifi enabled) laptop, but
am getting a 'failed to create SSPI context' message (note that I'm
using Windows Authentication). I'm connected to my work LAN through a
SonicWall VPN. If I take the router out of the equation, I can connect
fine - even through the VPN.
Outlook also has no luck connecting - it appears that some aspect of
Windows Authentication is broken by the router being included in the
setup.
I can ping machines on my company LAN when connected through the
router, and can also connect to SQL server using the SS authentication
- so I'm not far away from being able to authenticate.
Any thoughts/help would be much appreciated.
Thanks,
Will (LemonSmasher)
Mmm... looks like I've 'solved' this. Having established the VPN
connection for the first time, I logged off of Windows, then logged
back on, reestablished the VPN connection and then authentication
worked. Must've been down to something being cached in my original
session - if anyone can shed light on this (or if its just a lucky
coincidence!), I'd be interested in hearing from you!
Will.
LemonSmas...@.hotmail.com wrote:
> Hi All,
> I have a NetGear combined wireless router / ADSL modem, and am
> attempting to connect to SQL Server from my (wifi enabled) laptop, but
> am getting a 'failed to create SSPI context' message (note that I'm
> using Windows Authentication). I'm connected to my work LAN through a
> SonicWall VPN. If I take the router out of the equation, I can connect
> fine - even through the VPN.
> Outlook also has no luck connecting - it appears that some aspect of
> Windows Authentication is broken by the router being included in the
> setup.
> I can ping machines on my company LAN when connected through the
> router, and can also connect to SQL server using the SS authentication
> - so I'm not far away from being able to authenticate.
> Any thoughts/help would be much appreciated.
> Thanks,
> Will (LemonSmasher)
Connecting to SQL Server over a VPN & through a router...
Hi All,
I have a NetGear combined wireless router / ADSL modem, and am
attempting to connect to SQL Server from my (wifi enabled) laptop, but
am getting a 'failed to create SSPI context' message (note that I'm
using Windows Authentication). I'm connected to my work LAN through a
SonicWall VPN. If I take the router out of the equation, I can connect
fine - even through the VPN.
Outlook also has no luck connecting - it appears that some aspect of
Windows Authentication is broken by the router being included in the
setup.
I can ping machines on my company LAN when connected through the
router, and can also connect to SQL server using the SS authentication
- so I'm not far away from being able to authenticate.
Any thoughts/help would be much appreciated.
Thanks,
Will (LemonSmasher)Mmm... looks like I've 'solved' this. Having established the VPN
connection for the first time, I logged off of Windows, then logged
back on, reestablished the VPN connection and then authentication
worked. Must've been down to something being cached in my original
session - if anyone can shed light on this (or if its just a lucky
coincidence!), I'd be interested in hearing from you!
Will.
LemonSmas...@.hotmail.com wrote:
> Hi All,
> I have a NetGear combined wireless router / ADSL modem, and am
> attempting to connect to SQL Server from my (wifi enabled) laptop, but
> am getting a 'failed to create SSPI context' message (note that I'm
> using Windows Authentication). I'm connected to my work LAN through a
> SonicWall VPN. If I take the router out of the equation, I can connect
> fine - even through the VPN.
> Outlook also has no luck connecting - it appears that some aspect of
> Windows Authentication is broken by the router being included in the
> setup.
> I can ping machines on my company LAN when connected through the
> router, and can also connect to SQL server using the SS authentication
> - so I'm not far away from being able to authenticate.
> Any thoughts/help would be much appreciated.
> Thanks,
> Will (LemonSmasher)
I have a NetGear combined wireless router / ADSL modem, and am
attempting to connect to SQL Server from my (wifi enabled) laptop, but
am getting a 'failed to create SSPI context' message (note that I'm
using Windows Authentication). I'm connected to my work LAN through a
SonicWall VPN. If I take the router out of the equation, I can connect
fine - even through the VPN.
Outlook also has no luck connecting - it appears that some aspect of
Windows Authentication is broken by the router being included in the
setup.
I can ping machines on my company LAN when connected through the
router, and can also connect to SQL server using the SS authentication
- so I'm not far away from being able to authenticate.
Any thoughts/help would be much appreciated.
Thanks,
Will (LemonSmasher)Mmm... looks like I've 'solved' this. Having established the VPN
connection for the first time, I logged off of Windows, then logged
back on, reestablished the VPN connection and then authentication
worked. Must've been down to something being cached in my original
session - if anyone can shed light on this (or if its just a lucky
coincidence!), I'd be interested in hearing from you!
Will.
LemonSmas...@.hotmail.com wrote:
> Hi All,
> I have a NetGear combined wireless router / ADSL modem, and am
> attempting to connect to SQL Server from my (wifi enabled) laptop, but
> am getting a 'failed to create SSPI context' message (note that I'm
> using Windows Authentication). I'm connected to my work LAN through a
> SonicWall VPN. If I take the router out of the equation, I can connect
> fine - even through the VPN.
> Outlook also has no luck connecting - it appears that some aspect of
> Windows Authentication is broken by the router being included in the
> setup.
> I can ping machines on my company LAN when connected through the
> router, and can also connect to SQL server using the SS authentication
> - so I'm not far away from being able to authenticate.
> Any thoughts/help would be much appreciated.
> Thanks,
> Will (LemonSmasher)
Subscribe to:
Posts (Atom)