unable to access db

BOBCOLIN
BOBCOLIN used Ask the Experts™
on
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


Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
make sure your connect string connects to the database on the server
Imran Javed ZiaConsultant Software Engineer - .NET Architect

Commented:
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 ,
Commented:
HI All,

I have added
 <remove name ="XYZ"/>

it works fine

Author

Commented:
it works fine for me

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial