This is a connection between a Vista computer and a Server 2003 domain controller. I have used the SQLCMD ( Sqlcmd –S “tcp:erverName\instanceName,portNumber”) to verify access to the server and named instance and can connect with no problem, so it appears that would eliminate any firewall (which I turned off) problem or permission problem on the SQL Server. I keep receiving errors that the database cannot be found. Then I loaded 2007 Business Contact Manager on a workstation on the LAN and attempted to use the wizard to connect to the remote database. Everything worked as it should and I verified the database existed and was populated with data and all the permissions were set correctly to access the database. I'm looking for a little help on a strange problem, used Business Contact Manager 2007 Database Tool to create a shared database in SQL Server 2005 on a server on the LAN, placed the database in the default instance of MSSQLSERVER then used the database tools to restore a 2003 BCM database to the newly created database in SQL.
0 Comments
Leave a Reply. |