Link to home
Start Free TrialLog in
Avatar of BOBCOLIN
BOBCOLIN

asked on

unable to access db

Hi Team,

I have published the application in IIS on Windows server 2008 R2 and database ms sql server 2008 on windows vista system connected thru LAN.

I am not able to login in to application but it works fine when db is on windows server 2008

Regards,
Bob


Avatar of Randy Downs
Randy Downs
Flag of United States of America image

make sure your connect string connects to the database on the server
Hi,
It seems you have not given proper atuthentication in connection string or you have not enabled external access in sql server.
Please provide detail of exception for further help:

you may find following helpful:
http://technet.microsoft.com/en-us/library/cc646023.aspx
http://msdn.microsoft.com/en-us/library/dd857537(v=vs.85).aspx
http://msdn.microsoft.com/en-us/library/ms165718.aspx

Thanks
did u get the error 40 or 18452 error ,
ASKER CERTIFIED SOLUTION
Avatar of BOBCOLIN
BOBCOLIN

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BOBCOLIN
BOBCOLIN

ASKER

it works fine for me