For help! Why pb6.5 connection under Windows xp not SQL2005 database on a local area network,

CodePudding user response:

What tips??
To say your tips,

CodePudding user response:

After the installation is essentially 2005, the default system is Windows authentication, and the sa user is disabled.
To sa to login, the following operation
1. The first login in Windows authentication mode, wait for after the connection is successful, right-click on the instance, select properties security, on the right to choose SQL Server and Windows authentication mode.
2. The safety of the users under the instance under the tree, right-click the sa properties, click the general, set up the sa password. Then click on the state, check the granting and enable two radio. At this point, set up.
3. Restart the SQLExpress service is ok

CodePudding user response:

If sql2005 service to use the default instance name, connect to the server to write the instance name

CodePudding user response:

The up...

CodePudding user response:

Sql2005 is used, whether need to have special Settings,

CodePudding user response:

Sign out to know what is going on, they said even, also don't know how to help you

CodePudding user response:

In PB client need to install sqlncli. Msi 3.5 M, installation plate is sql2005,
//Profile
The SQLCA. DBMS="MSS Microsoft SQL Server 6. X"
SQLCA. ServerName="10. XX. XX. XX"//IP address, or instance name, need to see you on sql2005 Settings
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

CodePudding user response:

See if your firewall to access the computer on, set a minute!

CodePudding user response:

With manager first login, look the way manager login

Sqlexpress default use IP cannot login

To ensure that your manager can log in

CodePudding user response:

Not sqlncli. Msi, I doubt or SQLCA SQLNAME input format, with the server \ instance name also can not pass,

CodePudding user response:

Uping...

CodePudding user response:

Everyone is so concerned about, the original poster is not reply

CodePudding user response:

I use the PB7 of, can't connect on SQL2005, is by reading the ini file, can't the connection way, because there is no source code, only after the release of the installation files, sad, who knows what's going on, whether PB7 cannot connect SQL2000 SQL2005 can only be connected.