I was going through the tutorial and when I was in the Business Object Mapper I was unable to connect to SQL Server 7.0. The server is running Windows 2000 SP4. I've tried connecting using Windows Integrated Security and by using the 'sa' account. Neither works. The sa password is not blank.



It sees the server but when it tries to load the databases, it doesnt populate the databases combo box.



Any suggestions?

Thanks

Mike

Whatever database is set as the initial catalog (in this case "InjuryCostTracking") should contain the table/view/stored procedure "Items", if it doesn't then there's your problem. It might also be that "Initial Catalog" is a 2000+ term, and you might replace it with "Database" making your connection string this:



workstation id=ILPMMURPHY;packet size=4096;user id=sa;data source=web;persist security info=True;Database=InjuryCostTracking;



For some reason, the SQL client cannot see the table "Items" when connecting with the connection string you've provided.