Microsoft Developer Network >
Forums Home
>
BizTalk Server Forums
>
BizTalk Server General
>
Moving my Database From sQLServer 2005 to SQLServer 2008
Moving my Database From sQLServer 2005 to SQLServer 2008
- Hi all,
We had to move our data database - not our biztalk database - from sqlserver 2005 to sqlserver 2008, however I'm receiving the following error in biztalk server:
[ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation
Do I need to change my sqladapter to a newer version ?
What issues may I have with this migration?
Luis Diego Rojas. http://icomparable.blogspot.com
MCP, MCTS Biztalk ServerLang Detect en>es GoogleDic Cdeber, tener que, deber de, debería- Edited byLuis D. Rojas Wednesday, November 04, 2009 4:23 PMspelling
Answers
- Hi,
Create a UDL in your BizTalk server and using that UDL try to connect to the new server using the same user and credentials that your SQL adapter host is using to verify that you can connect to the new server.
Regards,
Tariq Majeed
Please mark it as answer if it helps- Marked As Answer byWen-Jun ZhangMSFT, ModeratorWednesday, November 11, 2009 11:00 AM
All Replies
- Hi,
Create a UDL in your BizTalk server and using that UDL try to connect to the new server using the same user and credentials that your SQL adapter host is using to verify that you can connect to the new server.
Regards,
Tariq Majeed
Please mark it as answer if it helps- Marked As Answer byWen-Jun ZhangMSFT, ModeratorWednesday, November 11, 2009 11:00 AM
The error usually indicates Biztalk is trying to connect to a Microsoft SQL Server instance that isn't available. Make sure your SQL Server instance is available. Please try to manually connect to the SQL Server instance through SQL Server Management Studio.
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
