Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SandyRyan
Starting Member
5 Posts |
 Posted - 2004-11-06 : 09:21:21
|
| ok -- i have another problemI have an ASP page that uses SQL Authentication... and it authenticates fine against the test sql box - if i point it to the production box - i receive ACCESS DENIED..I'm sure it is a network login permission or log on locally setting but I can't find it anywherethanksSandy |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-06 : 09:41:20
|
| Are you sure the login and password on the production box are the same as the test box? |
 |
|
|
SandyRyan
Starting Member
5 Posts |
Posted - 2004-11-06 : 15:06:11
|
| yes === |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-08 : 03:17:10
|
quote:
Originally posted by SandyRyan
yes ===
verify your connection information--------------------keeping it simple... |
|
|
|
SandyRyan
Starting Member
5 Posts |
Posted - 2004-11-08 : 08:30:32
|
| it isn't the connection string - i think it may have to do with authentication using name pipes - the sql server is on a different system then the web server - there is a microsoft article concerning this - but I can't find it again! |
|
|
|
|
|
|
asp page not authenticating with SQL