mid.gif (2241 bytes)
FormMenuStart.gif (2069 bytes) FormMenuEnd.gif (441 bytes)
Knowledgebase Article 1002
FormHorizontalLine.gif
QUESTION:

When changing the database from ACCESS to SQL Server I get the following error message.

Error 9040: An error occured while changing the database provider.

Error -2147217843: Login failed for user 'DOMAINNAME\prtracker'.
SqlServerInstance=DATA\SOFTWISESQL

PrtrackerInterface:InitNewProviderDatabase ProjectDb.CreateDb Microsoft OLE DB Provider for SQL Server 5.10.0056

PR-Tracker 5.10.0137
frmConfigureProject:cmdClickOK PRBASE:ConvertDbToNewProvider prtracker

ANSWER:

Error occurs -2147217843 because the user prtracker does not have privilege to create a SQL Server database. Note that all database operations are performed by functions inside PRTRACK.DLL which runs under the authority of user prtracker (assuming that you set it up this way in component services). The two ways to fix this problem.

1) Make the user prtracker a local administrator on the SQL Server computer.
2) Or make user prtracker a System Administrator of SQL Server.

See http://help.prtracker.com/ConfigureSQLServer.html
CornerLeft.gif (244 bytes) CornerRight.gif (244 bytes)

 

endln.gif (223 bytes)
Nine tips for effective bug tracking | Home | Site Map | Search Knowledgebase