hello
i'm having the exact same issue...
I'm working on Windows XP and SQLServer 2008...
I'm not even trying to execute sql script... i just whant to create new
database.
I try with Windows Authentication and SQL-Server Authentication same
error.
Are there any new information about this issu
Re-looking at your code, I noticed that some of the sql:sqlString statements
don't have a sqlDb attribute on them. Not sure what the consequences are of
leaving it off - I always put one on all of my sqlScript statements.
Mike
*Mike Rerick*
*Sr. Software Engineer*
[image: Google Docs
Mike,
My SQL script is not having GO command after each sql statement. The reason
being the sql scripts works perfect when executed manually in Management
studio.
If nothing works then I have to create database from within sql script
"Create database"
tag is simply not working in this scena
ue.
>
> Michael
>
> -Original Message-
> From: kim [mailto:contactme...@gmail.com]
> Sent: Friday, 18 March 2011 7:17 AM
> To: wix-users@lists.sourceforge.net
> Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create
> SQL database
>
> Ok, Keeping it
Hi
-2147467259 converts to 80004005. Try searching on this value.
Michael
-Original Message-
From: kim [mailto:contactme...@gmail.com]
Sent: Friday, 18 March 2011 7:17 AM
To: wix-users@lists.sourceforge.net
Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL
MSI.
Hope these help
Michael
-Original Message-
From: kim [mailto:contactme...@gmail.com]
Sent: Friday, 18 March 2011 6:27 AM
To: wix-users@lists.sourceforge.net
Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL
database
Thanks for reply Mike.
Yes I am usi
Ok, Keeping it simple:
I need to create database and other objects using my msi. Target machine is
Windows XP SP3 and SQL Server 2008 express edition.
I am using following code to create database but its failing with error
code: "Error 26201. Error -2147467259: failed to create SQL database " Thi
ers@lists.sourceforge.net
Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL
database
Thanks for reply Mike.
Yes I am using Windows Authentication to connect to database. However when
installing SQL Server 2008 Express edition I selected Mixed mode.
I am attaching my cod
Thanks for reply Mike.
Yes I am using Windows Authentication to connect to database. However when
installing SQL Server 2008 Express edition I selected Mixed mode.
I am attaching my code here (since due to some wierd error my code is not
visible in post)
http://windows-installer-xml-wix-toolset.6
I have seen this error when the username or password is incorrect.
How are you trying to access the database: via windows or server
authentication?
If you are trying to access sql express via a user name (probably sa?) and
password, did you install SQL Express in mixed mode and specify a sa
passw
Can someone please help me with this issue?
I checked that Network Service account was not having full control
permission on C:\Program Files\Microsoft SQL Server folder and subfolders
where is the default path to create database.
Still database creation is failing with this error (as mentioned i
Michael,
In my code I am not specifying paths for MDF and LDF files. I am just using
tag to create DB. What confuses me is that this same code works on Windows 7
machine and not on XP. I installed SQL Express on XP box is same way as I
did on windows 7.
Also,
SQL Server Express will be installe
March 2011 1:32 AM
To: wix-users@lists.sourceforge.net
Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL
database
Michael,
Can you please guide me on how should I check the file permissions for SQL
Server? While installing SQL Express I did used NT AUTHORITY\NETWO
Michael,
Can you please guide me on how should I check the file permissions for SQL
Server? While installing SQL Express I did used NT AUTHORITY\NETWORK SERVICE
account.
thanks
--
View this message in context:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-26201-Error-21474
I am not sure why my code is not visible. when I edit my message I see the
code there.
Anyways I have attached .txt file having create database code from .wxs file
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n6173167/CreateDatabaseScript.txt
CreateDatabaseScript.txt
--
--
View this message in context:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-26201-Error-2147467259-failed-to-create-SQL-database-tp6163225p6173147.html
Sent from the wix-users mailing list archive at Nabble.com.
--
Hi
I suspect the error is that the service account for the SQL Server does not
have permissions to the file path to actually create the database files. Your
WXS snipit was not visable, so I am guessing that you are specifying a file
path for the data file and log file.
With SQL Server the ac
Not sure about anyone else but your code isn't visible.
-Original Message-
From: kim [mailto:contactme...@gmail.com]
Sent: Friday, March 11, 2011 6:10 PM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] Error 26201. Error -2147467259: failed to create SQL
database
Hello,
I am
18 matches
Mail list logo
