Link to home
Create AccountLog 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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of BOBCOLIN
BOBCOLIN

ASKER

it works fine for me