| asp.net connecting database in different server |
 |
 |
 |
| Friday, 28 March 2008 18:21 | |
|
have you ever curius why you always have error of unauthorise user connection when connecting with mssql server in different location when the mssql server using windows authentification method? Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. i just found out today that you need to have the same username that is known by both the server, the web and the database server. so the error generated because one server doesn't recognise the user name. the trick is to add user credential in your web.config file under <system.web></system.web> you just add this sytax: <identity impersonate="true" userName="domain user name" password="domain user name password" /> and voila you can connect to the mssql server on other machine. |
Add your comment
Zaragoza Clouds
altiris
application
connect
create
database
deep
different
environment
error
example
express
files
freeze
install
like
management
memory
need
options
page
program
programs
protection
sandbox
sandboxie
schedule
server
session
simple
software
solution
spyware
time
used
user
using
virtual
windows
2008
Created with Zaragoza Clouds
Created with Zaragoza Clouds
