注册 登录
编程论坛 SQL Server论坛

SQL2008无效的连接错误

charlescg 发布于 2011-11-17 14:12, 984 次点击
安装2008后,用连接工具已经可以登陆SA账号,但是程序连接总是提示无效的连接80004005错误,程序段如下:CString strIP = ini.GetValue( "DBSetup", "IP", "127.0.0.1" );
    CString strDBName = ini.GetValue( "DBSetup", "DBName", "apollo" );
    CString strUserName = ini.GetValue( "DBSetup", "UserName", "sa" );
    CString strPassword = ini.GetValue( "DBSetup", "Password", "apollo" );

    CString strConnection = _T("Provider=SQLOLEDB;Network Library=DBMSSOCN;Data Source=" + strIP \
        + ";Initial Catalog=" + strDBName \
        + ";User Id=" + strUserName \
        + ";Password=" + strPassword + ";");
   
    if ( g_db.Open(strConnection) == FALSE )
    {
        CSetupSheet sheet("系统设置", NULL, 0);
        
        if ( sheet.DoModal() != IDOK )
            return FALSE;
        
        strConnection = _T("Provider=SQLOLEDB;Network Library=DBMSSOCN;Data Source=" + sheet.m_wndDBPage.m_strIP \
            + ";Initial Catalog=" + sheet.m_wndDBPage.m_strDBName \
            + ";User Id=" + sheet.m_wndDBPage.m_strUserName \
            + ";Password=" + sheet.m_wndDBPage.m_strPassword + ";");
        
        if ( !g_db.Open(strConnection) )
            return FALSE;
    }
1 回复
#2
aklbryan2011-11-28 21:16
我不会编程,但是有几个想法:

程序是在其他机器访问的话,可能要开TCP 1433和UDP 1434 端口

又或需要打开SQL Browser服务。
1