Thanks. that worked like charm!
I really thank a lot you because you give your time to me to solve my problem.
Suggested Articles
Search found 21 matches
- Tue Apr 28, 2020 7:22 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
- Wed Apr 15, 2020 7:37 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi,
Thanks for reply.
In order to enable "Trusted Authentication", please proceed as it follows:
- go to "SQL Databases" page
- select "DlgPredefinedConnection"
- under "Authentication" section, please check the "Trusted Authentication (Windows Integrated authentication)" checkbox.
with this ...
Thanks for reply.
In order to enable "Trusted Authentication", please proceed as it follows:
- go to "SQL Databases" page
- select "DlgPredefinedConnection"
- under "Authentication" section, please check the "Trusted Authentication (Windows Integrated authentication)" checkbox.
with this ...
- Tue Mar 24, 2020 7:15 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi
by uncheck "create database if not exist" it worked.
Thanks a lot.
but as in my previous post i asked about connect with trusted connection you said:
In what regards your second question, if you use a trusted connection, the connection will try to connect to the "master"database (which comes by ...
by uncheck "create database if not exist" it worked.
Thanks a lot.
but as in my previous post i asked about connect with trusted connection you said:
In what regards your second question, if you use a trusted connection, the connection will try to connect to the "master"database (which comes by ...
- Wed Mar 11, 2020 10:17 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi
Please go to "SQL Databases" page --> your predefined connection --> in "Database" field, please insert a property that resolves to an empty value during installation (that basically does not currently exists)
i create a property with name of "[EMPTY_DATABASE]" as aip file attached but give me ...
Please go to "SQL Databases" page --> your predefined connection --> in "Database" field, please insert a property that resolves to an empty value during installation (that basically does not currently exists)
i create a property with name of "[EMPTY_DATABASE]" as aip file attached but give me ...
- Sat Mar 07, 2020 6:57 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi
because when a database created before attaching the database has no meaning.
I think it is clear that Attach a database to an existing database do not work and tell the database exist!A solution would be to let the user select an already existing database and attach your database to it.
because when a database created before attaching the database has no meaning.
- Sat Feb 29, 2020 7:49 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi
Thanks for Reply.
your solution worked but it make an aditional database that we set it's name in predefinedconnectiondlg.
that sounds not good. is there a way to attach the db without create additional db. i Think i because of this option you noticed:
go to "SQL Databases" page ...
Thanks for Reply.
your solution worked but it make an aditional database that we set it's name in predefinedconnectiondlg.
that sounds not good. is there a way to attach the db without create additional db. i Think i because of this option you noticed:
go to "SQL Databases" page ...
- Sat Feb 29, 2020 7:37 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi
Thanks for Reply.
your solution worked but it make an aditional database that we set it's name in predefinedconnectiondlg.
that sounds not good. is there a way to attach the db without create additional db. i Think i because of this option you noticed:
go to "SQL Databases" page ...
Thanks for Reply.
your solution worked but it make an aditional database that we set it's name in predefinedconnectiondlg.
that sounds not good. is there a way to attach the db without create additional db. i Think i because of this option you noticed:
go to "SQL Databases" page ...
- Wed Feb 19, 2020 5:19 pm
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
hi
Could you please try to manually connect to the same instance using the "sa" account, try to run your script from there and see if that works?
the script is work with "sa" account in sql management studio without any problem.
Additionally, could you please go to "SQL Databases" page ...
Could you please try to manually connect to the same instance using the "sa" account, try to run your script from there and see if that works?
the script is work with "sa" account in sql management studio without any problem.
Additionally, could you please go to "SQL Databases" page ...
- Wed Feb 12, 2020 8:12 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
Hi
Thanks for reply.
One thing I have noticed from the log file you've earlier sent:
- the DATABASE_PROP is nowhere to be found in your log file. Are you connecting to any database during the "SQLServerConnectionDlg" dialog? If not, please connect to one by clicking the "..." button and then ...
Thanks for reply.
One thing I have noticed from the log file you've earlier sent:
- the DATABASE_PROP is nowhere to be found in your log file. Are you connecting to any database during the "SQLServerConnectionDlg" dialog? If not, please connect to one by clicking the "..." button and then ...
- Tue Feb 04, 2020 5:22 pm
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
hi
could you please follow the steps I've given in my previous thread and let me know if that helps in any way?
i use sa user that exist in Security -> Logins in SSMS and can attach my db with script with SSMS without any problem.
could you please forward me a copy of your .AIP file by e-mail at ...
could you please follow the steps I've given in my previous thread and let me know if that helps in any way?
i use sa user that exist in Security -> Logins in SSMS and can attach my db with script with SSMS without any problem.
could you please forward me a copy of your .AIP file by e-mail at ...
- Tue Jan 28, 2020 3:38 pm
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
hi
thanks for reply
i send you my setup log for more details.
i use sa user and it's password that when i click test sql connection the result is successful in setup. but when wanna execute the attach script the above error occur.
i thinks i missed something.please check and any solution appreciated
thanks for reply
i send you my setup log for more details.
i use sa user and it's password that when i click test sql connection the result is successful in setup. but when wanna execute the attach script the above error occur.
i thinks i missed something.please check and any solution appreciated
- Thu Jan 23, 2020 7:20 am
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
could you please give me an example aip file that attach db?
- Tue Jan 21, 2020 2:35 pm
- Forum: Building Installers
- Topic: Source File Not Found ????
- Replies: 13
- Views: 33907
- Jump to post
Re: Source File Not Found ????
hi,thanks for quick reply. i add it and not display Source File Not Found Error
thanks
thanks
- Tue Jan 21, 2020 6:53 am
- Forum: Building Installers
- Topic: Source File Not Found ????
- Replies: 13
- Views: 33907
- Jump to post
Re: Source File Not Found ????
hi
i use advanced installer 16.5 and i can't see ExtractFilesFirst property in install parameter page. is it exist in this version?
i use advanced installer 16.5 and i can't see ExtractFilesFirst property in install parameter page. is it exist in this version?
- Sun Jan 19, 2020 3:36 pm
- Forum: Common Problems
- Topic: attach sql db file show me error
- Replies: 27
- Views: 116066
- Jump to post
Re: attach sql db file show me error
hi
i have same issue and used following article to attach db:
https://www.advancedinstaller.com/user-guide/qa-custom-property-in-script.html
but i face the error:
SQLDriverConnect]{SQL_STATE:42000}[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "dbname" requested by login.the ...
i have same issue and used following article to attach db:
https://www.advancedinstaller.com/user-guide/qa-custom-property-in-script.html
but i face the error:
SQLDriverConnect]{SQL_STATE:42000}[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "dbname" requested by login.the ...