Database Authentication


Author
Message
Daniel Essin
Daniel Essin
StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)
Group: Forum Members
Posts: 235, Visits: 309
I am running the installer on a clean machine. The SQL Server is on another machine. The SQL Management Studio can connect using Windows Authentication. The Strataframe installer can only connect if I use SQL Server authentication.

Is there some setting that controls this?

Does anyone have an idea why Windows Authentication would fail within the Strataframe context but succeed in the Visual Studio context?

Thank you

Replies
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Are you running SQL Server 2000?  Could you post the log file from the install?  It should be located in the C:\Program Files\Common Files\MicroFour\StrataFrame\ folder.
Daniel Essin
Daniel Essin
StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)
Group: Forum Members
Posts: 235, Visits: 309
No, this is a clean install of SQL Server 2005.



Since the previous message I uninstalled and reinstalled. Got the same error.

Then I ran the install again but chose modify. This time it seems to be generating database activity.



The log files that I have are all named xxx_results.log. The first 3 log files from the 3 installs are all 0 length. Then I have 2 from the Modify that are named Strataframe_results.log and StrataframeSample_results.log.



The Modify has now completed and everything seems to be working. I'm not sure that sending you the logs will help because every log from a failed install is empty and the logs from the modify contain all the expected messages about the databases being created. They are attached nevertheless.



I'm pleased that this procedure seems to have worked but I'm a little perplexed as to why I have run into the failure of the initial install (all identical failures) on several different machines. Is it something that I'm consistently doing wrong?



Thanks
Attachments
logs.zip (117 views, 16.00 KB)
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Did you try to install SF to a non-default location (not C:\Program Files\MicroFour\StrataFrame, or whatever the default is...)?  It could be that the install could not locate the *.pkg file for the data deployment, not that the *.mdf file could not be created. 

I'm leaning toward the *.pkg file being unavailable because the log files would contain a few lines and the exception saying that the *.mdf file could not be located; but since the log file was empty, I don't think the *.pkg file was found because it never even started...

Daniel Essin
Daniel Essin
StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)StrataFrame User (339 reputation)
Group: Forum Members
Posts: 235, Visits: 309
No, everything is clean, stock, and default. I didn't tweak anything.
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Hrm... well then, it looks like when the install ran, it did not deploy the *.pkg file, so when the installer action tried to deploy the data, it failed because it couldn't find the file...
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Daniel Essin - 18 Years Ago
StrataFrame Team - 18 Years Ago
Daniel Essin - 18 Years Ago
StrataFrame Team - 18 Years Ago
                     No, this is a clean install of SQL Server 2005.

Since the...
Daniel Essin - 18 Years Ago
                         Did you try to install SF to a non-default location (not C:\Program...
StrataFrame Team - 18 Years Ago
                             No, everything is clean, stock, and default. I didn't tweak anything.
Daniel Essin - 18 Years Ago
                                 Hrm... well then, it looks like when the install ran, it did not...
StrataFrame Team - 18 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search