Factorytalk View History

[omarzdn]

Dear All
When I try to add New Database to Factorytalk View project the message "Unable to connect to database.Database
error- [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server dose not exist or access denide."
What Can I do to solve this problem?
Thanks

[NowanH]

a) First, you have to check what user you are using to log in: don't use Window's users. It's better to use the default user sa.

b) By default SQL Server Express installs with an instance name of "SQLEXPRESS" or "MSSQLSERVER". If you are using a named SQL instance, you will need to specify the instance name when you are configuring alarm and event historian.

c) If you have problems with SQL Server Express try reinstalling. You can use SQL Server Management Studio (free to download from Microsoft) to check your SQL Server and database users.

[omarzdn]

Dear NowanH
I have not a user called sa in my computer (I install SQL from factorytalk view DVD)
Do you have a simple way to make log file and print history without SQL Server?
Thanks

[NowanH]

Dear NowanH
I have not a user called sa in my computer (I install SQL from factorytalk view DVD)
Do you have a simple way to make log file and print history without SQL Server?
Thanks

sa is not part of Window's users but SQL Server's users. If you installed SQL Server from FTView DVD then you have sa registered in the SQL Server instance. I think there is a link in the DVD for recreating the SQL Server instance (and recreating sa account).

You can log data using Data Log Models. So far I remember this feature works with an ODBC driver, ie writes a database like Access. When you are setting up a Data Log you need to specify tags and samples; optionally you can specify a directory and file to use as database, in case you don't want to use default parameters. There's more information in FTView's help.

Data Logging is good for trending. If you need to storage a high number of tags for a long period (months or years) is better to use SQL Server. Additionally you can storage tags related information (timestamp, messages, priority, etc).

[omarzdn]

Dear NowanH
Thanks so much