I trying to connect to a SQL DB SP 3 using cisco client
VPN v.4.01. The VPN is connecting to a cisco PIX515 with
MS IAS as its AAA. On a remote PC running Win XP SP1
logging in with the local builtin administrator account,
I can connect to the SQL after I VPN in. With everything
remaining the same, I logon with a user account I created
belonging to the Administrators group, I get an error
trying to connect to SQL. The only account that is able
to connect to the SQL is the local Administrator
account. All other accounts are getting error of no "not
associated with a trusted SQL Server connection." All
the other account are in the Administrators group. The
security is set to "With Windows NT authenication using
network login ID."If the builtin\administrators group has been removed from SQL Server, then
the other accounts would have to be explicitly added as allowed accounts in
SQL Server. The "with Windows authentication using network..." sounds like
a linked server setting, where are you checking that?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label vpn. Show all posts
Showing posts with label vpn. Show all posts
Thursday, March 22, 2012
connectivity
I trying to connect to a SQL DB SP 3 using cisco client
VPN v.4.01. The VPN is connecting to a Cisco PIX515 with
MS IAS as its AAA. On a remote PC running Win XP SP1
logging in with the local builtin administrator account,
I can connect to the SQL after I VPN in. With everything
remaining the same, I logon with a user account I created
belonging to the Administrators group, I get an error
trying to connect to SQL. The only account that is able
to connect to the SQL is the local Administrator
account. All other accounts are getting error of no "not
associated with a trusted SQL Server connection." All
the other account are in the Administrators group. The
security is set to "With Windows NT authenication using
network login ID."
If the builtin\administrators group has been removed from SQL Server, then
the other accounts would have to be explicitly added as allowed accounts in
SQL Server. The "with Windows authentication using network..." sounds like
a linked server setting, where are you checking that?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
VPN v.4.01. The VPN is connecting to a Cisco PIX515 with
MS IAS as its AAA. On a remote PC running Win XP SP1
logging in with the local builtin administrator account,
I can connect to the SQL after I VPN in. With everything
remaining the same, I logon with a user account I created
belonging to the Administrators group, I get an error
trying to connect to SQL. The only account that is able
to connect to the SQL is the local Administrator
account. All other accounts are getting error of no "not
associated with a trusted SQL Server connection." All
the other account are in the Administrators group. The
security is set to "With Windows NT authenication using
network login ID."
If the builtin\administrators group has been removed from SQL Server, then
the other accounts would have to be explicitly added as allowed accounts in
SQL Server. The "with Windows authentication using network..." sounds like
a linked server setting, where are you checking that?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 19, 2012
Connectiong to SQL Server 2000 over VPN
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.Can you reach the server on the VPN (ping it) ?
if not, you need to reconfigurate your network settings(IP of the switch connectiong to the VPN)
if you can ping it, you should have no problem using SQL server Authentication (unless firewall filter the SQL Server port)
Originally posted by kevin86
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.|||I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||I think you have to ask to the system admin for the firewall.
Do you asked someone on the domain (not using the VPN) to try login SQL server with the same users you tried ?
Originally posted by kevin86
I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?|||Originally posted by kevin86
Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?
You cannot register as windows nt user (trusted) cos you might not be added to that server as a user, and as you are able to ping the server , you are suppose to register the server using sql login, the only reason i would say you are not able to register is the sa password is wrong, try overwriting the password froom any of the machines where its already connected and then register it ...you should be able to connect ...
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.Can you reach the server on the VPN (ping it) ?
if not, you need to reconfigurate your network settings(IP of the switch connectiong to the VPN)
if you can ping it, you should have no problem using SQL server Authentication (unless firewall filter the SQL Server port)
Originally posted by kevin86
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.|||I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||I think you have to ask to the system admin for the firewall.
Do you asked someone on the domain (not using the VPN) to try login SQL server with the same users you tried ?
Originally posted by kevin86
I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?|||Originally posted by kevin86
Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?
You cannot register as windows nt user (trusted) cos you might not be added to that server as a user, and as you are able to ping the server , you are suppose to register the server using sql login, the only reason i would say you are not able to register is the sa password is wrong, try overwriting the password froom any of the machines where its already connected and then register it ...you should be able to connect ...
Thursday, March 8, 2012
Connection to remote server using VPN
Hi - I am a relative newbie to setting up and configuring servers so am a
bit baffled by all the server techno-speak.
My issue - I have a client who is based about 40 miles away who want me to
do some database work for them. I am a freelancer and he is a small company
who relies on a non sql server specific moonlighter for tech support (it's
not as wing and prayer as it might seem!).
They bought MS Small Biz server which includes SQL 2000. I tried to install
it on my XPHome pc but came to the view that you need a 2000/2003 server to
run anything bigger than a 4Gb database. Given that the db will be much
bigger than 4Gb we therefore need to install SQL Server on his server and
run it as a sql server with me installing query analyser and eneterprise
manager on my PC and connect. All fine in theory. Now for security I am
assuming the best way to connect is by using VPN? If this is so, can any
one point me to any info on setting up my end + his end and what may be
required h/w + s/w etc?
His moonlight techie says I need a static IP address... I think I have a
dynamic one, and that all he need to do is set up some filters his end. I
also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has router
and firewall his end.
I looked for past postings and find ref to this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
but now it's dead.
Any help much appreciated!
Happy New Year.
Andythere is a thread going on at www.sqlservercentral.com
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
maybe that will get you on track
jobi
"Andreww" <andrew@.fake.com> wrote in message
news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> Hi - I am a relative newbie to setting up and configuring servers so am a
> bit baffled by all the server techno-speak.
> My issue - I have a client who is based about 40 miles away who want me to
> do some database work for them. I am a freelancer and he is a small
company
> who relies on a non sql server specific moonlighter for tech support (it's
> not as wing and prayer as it might seem!).
> They bought MS Small Biz server which includes SQL 2000. I tried to
install
> it on my XPHome pc but came to the view that you need a 2000/2003 server
to
> run anything bigger than a 4Gb database. Given that the db will be much
> bigger than 4Gb we therefore need to install SQL Server on his server and
> run it as a sql server with me installing query analyser and eneterprise
> manager on my PC and connect. All fine in theory. Now for security I am
> assuming the best way to connect is by using VPN? If this is so, can any
> one point me to any info on setting up my end + his end and what may be
> required h/w + s/w etc?
> His moonlight techie says I need a static IP address... I think I have a
> dynamic one, and that all he need to do is set up some filters his end. I
> also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
router
> and firewall his end.
> I looked for past postings and find ref to this link
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> but now it's dead.
> Any help much appreciated!
> Happy New Year.
> Andy
>|||Jobi - thanks. I took a look and it seems more about how to set things up
once the VPN is set up... which helps.
In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?
Help appreciated... even if it's that I'm in the wrong news group!
Regards
Andy
"jobi" <jobi@.reply2.group> wrote in message
news:bsud5v$fhp$1@.reader08.wxs.nl...
> there is a thread going on at www.sqlservercentral.com
> http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
> maybe that will get you on track
> jobi
> "Andreww" <andrew@.fake.com> wrote in message
> news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> > Hi - I am a relative newbie to setting up and configuring servers so am
a
> > bit baffled by all the server techno-speak.
> >
> > My issue - I have a client who is based about 40 miles away who want me
to
> > do some database work for them. I am a freelancer and he is a small
> company
> > who relies on a non sql server specific moonlighter for tech support
(it's
> > not as wing and prayer as it might seem!).
> >
> > They bought MS Small Biz server which includes SQL 2000. I tried to
> install
> > it on my XPHome pc but came to the view that you need a 2000/2003 server
> to
> > run anything bigger than a 4Gb database. Given that the db will be much
> > bigger than 4Gb we therefore need to install SQL Server on his server
and
> > run it as a sql server with me installing query analyser and eneterprise
> > manager on my PC and connect. All fine in theory. Now for security I am
> > assuming the best way to connect is by using VPN? If this is so, can
any
> > one point me to any info on setting up my end + his end and what may be
> > required h/w + s/w etc?
> >
> > His moonlight techie says I need a static IP address... I think I have a
> > dynamic one, and that all he need to do is set up some filters his end.
I
> > also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
> router
> > and firewall his end.
> >
> > I looked for past postings and find ref to this link
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> > but now it's dead.
> >
> > Any help much appreciated!
> >
> > Happy New Year.
> >
> > Andy
> >
> >
>|||"In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?"
Given what little knowledge I have about your situation, I would say that VPN is your best bet. It's going to be the most economical, practical, and easiest way to connect to your client using SQL. Anything else would be expensive and/or unsecure.
But that's just my opinion...
Hope this helps.
Shaun
bit baffled by all the server techno-speak.
My issue - I have a client who is based about 40 miles away who want me to
do some database work for them. I am a freelancer and he is a small company
who relies on a non sql server specific moonlighter for tech support (it's
not as wing and prayer as it might seem!).
They bought MS Small Biz server which includes SQL 2000. I tried to install
it on my XPHome pc but came to the view that you need a 2000/2003 server to
run anything bigger than a 4Gb database. Given that the db will be much
bigger than 4Gb we therefore need to install SQL Server on his server and
run it as a sql server with me installing query analyser and eneterprise
manager on my PC and connect. All fine in theory. Now for security I am
assuming the best way to connect is by using VPN? If this is so, can any
one point me to any info on setting up my end + his end and what may be
required h/w + s/w etc?
His moonlight techie says I need a static IP address... I think I have a
dynamic one, and that all he need to do is set up some filters his end. I
also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has router
and firewall his end.
I looked for past postings and find ref to this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
but now it's dead.
Any help much appreciated!
Happy New Year.
Andythere is a thread going on at www.sqlservercentral.com
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
maybe that will get you on track
jobi
"Andreww" <andrew@.fake.com> wrote in message
news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> Hi - I am a relative newbie to setting up and configuring servers so am a
> bit baffled by all the server techno-speak.
> My issue - I have a client who is based about 40 miles away who want me to
> do some database work for them. I am a freelancer and he is a small
company
> who relies on a non sql server specific moonlighter for tech support (it's
> not as wing and prayer as it might seem!).
> They bought MS Small Biz server which includes SQL 2000. I tried to
install
> it on my XPHome pc but came to the view that you need a 2000/2003 server
to
> run anything bigger than a 4Gb database. Given that the db will be much
> bigger than 4Gb we therefore need to install SQL Server on his server and
> run it as a sql server with me installing query analyser and eneterprise
> manager on my PC and connect. All fine in theory. Now for security I am
> assuming the best way to connect is by using VPN? If this is so, can any
> one point me to any info on setting up my end + his end and what may be
> required h/w + s/w etc?
> His moonlight techie says I need a static IP address... I think I have a
> dynamic one, and that all he need to do is set up some filters his end. I
> also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
router
> and firewall his end.
> I looked for past postings and find ref to this link
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> but now it's dead.
> Any help much appreciated!
> Happy New Year.
> Andy
>|||Jobi - thanks. I took a look and it seems more about how to set things up
once the VPN is set up... which helps.
In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?
Help appreciated... even if it's that I'm in the wrong news group!
Regards
Andy
"jobi" <jobi@.reply2.group> wrote in message
news:bsud5v$fhp$1@.reader08.wxs.nl...
> there is a thread going on at www.sqlservercentral.com
> http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
> maybe that will get you on track
> jobi
> "Andreww" <andrew@.fake.com> wrote in message
> news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> > Hi - I am a relative newbie to setting up and configuring servers so am
a
> > bit baffled by all the server techno-speak.
> >
> > My issue - I have a client who is based about 40 miles away who want me
to
> > do some database work for them. I am a freelancer and he is a small
> company
> > who relies on a non sql server specific moonlighter for tech support
(it's
> > not as wing and prayer as it might seem!).
> >
> > They bought MS Small Biz server which includes SQL 2000. I tried to
> install
> > it on my XPHome pc but came to the view that you need a 2000/2003 server
> to
> > run anything bigger than a 4Gb database. Given that the db will be much
> > bigger than 4Gb we therefore need to install SQL Server on his server
and
> > run it as a sql server with me installing query analyser and eneterprise
> > manager on my PC and connect. All fine in theory. Now for security I am
> > assuming the best way to connect is by using VPN? If this is so, can
any
> > one point me to any info on setting up my end + his end and what may be
> > required h/w + s/w etc?
> >
> > His moonlight techie says I need a static IP address... I think I have a
> > dynamic one, and that all he need to do is set up some filters his end.
I
> > also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
> router
> > and firewall his end.
> >
> > I looked for past postings and find ref to this link
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> > but now it's dead.
> >
> > Any help much appreciated!
> >
> > Happy New Year.
> >
> > Andy
> >
> >
>|||"In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?"
Given what little knowledge I have about your situation, I would say that VPN is your best bet. It's going to be the most economical, practical, and easiest way to connect to your client using SQL. Anything else would be expensive and/or unsecure.
But that's just my opinion...
Hope this helps.
Shaun
Subscribe to:
Posts (Atom)